Automatically Insert Serial Number after filter in excel

Automatically Insert Serial Number after filter in excel

MS EDUCATION NETWORK

3 года назад

35,496 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Ali Zaidi
Ali Zaidi - 31.10.2023 23:10

it is very helpful

Ответить
Jaagrook Bhartiye
Jaagrook Bhartiye - 21.07.2023 16:06

=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?

Ответить
Arpit Panchal
Arpit Panchal - 22.05.2023 20:29

Thanks for sharing

Ответить
sammi kumar
sammi kumar - 23.04.2023 10:02

nhI huua huaa toh time waste

Ответить
Shubham Laddha
Shubham Laddha - 18.02.2023 19:47

Clear nhi hua

Ответить
Muhammad Zafarullah
Muhammad Zafarullah - 26.01.2023 06:10

love u sir . God bless u .. chtki main kamm ho gaya .. thanxx again

Ответить
Livvel SNA Traders
Livvel SNA Traders - 16.01.2023 00:17

instead of simple using your data I used this formula which works fine

=IF(B38="","",SUBTOTAL(3,$B$3:B38))

Thanks & Best Regards

Ответить
Livvel SNA Traders
Livvel SNA Traders - 15.01.2023 23:53

First of all thanks for your kind support. 2nd I have applied this solution but facing a problem that last row of the data is appearing in each filter. If possible please support to resolve this problem. Best Regards

Ответить
Abrar Multani
Abrar Multani - 16.12.2022 16:22

Super educational video janab

Ответить
siddu basha
siddu basha - 10.11.2022 05:42

Tq Bhai 💕

Ответить
Al-Khair City
Al-Khair City - 21.09.2022 20:06

Thank you so much , Despite I don't speak your language but this Video Helped me a lot .
Best of many videos out there .

Ответить
Atiq Sheikhupura
Atiq Sheikhupura - 15.07.2022 08:01

Best one

Ответить
RAHUL GARG
RAHUL GARG - 11.06.2022 09:16

but in filter mode by default 1 cell ati h extra

Ответить
Muzammil Hussain
Muzammil Hussain - 29.03.2022 05:09

Video pixel sahe nhe ha

Ответить
muhammad younas
muhammad younas - 23.05.2021 19:16

ALLAH PAK AP KO JAZA DE AUR ISTIQAMAT ATAA FERMAI. AAMEEN

Ответить
ASAD RAO a
ASAD RAO a - 01.05.2021 21:48

So nice

Ответить