ExcelBanter - View Single Post - Convert a 8X3 table to a vertical range of the Unique strings only

Thread: Convert a 8X3 table to a vertical range of the Unique strings only

View Single Post

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Herbert Seidenberg Herbert Seidenberg is offline

Herbert Seidenberg is offline

external usenet poster

Posts: 1,180

Default

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

Reply With Quote

Reply With Quote