Site icon 🐝 🐤 @ksbizintel

EXCEL AUTO Row Numbering …

Demystifying MDX Queries Part I


To automatically include Row Number quickly in your excel worksheets, you can use this formula in each cell. =ROW() – ROW($A$8) + 1 where cell A8 is the #1 row.

You must be sure to make the cell reference absolute using the $.  Iif you add or delete rows above the first row, this absolute reference is adjusted correctly to keep the reference to the first cell so the first row is always numbered 1. It saves having to enter beginning row number into a different cell elsewhere on the worksheet.


 Another Tip From:


Microsoft Store

Exit mobile version