View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tickfarmer Tickfarmer is offline
external usenet poster
 
Posts: 17
Default Subtotal To Include Item Description On Subtotal Line

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

--
Tickfarmer