HI.

I need your help!

if I have a column A (serial number), B (name), C (last name) and so on, it doesnt matter, and I auto filter, lets say column B, so that show only people with the name "John". Is it possible to automatic add serial numbers (1,2,3,4....) in column A to only that filtered result....Because if I type 1, 2, 3 and then drag it down it does not work as normally. and as I have a lot of results, I will spend a lot of time to manually type numbers!

Please, help me...hope that u understand me...

Cheers..