Any formula, if duplicate, say: "Duplicate"?

Paul Newcome

Can you copy/paste the exact formula that gives you the error from the sheet to here?

A Rose

@Paul Newcome

Below is the one, just diferent column names

=IF(AND([Column B]@row <> "", COUNTIFS([All Names]:[All Names], [All Names]@row) > 1), "Duplicate"))

Paul Newcome

Can you pull it directly from the sheet though and post here?

A Rose

I can't do that,

sorry.

Paul Newcome

I mean to go in to edit the cell as if you are going to edit the formula, highlight the formula, copy it, then paste it here.

Navroz Kajani

@Paul Newcome Dear Paul, Good Evening, Can you able to help me with this error?

I need to find the duplicates in my PO number column. I tried working with 2 formulas. But both of them throwing me error messages. Could you please able to help to find out what's wrong in this one ?

Both the columns are created under Text/Unmber.

Will be waiting to hear from you.

Thanks in advance

Manuel Jacob.

Paul Newcome

@Navroz Kajani I am not sure exactly what you are trying to accomplish. Are you just wanting to flag rows where the [PO Number] is duplicated?

Navroz Kajani

https://community.smartsheet.com/discussion/comment/295278#Comment_295278

@Paul Newcome - Hello Paul, I need to find the duplicates in the PO number column. Can you help me ?

Andrée Starå

Hi @Navroz Kajani

I hope you're well and safe!

Try something like this.

=IF([PO Number]@row = "", "", IF(COUNTIF([PO Number]:[PO Number], [PO Number]@row) > 1, "Duplicate"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Navroz Kajani Take a look at @Andrée Starå's solution. It is pretty much the same thing I would have suggested.