Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a formula that will help me generate a sequential list. My values are
as follows note that the "+" is strictly text and has no mathematical significance): 0+83, 0+88, 0+93, 0+98, 1+03, 1+08, 1+13, .... The number before and after the "+" change per each report but the number after the "+" always increases by 5. The number before the "+" increases by 1 once the numbers after the "+" exceed 100 (so that there are only ever 2 space values after the "+"). Someone please help as I have to generate hundreds of these reports. FYI the numbers reference a station on a CAD drawing and I will later be inputting voltage potential data in the cells adjacent the stations so that the report will show a location corresponding to a potential. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sequential text and numbers problem | Excel Discussion (Misc queries) | |||
Sequential Numbers | Excel Discussion (Misc queries) | |||
Sequential Numbers | Excel Discussion (Misc queries) | |||
sequential numbers | Excel Worksheet Functions | |||
sequential numbers | Excel Discussion (Misc queries) |