It sure seems like a small step (to me, anyway) to make =subtotal(1##,...) work
with hidden columns.
But who the heck knows, well outside of MS?
Bob Phillips wrote:
I am not sure what I was thinking now, as it couldn't have worked. You can't
filter a row, so if anything in A1:E1 is filtered, it all is. Oh well. Poor
implementation though, they obviously just carried the existing
functionality, without considering that whilst columns may not get hidden by
filter, they can by manually hiding.
Bob
"Dave Peterson" wrote in message
...
=subtotal(9,a1:e1)
didn't exclude cells in hidden columns for me in xl2003.
(Did you really mean to type columns in your question?)
Bob Phillips wrote:
Thanks Dave, that explains it. Do you know why as SUBTOTAL(9 works fine
with
columns?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Dave Peterson" wrote in message
...
=subtotal(109,....) works nicely with hidden rows--not so nicely with
hidden
columns in xl2003.
Bob Phillips wrote:
Something like =SUBTOTAL(109,A1:E1) should work in those
circumstances.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"starguy"
wrote
in
message ...
I have hidden columns not rows. I hide them by both ways using
Ctrl+9
and by menu Format Column Hide but nothing happened after
hiding.
I
also pressed F9 to recalculate after hiding columns.
Bob Phillips Wrote:
How have you hidden the rows?
--
HTH
Bob Phillips
--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=537953
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson