From: Tickfarmer on 23 Feb 2010 11:16 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 From: Dave Peterson on 23 Feb 2010 11:39 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. Tickfarmer wrote:> > 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 -- Dave Peterson From: Tickfarmer on 23 Feb 2010 14:56 Hi Dave. Thanks so much for the suggestion. With some slight editing of your formula, I have accomplished my goal. Appreciate your help. -- Tickfarmer "Dave Peterson" wrote: > 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. > > > > Tickfarmer wrote: > > > > 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 > > -- > > Dave Peterson > . >  |  Pages: 1 Prev: Conditional formatingNext: Multiple IF and a sum