Hi All
I have a simple spreadsheet with 2 columns
What i want do is to somehow flag out rows where the concatenate of column A and B (column C) has 2 or more unique values
As you can see from my example
Item A is disregarded since there is only 1 possible such combination
Item B is flagged because it has more than 1
How do I do this? I'd prefer not to use any advanced autofilter
Bookmarks