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 |
999 | 5555160 | 5555165 |
999 | 5556401 | 5556450 |
When I submit the port to another carrier they want each number listed individually, like this.
Area Code | TN Range Begin |
999 | 5555160 |
999 | 5555161 |
999 | 5555162 |
999 | 5555163 |
999 | 5555164 |
999 | 5555165 |
Can excel look at the TN Range Begin and TN Range End and fill in all the numbers in between? Doing this manually by putting the TN Range Begin in a column and then dragging down till I get to what the TN Range End works but is time consuming.
=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.
