I am trying to use the advanced filter to grab distinct values from a
column on my spreadsheet and copy it to a different location. This
works fine if the column that I am trying to grab them from has actual
values, not formulas. If the column has formulas, I get an error
saying that the extract field has a missing or illegal field name.
After hitting ok, it gives me one of the values,but not all, and if I
do this on a different column with a formula, it doesn't give me the
correct values at all. Any ideas?

Thanks!

Oh, also, sometimes when it is giving the correct value, it is pasting
the original formula from the source column, but the cell references
have changed.

Thanks!
Aimee

I assume there is a reason you need to keep the formulae? If so, you
could copy the the column to a new column using Paste Special/Values &
then use the filter.

Alternatively, you may want to look at some of the Database functions
(DGet, DSUM, DCOUNT, etc).

--Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=523242

Duh, I totally forgot about the past special...Thanks that worked great!