MS365: excel formula for last used row number. The LUR() function
The LUR (Last Used Row) function is a LAMBDA function, so no macros involved. It works on MS365 / Excel Online. Purpose is simple – return the range in a column from the cell given, e.g. A1 to the last used row. LUR syntax The syntax is LUR(TableStart,CheckRows) TableStart is the cell reference for the…