I have a simple exel formula that i would like to have it adapt when the number of rows change in my data.
Manager Rank 1 Rank 2 Diff Sqre Coef
A 1 2 -1 1 0.82
B 2 1 1 1
C 3 4 -1 1
D 4 3 1 1
E 5 6 -1 1
F 6 7 -1 1
G 7 5 2 4
Total 10
the .82 is formula is =1-(6*E9/(COUNT(E2:E8)*(COUNT(E2:E8)*COUNT(E2:E8)-1))).
Is there away create a macro that would
1) take the differnce between Rank 1 and rank2 (diff Column).
2) Square that differnce (column sqre).
3) sum that column ie 10.
4) then plug those variables into the formula.
Any help would be great
john
Bookmarks