Entering numerical range
 

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

Entering numerical range
 

what do you want to do with it?
you could always just type it in,

"Vi" wrote:

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

Entering numerical range
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vi" wrote:
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

Entering numerical range
 

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

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

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

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

Rick

Entering numerical range
 

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

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

Cell c3 needs to be 45650-45674

I'd rather leave it as the former.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Entering numerical range
 

=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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---