| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table using very large dataset | Excel Discussion (Misc queries) | |||
| How to create a data list from a pivot table | Excel Discussion (Misc queries) | |||
| How do I create a combination chart and table with different data. | Charts and Charting in Excel | |||
| Multi-Sheet Pivot Table Too Large | Excel Discussion (Misc queries) | |||
| Pivot Table Too Large? | Excel Discussion (Misc queries) | |||
Threaded Mode
