Entering numerical range

V

Vi

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
 
M

Max

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
M

Max

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

Max

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