search string with condition
Hi,
Try this array formula
=MAX(IF(ISNUMBER(FIND("-",A1:A22)),-MID(A1:A22,FIND("-",A1:A22),10),""))
To enter this as an array press Shift+Ctrl+Enter instead of Enter.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"pburk" wrote:
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.
|