How to Create a Dynamic Numbered List in Excel part 2| Excel tips and tricks | #shorts

In this short you will learn How to Make serial numbers automatic and dynamic with this method serial numbers add automatically when you add new Data and rearrange dynamically when you hide or filter your data

Link to more YouTube Shorts videos:
#excel
#exceltipsandtricks
#exceltutorial
#exceltips

[ChrisLim-ifrk]

What is 103 inside subtotal parenthesis?

[mrcoolst]

Does it matter whether you say "B2:$B$2" or "$B$2:B2" in the subtotal function? Do they have different effects?

[mrcoolst]

In the If function, why say "B2 <>0" as the logical? Wouldn't it always return True?

[Destinied]

Once I type additional details to add a new bottommost row the last row number and the second from the last become identical,
how to prevent this error?