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