| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
unique occurences in list
Hi
I have a long list of hotel names in column A. Some of the hotel names occur more than once in the list, so the 500 item list only contains the names of about 180 different hotels. Is there a function I can use that will list in column B just the 180 different names,i.e. reduce the list in column A to just the unique occurences? Very grateful for any advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unique occurences in list | Excel Worksheet Functions | |||
| Finding unique records from a list. | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
