How about

A B C 2 IAF 1234 3 IAF 1201 4 IAF 1300 5 IAF 1001 IAF 1301 Sales

Array Formulas

Cell Formula C5 {="IAF "&MAX(IF(LEFT(A$2:A5,3)="IAF",RIGHT(A$2:A5,4)*1))+1} Entered with Ctrl+Shift+Enter.If entered correctly, Excel will surround with curly braces {}.

Note: Do not try and enter the {} manually yourself

## Like this thread? Share it with others