Another user helped me with some of the functions in this file, and the problem is that I have one bug I can't fix. There are four sheets. The first two sheets contain different types of scores.
The fourth sheet ranks each of the different types of scores on both first sheets. The third sheet reports out on the bottom five scores in each category. If one of the scores is missing, the whole thing gets screwed up.
I have attached the file and removed a some of the scores to illustrate. If anyone is willing to take a look and recommend a fix, I would be so appreciative.
Bookmarks