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 |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com