On Jun 17, 10:04 pm, Len wrote:
On Jun 17, 12:42 am, Spiky wrote:



On Jun 15, 9:16 am, Len wrote:

Auto-numbering fails

After data filtering, it seems that auto-numbering in column A is not
working when I select range A2 to A13 and double click the Fill Handle
at cell A13 , e.g..

Column A B
Row
2 1 AA
10 2 BB
13 3 CC
39 SS
116 SS
119 WW
225 OO
230 DD
305 CC

In this case, how to solve the above scenario with Excel function and
give the result with auto-numbering as follows : -

Column A B
Row
2 1 AA
10 2 BB
13 3 CC
39 4 SS
116 5 SS
119 6 WW
225 7 OO
230 8 DD
305 9 CC

Please help, thanks

Regards
Len

I'm a little confused by your data above, if you actually mean those
numbers as different rows or as data. If those are row numbers spread
from 2 to 305, a simple Fill may be impossible. But if you are really
just trying a simple Fill from cells A2 to A13, then....

Instead of the double-click method which requires Excel to guess what
you want, highlight just the first two entries (1 and 2 in your
example), and click-drag the fill handle down to where you want. This
should work better, as long as the numbering desired is simple like
1...2...3...4. Using the Fill Series... command in the Edit should
also work more consistently, although it's slower to use.- Hide quoted text -

- Show quoted text -

Hi Spiky,

Thanks for your advice, I've tried =ROW ()-1, it gives wrong result
and copy down it becomes 1 all the way under column A and also, after
insert A2=1, A3=MAX(A$2:A2)+1, the result shows 2 and copy down it
becomes 2 all the way under column A.

Is my excel formula incorrect or have I missed out anything in this
formula or is there any excel function/formula more applicable ?

Regards
Len

It sounds like you are trying to do something a little different, now.
I tried your formula and it worked for me, exactly as shown in your
post. Are you sure you did the copy correctly?

Although, all you really have to do in A3 is:
=A2+1

And copy down.