![]() That might include duplicates in the same column or items that occur more than once across both columns. This rule applies highlighting if the item appears more than once–anywhere. To do so, select B2:C12 and follow the same steps as above. Now let’s use the same built-in rule to compare the list in columns B to the list in column C. Figure B The built-in rules highlights duplicates in the same column. As you can in Figure B, this built-in rule highlighted duplicates in the same column because we selected a single column.įigure A This built-in duplicate rule compares items in a single list. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |