Is there a way to catch duplicates?

Nicole Emard

Hello,

I have created a bid list for my Salesman to let us know which jobs they are bidding. I created a form for them to do this.

The problem I am running into is if the Salesman are bidding the same job.

I have a Row called Job Name. Is there a way to flag duplicates for the same job name?

Thanks!

Paul Newcome

Conditional Formatting on its own cannot be used to flag duplicates. Insert another column (symbol/flag in this example) and enter the following into row 1 then dragfill down for the remaining rows. Auto-fill should pull the formula into new rows as they are added.

=IF(COUNTIFS([Job Name]$1:[Job Name]@row, [Job Name]@row) > 1, 1)

Joey Razzano

You can use conditional formatting to visually see duplicates and you can use the DISTINCT formula to catch dupes as well

Jenna Bailey

@joey.w.razzano33566 .. how do you do the conditional formatting? I have tried a few times but can't seem to figure it out!

Paul Newcome

Are new forms entered at the top or the bottom of the sheet?

Nicole Emard

The bottom. And, I also was unable to figure out how to do the conditional formatting for duplicates.

Paul Newcome

Conditional Formatting on its own cannot be used to flag duplicates. Insert another column (symbol/flag in this example) and enter the following into row 1 then dragfill down for the remaining rows. Auto-fill should pull the formula into new rows as they are added.

=IF(COUNTIFS([Job Name]$1:[Job Name]@row, [Job Name]@row) > 1, 1)

Nicole Emard

Thanks Paul!

Paul Newcome

Happy to help. 👍️