TheSORTBY functioncan perform a “reverse sort” with help from theSEQUENCE function.
The first count is used as therowsargument in sequence, the second count is used for thestartargument.
it’s possible for you to use INDEX to retrieve individual values, or entire rows and columns.
COUNTA does not count empty cells.
ROW Function
The Excel ROW function returns the row number for a reference.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
The range or array used to sort does not need to appear in results.
SEQUENCE Function
The Excel SEQUENCE function generates a list of sequential numbers in an array.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
