| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create list of unique entries for use in validation
Is there a function/formula I can put into a series of cells which can look
at a list (with repeat entries) and simply return the unique one. E.g. Tomato Tomato Banana Tomato Pear Banana Apple Pear Apple Tomato Would be displayed as Tomato Banana Pear Apple Then I can use Validation on this 'filtered' selection to create a drop down selection box. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| Unique list of entries | Excel Worksheet Functions | |||
| DataValidationList - Unique Entries | New Users to Excel | |||
| Best way to get a list of unique entries in a field | Excel Worksheet Functions | |||
| counting unique entries in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
