I have a spreadsheet with 8 columns and I constantly add more rows. One of
the columns is a value of something, in this case time, but that doesn't
matter, it could be just any type of number.
I usually use auto filter on that sheet, but this time I needed one of two
conditions to be true for the same column (D), so a standard filter seemed
to be the way to go.
So I opened the Standard filter dialogue and made my filtered data to land
at an empty sheet, starting at A1.
Then, on that new sheet, I summed one column, F. I got my value and was
happy with that.
However, remembered that I could do the same thing without needing to copy
the filtered data anywhere, by just filter on the same sheet and then sum
the visible cells by =SUBTOTAL(9;F1:F65536), but this time I didn't get
the same result!
After maybe half an hour of debugging I found that one of the rows got the
wrong value in the copy that I pasted on that empty sheet, since some of
the rows in column F are formulas. So one of the rows was like =F25-F23.
That is okay on the original sheet, but the filtered copy lacks one of the
rows and the formula gives therefore the wrong result.
I then opened the Standard filter dialogue again to see if there is a way
to paste the filtered data to a sheet with no formulas involved, you know,
like Paste Special with Formulas unchecked, but I didn't find an option
like that.
I think this would be a nice feature to add, or am I totally out of my
mind?
Just wanted to hear your opinions before I report a feature request.
--
Best regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
