Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicated values | Excel Discussion (Misc queries) | |||
How to delete duplicated values in each row ??? | Excel Discussion (Misc queries) | |||
Formula to Check Values between to variables | Excel Worksheet Functions | |||
To find duplicated values in a range | Excel Worksheet Functions | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions |