• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get combinations in grid format

syp1677

Member
Dear Gurus,
I want to construct a combinations in grid form. Please find attached sample data.
Row C2:H2 represents reagents and C3:H14 represent the respective lots of the reagents for combination.
Row C16:H16 count of number of lots of each reagents. Product of these should not exceed 96 (cell # E18).
I want to show combinations in grid format as represented in L3:V17. Grid can be at the max 18(rows) x 11(columns).
Your help in this will be highly appreciated.
Best Regards,
S
 

Attachments

  • Sample16012023.xlsx
    11.3 KB · Views: 4
Back
Top