Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotal function
I have a list of item numbers, descriptions, quantity sold and few other
fields. Data looks like this Item Description unit Cost Quantity 123 Rubberband LB 1.00 2 123 Rubberband LB 1.00 4 123 Rubberband LB 1.00 2 124 Note pad Ea 1.50 1 124 Note pad EA 1.50 3 When I sort by Item number and subtotal I get 123 Rubber band LB 1.00 2 123 Rubberband LB 1.00 4 123 Rubberband LB 1.00 2 123 Total 8 124 Note pad Ea 1.50 1 124 Note pad EA 1.50 3 124 Total 4 When I collapse it to subtotals only I get 123 Total 8 124 Total 4 Is there any way to include the description on the subtotal line? gls858 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotal function
You can get the names under each item number by sorting a second time.
Use something like "Count" in the Name column and *uncheck* <Replace Current SubTotals -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "gls858" wrote in message ... I have a list of item numbers, descriptions, quantity sold and few other fields. Data looks like this Item Description unit Cost Quantity 123 Rubberband LB 1.00 2 123 Rubberband LB 1.00 4 123 Rubberband LB 1.00 2 124 Note pad Ea 1.50 1 124 Note pad EA 1.50 3 When I sort by Item number and subtotal I get 123 Rubber band LB 1.00 2 123 Rubberband LB 1.00 4 123 Rubberband LB 1.00 2 123 Total 8 124 Note pad Ea 1.50 1 124 Note pad EA 1.50 3 124 Total 4 When I collapse it to subtotals only I get 123 Total 8 124 Total 4 Is there any way to include the description on the subtotal line? gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Subtotal function | Excel Discussion (Misc queries) | |||
subtotal function | New Users to Excel | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Subtotal function (again) | Excel Worksheet Functions |