Excel Formula: Combination Formula for 2 Sets of Data
I currently use this Excel formula to give me the possible combinations from 2 sets of data. With the combinations, I can easily allocate them to various other breakups or sub-divisions. Example: My reporting levels are divided into country and division. Countries 1. Canada 2. USA 3. UK Divisions 1. Retail 2. Service 3. Warehouse …
Excel Formula: Combination Formula for 2 Sets of Data Read More »