Finding the max value in a column when both numeric and alpha numeric values are expressed

How can I set up a cell to show the max value in a column when both numeric and alphanumeric values are expressed?
For example, I have a column that includes the following;
101309
101310
101311
101312
101313
101314
101315
101316
101317
101318
G101319
G101320

These values are under column B and the cell I wish to show the Max value in in F5.What I would like to do is just show the largest numeric value in F5.

Thanks for the help.

Paul

=MAX(IF(ISNUMERIC(B1:B100),B1:B100,0)
it's an array formula so you need to confirm with ctrl+shift+enter.

Originally Posted by yudlugar

=MAX(IF(ISNUMERIC(B1:B100),B1:B100,0)
it's an array formula so you need to confirm with ctrl+shift+enter.

I get an error that states Your formula is missing a parenthesis--) or (.Check the formula,and then add the parenthesis in the appropriate place.

So it is
=MAX(IF(ISNUMERIC(B1:B100),B1:B100,0))

Originally Posted by yudlugar

So it is
=MAX(IF(ISNUMERIC(B1:B100),B1:B100,0))

Keep gettiing a #Name error

What I am looking for is the Max value to read 101320 ignoring the "G".

You could use this formula (credit I believe to Ron Coderre):
=1*(SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))*ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10))
in a helper column to remove all the letters and then max on those values

array forumula (C S E)
=MAX(--RIGHT(A1:A12,6))