moee
excel isnt the proram for this, but anyway

add a column to your data that will have the formula countnumbers.

then apply conditional formatting so any row that has a 5 = (5 starts) will be formatted red, then add more formatting so that each of the cells with countnumbers are all different colours.

then sort the data using advanced filter , using colour as the filter so now will only have entrants wth 5 starts , then just create a macro to paste your new number, then copy and paste to another sheet
then repeat till you do done them all...then automate it into one macro..