This approach will work with any kind of data, including numbers, text, dates, etc.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
Last row in mixed data with blanks
To get the last relative position (i.e. last row, last column) for mixed data that may contain empty cells, you can use the MATCH function as described below. In the example shown, the formula in E5 is: {=MATCH(2,1/(B4:B10""))} Note: this is an array formula and must be entered with Control+Shift+Enter.
