serial (ordinal) numbers after filtering

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..

not working...it gives me all Ones (1)...

hm, yeah this works, but the problem starts when I have more columns to filter, and I do actually in my real problem. And I must print various filter results....of course all results must have serial number in first column....

Originally Posted by NBVC

How about:

=SUBTOTAL(3,$B$1:B2)-1

in A2 copied down...

See attached...

Thanks bro it helped me lot, searching for this for a long time

Thanks for the trick...

Ouu yeah...thats it man...THANK you very much....saved me from pain

ah one more thing....if I have at the end row TOTAL and one column with some numbers...how to force that total row to sum only filtered results?

I found it.

=SUBTOTAL(109;range)

is it?

Hi,
I need a help
I have a excel sheet of debtors, in which i have Debtor name in column A, address in Column B, Balance in Column C, now i need to Filter List with balance more than 0.Is it possible to automatic add serial numbers (1,2,3,4....) in column A to only that filtered result....Because I have used the formula =COUNTIF($B$2:B2,B2) but it doesn't help as every debtors have diff balance so it gives a new serial number on each diff balance. I need serial number (1,2,3,4....) for whole list.

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

Jaikaram,

It would help if you posted an example. You can easily do this with VBA, but an example is really necessary.

KDB

Suppose There are 200 different employee names in column 2 and some are hides in between and we want to give serial number the filter one in (1,2,3,4,......). Please reply