Show all filled cells

[vcff]

Hi All

Col A & B is product code, col C... is customer list
To show only the products with pricing
e.g. if row 26, C1 to GR no cell is fill (no pricing), it will not show row
26.
Any help?

Thanks

 

[Per Jessen]

Hi

You can use an autofilter to filter away rows with blank pricing cells.

Select the entire table, goto Data > Autofilter.

In the pricing column filter on 'non-blank' cells.

Hopes this helps.
....
Per

 

[vcff]

Hi

Thanks but not what I want.

Autofilter will only filter single column.
What I need is column A & B is the product code, row 1 is the customer's data.
Range C2:GR201 is the pricing (with blank cells as customer is not
purchasing all 200 products).

Does not want to show products without selling price. (meaning if there is
no pricing for certain product, to hide the product (row).

Thanks