First row number in range |
ROW MIN |
Get relative column numbers in range |
COLUMN |
Get relative row numbers in range |
ROW |
Last column number in range |
COLUMN COLUMNS MIN |
Last row number in range |
ROW ROWS MIN |
Range contains a value not in another range |
ISNA MATCH SUMPRODUCT |
Range contains numbers |
ISNUMBER SUMPRODUCT |
Total cells in a range |
COLUMNS ROWS |
Total columns in range |
COLUMNS |
Total rows in range |
ROWS |