My reply to your other post;

Autofill won't work with Filter.
Assuming you want to assign seatnumbers whre Col A has English... (with
first row having headers) enter this formula in row 2 of any col and copy down
=IF(A2="English",COUNTIF($A$2:A2,"English"),"")
This will enter 1,2, ... to those rows having English.
You can format them as 000 to get 001,002,...


"alibaba" wrote:

I cannot use sort in Column A because Column A contains subject abbreviations
in this format:
e.g.
cell A2 contains:
CHI, ENG, MAT, ECO, CHS, CLI, HIS, PAC1, CMM

cell A3 contains:
CHI, ENG, MAT, ECO, CHS, CLI, HIS, PAC1

What I am doing now is:
To arrange seat number for English, I need to use filter with the 'cell
contain ENG' option to filter out English in column A and then type 001, 002,
003 manually in column B. This could be a trouble if there are more than 50
English students.


"Fred Smith" wrote:

You're correct. Autofill does not work on filtered lists.

You could sort the list by your criterion, fill in column B, then sort it
back.

Regards,
Fred.

"alibaba" wrote in message
...
Let me make it simpler.
column A stores the exam subjects that I am going to filter. I found that
after applying the data--filter--autofilter

(with some creteria) on column A, a certain subject(say English) is
filtered. Then I try to use autofill in column B to

assign seat number to the students(001, 002, 003,..). However, I cannot
fill
in the series. Can anybody help me?