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