| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal Function
I understand the Subtotal function only ignores hidden data in rows. Is
there a similar function that will ignore hidden data in columns? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Function
Hi
No built in function but look at the workaround produced by Debar Dalgleish http://www.contextures.com/HideMarkedCols.zip -- Regards Roger Govier "lindsayhyle" wrote in message ... I understand the "Subtotal" function only ignores hidden data in rows. Is there a similar function that will ignore hidden data in columns? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Function
produced by Debar Dalgleish Or even Debra Dalgleish. Sorry Deb, it's late and last night was an all-nighter. Well that's my excuse anyway<g I even got Dalgleish as Dalgelish this time till spell checker picked it up. Definitely time for bed. -- Regards Roger Govier "Roger Govier" wrote in message ... Hi No built in function but look at the workaround produced by Debar Dalgleish http://www.contextures.com/HideMarkedCols.zip -- Regards Roger Govier "lindsayhyle" wrote in message ... I understand the "Subtotal" function only ignores hidden data in rows. Is there a similar function that will ignore hidden data in columns? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal Function
Thanks! I will give that a try.
"Roger Govier" wrote: produced by Debar Dalgleish Or even Debra Dalgleish. Sorry Deb, it's late and last night was an all-nighter. Well that's my excuse anyway<g I even got Dalgleish as Dalgelish this time till spell checker picked it up. Definitely time for bed. -- Regards Roger Govier "Roger Govier" wrote in message ... Hi No built in function but look at the workaround produced by Debar Dalgleish http://www.contextures.com/HideMarkedCols.zip -- Regards Roger Govier "lindsayhyle" wrote in message ... I understand the "Subtotal" function only ignores hidden data in rows. Is there a similar function that will ignore hidden data in columns? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal function | Excel Worksheet Functions | |||
| subtotal function | New Users to Excel | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
| Subtotal function | Excel Worksheet Functions | |||
Linear Mode
