| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Checking for duplicate items in list
If I have a list of items is there anyway to check to see if any of them are duplicated? I.e. check to see if the same entry has been made more than once? The list I have at the moment looks something like this: Name ------- Susan Bob Michael Roger Bob Anne So the name "Bob" appears twice, so how do I get Excel to check every entry in the list and to see if it appears more than once? Cheers -Rob -- TheRobsterUK ------------------------------------------------------------------------ TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924 View this thread: http://www.excelforum.com/showthread...hreadid=483996 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbering items from a list in order | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
Threaded Mode
