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....
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?
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.
Let's say that
1) The sheet in your screenshot is named Products, and
2) the products are in H1:U1, and
3) You enter a serial number in A1 on another sheet.
Formula for the marked items for this serial number:
=TRANSPOSE(FILTER(Products!H1:U1, FILTER(Products!H2:U100, Products!A2:A100=A1)>0))- HansVogelaar
Hi i tried, but it is not working. Can you please send me the same in an excel sheet. Or is there any issue relating to the MS version or something? Need your guidance
HansVogelaar Thank you very much. I got my solutions.