Learn how to auto adjust serial number in Excel. At the same time you will learn how to autofill serial numbers or auto arrange serial numbers in Excel. Technically, how to automatically feel serial number in excel without dragging or fixable number in excel? Also learn how do I use dynamic numbering in Excel?
Link to PART 2 of my video.
Auto adjusting serial numbers… Another method – Excel Tips and Tricks
https://youtube.com/shorts/cX6Xr8zIoAU?feature=share

These are the hotkeys featured in this video.

Apply Filter Hotkey
Ctrl + Shift + L

Hide row
Ctrl + 9

These are the formulas used on the video.

Formula
=SUBTOTAL(3,$B$2:B2)

Formula
=SUBTOTAL(103,B$2:$B2)

Here’s a breakdown of the formula for
=SUBTOTAL(3,$B$2:B2)

– “SUBTOTAL” calculates a subtotal based on the specified function number.
– “103” is the function number for the SUM function (COUNTA). In this case, the formula will calculate the sum of the values in the range. In another words, the “COUNTA” function in Excel is used to count the number of cells in a range that are not empty. It can count both numeric values and text values.
– “$B$2:B2” is the range of cells over which the subtotal will be calculated. The dollar signs ($) before the column and row references make them absolute references, which means the range won’t change when the formula is copied to other cells horizontally.
– The “B2” part represents the current cell reference. As the formula is copied down to other cells, this part will change accordingly to match the row of each respective cell.

Here’s a breakdown of the formula for
=SUBTOTAL(103,B$2:$B2)

– “SUBTOTAL” calculates a subtotal for a given range based on a specified function.
– “103” represents the function code for COUNTA. In this case, the formula will use the COUNTA function to count the number of non-empty cells in the range.
– “B$2:$B2” defines the range of cells over which the function will be applied. It starts from cell B2 and goes up to the current row, denoted by “B2” with a relative reference.
– The range is dynamic because it uses a mixed reference. The column reference, “$B,” is absolute because the dollar sign “$” is used before it, meaning it won’t change when the formula is copied horizontally. The row reference, “2,” is relative, without a dollar sign, so it will adjust as the formula is copied vertically to different rows.

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google