A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2009, 07:17 PM posted to microsoft.public.excel.worksheet.functions
Mr. Low
external usenet poster
 
Posts: 549
Default 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  
Old April 14th, 2009, 01:11 AM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.