Jul 24, 2020 ... Hi team, I'm quite new to google sheets and excel. ... There are likely many ways to do this, but I think SORTN() might be the easiest function ...

Dec 14, 2023 ... The first 2 in the SORT function is supposed to grab the second highest value, which it does. If I make it a 3 it grabs the third highest number ...

Jan 10, 2021 ... I am trying to write a formula that can identify the maximum value and the minimum value within a set of data, then calculate the difference between the two to ...

Jul 5, 2019 ... Closest I've come is an Excel discussion ... Might there be a way to have it find the MAX in column T but return the value for column A?

Dec 18, 2020 ... I am trying to use a custom formula in conditional formatting to highlight the maximum absolute value in each row in a range.

Row with greatest value in columnReturns the key of a row (Ref value) ... Any data set name that matches an AppSheet or Excel function name may produce this ...

Mar 21, 2021 ... I want this spreadsheet to lookup the max value for the "Profit Per Day" column, and return the name of the product associated with that value which is in a ...

Apr 14, 2020 ... Get link. Report abuse. Hello Michael,. I have added a rule that looks like this,. Apply to Range: K63:K72. Custom Formula is: =K63=MAX($K$63:$K ...

Jun 13, 2021 ... I want the formula to bring me the largest value, but the value have to be smaller then 6. so in this case formula shuld give me 5.

Jul 5, 2022 ... Get link. Report abuse. Conditional Formatting, Highlight ... Both are using the same formula (=B12=MAX($B$12:$J$12)). What I would ...

Feb 11, 2024 ... Again I do get the correct values if I put that Formula simply in a random cell.. but I don't get the correct highlighting. [=$B:$B=LARGE(B2: ...

May 5, 2019 ... ... return specific columns. So far I have tried the filter function and Query, but can not add the Max function to it and get it to work. Here ...

Aug 24, 2021 ... Hi I am looking to find a function that will show me the maximum price that a stock price hits. For example if i use the googlefinance ...

May 4, 2023 ... To briefly explain, I always try and automate all of my formulas so all I have to do is copy the top of a column that contains a formula and ...

Jun 6, 2019 ... I expected SUMIF to return a higher value than SUMIFS, but it seemed to me SUMIF returned wrong values. ... Instead, copy the formula to Excel and ...

Aug 1, 2021 ... Spreadsheet formulas always calculate their results dynamically. If you want some results to stay put, you will need a script. Cheers --Hyde.

Jun 1, 2020 ... Now I'm trying to do the same, but with finding the max value. And I'm struggling to figure out how to make the different functions work ...

month average and then utilizing the MAX or MIN function to determine the ... this new range to get the highest and lowest values for 3 consecutive months.

Oct 18, 2021 ... Is there a way to get the second largest value from non-adjacent cells with LARGE function? Or would some other function more useful here?

Jun 2, 2023 ... Anything below is fine, but I want the max value to never be higher than 50. What's the best function to use to achieve this? Details. Sheets, ...