Issues with Advanced Filter

[[email protected]]

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!

[[email protected]]

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

[gjcase]

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

[[email protected]]

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