View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiAD LiAD is offline
external usenet poster
 
Posts: 386
Default Unique value list

Hi,

I have found the following formula which I'm trying to use to try to sort a
table of four columns into a list of unique values - but I can't get it to
work!

My data is in cols Z3 to AE100, its a mix of text and numbers. It looks
something like

A3 BB A4 DD
BB A4 CC EE
A3 A4 EE A1

I would like a list outputted that reads (in any order whatsoever)

A3
BB
A4
DD
EE
A1
CC

Is this possible?

Thanks in advance