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