ExcelBanter - Formula to check duplicated values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to check duplicated values (https://www.excelbanter.com/excel-discussion-misc-queries/133050-formula-check-duplicated-values.html)

Mary

Formula to check duplicated values

Hi!
Can you please a formula or advise how can I check duplicated values on the
same colum.
Example: Column A
24L36
29R50
45P78
24L36
29R51
45P76
29R50

Toppers

Formula to check duplicated values

Put this in column B and copy down:

=IF(COUNTIF(A:A,A1)1,"Duplicate","")

HTH

"Mary" wrote:

Hi!
Can you please a formula or advise how can I check duplicated values on the
same colum.
Example: Column A
24L36
29R50
45P78
24L36
29R51
45P76
29R50

Mary

Formula to check duplicated values

Thank you so much.

"Toppers" wrote:

Put this in column B and copy down:

=IF(COUNTIF(A:A,A1)1,"Duplicate","")

HTH

"Mary" wrote:

Hi!
Can you please a formula or advise how can I check duplicated values on the
same colum.
Example: Column A
24L36
29R50
45P78
24L36
29R51
45P76
29R50

All times are GMT +1. The time now is 03:03 PM.