How can I use a Conditional Rule in one column to drive what is diplayed in another?

[The Fuge]

I have a conditional rule which identifies duplicate records in column A.

If the condition is true, I want to display a value "duplicate" in column B.

I cannot find any info on how to display a random value based on a conditional rule.

 

[bbott]

Welcome to the board.

Try this in B1 and copy down:

=IF(COUNTIF(A:A,A1)>1,"duplicate","")

 

[sheetspread]

How about an if/countif formula that returns "" or "duplicate"?

 

[The Fuge]

Welcome to the board.

Try this in B1 and copy down:

=IF(COUNTIF(A:A,A1)>1,"duplicate","")

That did it! Thank You!

 

[bbott]

That did it! Thank You!

You're welcome.