moderate

I am working with 7 lists using conditional formatting to sort list selections by color. I am hoping to find a way to combine list results to reach a conclusion. Each list supplies the option to choose Low, Minimal, Moderate, High. If List 1 is Moderate, List 2 is Low, and List 3 is Moderate...

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

Hi All, I am a VBA newbie and would like some help with getting the code right background: row number of these values are never constant, ie one day row D6 might contain the keyword minor the next D65 might contain the word minor. (Refer to screenshot) goal: I want to script to search...

So I have this question that asks: In the past 30 days, how many days did you have: And the user puts in 3 different amounts of days, mild, moderate, or severe. I want the final textbox to automatically calculate 30-input for mild-input for moderate-severe. here is an image:

Excel 2016 without the office 365 subscription so I can't use IFS. So I've got two columns of conditions. Column 1 has five possible values; low, low/mod, moderate, mod/high, and high. Column 2 has four; Strong, adequate, needs improvement, and none exists. I want to look at those values and...

Hi all, could anyone please help me to sort the below question. A table contains List of project, Benefits and complexity and another table contains Headings and rows as Complexity and Benefits how could i get ans like in the table 2: For Eg: Table 1: Projects Benefits Complexity...

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

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