J
Jerry
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
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