AutoFilter lists unique values

[Guest]

I have a large list of material invoices. There are material ID numbers that
reoccur on each invoice. When I activate the Auto Filter I see a list of
unique values in the drop down. Is there a simple way to get this unique list?

 

[JulieD]

Hi

Check out Debra Dalgleish's notes on using Advanced Filtering to extract a
list of unique values at
http://www.contextures.com/xladvfilter01.html

 

[Guest]

One way: You can use the Advanced Filter to get a unique list from a column.
Be sure to copy to a different location to avoid losing data.

 

[Alan Beban]

I have a large list of material invoices. There are material ID numbers that
reoccur on each invoice. When I activate the Auto Filter I see a list of
unique values in the drop down. Is there a simple way to get this unique list?

No claims as to simplicity, but if the functions in the freely
downloadable file at http:/home.pacbell.net/beban are available to your
workbook

=INDEX(ArrayUniques(data_range),ROW(A1)) copied down until you get a
#REF! error

Alan Beban