high

  1. W

    Need help urgent!!

    Here's a quick question. I am currently trying to create a calculator on excel that determines if a cell is greater than 10% then by how much and then allocates the amount that it is greater than to another cell respectively. So I have 3 categories High Medium Low that equate to 100% there are...
  2. B

    Index and Match Help for Risk Calculation

    I am trying to auto populate the risk level of an item based on the selection from two fields and where they intersect in a matrix Column A = Impact; dropdown selection Column B = Probability; drop selection Column C = Risk Level; calculated based on the selection in the above two fields and...
  3. 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...
  4. J

    Find a name when there are duplicates in search columns.

    <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Gender Name hcp HGS HSS HGH HSH gms Ave Total Pins HGS Left High HGS Right High HGH Left High HGH Right High HSS...
  5. E

    Consolidating multiple rows into one row with row data from some columns across page

    Hello. I have multiple rows of data that I would like to consolidate into one row based on information in a number of columns. In the example 1 below I would like to consolidate all rows based on UniqueId, however would like the rows for Product & Question columns combined across the page with...
  6. 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...
  7. 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...
  8. 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...
  9. R

    Highlight high value row

    Hi, I would like to highlight the entire row based on the high value of an item: Here is sample data. <tbody> Item name Value A 5 A 4 B 8 B 2 B 0 C 9 D 12 D 12 D 11 D 2 D 0 </tbody> Data is sorted by item and I would like to highlight the entire row based on the high...
  10. 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...
  11. N

    VBA so it returns 2 columns of data not 4

    The vba codes (TeeDrawPlayers) below returns 4 columns of data and the second one (TeeDrawCarts) I want it to return 2 columns of data how can I update the second one to do this Cheers NZAS Sub TeeDrawPlayers() Range("A3:D40").ClearContents lo = Range("A2") ' low hi = Range("B2") 'high rg =...
  12. P

    GetPivot Function to get Sub Total

    Hi All: I have a formula: =GETPIVOTDATA("[Measures].[Sum of Apr-19 2]",$D$15,"[TotalCombinedFTEByCheckType].[Check Type]","[TotalCombinedFTEByCheckType].[Check Type].&[High Risk Trader]") - which gets the subtotal for column named High Risk Trader. I need this to be dynamic and refer to a...
  13. 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...
  14. 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...
  15. 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. -...
  16. A

    Dependency Data Validation help!!

    Hello, I’ve been asked to create an employee performance review spreadsheet with drop down lists, each employee will receive a percentage of their pay as a bonus. Every employee is in one of three incentive categories (let’s say these are called high, medium and low) and for each rating (let’s...
  17. sharky12345

    Rank data with specific text

    I'm using this formula to rank my data; Can anyone show me how to use specific text instead of a numeric value? What I'd like is LOW, MEDIUM and HIGH instead if that's possible?
  18. C

    Nested IF formula

    Hi, I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received! SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a...
  19. S

    Calculate Weekly High - Stock market basic data.

    Hi all, I am hoping this is an easy get for someone. My brain has shutdown after waaaay too much computer time. I am trying to show the highest of the high's of the previous week. In my data each row represents a trading day. I have the current week number in "g" column. I would like to look...
  20. 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...

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