If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|