With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, March 30, 2014
yogi_Compute Row By Row Number Of Work Days in Column L Based On Maximum Work Capability As Delineated In Cells E2:I2
Google Spreadsheet Post #1580 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Mar-30-2014 post by Sedonafilmer (https://productforums.google.com/forum/#!mydiscussions/docs/nLE3Q2dJrx8) Using MAX formula in an array formula
I'm making a spreadsheet that calculates out of different work types it will display the largest amount of workdays required.
I'm trying to get the max value listed in a column based on the multiple calculations in several columns. The MAX function does what I need it to do but the arrayformula will not automatically calculate the following rows.