identifying a duplicate entry

johann

hello, Im looking for a formula to red flag all the duplicates entry in a previous column. Above an image that what can im looking for, thanks

Im put the red flag manually for show you.

Matt Johnson

Hi there,

I think this should work:

=IF(COUNTIF(Referencia:Referencia, Referencia@row) > 1, 1)

Have a great day.

Matt

Matt Johnson

Hi there,

I think this should work:

=IF(COUNTIF(Referencia:Referencia, Referencia@row) > 1, 1)

Have a great day.

Matt

johann

thanks a lot. Works perfectly. Only that we should convert to column formula right??

thanks again

Johann