Issues with Advanced Filter
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! |
Issues with Advanced Filter
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 |
Issues with Advanced Filter
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 |
Issues with Advanced Filter
Duh, I totally forgot about the past special...Thanks that worked great!
|
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com