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 |
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. |
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 |
All times are GMT +1. The time now is 06:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com