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.