6th April 2012, 03:52 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 696
|
|
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..
|