Crap. I am bugged with an excel problem. (using excel 2007)
I have like column P and Q, one with name and other with values from the following formula: = TRUNC((COUNTIF(C5:G2000,"1")/COUNT(A5:A2000))*100,2)
What I am doing is to count the number of times that the number 1 appears in the cells range C5:G2000, etc.
My problem is I wanna sort the P and Q.
Example of P and Q
N01 10.32
N02 8.55
...
N40 9.43
I wanna get the top 5 so I just select the 2 columns and use excel sort. The problem here is that the sort changes the values in the 2 ranges (C5:G2000 and A5:A2000) and I dunno why. I can't figure it out why it changes the formula. I couldn't find any solution in google.