I have data in the following table:
1 2 3 4 5 6
a 50 53 73 72 62.5 33
b 63 110 68.5 82 30 50.5
c 67 40.5 44 66.5 49 69
d 95.5 95.5 52 124 76.5 43.5
e 65 85 45 86 31 35
f 64 112 75 90 50 15
each column is a score for a particular week for that particular row. What I am trying to do is find a formula or way to calculate how many times row 'a' score was greater than row 'b' score, row 'a' greater than 'c', and so on.
If this needs a sepreate table then fine but my main issue is comparing two rows of data and counting how many times one row is larger than the other.
please help.
1 2 3 4 5 6
a 50 53 73 72 62.5 33
b 63 110 68.5 82 30 50.5
c 67 40.5 44 66.5 49 69
d 95.5 95.5 52 124 76.5 43.5
e 65 85 45 86 31 35
f 64 112 75 90 50 15
each column is a score for a particular week for that particular row. What I am trying to do is find a formula or way to calculate how many times row 'a' score was greater than row 'b' score, row 'a' greater than 'c', and so on.
If this needs a sepreate table then fine but my main issue is comparing two rows of data and counting how many times one row is larger than the other.
please help.