Forum Discussion

DobeJR's avatar
DobeJR
Copper Contributor
May 01, 2020
Solved

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...
  • ExcelExciting's avatar
    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

Resources