show a filter of a range

[AJB]

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

 

[Roger Govier]

Hi

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