Forum Discussion
Help!!! how can I rank or score this???
Looking at the 3 groups below. I asked each group to give me their list of top 5. Each group was asked to rank 1-5 with 1 being the best and 5 being the least. how can I score these so the 1's ar...
Your rankings would be reversed by the formula
= IF( rank, 6 - rank, 0 )
One way of summing individual rows is to use MMULT
= MMULT( IF( rank, 6 - rank, 0 ), {1;1;1} )
Alternatively you could use a relative reference to a single row at a time, in which case the formula
= SUM( IF( nameRank, 6 - nameRank, 0 ) )
needs to be copied down.