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 duplicate item numbers.
We could go through and filter and sort and try to manually identify but I am thinking if we could write a formula to highlight those instances it would speed things up.
Thanks, Jacquie
Hi Jacquie,
You may highlight with conditional formatting
using formula rule
=COUNTIFS($B$2:$B$10,$B2,$C$2:$C$10,$C2,$G$2:$G$10,$G2)-1
adjusted to your ranges
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.
