Essential Function List of Microsoft Excel

Auto Numbering:

Automatically number show on column A based on column B's Value.

="No. "&SEQUENCE(COUNTA((B:B)))