Can I identify duplicate values by rows not just by column?

StephaniePharm

I need to ensure that entries to this sheet are not duplicated based on three columns, the name, the activity, and the start date. The examples I've found only review duplicate values within a column.

thank you for your help!

Kelly P.

@StephaniePharm

You could easily combine the 3 columns in a backend column and then look for duplicates in that new column.

Hope this helps!

Hollie Green

I typically create a helper column and do a COUNTIFS formula. Anything over a 1 would be a duplicate. You can then set up any conditions you need to do what you want to with the duplicate row.

=COUNTIFS([Employee Name]:[Employee Name],[Employee Name]@row,[Activity]:[Activity],[Activity]@row,[Start Date]:[Start Date],[Start Date]@row)