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

preview_player
Показать описание
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
  1. Computer Geeks
  2. Auto Serial Numbers
  3. MS Excel
  4. Applying Filters in MS Excel
  5. Subtotal formula in excel
  6. Auto serial numbers in Excel
Рекомендации по теме
[Geek 10] How 0:03:45

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

Geek Uninstaller - 0:04:11

Geek Uninstaller - Uninstall Windows Programs & Windows Store Apps Easier

10 Tech Websites 0:06:31

10 Tech Websites Every Geek Should Know!

I have been 0:11:47

I have been a coffee geek for 16 years. Here's my best advice.

Epic Rap Battle: 0:03:44

Epic Rap Battle: Nerd vs. Geek

Medik8 Retinal 10 0:06:45

Medik8 Retinal 10 v Geek and Gorgeous Retinal 10: How does the budget serum compare?

Geek and Gorgeous 0:19:37

Geek and Gorgeous brand review | Dr Dray

Opening the August 0:08:40

Opening the August 2024 WRESTLE CRATE UK Wrestling Subscription Mystery Box

YouTube Geek Week, 0:00:30

YouTube Geek Week, coming August 4-10

DaBaby Wants His 0:00:23

DaBaby Wants His Daughter to Date a Geek 😂

Create this AWESOME 0:10:40

Create this AWESOME 3D Animation in 10 Minutes

Andrew Tate was 0:01:03

Andrew Tate was a GEEK once too 💊 💯 🤨 😤

How to Play 0:16:08

How to Play Succulent (Rules School) with the Game Boy Geek

How To Fertilize 0:11:34

How To Fertilize Peppers (Complete Guide) - Pepper Geek

Top 5 Geek 0:11:34

Top 5 Geek Movies

10 Cars Flying 0:11:54

10 Cars Flying Off the Lot! Here is why !!

How to Make 0:01:01

How to Make Geek or Nerd in Infinite Craft 2024

Edot Baby - 0:02:06

Edot Baby - “GEEK” (OFFICIAL MUSIC VIDEO)

Geek & Gorgeous 0:09:46

Geek & Gorgeous Skincare 101 A-Game 10 & A Game 5 Review and How to Use

Geek & Gorgeous: 0:21:37

Geek & Gorgeous: $10-$20 Unique Actives?!

Where do I 0:02:34

Where do I get my geek shirts?

I Asked Best 0:30:37

I Asked Best Buy to Fix my PC… They FAILED - Geek Squad vs Mom & Pop Shop

GEEK GIRL Trailer 0:02:26

GEEK GIRL Trailer (2024) Emily Carey, Teen Series

10 Years Younger 0:09:43

10 Years Younger Skin Routine | Makeup Geek

Комментарии
Автор

It's very useful, thank u for, I tried a lot

RamaKrishnan-dqcb
Автор

What u press to add the $ to the b3 automatically

kawaaziz
Автор

=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 and then 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.

JaagrookBhartiye
Автор

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

timvancaelenberge
Автор

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

viralneeraj
Автор

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

giteshpandagale
Автор

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

dirokql