highest

I have a table with three columns. Column 1 is a date column. Columns 2 and 3 are water pressure vales (high in column 2 and low in column 3). I want to look down the column 2 entries, find the highest [=max(X:X)] value and return the value in the cell immediately to the right in column 3...

Hello all I am new to using the more advanced functions and equations within excel. Could someone help out with a SUM equation to always include max value of column A as a part of the equation and then add this number to the SUM of the two highest max values from either column B or C or D...

I have column A with a list of numbers, and I am trying to highlight the top 3 highest value/s. However, conditional formatting is not working properly if there are duplicate values. Highest value/s – Color Blue 2nd Highest value/s – Color Yellow 3rd Highest value/s – Color Green Other Values...

I have following values in cells: S4: 846 T4: 846 U4: 846 V4: 893 W4:893 X4: 893 Y4: 893 Z4: 0 AA4: 0 AB4: 0 AC4: 0 AD4: 0 I need to sum the six highest value within those cells. I expect to get a sum of 5264, but does not know how to create a formula for this. I tried using SUMPRODUCT function...

If I have a column with 365 rows with each cell representing total sales for each day of the year. If I wanted to find any 30 consecutive days with the highest sum, how could I do that?

Greetings, I am using a spreadsheet to record the results of a golf competition. Each team will play a round and the winner will be awarded a number of points, down to last place who will receive zero. There are 6 rounds with the highest number of points received from only the best 4 rounds...

Let's say I have 3 columns - of which A and B contain multiple records of the name. Column A = Color Column B = Manufacturer Column C = A number What I'm looking for is if Column A = "Green" AND Column B = "Microsoft", return the 5th highest value in Column C. (which obviously matches my...

Here is the deal, i have 2 columns in a google sheet doc with a bunch of values and #error ! and #ref ! I use =$B:$B=max(IFERROR(B:B)) and =$C:$C=min(IFERROR(C:C)) to highlight the lowest value in C and the highest value in B, and ignore errors Problem 1= how to compute the spread and the...

Hello, Does anybody know how to automatically highlight the highest value in each row label of a pivot table? In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting. Thanks. <tbody> Sum of Amount Row...

Hello, Does anybody know how to automatically highlight the highest value in each row label of a pivot table? In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting. Thanks. <tbody> Sum of Amount...

I have two sets of data. The first set contains information about the highest and lowest values in the second set of data. The first set is weekly data; the second set daily data. I want to use the daily data to find out which value occurred first, the highest or the lowest. To illustrate...

Hi, Basically if row 3 (columns B to AD) has numbers in find the highest number and then give me the number in the same column in row 2. So for example if B2-H2 was 1 2 3 4 5 6 7, H2 would be the highest so i would want the number in H1 giving back to me as the answer to the formula. Can...

This is what I want the macro doing : Find the last row with data for column A Then, compare the value in that cell with the value in the cell just above If the value is the same, delete the entire row of the highest cell If the value is not the same, get to the next cell i column A and repeat...

Hi, I have a table named "Lisensoversikt" where I have the following items. Second column shows product number: I would like to create a query to return "Aktivitet", "Antall lisenser" og "Dato fra" with the highest date-value. In the example above I would have seen ID 2 = 125 since...

Hi, I have two Ranked Columns Example: A B 1 3 2 4 3 1 4 1 5 5 6 1 7 2 I need to search COLUMN "B" For Highest Rank, and then once that is found, I need to have it tell me which of those have the highest rank in Column "A".... So in this instance, it would...

I have a spreadsheet that is supposed to find the top three players that meet two criteria (position (set in cell $K$4) and salary (set in cell $K$5) (less than or equal to a desired amount) that have the highest projected points. My first formula seems to work. This finds the highest three...

Hi can anyone help with a Formula? I am using column A1:A21 as a reference column and I have a list of values in column B1:B21. I want to find the first 7 highest values in column B and have the results auto show in D1:J1 using the reference from column A ie the results in D1:J1 using the...

Consider the following example of a dataset: 2,3,3,4,5,7,7,8,9. The average is 5.333. I am looking for a formula that gives me the "next lowest value" and the "next highest value" from the average within the dataset. In this example, the next lowest value is "5" and the next highest value is...

Hi all hows things. Could any person help me with a formula to find the difference in a group of numbers compared to the highest number in that group? e.g.: Number Range (in a column) 146 124 98 90 85 82 I want to know the difference between 146 (Highest Number) against every other number...

Morning, I am wanting to select a cell in a column, for example B2=10 B3= B4= B5= 400 B6= 2 B7= B8=6 So even though B6 is the lowest range and B5 is the highest i would like to pull whatever is in cell B8. These cells are forever expanding so how can i do this? I am pulling this information...