SOLVED

# Excel Auto Fill in Number range

Copper Contributor

# 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.

best response confirmed by IUH_Telecom (Copper Contributor)
Solution

# Re: Excel Auto Fill in Number range

=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.

1 best response

Accepted Solutions
best response confirmed by IUH_Telecom (Copper Contributor)
Solution

# Re: Excel Auto Fill in Number range

=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.