Interesting results:
=AVERAGE(N4:N8) 60.32
=AVERAGE(OFFSET($N$1,3,0,5)) 60.32
=OFFSET($N$1,MATCH(A1&"",$N$1:$N$200,0)+1, 0,5) 60.69
=OFFSET($N$1,MATCH(A1&"",$N$1:$N$200,0), 0,5) 60.69
Jason's formula: 59.87
??????
Interesting results:
=AVERAGE(N4:N8) 60.32
=AVERAGE(OFFSET($N$1,3,0,5)) 60.32
=OFFSET($N$1,MATCH(A1&"",$N$1:$N$200,0)+1, 0,5) 60.69
=OFFSET($N$1,MATCH(A1&"",$N$1:$N$200,0), 0,5) 60.69
Jason's formula: 59.87
??????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks