1. C

    Rank IF / Sum product - Multiple Criteria

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

    Line Chart High & Low Points

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

    Return string when value between 2 numbers

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

    Representing a range of percentages with a number

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

    Risk Matrix Index and Match Problem

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

    Multiple count IFs

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

    Between Range of Cells

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

    Index Match with multiple nested if statements

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

    One filter for high/moderate/low by using groups

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

    Conditional Formatting: Color row green if cell in column D says "Low"

    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!
  11. Z

    Complex IF Statements

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

    Very strange SUMPRODUCT failure to return

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

    Excel Formula with Hierarchy Table

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

    Automatic high/low data callout for nearest point to click on chart

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

    I need to pull out high and low temps based on (weird) date, any help please?

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back