Does Excel support Auto fill on filtered data?

[Guest]

I have to give continous numbers for a some rows after skipping some rows
here and there in between.

I am giving membership numbers to a club. There are old members and new
members. Old members are given one sequence of numbers and new members
another sequence of numbers.

But all the old and new members are arranged in alpahabetical order of their
names in my worksheet.

So I filtered all old members first. (I have a column "member status" in
which "old" or "new" is entered.)

After filtering for old, how do I give the numbers continuosly using the
auto fill feature of excel?

When I try pulling the cross hair handle after filetering the data and
selecting the first two cells, it only repeats the numbers.

Does Excel support Auto fill on filtered data?

 

[Dave Peterson]

You have one suggestion at your first post.

I have to give continous numbers for a some rows after skipping some rows
here and there in between.

I am giving membership numbers to a club. There are old members and new
members. Old members are given one sequence of numbers and new members
another sequence of numbers.

But all the old and new members are arranged in alpahabetical order of their
names in my worksheet.

So I filtered all old members first. (I have a column "member status" in
which "old" or "new" is entered.)

After filtering for old, how do I give the numbers continuosly using the
auto fill feature of excel?

When I try pulling the cross hair handle after filetering the data and
selecting the first two cells, it only repeats the numbers.

Does Excel support Auto fill on filtered data?