![]() |
How can I list every data combination from a large pivot table?
I've got 125 line items (text) I need to multiply out and show every
combination in 2 columns (15625 possible line item combinations). In addition, I will need to run formulas for each row so Merged Cells do not work. My closest attempt with reference data arrays and lookup functions could work, but I will need to c/p too much. I'd like to just fill-down my formulas. |
How can I list every data combination from a large pivot table?
|
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com