View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
מיכאל (מיקי) אבידן ® מיכאל (מיקי) אבידן ® is offline
external usenet poster
 
Posts: 5
Default Convert a 8X3 table to a vertical range of the Unique strings only

Hi,

I have got a 2 dim. table (8 rows by 3 columns).

24 strings (2-3 characters each) were typed into the table - however only 8
of them are unique - meaning, some of them appear more than once.

I'm looking for a Worksheet Function in order to present only the unique
strings in adjacent(!) cells in a vertical range in col. A

If the results in the vertical range could be sorted, in ascending order,
will be fine.

(I know how to achieve that with 1-2 helper columns but I prefer solving it
without those helpers).

With your permission I uploaded a picture to
in order to emphasize what I have in mind.

http://img299.imageshack.us/img299/7...iquevalues.png

Thanks, Mike