[Geek 10] How to get Auto Serial Numbers after applying filters in MS Excel (

Dear all,
Formula: =SUBTOTAL(3,$B$3:B3)
This tutorial contains very simple formula in easy steps to overcome the problems of auto serial numbers in MS Excel software after applying one or more filters.
Please like our video and subscribe our channel too.
Thanks

[@thwaleed2838]

Brother, you are overwhelmed
Good

[@cgeeks]

Please subscribe our channel too

[@abdulsameekhan2962]

Best for office works..

[@abdulwasay789]

Likes 👌

[@bashkaahmed3353]

Thanks 🙏... It was soo helpful

[@cgeeks]

Please subscribe our channel too

[@computer6028]

Amazing nd very useful

[@xbogdy33]

Thank you !!!

[@cgeeks]

Welcome dear,
Please like our tutorial and subscribe computer geeks too

[@B4_Banana]

Perfect

[@user-wv8qe7cn4l]

good

[@cgeeks]

Super

[@cgeeks]

Don't forget to subscribe our channel.

[@JaagrookBhartiye]

=IF(C2="","",SUBTOTAL(3,$C$2:C2))
this formula doesn't work online on MS Teams, as "serial number", it goes to 0000 and then 11111 and then 22222 and so on...
is it possible to shed some light how to solve this issue with online excel spreadsheet, please?
All I need is a column with serial numbers on my online (MS Teams) excel spreadsheet, which works even after "filtering" the data.

[@cgeeks]

Did you check on Desktop Excel?

[@kawaaziz7106]

What u press to add the $ to the b3 automatically

[@cgeeks]

Dear,
It's 'F4' function key

[@cgeeks]

Please like our tutorials and subscribe Computer Geeks

[@viralneeraj]

MALE FILTTER KARNE K BAD V FEMALE LAST ROW ME KYU AA RAHA HAI , YE SOLVE KYU NAHI KIYE

[@timvancaelenberge7849]

But it only copies the 1 when I drag, so I get a long list of 1's...

[@cgeeks]

It works for whole list, watch tutorial again and drag as shown in video

[@timvancaelenberge7849]

@@cgeeks Are there multiple ways to drag down? I don"t think so. If I do it, it copies 1.

[@cgeeks]

Did you follow all steps

[@timvancaelenberge7849]

@@cgeeks Dragging is dragging, there is only 1 step.

[@giteshpandagale2053]

mujhe filter hatane ke baad woh number waha par hi freeze chye toh woh kaise hoga!

[@cgeeks]

Simple give serial #

[@user-di7ro5kq3l]

After applying filter. It adds one unwanted line. pls see

[@cgeeks]

Which Excel you are using

[@user-di7ro5kq3l]

LTSE Prof Plus 2021

[@cgeeks]

It should work, did you try again

[@user-di7ro5kq3l]

Yes, I've tried with new data sheet. It is working perfect. Maybe my prev database is having some issues. Thankyou so much

[@cgeeks]

You welcome dear,
Don't forget to subscribe our Channel..

[@bashkaahmed3353]

Thanks 🙏... It was soo helpful

[@cgeeks]

My pleasure 😊
Please subscribe our channel too for more amazing geeks.