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
|