How to calculate best bowling figure (cricket)

[p45cal]

You seem to have done it in the ODI Bat.xlsx file you attached. Is there something missing?
One problem may be that you'll want to use those high scores as numbers (to do calculations or something else numeric) and those with the asterisk can't be; they're text.
In the attached I added a column O (headed High Score b) that is a shorter version of your formula, although all values in that column are text.
I also added a column P (headed High Score c). All these values can be treated as numbers. I used conditional formatting to add an asterisk if column H contained a 1.
What version of Excel are you using?