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 MI     www.energyefficientbuild.com.   Mar-30-2014
post by Sedonafilmer (https://productforums.google.com/forum/#!mydiscussions/docs/nLE3Q2dJrx8)
Using MAX formula in an array formula
Hello,
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.

 =ARRAYFORMULA(MAX(E2:E/400, F2:F/100, G2:G/200, H2:H/500, I2:I/500))

This only calculates the first row. I need it to auto fill the rest of the rows without doing a click and drag all the time. Do I need to use a different formula?

Thanks,
Richard
---
Hi Yogi,
Here is a copy of the sheet:

I'm creating a working form that will input the quantity and type of a customers order then display how many days the project will take to complete (based on which item will take the longest)

Columns E through K are the data input of the quantities (the note on row 1 describes the quantity per day each type is)

The max function listed above gives the correct result per row, however I need column L to auto fill as rows will be added and deleted throughout the day (I've done this with arrayformulas).

Hope that clarifies! 
------------------------------------------------------------------------------------------------------------------------------------------------------