Wednesday, December 25, 2013

yogi_MultiCell Array Formula For Computing Row By Row Minimum For Entries In Range B5 To H8

                                          Google Spreadsheet   Post  #1446
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-25, 2013
question by QusdT (http://productforums.google.com/forum/?zx=kfloo0schu1p#!category-topic/docs/spreadsheets/83KuHWqzeAQ)
ArrayFormula not continueing - AKA Using the MIN FUNCTION with ARRAYFORMULA
The function I'm trying to perform in an arrayformula is:

=ArrayFormula(IF(COUNT(B5:H5)=7,ROUND(MIN(B5:H5),2),""))

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!
-------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment