Issues with Advanced Filter

Q

quiggle

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!
 
Q

quiggle

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
 
G

gjcase

I assume there is a reason you need to keep the formulae? If so, yo
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 function
(DGet, DSUM, DCOUNT, etc).

--Glen
 
Top