Issues with Advanced Filter

  • Thread starter Thread starter quiggle
  • Start date Start date
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!
 
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, 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
 
Back
Top