Thursday, January 2, 2014

yogi_Compute Row By Row Minimum Score From Entries In B2 to H If Count In Rows Of B to H = 7

                                          Google Spreadsheet   Post  #1464
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-02-2014
post by QuadT(!mydiscussions/docs/83KuHWqzeAQ)
ArrayFormula not continueing - AKA Using the MIN FUNCTION with ARRAYFORMULA
The function I'm trying to perform in an arrayformula is:


I've seen some alternative solutions instead of using MAX posted by Adam & Yogi with explanations that MAX doesn't work so well in ArrayFormula; so I assume since MIN & MAX are best friends that MIN doesn't get along well with ARRAYFORMULA either.

Although just having the correct formula would be AWESOME. It sure would be nice to have the sections of the formula explained so that I can figure it out on my own for future needs.

Thanks Everyone...I sure do appreciate this forum, I use it regularly!
Here's the sample spreadsheet