Entering numerical range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to enter a numerical range in several adjacent cells. E.G.:
Cell c3 needs to be 45650-45674
Cell c4 needs to be 45675-45699
Cell c5 needs to be 45700-45724

How can I do that?

Thanks
 
Place in any starting cell, eg in C3:
=45650+ROWS($1:1)*25-25&"-"&45674+ROWS($1:1)*25-25
Copy down as far as required
 
I want to enter a numerical range in several adjacent cells. E.G.:
Place in any starting cell, eg in C3:
=45650+ROWS($1:1)*25-25&"-"&45674+ROWS($1:1)*25-25
Copy down as far as required
Click to expand...

It looks like that formula can be shortened to this...

=45625+ROW()*25&"-"&45649+ROW()*25

Rick
 
It looks like that formula can be shortened to this...
=45625+ROW()*25&"-"&45649+ROW()*25
Click to expand...

Agreed Rick, but then it won't be so apparent how that relates to the
specified result in the top cell:

I'd rather leave it as the former.

---
 
=45625+ROW()*25&"-"&45649+ROW()*25
The above would also need to be adjusted (and hence be longer <g>)
if placed in other than the first row.

---
 
Back
Top