| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique values in an array.
Is there a way, in Excel 2003, to return a summary list of all the unique
values in an array? For example, in the following array of 10 values, there are only three unique values. How would I get excel to give me a list of the unique values? Array: BOB SUE JON JON SUE BOB BOB BOB JON JON I would like Excel to give me a list of the unique values in this array. i.e - BOB SUE JON Any ideas? Thanks, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning an array of unique values? | Excel Worksheet Functions | |||
| Array formula for unique values | Excel Worksheet Functions | |||
| Array formula for unique values | Excel Worksheet Functions | |||
| Non-unique elements in an array | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Threaded Mode
