You can use an advanced filter to extract the unique values from a
column in the table. There are some instructions he
http://www.contextures.com/xladvfilter01.html#FilterUR
cribeiro wrote:
When we apply filters in a range of data we can see that there aren't
duplicates in the filter columns.
Is it possible to get these itens from these filters?
Where are these data? Are they in one array, collection or what?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html