根据惟一标准的出现顺序对Excel中重复的文本值进行排序

In Excel I have results data that is ordered in a list similar to below. I am looking for a formula to rank the 'class' column. I have come up with the following which seems to work, but without considering the 'unique' RaceID column.In Excel I have results data that is ordered in