Single Ranking with Two Data Sets in One Column

[ryanambrose]

I'm trying to rank scored participants from highest score to lowest with one added criteria. Those who fouled, designated by an asterisk before the score, are still given a score but ranked lower than all the ones who did not foul.

 

[Eric W]

Welcome to the MrExcel forum.

Try:

Book1
	A	B	C
1	Participant	Score	Ranking
2	Bill	45.25	2
3	John	37.5	4
4	Sue	*41.75	6
5	Lee	48.5	1
6	Jill	*49.25	5
7	Jack	43.5	3
Sheet8

Cell Formulas
Range	Formula
C2:C7	C2	{=SUM(--(IFERROR(B2*1000,MID(B2,2,9)+0)<IFERROR(B$2:B$7*1000,MID(B$2:B$7,2,9)+0)))+1}
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[ryanambrose]

Outstanding! Thank you!!

 

[Eric W]

Glad to help!