AutoFilter lists unique values
 

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?

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"R.J.H." wrote in message
...
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?

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.

"R.J.H." wrote:

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?

R.J.H. wrote:
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