high

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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