flag a row when compared to other rows

System

This discussion was created from comments split from: Flag duplicates based on multiple columns being the same.

alexis.ray89371

Hi!

I have another similar situation where I want to flag a row when compared to other rows in the sheet the Invoice Number and Supplier Name are the same, but the Funding Date is different. The below formula is what I was trying, but doesn't work. Hoping someone knows how to do this. Thanks!😁

=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))

Paul Newcome

@alexis.ray89371 Try changing it from being greater than 1 to greater than 0.

When flagging for overlap and comparing rows that may equal each other, using "@row" in your criteria sets means there will be at least 1 row that matches (current row), but in your case you are looking for rows where the date does NOT match. That means "@row" will not be counted, so if there are no rows then the COUNTIFS will output zero.

Does all of that make sense?

alexis.ray89371

That makes complete sense. Thank you so much! Can't believe I didn't think of that. 😁

Paul Newcome

Happy to help. 👍️