Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Multiple Cells when Using Subtotal Function
I have a 12 column 200 row table for which I will have two subtotals. The
first will subtotal the invoice value by customer number, then by invoice number. (A nested subtotal function) Once subtotals are complete, I want to list the customer name next to the customer number on the first subtotal function. The customer name is in one of the columns in the spreadhseet. I also want to list the invoice date next to the invoice number on the second subtotal function. The invoice date is in one of the columns in the spreadsheet. Please advise how do do this using the subtotal function. I would rather note concatenate the data together prior to subtotal. Is there some other way? -- Tickfarmer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get subtotal line to display other column? | Excel Discussion (Misc queries) | |||
Nested subtotal display error | Excel Discussion (Misc queries) | |||
Display data from multiple worksheets' cells in one worksheet | Excel Worksheet Functions | |||
Search multiple columns and display corresponding cells in a list?!? | Excel Discussion (Misc queries) | |||
multiple results display after filter function | Excel Worksheet Functions |