| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numerical problems... | Excel Worksheet Functions | |||
| Entering a range of numbers and searching same | Excel Discussion (Misc queries) | |||
| Preventing user entering duplicate values in a cell range | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Linear Mode
