Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtotal question?
I did a subtotal function. I was in trouble of extracting just those cells containing subtotals without copying those detailed cells. How can I have a pure "subtotal" only worksheet? Thank you. -- wonderdogs828 ------------------------------------------------------------------------ wonderdogs828's Profile: http://www.excelforum.com/member.php...o&userid=30086 View this thread: http://www.excelforum.com/showthread...hreadid=497714 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtotal question?
Hi,
Whats the formula you used. For picking up only subtotals, use =SUBTOTAL(9,RANGE) Regards Govind. wonderdogs828 wrote: I did a subtotal function. I was in trouble of extracting just those cells containing subtotals without copying those detailed cells. How can I have a pure "subtotal" only worksheet? Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtotal question?
See response in excel.misc
-- HTH RP (remove nothere from the email address if mailing direct) "wonderdogs828" wrote in message news:wonderdogs828.212xj0_1136326506.2218@excelfor um-nospam.com... I did a subtotal function. I was in trouble of extracting just those cells containing subtotals without copying those detailed cells. How can I have a pure "subtotal" only worksheet? Thank you. -- wonderdogs828 ------------------------------------------------------------------------ wonderdogs828's Profile: http://www.excelforum.com/member.php...o&userid=30086 View this thread: http://www.excelforum.com/showthread...hreadid=497714 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal question | Excel Discussion (Misc queries) | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Subtotal Question | Excel Worksheet Functions | |||
Subtotal question | Excel Worksheet Functions |