| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a 8X3 table to a vertical range of the Unique stringsonly
Excel 2007
Converts any size table. Uses no formulas. Dynamic. Can be turned into a Macro or UDF. http://www.mediafire.com/file/gz53tygeznz/04_30_09.xlsx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a 8X3 table to a vertical range of the Unique strings
Thanks, Herbert,
Can this be achieved, that way, in Excel versions prior "2007" !? Mike "Herbert Seidenberg" wrote: Excel 2007 Converts any size table. Uses no formulas. Dynamic. Can be turned into a Macro or UDF. http://www.mediafire.com/file/gz53tygeznz/04_30_09.xlsx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a 8X3 table to a vertical range of the Unique strings
Excel 2003
Since "Remove Duplicates" is not featured in 2003, this macro implementation is clunky: http://www.mediafire.com/file/yzmlmlnlmjk/04_30_09.xls |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a 8X3 table to a vertical range of the Unique strings
Thanks, Herbert.
"Herbert Seidenberg" wrote: Excel 2003 Since "Remove Duplicates" is not featured in 2003, this macro implementation is clunky: http://www.mediafire.com/file/yzmlmlnlmjk/04_30_09.xls |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
