Flag duplicates based on multiple columns being the same
I have a "flag" column that I would like to use to flag rows that we consider duplicates. I got it to where it will flag if one piece of the criteria is duplicated, but not sure how to do the formula with multiple criteria met.
The purple fields need to all be the same to be considered a duplicate.
The formula I had working for one criteria is:
=IF([Supplier Invoice No]@row = "", 0, IF(COUNTIF([Supplier Invoice No]:[Supplier Invoice No], [Supplier Invoice No]@row) > 1, 1))
Any help would be much appreciated. Thank you!
Help Article Resources
Check out the Formula Handbook template!