Auto adjusting serial numbers... Another method - Excel Tips and Tricks

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 1 of my video.
Auto adjusting serial numbers - Excel Tips and Tricks

These are the hotkeys featured in this video.

Apply Filter Hotkey
Ctrl + Shift + L

Hide row
Ctrl + 9

This is the formulas used on the video.

Formula
=AGGREGATE(3,5,$B$2:B2)

Here's a breakdown of the formula for
=AGGREGATE(3,5,$B$2:B2)

- "AGGREGATE" is an Excel function that performs various aggregate calculations on a range of data, such as finding the minimum, maximum, average, etc.
- "3" specifies the aggregate function to use. In this case, 3 corresponds to the function AVERAGE.
- "5" specifies the options for the function. 5 indicates that any error values in the range should be ignored.
- "$B$2:B2" represents the range of values over which the aggregate function will be applied. The dollar signs in $B$2 make the reference absolute, while the B2 reference is relative and will change when the formula is copied or filled down to other cells.
- The formula is likely entered in a cell, and as it is filled down to subsequent cells, the range expands incrementally due to the relative reference B2. For example, if the formula is in cell C3, it will reference the range $B$2:B3.

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

[misterwill]

I absolutely it😍I’ve sometimes wondered if there was a formula for this and here you are providing it. Thank you👏🏾Does this also work if the data is in a table?

[misterwill]

🫣How do you get to the description that you mentioned at the beginning of the video?