Dynamic Combinations In Excel from 3 Lists
Learn how to create dynamic combinations (or all permutations) from 3 lists so they automatically adjust to include added items without the need to copy formulas down or change any cell references. And it works with standalone Excel and Microsoft 365.
Excel Version
Recorded using Excel Pro Plus 2021
MS 365 gets regular updates and in some cases, new functions, which could make this solution simpler or even different.
Excel Tips Playlist
• EXCEL TIPS