I have a document that has a column for recording revision levels for the document, these revisions could be numerical or alphabetical, I need to find a formula that permits me to search this column for the last entry and return that value regardless of the type of data it contains.
Any help would be greatly appreciated!!
LOOKUP(2,1/(B11:B30<>""),B11:B30) Does not work
Subsequently, neither does: =IF(ISNA(LOOKUP(2,1/(B11:B30<>""),B11:B30)),“No Rev”,LOOKUP(2,1/(B11:B30<>""),B11:B30))
Both of these formulas work in Excel…