I've 300 odd entries in column A. I'm trying to come up with a formula to just identify the highest version and write it to a different column. Could you please help. For example I've listed below entries, I'm expecting the following entries (Iss 2.3, Jav 12.2 & YYY 1.1) to be written in say column C.

Please help.

Example
Column A
Iss 2.1
Iss 2.2
Iss 2.3
Jav 12.1
Jav 12.2
YYY 0.0
YYY 1.1