| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Detect Duplicates
I have a list of values in B11 down to B97. The values are either numbers or
text, but there are no empty cells in the list. Is there a formula that will give me 0 if all the values are unique and give me 1 if any of the values are duplicated? Thanks in advance for any help. -- jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to detect characters with a cell? | Excel Discussion (Misc queries) | |||
| How to detect #N/A and return 0? | Excel Discussion (Misc queries) | |||
| detect cells with links | Excel Worksheet Functions | |||
| How to detect changes in a column? | Excel Discussion (Misc queries) | |||
| how to detect 5th character? | Excel Discussion (Misc queries) | |||
Threaded Mode
