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!