lowest

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, I have a a column containing a list of scores (Column C) and another containing the list of checks completed (column B). I have a SMALL formula which ranks Column C from lowest to highest, but I am wanting to have a formula in Column B which lists the number of completed checks from...

Running Excel 2016, in 2011 a good gentleman helped me with a formula here in Mr Excel in which I have lost, here is what I am needing to do again. In cell A11, I need a formula that will find the lowest number in a range of columns lets say G11:P11, trick is if all cells in that row between...

Hi All, I am trying to return a status in the following table <tbody> Name Flange Rating Lowest Value Status Example1 150 1.0 X Example2 150 1.5 X Example3 450 6.0 X Example4 450 6.3 X </tbody> Based on the following conditions <tbody> Flange Rating...

Hi Folks I am trying to formulate a workbook that has a data tab with the possibility for multiple entries for each client and I need to be able to get the lowest value result from one column and the highest from another and place them on another sheet in a different tab (to track weight loss in...

Hello - I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. <tbody> Aetna BCBS Health Net Dean Geisinger Bronze 10 N/A 100 35 5 Bronze Plus 15 N/A 50 45 10 Gold 20 N/A 75 55 15...

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...

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...

I am looking for a Conditioning formula to find the lowest Unique number in a column. I found out how to Highlight a unique number in the column, but not JUST the lowest number. I run Golf Tournaments and so I have Rows 1-18, thats for the holes, and I usually have 20 to 30 teams in columns...

Hello - I'm looking to find the lowest carrier based on a certain criteria. Hoping someone can help. Cell C56 gives me my rating bands 1-22 If C56 is NOT 7 or 15 I need to find the lowest silver rate among Aetna, BCBS or United F55:O55 is the row that list all my carriers F56:O59 are my rates...

I'm looking for a formula to help me determine the lowest set of data based on these characteristics. We have contests that we run that have certain base criteria. Here is what the criteria is for the 2 different states. For Michigan you need to be 15% above the minimum and for Ohio you need...

Need help with a formula. I have 2 columns Column A1:A100 contain duplicate values ranging from 1 through 19 Column B1:B100 contain various values and some duplicate values based on the value in column A. See below. My question is this: 1st I would like to create a formula that calculates...

Hello, I'm using excel solver and have a problem I can't figure out. Here's an example: suppose I have 20 suppliers and I want solver to find me the lowest cost based on a set amount of suppliers. For example, I may want solver to give me the lowest cost using only 5 suppliers in one scenario...

I've tried using the SMALL function, but this doesn't work when you want the 3 lowest results and they can often be the same amounts. My data is pulled from another table via pivot table, and looks like this: <tbody> Area 1 Area 2 Area 3 Area 4 3 2 2.5 2.5 2.65 1 1 1 </tbody> My data...

Hi All, I am looking to find and return some values. in cells B4,B6,B8,B10,B12,B14 I have values 1,2,3,4,5,6 representing greyhound traps in cells Q4,Q6,Q8,Q10,Q12,Q14 I have race times What I would like to do in cells D,E,F 17 is to sort the times into the three lowest and return the...

<tbody> Area 1 Area 2 Area 3 Area 4 Area 5 Lowest 2nd lowest 3rd lowest 1.2 1.6 1.2 1.4 1.7 =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,1),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,2),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,3),$A2:$E2,0)),"") 1.1 2.8...

Hi, I am trying to return multiple criteria based up the records with the 3 lowest date. Below is an example data set I am using. <colgroup><col span="4"><col><col span="6"></colgroup><tbody> Per.ID Location Work Date 1 Leeds stage 1 1/1/2015 Location Leeds 2 York stage...

I have rows of 1,2,3,4 and A, B, C, D; all with empty (blank) cells too. I am hoping there is a way to return either the highest number or highest letter, without being impacted by the blank cells. To help others too, if someone out there knows, may as well provide a formula which finds...

Highest score wins. We determine who is the champion(s), 2nd, 3rd winner etc. If two winners have the same highest score, both are 1st winner. The next will be 3rd winner. If three winners have the same highest score, three are 1st winner. The next will be 4th winner. The same logic applies to...

i have numeric data in first column of table i want to give the percentage of each value, but lower should get 100%, then higher values get lower percentage comparetively pls help