Adding A Column for a Median Rating

[Dmcl]

Hi, I have a sheet with a full days horse racing on it. The sheet has many columns of data. One column is for the Official Rating of each runner (OR). What I would like to do is add column with a Median Rating for each race based on the OR of each runner. I have really hit a wall in trying to achieve this without going through each race on the sheet and adding it manually. Would anyone be able to help with a formula to do this? Hope it makes sense. Thanks

 

[jasonb75]

Without a visual example of your data layout an accurate formula is impossible, the principle would be an array formula something like

=MEDIAN(IF(A$2:A$200=A2,B$2:B$200))

Array confirmed with Ctrl Shift Enter, where A2:A200 contains the list of runner names and B2:B200 contains the official ratings.