Auto fill question

[wilster98]

At times when we are making a quality report, we have a long list of numbers that we have to identify as (eg) 2 then 2.1, 3 then 3.1. These features are X and Y coordinates for holes, so it's always a number then a sub. Is there a way to use auto fill to do this? I've tried entering 2 then 2.1 and then drag. The sequence goes 2.2 thru 2.9, then to 3.
I've tried manually entering 2 then 2.1, then 3 and 3.1 then highlight the 2 thru 3.1 sequence and drag it down, but the sequence goes wrong for my needs (3.6 then 4.02, 4.44 4.86). Is there a way to do this quickly? We sometimes have to enter over 100 numbers this way.

Thanks in advance

[wanmuhd]

At times when we are making a quality report, we have a long list of numbers that we have to identify as (eg) 2 then 2.1, 3 then 3.1. These features are X and Y coordinates for holes, so it's always a number then a sub. Is there a way to use auto fill to do this? I've tried entering 2 then 2.1 and then drag. The sequence goes 2.2 thru 2.9, then to 3.
I've tried manually entering 2 then 2.1, then 3 and 3.1 then highlight the 2 thru 3.1 sequence and drag it down, but the sequence goes wrong for my needs (3.6 then 4.02, 4.44 4.86). Is there a way to do this quickly? We sometimes have to enter over 100 numbers this way.

Thanks in advance

What sequence number that you actually want

[wilster98]

I need it to sequence a whole number then the number + .1, e.g 2 then 2.1, 3 then 3.1, 4 then 4.1 etc.

[teylyn]

Hello,

don't use the fill feature, because that can only do regular patterns. Instead, use a formula.

Assuming that the first row has headers and cell A2 has your starting value of 2 and A3 has your next value of 2.1. In A4 use the formula

=A2+1

and copy down.

cheers, teylyn

[Tony Valko]

Maybe this...

Data Range

	A
1	2
2	2.1
3	3
4	3.1
5	4
6	4.1
7	5
8	5.1
9	6
10	6.1
11	7
12	7.1
13	------

Manually enter the first number (a whole number) in A1.

Then, enter this formula in A2 and copy down as needed:

=A1+IF(MOD(ROWS(A$2:A2),2),0.1,0.9)

[wilster98]

It worked! Thank you