Being able to pull out highest number when divided by dots and using multiple criteria with some numbers being 0

[exceldaddy]

Hi everyone,

I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like:

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Xbox[/TD]
[TD]8.123.12[/TD]
[/TR]
[TR]
[TD]Playstation[/TD]
[TD]7.2.13.55
[/TD]
[/TR]
[TR]
[TD]Xbox

Xbox[/TD]
[TD]8.99.9.121

0[/TD]
[/TR]
[TR]
[TD]Nintendo[/TD]
[TD]9.2332.121[/TD]
[/TR]
[TR]
[TD]Playstation

Nintendo[/TD]
[TD]6.232.231

0



[/TD]
[/TR]
</tbody>[/TABLE]


(although it has over hundreds of rows).

I am looking for my output to pull out the highest number while searching for a specific criteria. I expect my output to look something like:

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Xbox[/TD]
[TD]8.99.9.121[/TD]
[/TR]
[TR]
[TD]Playstation[/TD]
[TD]7.2.13.55[/TD]
[/TR]
[TR]
[TD]Nintendo[/TD]
[TD]9.2332.121
[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance for the time and help.

I also do not have experience with macros, so if that could be avoided, that would be great.

 

[exceldaddy]

Please also note that the amounts of dots vary per text. Thank you.