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