Prev: Conditional formating
Next: Multiple IF and a sum
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 formating
Next: Multiple IF and a sum