search string with condition
I have a range of cells with text and numbers. I need to search the range of
cells for the string with a condition ie, spare-1, spare-2,etc. then
determine what the maximum number is after the "-". assistance is greatly
appreciated.
|