Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals
OK i ned some help what i have is a spread sheet that is sorted by INvestor
number. WHat i need is to have a sub total placed 2 spaces below the total that contains a total for each one of the investor numbers that show up in the Investor number column. I will need the matching investor number to go along with the subtotal. SO what do you guys think? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals
You can use the builtin subtotals command under the Data menu. It won't do
the spacing your want, but would be a good start. It also applies outlining. -- Regards, Tom Ogilvy "jln via OfficeKB.com" wrote: OK i ned some help what i have is a spread sheet that is sorted by INvestor number. WHat i need is to have a sub total placed 2 spaces below the total that contains a total for each one of the investor numbers that show up in the Investor number column. I will need the matching investor number to go along with the subtotal. SO what do you guys think? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals
I was thinking along the same lines but what i didnt know how to place the
subtotals by investor number below the sum line in the columns that i need then to go to. Tom Ogilvy wrote: You can use the builtin subtotals command under the Data menu. It won't do the spacing your want, but would be a good start. It also applies outlining. OK i ned some help what i have is a spread sheet that is sorted by INvestor number. WHat i need is to have a sub total placed 2 spaces below the total [quoted text clipped - 3 lines] SO what do you guys think? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals function offset subtotals summary | Excel Programming | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |