| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
