T
Tickfarmer
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?
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?