Forum Discussion
Solved
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....
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.
- Thank you for the solution.
Can i get the same in column, one below the other.
I want to generate a bill for each row in the data base. Hope you can understand?Basically i need to generate a bill for each serial number entry. so if i enter the serial number in another sheet, as mentioned before only the marked products should display one below the other for that serial number alone.