Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002-7: Modifying Sub Total Function to allow insert blank r
Hi,
I have an idea to make use of the subtotal table to insert an empty row below a change of certain reference in column C as ilustrated below: A B C D Flight Fare Type 1 M21 2,250 1 2 H32 2,530 1 3 T30 850 2 4 Q41 750 2 5 C47 650 2 6 Q21 3,650 8 7 Q72 3,820 8 5000 At pressent the Sub Total function is use for summing, averaging and getting some other statistical derivations. It would be helpful to add one more function of addindg empty rows only. With this function, the user can use it to edit table with long listing of item whiout having to learn the Macro code which is quite complicated. For the next generation of Excel, I am really looking for more useful functionality previously done by Macro could be simplify into desktop function such as the one under Pivot Table and Sub total Table. I hope my suggestion helps. Thanks -- A36B58K641 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002-7: Modifying Sub Total Function to allow insert blank r
Hi,
You can try something like this. 1. Sort the range below in ascending order by column C; 2. Now highlight the range and go to Data Subtotals. Use the sum function for every change in Type and add the result to Fare 3. Now click on 1 at the top left corner (the outline symbol). Once you do so, the rows with the total fares will be vivible Highlight the range which and press Alt+; to highlight the visible cells. Now hit the delete key. You will now get a blank row for each change in column C -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mr. Low" wrote in message ... Hi, I have an idea to make use of the subtotal table to insert an empty row below a change of certain reference in column C as ilustrated below: A B C D Flight Fare Type 1 M21 2,250 1 2 H32 2,530 1 3 T30 850 2 4 Q41 750 2 5 C47 650 2 6 Q21 3,650 8 7 Q72 3,820 8 5000 At pressent the Sub Total function is use for summing, averaging and getting some other statistical derivations. It would be helpful to add one more function of addindg empty rows only. With this function, the user can use it to edit table with long listing of item whiout having to learn the Macro code which is quite complicated. For the next generation of Excel, I am really looking for more useful functionality previously done by Macro could be simplify into desktop function such as the one under Pivot Table and Sub total Table. I hope my suggestion helps. Thanks -- A36B58K641 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Any button to insert blank rows at specific interval? | Excel Discussion (Misc queries) | |||
Insert Blank Row Below Sub-Total? | Excel Worksheet Functions | |||
Excel 2002 Editing/Modifying a link | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Stop Insert Row modifying formula data | Excel Discussion (Misc queries) |