| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Just the Unique Entries From a Range of Cells
I have a range of 1000 cells..A1:1000. This range holds the favorite
restaurant list as provided by our customers. So, in each cell is a restaurant name. There are approximately 50+/- unique restaurant names in these 1000 cells. Many are obviously repeated since different customers say the rest is their favorite too. How do I extract this list of the 50+/- unique restaurants mentioned in the range of 1000 cells? and place these unique names in B1:50? I need the unique list so that I can then count the number of occurrences of each unique name and then rank them. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find number of unique entries within a date range | Excel Worksheet Functions | |||
| Find number of unique entries within a date range | Excel Worksheet Functions | |||
| Count unique entries in data range | Excel Worksheet Functions | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| How do I return the unique entries from a column to a listbox | Excel Worksheet Functions | |||
Threaded Mode
