Marking Dupes based on multiple columns

jfatoliveira

Hello everyone, long time watcher, first time caller,

I've been search for an answer for a while on the forum but I can't seem to get it to work.

I am trying to highlight duplicates entries based on more than 1 column.

I did the helper column with the duplicate check, using the countifs formula but this gives me the duplicates based only on that 1 column - in this case, I have it dupe checking the Booking column.

Here's what I'm looking for, highlight dupe only if all 3 product, amount and booking are the same.

So row 4 would not be highlighted as not all columns are the same as row 1.

Thank you in advance!

Paul Newcome

What is your existing formula? If you are using a COUNTIFS, you should be able to just add more range/criteria sets to it.

jfatoliveira

=IF(COUNTIFS(Booking:Booking, Booking@row) > 1, 1) = 1

This is what I currently have - I am struggling to make the formula work with the added criterias :(

Paul Newcome

How exactly are you adding the extra range/criteria sets? Are you able to provide some of your most recent iterations as well as the outcomes?