Forum Discussion
to get only the marked cells in a row.
in one row i have multiple products name (40 products). But i out of 40 i would have marked only few of them.
I need only that marked products to display in another sheet.
can someone help me here.
How did you mark those products?
- by entering the number of quantity that product is purchased. Like 1, 2 etc.
Let's say that you have a sheet named Products with product names in row 1 and quantities in row 2:
On anther sheet, enter the following formula in A1:
=FILTER(Products!A1:F1, Products!A2:F2>0)Result:
The formula result will spill to as many cells as needed.
You'll have to adjust this for your setup, of course.
