Forum Discussion
Formula
I am trying to do multiple formula and I want to make sure that I have the correct information in the formula. in column p i need to have it by state from a-z but also need to have it use column o f...
Turtle34 Your current formula attempts to count the number occurrences of the numbers in "Net Score" in an array of "St/Pr" containing only texts "AK" or "YT". Obviously, that does return -zero- all the way and this is NOT what you want to do.
Your "St/Pr" columns has 22 occurrences for AK and 2 for YT. Your "Net Score" "column O" is sorted (high-to-low). The first nine entries are all from AK. So, these are ranked 1 to 9 for AK. Similarly, the 10th entry would rank as 1 for YT, the 11th would be the 10th for AK and so on. Is this what you want to do in a formula? If so, the enter the one below in P5 and copy it down.
=COUNTIF($C$4:C4,C5)+1
so since i have the actual rank done and the net score is in order it is looking at the states and sorting from there?