Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I count unique strings of data in a field? | Excel Discussion (Misc queries) | |||
How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
strings in a range | Excel Worksheet Functions | |||
Convert text strings to a code or number | Excel Worksheet Functions | |||
counting unique strings | Excel Discussion (Misc queries) |