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?