unique values
 

I have a table of data in Sheet1 A1:Z100. In Coumn A of
Sheet 2 I need to list all the unique entries in the table
in Sheet1 whose values are between 1 and 10 (it can ignor
all other values). Please help!

unique values
 

Hi
use 'Data - Filter - Advanced Filter' for this. Also try Ron's Filter
addin for this:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"shawn" schrieb im Newsbeitrag
...
I have a table of data in Sheet1 A1:Z100. In Coumn A of
Sheet 2 I need to list all the unique entries in the table
in Sheet1 whose values are between 1 and 10 (it can ignor
all other values). Please help!