View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default 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