Hi,
.
I want to compare multiple cells value with each other and track any changes from 1 to 10 scale.
.
Example:
I have 8 cells and value of those cells change every day.
.
I want to compare each cell's value with other 7 cells and record the changes in 1 to 10 scale. I don't know how to calculate in scale. I want to populate result in Colmn C1.
.
Need formula how to calculate. Any help would be appreciated....... Thanks,
.
-----Colmn A ---- Colmn B --- Colmn C
Row1:Client ----- Average-----Change
Row2:Edd ------ 23.38
Row3:Gem ------- 26.17
Row4:Adam ------- 14.88
Row5:Usher ------- 15.95
Row6:Sam ------- 1.14
Row7:Jim ------- 99.77
Row8:Neil ------- 14.03
Row9:Chuck------- 13.15
Bookmarks