example.xlsxColumn A (ticket numbers)
DAS-011 E
DAS-012 E
DAS-013 E
I want to look up the maxium ticket number in column A. so all i need is the formula to return the value "013". Can this be done?
I tried creating column b using the MID formula =MID(A3,7,3) and then just doing a MAX formula but all it returns is a zero.
anyone help me please?
Bookmarks