Thread: unique values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree[_2_] scrabtree[_2_] is offline
external usenet poster
 
Posts: 47
Default unique values

Hello. I have posted this question a couple times and
haven't got the answer I need yet. Past suggestions have
suggested using advanced filter, but that don't do what I
need.

I have a table in Sheet1 A1:Z100. I need, in Sheet2
Column A:A a list of all the unique values in Sheet1
A1:Z100 that are between the values of 1 and 1,000.

Please help!