max array

I am sure something like this has been answered numerous times but I cannot seem to find something similar. Basically, I need excel to record the max value in Column A in Column B as it goes down Column A. I have attached an image showing what I need from a sample set by manually solving my...

Hi All, I have a real problem which I just cannot resolve, struggling to even know where to start to be honest! So.... I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows: and one called "Payment Record", as...

Hello, I am trying to look up the Max Value (Paid Rate) from one sheet and return it to another sheet. I have employees that are paid at a Base Rate, but sometimes are paid at a different rate. On 'Orig' Tab there can be a lot of Rows for employees and I need to find the MAX Paid Rate in Column...

Hi, I have the following formulas in cells FQ3 and FR3 which return the numbers 16 and 19 repsectively =IFERROR(LEFT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"") =IFERROR(RIGHT(INDIRECT(FQ$1&$DZ3),(FIND("-",INDIRECT(FQ$1&$DZ3),1)-1)),"") However I then want a formula that...

Sub Macro1() ' Sheets("issue raw data").Select Range("Table1[[#Headers],[Amount of matches]]").Select highest = WorksheetFunction.Max(Selection) answer = MsgBox(highest) End Sub So I have numbers like 1,2,3,4,5 in column, but for some reason it results in 0. I tried to add Dim...

Hi all, I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this: <h5,c16:c28226,0)))}, and="" it="" works="" great! <h5,c16:c28226,0))) <h5,c16:c28226,0))) <h5,c16:c28226,0)))...

Please help me look for a formula to get the Max and Min value based on given criteria. <tbody> Client Campaign Name Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67% Product1...

Please help me look for a formula to get the maximum and minimum value based on certain criteria. Thanks. <tbody> Client Campaign Sent Unique Opens Opens rate Product1 Campaign1 20 14 70.00% Product1 Campaign2 18 11 61.11% Product1 Campaign3 10 8 80.00% Product1 Campaign4 9 6 66.67%...

Hi there, I am looking to extract max and min values from an array containing several thousands of records in the following format: <tbody> A B C D Year 1 1 0 8 2017 7 3 1 3 2017 9 6 2 4 2017 3 8 3 2 2017 9 9 4 7 2017 5 0 5 8 2018 4 1 6 9 2018 5 4 7 0 2019 </tbody> On a...

Dear All My data set is given below. I want to get the maximum value for "Package 1" highlighted in RED, BLUE and the middle column is just BLACK. So the output should be 0.69, 0.59,0.96. There are other packages too. The next one is Package 11+14, for that the answer I want should be 0.54...

Hi, I have a large spreadsheet wherein I want to identify a users most recent device, to do this I need to find the most recent date and then return the value associated with that date and the user. I tried using =VLOOKUP(MAX(A2:A9),A2:C9,3,0), but it just returned the overall recent date not...

I am trying to write an array formula that will return the row number for the row containing the maximum number of values in a set of data. For example, I would like the formula to return 3 for the following as row 3 contains the maximum number of data entries. <tbody> 1 1 1 1 1 1 1 1...

I am trying to write an array formula that will individually count the number of values in a set of rows and return the maximum count. For example, I would like the formula to return a value of 4 for the following table as the maximum number of values in a single row is 4 (row 3): <tbody> 1 1...

If I do =MAX({1;2;3}), it works (I get 3). But if I write ={1;2;3} in cell A1, then do =MAX(A1) in another cell (with or without Ctrl + Shift + Enter), it doesn't work (I get 1). Am I doing something wrong?