Rank ignoring character

[hazzaska]

Hi is it possible to rank numbers ignoring a "*" at the start or end of a number? As in below example?

*64.9
71.4
40.3
84.1*

Thanks for any input

 

[mole999]

in a helper cell > =SUBSTITUTE(A1,"*",""). I cant get it to work in RANK on its own?

 

[Peter_SSs]

Does this copied down do what you want?

Excel Workbook
	A	B
1	*64.9	3
2	71.4	2
3	40.3	4
4	84.1*	1
Rank