Forum Discussion
DobeJR
May 01, 2020Copper Contributor
Formula to spill an array a certain # of times?
Wondering if there is a Formula to spill an array a certain # of times? Any formulas to make this process easier would be awesome! I'm creating a lookup template file, and I need to have every c...
- May 02, 2020
Hi DobeJR
Please see the attached workbook with your desired results
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
May 02, 2020
Hi DobeJR
Please see the attached workbook with your desired results
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
DobeJR
May 14, 2020Copper Contributor
ExcelExciting Thanks for this. This is hurting my brain trying to understand how it's working with the MOD formula, but I think I get it.... lol
CHEERS!