If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is it possible to do this?
I'm taking column A which has a header, column B has a header. Column A is a
numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in Column B. Column A 2.1 2.2 2.3 2.4 2.5 etc. on down Column A Column B acap at-echo at-nbp at-rtmp at-zis auth etc. How can I have this auto file down column A with numbers that have decimals? |
#2
|
|||
|
|||
Is it possible to do this?
HI,
let's say that 2.1 is in A2 in A3 enter =A2+0.1 Copy this formula down "Jim S" wrote: I'm taking column A which has a header, column B has a header. Column A is a numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in Column B. Column A 2.1 2.2 2.3 2.4 2.5 etc. on down Column A Column B acap at-echo at-nbp at-rtmp at-zis auth etc. How can I have this auto file down column A with numbers that have decimals? |
#3
|
|||
|
|||
Is it possible to do this?
It only works up to 2.9 than it changes to 3.0, 3.1,..,3.9 etc, than it
changes to 4.0, 4.1, etc. I would like to be able to copy down to 2.1 to 2.191 or higher, than switch to the next set of numbers such as 3.0 to 3.109 or what ever numbers i would like at that point. "Eduardo" wrote: HI, let's say that 2.1 is in A2 in A3 enter =A2+0.1 Copy this formula down "Jim S" wrote: I'm taking column A which has a header, column B has a header. Column A is a numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in Column B. Column A 2.1 2.2 2.3 2.4 2.5 etc. on down Column A Column B acap at-echo at-nbp at-rtmp at-zis auth etc. How can I have this auto file down column A with numbers that have decimals? |
#4
|
|||
|
|||
Is it possible to do this?
Try this in A2, and copy down as needed:
="2."&ROWS($1:1) When it's time to change sequence, just use the same formula from A2 and revise your starting series number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim S" wrote in message ... It only works up to 2.9 than it changes to 3.0, 3.1,..,3.9 etc, than it changes to 4.0, 4.1, etc. I would like to be able to copy down to 2.1 to 2.191 or higher, than switch to the next set of numbers such as 3.0 to 3.109 or what ever numbers i would like at that point. "Eduardo" wrote: HI, let's say that 2.1 is in A2 in A3 enter =A2+0.1 Copy this formula down "Jim S" wrote: I'm taking column A which has a header, column B has a header. Column A is a numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in Column B. Column A 2.1 2.2 2.3 2.4 2.5 etc. on down Column A Column B acap at-echo at-nbp at-rtmp at-zis auth etc. How can I have this auto file down column A with numbers that have decimals? |
#5
|
|||
|
|||
Is it possible to do this?
Hi,
Since you want to switch to whatever number you want, you will need to do it in steps: The first step would be to enter the following formula in A2 and copy it down as far as you want the 2.x's to go: =--(2&"."&ROW(A1)) to begin the 3's or whatever enter =--(3&"."&ROW(A1)) and fill down... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jim S" wrote: It only works up to 2.9 than it changes to 3.0, 3.1,..,3.9 etc, than it changes to 4.0, 4.1, etc. I would like to be able to copy down to 2.1 to 2.191 or higher, than switch to the next set of numbers such as 3.0 to 3.109 or what ever numbers i would like at that point. "Eduardo" wrote: HI, let's say that 2.1 is in A2 in A3 enter =A2+0.1 Copy this formula down "Jim S" wrote: I'm taking column A which has a header, column B has a header. Column A is a numbering sequence starting with 2.1 in Column A Row 2, Column A Row 3 should be 2.2, Column A Row 3 should be 2.3, etc down Column A to match the data in Column B. Column A 2.1 2.2 2.3 2.4 2.5 etc. on down Column A Column B acap at-echo at-nbp at-rtmp at-zis auth etc. How can I have this auto file down column A with numbers that have decimals? |
Thread Tools | |
Display Modes | |
|
|