About 1,500,336 results (3,725 milliseconds)
Highest value from column, get the name of row - Google Docs ...
https://support.google.com/docs/thread/60932043/highest-value-from-column-get-the-name-of-row?hl=en Jul 24, 2020 ... Hi team, I'm quite new to google sheets and excel. I'm trying to get a cell display the row with highest value from a specific column.
Conditional Formatting, Highlight Highest Value, IF Cell is not 0 or ...
https://support.google.com/docs/thread/169996036/conditional-formatting-highlight-highest-value-if-cell-is-not-0-or-empty?hl=en Jul 5, 2022 ... In `conditional format` I have been able to highlight the maximum value ... Both are using the same formula (=B12=MAX($B$12:$J$12)). What I ...
Sheets and Formula Question - Trying to Find Second Iteration of a ...
https://support.google.com/docs/thread/248535546/sheets-and-formula-question-trying-to-find-second-iteration-of-a-max-value?hl=en 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 ...
I am looking to highlight the max value cell in a specific range of ...
https://support.google.com/docs/thread/40018345/i-am-looking-to-highlight-the-max-value-cell-in-a-specific-range-of-cells?hl=en 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 ...
How can I limit the result of a formula to a maximum value? - Google ...
https://support.google.com/docs/thread/219019092/how-can-i-limit-the-result-of-a-formula-to-a-maximum-value?hl=en 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, ...
A funtion to mark the cell in a row with the highest number? - Google ...
https://support.google.com/docs/thread/227420819/a-funtion-to-mark-the-cell-in-a-row-with-the-highest-number?hl=en Jul 26, 2023 ... I have added a new conditional formatting rule to the sheet/tab which highlights each row's highest value. It uses the custom formula of:
find the greater value - Google Docs Editors Community
https://support.google.com/docs/thread/113416273/find-the-greater-value?hl=en 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.
Getting max value in a dynamic range - Google Docs Editors ...
https://support.google.com/docs/thread/50568313/getting-max-value-in-a-dynamic-range?hl=en Jun 1, 2020 ... =SUM(INDIRECT("C4:C"&row()-1)). This sums everything from C4 upto the cell above the one containing the formula. Now I'm trying to do the same, ...
Calculate Difference Between Max and Min Values - Google Docs ...
https://support.google.com/docs/thread/92922966/calculate-difference-between-max-and-min-values?hl=en 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 ...
Need the Sheet and Cell Address for the max value across multiple ...
https://support.google.com/docs/thread/9331320/need-the-sheet-and-cell-address-for-the-max-value-across-multiple-sheets-help?hl=en Jul 5, 2019 ... T7, I'd like it to tell me that. I have played with Address, Match, Cell, Index, and muchhhhh Googling. Closest I've come is an Excel discussion ...
Track highest and lowest number reached in a specific cell over a ...
https://support.google.com/docs/thread/119581487/track-highest-and-lowest-number-reached-in-a-specific-cell-over-a-period-of-time-in-google-sheets?hl=en Aug 1, 2021 ... I have a cell that references the total value of a stock portfolio. ... Spreadsheet formulas always calculate their results dynamically. If ...
Conditional Formatting does not work as expected (1st, 2nd, 3rd ...
https://support.google.com/docs/thread/258220486/conditional-formatting-does-not-work-as-expected-1st-2nd-3rd-highest-value?hl=en 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: ...
Highlight max/min of columns per month - Google Docs Editors ...
https://support.google.com/docs/thread/156036842/highlight-max-min-of-columns-per-month?hl=en Mar 20, 2022 ... I have an excel sheet with multiple columns, where I am putting ... You will notice I have a single formula for the MIN and MAX conditions.
MAXROW() - AppSheet Help
https://support.google.com/appsheet/answer/10107920?hl=en Row with greatest value in columnReturns the key of a row (Ref value) in the data set that contains the maximum value found in the named column from among ...
Displaying the maximum number that the google finance function hits.
https://support.google.com/docs/thread/122705379/displaying-the-maximum-number-that-the-google-finance-function-hits?hl=en Aug 24, 2021 ... ... find the maximum value in that data. This could all be combined ... He gives this single formula example, for finding the max: =QUERY ...
Find the Max value of a filtered set of data - Google Docs Editors ...
https://support.google.com/docs/thread/5541318/find-the-max-value-of-a-filtered-set-of-data?hl=en May 5, 2019 ... Hi, Andy Hayes 3627,. In addition to Lance and Adam's wonderful solutions, you can try this array formula too. ={"Grade", ...
Post question Use Large() & Max() functions in Array formula ...
https://support.google.com/docs/thread/104844972/post-question-use-large-max-functions-in-array-formula?hl=en Apr 2, 2021 ... It sets up a three column array where The second and third columns are sorted to make the max values at the top of each row.
Trying to highlight the highest 4 values - Google Docs Editors ...
https://support.google.com/docs/thread/216496145/trying-to-highlight-the-highest-4-values?hl=en May 19, 2023 ... In Excel this was very easy but I can't get it to work in Sheets. Here you can view what I tried, including one formula I paste as text because ...
How can I get the highest value per group but keep the group sorted ...
https://support.google.com/docs/thread/214187563/how-can-i-get-the-highest-value-per-group-but-keep-the-group-sorted-as-is-including-blanks?hl=en 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 ...
Change background color in the cell with the highest value ...
https://support.google.com/docs/thread/9390834/change-background-color-in-the-cell-with-the-highest-value-numbers?hl=en Jul 6, 2019 ... You want to set up a conditional format rule. range B2:H. select custom formula option with custom formula. =B2=max($B2:$H2). select color and ...