Kutools excel comparison12/11/2022 ![]() This rule works with values as well as text entries. To apply the rule to column B instead, you'd use the rule =COUNTIF(B2:B2,C2)=0 after selecting C2:C11. ![]() It doesn't highlight values that occur in both columns as the built-in rule did. This rule doesn't highlight duplicates any value in column B that contains a value not in the corresponding cell in column C is easy to identify thanks to the cell's contrasting fill color. Figure E The highlighted items in column B don't match the corresponding value in column C.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |