Conditional Formula to Give the Large Number

Hello,

I have a column of five-digit numbers beginning with either 11, 14, 19 or 31, and need a formula to give the largest number beginning with 11. Any help?

Thanks,
Gos-c

Try the following...

=MAX(IF(1-ISBLANK(A1:A10),(--LEFT(A1:A10,2)=11)*(A1:A10)))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Originally Posted by Gos-C

Hello,

I have a column of five-digit numbers beginning with either 11, 14, 19 or 31, and need a formula to give the largest number beginning with 11. Any help?

Thanks,
Gos-c

Perfect! Thank you, Domenic.

Gos-C