critical

  1. C

    Finding the correct % value

    I have 20 assets (devices) 9 of the devices have vulnerabilities. Device 1 has 8 x critical vulnerabilities and 20 x High vulnerabilities. How do I correctly determine the true percentage values of Critical vulnerabilities and High vulnerabilities against number of assets with issues...
  2. S

    Determine result based on age and score

    I would be so grateful for your help. I have been searching for days and am at a loss as to how to even find the answer. I need to determine whether a group of Primary School children are Below, At or Above Level based upon their score and where that lies in relation to their age. I can either...
  3. 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...
  4. Y

    Formula help please

    Hello, first time I have posted and need some help please. I have a table with 10 questions and people can choose from a drop down to say if a question is Critical, Essential or Recommended so I could end up with 3 Critical, 4 Essential and 3 Recommended etc. On a summary table I then want to...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top