Show all filled cells

  • Thread starter Thread starter vcff
  • Start date Start date
V

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
 
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
 
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
 
Back
Top