low

I am working with the following sample data. <colgroup><col><col><col span="6"></colgroup><tbody> Product Code Category 1 2 3 4 5 rank 123 Low 10 20 30 40 50 2 456 Low 5 10 15 20 25 3 789 Med 2 4 6 8 10 234 Med 3 6 9 12 15 567 High 100 200 300 400 500 345 High 20 40 60 80...

Hello - I have a horizontal line chart that contains numerous high and low points (with time and date stamps). I am trying to write a formula (or find a function) that would calculate the distances between each high and low point for each of the drops (sometimes numerous ups and downs per...

<tbody> A B C 1 3.0 5.0 HIGH 2 2.1 2.9 MODERATE 3 1.7 2.0 MEDIUM 4 0 1.6 LOW 5 6 2.2 </tbody> Return the appropriate string from column C where B6 is > column A and <= column B

Hi, I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour. The objective of the databook is...

Hello once again people. I have a problem i have been trying and it has been trying me. I am try to index and Match from a risk 5x5 table and place the corresponding outcome from the risk matrix. I have tried various formula for indexing and matching with a result of "Value"or Ïndex"in the cell...

I am trying to do an auto-stats sheet and need some help. We have assigned a value of HIGH and LOW based on a specific set of criteria. I'm trying to get a formula that will count how many cells apply in the given criteria: Count the number of sells in range of $Y$7:$Y$2478 that equals the...

Hello, I have a VERY large file that I in summary need to find a number between a range of cells. So Column A I have a low number Column B I have a high number (goes to row 1,000) and need to know if this other number (column C) falls between ANY of those ranges. See below for a small snipbit...

Hi, I have two tables, one with "source" data as follows: <tbody> A B C D E F G H I J K Lookup Helper High Low Geo_Lookup Geo_High Geo_Low Other Class Description Important A1 A1 11 Apples & Oranges N A2 #ALT 2 Apples & Pears N A2 55 High Apples & Pears Y A2...

So basically I have three categories, high, moderate and low. I want to have one filter on the top where the "high" category would include all high, moderate, and low data points(working with text no numbers). The next category would be "moderate", but only includes moderate and low data...

So I want to some conditional formatting that will color columns A through D in green if the cell in column D says "Low". I want this to apply for range A3:D100. Thanks!

Hi Guys I am trying and struggling to create a nested IF statement for risk assessment that works this way: The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low...

Hi All, I have a code that works great for returning information from cells that contain numbers derived from formulas, but not when one of the values can be "" or NA(). The code is =SUMPRODUCT(($G$6:$M$9)*(F6:F9="butter")*(E6:E9="low")) The layout looks like: <tbody> high eggs 33 31 38...

I just can't seem to figure out how to create this formula. So let me try my best to explain. I have a set of data with various members where each of these members have 1 or more "HCCs." I also have a hierarchy table in which if a member has a "highest rank HCC" and a lower rank HCC in the same...

Hi There. This may be too much of wishful thinking. I have a chart that plots the supply and return temperature from a heat exchanger. The pattern resembles a sine wave, however there are many spikes/valleys within each sine wave cycle. I am trying to get the numbers from the lowest point to the...

Hey guys! I'm working on my thesis, and I have a lot of files with the following data type: Date Time, GMT-04:00 Temp, °F 8/3/2011 17:40, 75.832 8/3/2011 18:40, 73.062 8/3/2011 19:40, 71.168 8/3/2011 20:40, 68.934 and I just need to pull out the highs/lows per date to graph. I'm having...