Identify duplicates with multiple criteria

alexis.ray89371 · 12/15/22

Hi,

I need to identify rows that have the same Invoice No (text column), the same Supplier Name (text column), but different Funding Date (date column) and flag the row.

This is the formula I attempted that did not work:

=IF(COUNTIFS([Invoice No]:[Invoice No], [Invoice No]@row, [Supplier Name]:[Supplier Name], [Supplier Name]@row, [Funding Date]:[Funding Date], <>[Funding Date]@row) > 1, 1)

Any help would be much appreciated. Thank you!