AutoFilter lists unique values

R

R.J.H.

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?
 
P

PegL

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.
 
A

Alan Beban

R.J.H. said:
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?
Click to expand...
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
 
Top