Excel 2002-7: Modifying Sub Total Function to allow insert blank r

M

Mr. Low

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/com...dg=microsoft.public.excel.worksheet.functions
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top