unique values

[shawn]

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!

 

[Frank Kabel]

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