| 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 | |||
Hybrid Mode
