About bignum
The biggest number Excel can handle is 9.99999999999999E+307.
You’ll see it used in various advanced Excel formulas.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
Last row in numeric data
To get the last relative position (i.e. last row, last column) for numeric data (with or without empty cells), you can use the MATCH function with a so-called "big number". In the example shown, the formula in E5 is: =MATCH(9.99E+307,B4:B9)
