Forum Discussion
Finding duplicates in multiple columns
The attached screenshot of a report has many duplicate entries. If Column C (invoice #) has duplicates, then we need to look at Column G (item #) within those records and see if there are also d...
Thanks for your help. I don't think conditional formatting is the answer. I have updated my question, hopefully it is more clear now what I am asking. Thanks again for helping, I appreciate it.
Sorry, I didn't catch what do you mean under highlight. If not colour when automatic filtering, or to show such records in separate table or what?
Another variant is the table with 3 helper columns and slicers by which you may select any combinations of such records - attached.