Forum Discussion
Solved
Excel Auto Fill in Number range
I just started porting telephone numbers between 4 different carriers. When I get numbers from a telephone carrier the numbers are in a range. Area Code TN Range Begin TN Range End ...
=DROP(REDUCE("",SEQUENCE(ROWS(B2:C3)),LAMBDA(x,y,VSTACK(x,SEQUENCE(INDEX(B2:C3,y,2)-INDEX(B2:C3,y,1)+1,1,INDEX(B2:C3,y,1),1)))),1)
With Office 365 or Excel for the web you can apply this formula.
=DROP(REDUCE("",SEQUENCE(ROWS(B2:C3)),LAMBDA(x,y,VSTACK(x,SEQUENCE(INDEX(B2:C3,y,2)-INDEX(B2:C3,y,1)+1,1,INDEX(B2:C3,y,1),1)))),1)
With Office 365 or Excel for the web you can apply this formula.