last five

[Guest]

ok. I give. I like Jason's formula (see below) that he came up with. I understand most of what it's doing but part of it has me stumped

Can somone that understands this email me

=SUM(LARGE(OFFSET(A1,MIN(LARGE(IF(A1:A20<>"",ROW(A1:A20))
{1,2,3,4,5}))-1,,MAX(LARGE(IF(A1:A20<>"",ROW(A1:A20))
{1,2,3,4,5}))),{2,3,4}))/


----- Jason Morin wrote: ----

I should probably mention that this formula will *always*
grab the last 5 scores, regardless of how many weeks you
skipped. For example, if you played weeks
1,2,4,5,7,10,11, then it will evaluate weeks 4,5,7,10,11

Jaso

 

[Jason Morin]

Send me an e-mail and I'll e-mail you back the file that I
used to test the formla, along with explanations.
Actually, I found that I could shorten it somewhat when I
dissected even further myself.

HTH
Jason
Atlanta, GA

-----Original Message-----
ok. I give. I like Jason's formula (see below) that he

came up with. I understand most of what it's doing but
part of it has me stumped.