low

  1. B

    Risk Assessment Calculation

    I am trying to calculate the level of risk for a particular item based on the user inputs to two fields. Column A = Impact; drop down of values Column B = Probability; drop down of values Column C = Risk Level; calculated based on the entry in Column A and B and where they intersect in a...
  2. B

    Formulas for 9 box grid

    I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...
  3. B

    Formulas for 9 box grid

    I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...
  4. B

    Sorting Column that has formula

    Greetings, I have not been able to find an answer using search techniques and hoping some one may have a solution for me ... I have a worksheet with a couple of columns that have formulas. The formulas' result is to conclude with either a specific cell's value (it will be numeric) or results...
  5. A

    How to see last four numeric values above in a column

    Hello, I am looking for a formula that will look up in a column from the row I am in and tell me the first 4 unique values it sees ignoring gaps. So that the result should look something like below. So each column row for HHHHLLLL will show the first above values for the High and Low columns. I...
  6. S

    IF statement with Concatenate

    I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement...
  7. A

    Combo Box Depend on TextBox Value

    Hello Everyone, I have two option button : London_Click() and Paris_Click() One text Box : TextBox1_Change() One combo box: DropDown_Change() Under the Combo box I have below items: "High London" "Low London" "High London 2" "Low London 2" "High Paris" "Low Paris" "High Paris 2"...
  8. H

    IF statement with range of numbers

    Hoping you could help me with an IF statement with range of numbers. For example, per the table below, if my value is between the low range (i.e. 137) and high range (i.e. 227), i want Excel to return "Level2", and so on <tbody> low high level # <colgroup><col...
  9. O

    Design software using excel equations

    New user here in need of help. I am creating a mixture design using 3rd party software and needhelp setting up the constraints. I’m using Excel to do the math and willput it into DOE software. What the DOE softwaredoes is it looks at the high and low ranges that you enter, and it...
  10. G

    How to efficiently model this data set?

    Hi, I am pretty decent with Excel, but wanted to know if there is an efficient way of modelling this, without having numerous if statements and vlookups. Scenario: What I have: - Data Table containing amounts labeled by a chronological key 1 through 100 with letters assigned to each amount. -...
  11. B

    If statement question

    Hello all! MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project. I'm attempting to solve for the Status As shown below, if the resident earns above...
  12. T

    Nested IF: return "High" if cell value is >5, "Low" if <-5, and "Mid" if in between

    I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...
  13. M

    VBA - Error Randomly Generating Numbers

    Hello, My script gives a randomly generated number between a range of numbers the user specifys. Take 2100 and 2199. The script will generate a random number between those numbers. But before the script generates the number - I want to compare it too a list on another sheet to see if the number...
  14. E

    Weighted Average / IF statement

    Hi all, Any help would be appreciated. I am trying to create a way to model some data in Excel. This involves taking three sections (lets call them a,b,c) and their sub-sections (lets call them A1, A2, A3, A4, B1, B2, B3, B4, B5, C1, C2, C3) and adds individual confidence ratings to these sub...
  15. A

    Risk Matrix INDEX & MATCH issue in Excel

    Hi All, I'm having an issue with an excel INDEX and MATCH formula for the risk matrix below. The formula I've used is: =IFERROR(INDEX('OHS Risk Matrix'!$C$4:$G$8,MATCH(C24,'OHS Risk Matrix'!$C$3:$G$3,0),MATCH(B24,'OHS Risk Matrix'!$B$4:$B$8,0)),"") It looks like it worked perfectly, however...
  16. S

    Add multiple columns into one cell

    In tab1, I have a table with the end user will complete: <tbody> Type Check 1 Check 2 Check 3 Check 4 Check 5 Check 6 Check 7 Check 8 Check 9 Combined Check Type1 L M L H H Type2 M L M M M </tbody> In tab2, Column B is what I'm attempting to get as an end result. I can't...
  17. D

    Extract unique values across rows and columns

    I have a sheet that looks like the below (except 4k rows and between 1 and 79 columns) I would like to extract all the unique values into one row or column so I can see what all of these unique values are. Removing duplicates does not seem to be working. <thead style="margin-left: 0px...
  18. Z

    Using Data from dropdown list

    Hi all, Need a favor. <tbody> A B C D E F G 1 2 Risk Profile 3 Low Medium High Score 4 Risk Appetite Low 1 2 3 1 </tbody> I like to have the Score (Cell G4) displayed based on selection made in Cell B4. Example if User choose "Low", Score = 1 Many thanks in...
  19. E

    IFS statement not working with SEARCH function

    It seems that the last part of this statement that uses the SEARCH formula is not working (highlighted in red). If cell C2 contains "1%", it will return the correct answer, but if it contains "2% or "4%", then it will return #value . Basically, the formula recognizes the first SEARCH, but not...
  20. M

    High, Low and Average based on two separate criteria

    <tbody> Item Price Classification A High A Low A Average B High B Low B Average Item A £4.50 A Item B £6.50 B Item C £5.75 B Item A £3.60 C Item B £10.05 E Item C £6.80 C Item A £4.75 B Item B £7.20 A Item C £5.45 B...

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
Top