Subtotal To Include Item Description On Subtotal Line

T

Tickfarmer

I am using the subtotal feature on data listed below. I have requested a
subtotal of item qty at every change in the item number. The subtotal line
will return the item number and the subtotaled qty. This is good. However,
I wold also like the item description to be included on the subtotal line.
How do I accomplish this?

Item Number Item Description Item Qty
RM Red Mug 100
RM Red Mug 25
RM-2 Red Dot Mug 49
RM-2 Red Dot Mug 2
 
D

Dave Peterson

Data|Subtotal won't do this on its own.

I'd insert a helper column in column A and add a formula:

=left(b2&rept(" ",30),30)&"-"&c2
and drag down

Then use that as the control field in the subtotals.
 
T

Tickfarmer

Hi Dave. Thanks so much for the suggestion. With some slight editing of
your formula, I have accomplished my goal. Appreciate your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top