|I don't understand what you are trying to do. What do you mean by "divide the score"?|
Are you trying to break the tie? Ties can be broken in many ways, such as by using a second set of criteria or even by adding a very small random number to each value so that ties are virtually impossible.
The more details your provide, the easy it will be for us to help you.
Perhaps if you included an example of what you want the outcome to be we could help you produce those values.
Please click on the following link and read the instructions on how to post example data in this forum so that the columns line up. Thanks.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03