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

A Rose

Any formula, if there's a duplicate in this column, say: "Duplicate"?

Thank you!

Paul Newcome

Try something like this...

=IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) > 1, "Duplicate")

Paul Newcome

Ok. Put it in any column OTHER than that column.

You cannot put the formula in the column that you are referencing.

Paul Newcome

Try something like this...

=IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) > 1, "Duplicate")

A Rose

@Paul Newcome

Amazing!

Thank you!

JeremiahHorstick

=COUNTIF([Check Duplicates]:[Check Duplicates], [Check Duplicates]@row)

If the count function returns a value greater than 1 there is a duplicate.

A Rose

@Paul Newcome

I actualy have now "#CIRCULAR REFERENCE"

What are the column names?

i want to see if "column 1" has duplicate, what's my formula?

Thank you!

Paul Newcome

You would need to put the formula into a different column and reference the column that you are wanting to evaluate.

A Rose

would this be good?

it syays blocked..

=COUNTIF([All Names]:[All Names], >1, "Duplicate")

@Paul Newcome

Thank you!

Paul Newcome

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

Put this in any text/number column other than the [All Names] column and it should work.

A Rose

@Paul Newcome

I got "#CIRCULAR REFERENCE" as a response..

Please let me know.

Thank you!

Paul Newcome

What column are you putting the formula in?

A Rose

In the all names column

@Paul Newcome

Paul Newcome

Ok. Put it in any column OTHER than that column.

You cannot put the formula in the column that you are referencing.

A Rose

@Paul Newcome

I put that in,

I'm getting now

"#BLOCKED"

A Rose

@Paul Newcome

I didn't do it correctly.

Now it's perfect.

Thank you!!

Is there a way it should say, duplicate, but only when column b has a value?

Paul Newcome

Try this...

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

A Rose

Got this

@Paul Newcome

#INCORRECT ARGUMENT SET