show a filter of a range
 

I have a pricing grid with item names in column A, quantities in column B,
rates in column C, and total price in column D. There are about 60 labels,
but the items vary each time a different combination is priced.


I would like to show in column G: only the names of items with quantities,
with their corresponding total price in column H. Any ideas on how best to
do this?

thanks in advance,

Andy

show a filter of a range
 

Hi

Apply an Autofilter to your label Row
use the dropdown on the Quantity column to select (NonBlanks)

--
Regards
Roger Govier

"AJB" wrote in message
...
I have a pricing grid with item names in column A, quantities in column B,
rates in column C, and total price in column D. There are about 60
labels,
but the items vary each time a different combination is priced.


I would like to show in column G: only the names of items with quantities,
with their corresponding total price in column H. Any ideas on how best
to
do this?

thanks in advance,

Andy