All Values in a Filter.....

[camster39]

Is there a way I can retrieve all the possible values from my auto-filter?

For example, I've got an auto-filter setup on a very large spreadsheet. In column B, for example, when I click the drop down I get about 60 or so values. Can I export these values or generate a list of these values?

Or is there a better workaround that I'm not thinking of.

Using Excel 2000. Thank you.

 

[xlbo]

have a look at ADVANCED filter. You can get a list of unique values from that

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question