Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
listing unique entries from the entire worksheet
Hello guys,
I wonder if it's possible to list (in one column, on a newly created sheet) all the unique entries from the entire worksheet (or at least from a range that is larger than one column), f. ex. A2:G50... Thanks for any hints! VBA welcome... Cheers, Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
listing unique entries from the entire worksheet
Hi
Create a pivot table, where all values in column are counted (without any summary rows). Arvi Laanemets "markx" wrote in message ... Hello guys, I wonder if it's possible to list (in one column, on a newly created sheet) all the unique entries from the entire worksheet (or at least from a range that is larger than one column), f. ex. A2:G50... Thanks for any hints! VBA welcome... Cheers, Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
listing unique entries from the entire worksheet
Try Data - Advanced Filter - Unique items only.
-- Damon Longworth 2006 East Coast Excel User Conference April 19/21st, 2006 Holiday Inn, Boardwalk Atlantic City, New Jersey Early Bird Registration Now Open!! www.ExcelUserConference.com 2006 UK Excel User Conference Summer, 2006 London, England "markx" wrote in message ... Hello guys, I wonder if it's possible to list (in one column, on a newly created sheet) all the unique entries from the entire worksheet (or at least from a range that is larger than one column), f. ex. A2:G50... Thanks for any hints! VBA welcome... Cheers, Mark |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
listing unique entries from the entire worksheet
On Wed, 15 Feb 2006 13:02:24 +0100, "markx"
wrote: Hello guys, I wonder if it's possible to list (in one column, on a newly created sheet) all the unique entries from the entire worksheet (or at least from a range that is larger than one column), f. ex. A2:G50... Thanks for any hints! VBA welcome... Cheers, Mark You could use the UNIQUEVALUES function from Longre's free morefunc.xll add-in available from: http://xcell05.free.fr It will return a single column array of the UNIQUEVALUES in a multi-column, multi-row range. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing a selection of data from one worksheet on another | Excel Discussion (Misc queries) | |||
Counting Unique text entries in a sheet with a condition | Excel Worksheet Functions | |||
Delete ENTIRE row after updating info in worksheet. | Excel Worksheet Functions | |||
Refrencing an entire worksheet? | Excel Discussion (Misc queries) | |||
filter list of text for unique entries using formulea | Excel Worksheet Functions |