risk

Hello, everyone I have three columns, F, AC and E. On column F I have the name of a Risk and on AC I have the department which have identified such risk. I'm trying to give a serial code to risks on colum E. Things to consider: - Each department can identify the same risk more than once. In...

Hello, I have written the following code, to copy relevant information into a different workbook, and then run a marco in that book. but it cannot find the Marco, "Macro3" Have I missedsomething? The data has pasted across,jut need t Marco to run. Thak Sheets("summary").Select If...

Hey, everyone, I just joined a company a couple of weeks ago and I realized that the department I'm working on has a lot of room for improvement. I don't want to get into details, but we deal with risk management. As we can imagine, we have excel files with hundreds of risks and KRIs that were...

Hi Folks, Sorry if this is a double post but my last one seems to have disappeared Hope someone can help. I'm using the following if statement to populate a calculated value in sharepoint. It ensures the values defined are present before populating the email calculated field...

Greetings, I am working on a spreadsheet for risk assessment entries, the spreadsheet will have specified areas for up to 20 hazards with 12 risks for each hazard. I will need specified rows to hide or unhide based on the numeric value of a cell in column A. i have received excellent help and...

I have a Risk Analysis spreadsheet. User registers a Risk, the number of the analysis, analysis date, risk probability, risk impact, days for next analysis. For the sake of clarity, lets not even consider the risk probability and risk impact. So you have like <tbody> DATE RISK NAME #...

Hi there, I am trying to construct an IF Function for the following problem: Data: 5 collums of data (A,B,C,D,E) and 33 participants. Conditions: define person as 'high risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than...

From a report, the data within one column will have multiple line breaks within the cell which I parsed out via marcro. Here is an example the layout of the mentioned cell: <tbody> Full Text: Here is the full sentence Description: Here is the full description for support. Type (1): Color...

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

I have created a Risk Register, which lists the number of days a risk has been open for, using the formula below (Column AC), where G4 is the date the risk was identified / raised on the register. =IF(AA4="Open", TODAY()-G4, "") Column G - Date Originated Column AA - status, either Open or...

Hi All, Hoping someone can help me sort out a dilemma I am having moving data from one sheet to another. I have data placed in Sheet List2 in a set order from A2:D2 and subsequent rows (3, 4 and so on). I am able to copy the first to to Sheet List to where I want it into a new row, however...

Hello, I am creating a databse to hold Risk Assessments, when a new Risk Assessment file is created and saved into the correct specific folder, excel picks this up and automatically generates a hyperlink to that file and also when the file was created into the database. In the new files that are...

Greetings, I am trying to put together a user defined function called risk of ruin. I would like it to output the probability associated with the occurrence of the 'bankroll' variable falling to <= 0. I am receiving 0 values as output for some reason. My graphing calculator and wikipedia...

Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...

I would like to write a formula that assigns a number to a cell value based on a range of numbers. For example, I have a column that calculates 'risk percentage', which I then need to assign to a 'risk ranking' as per the table below: <tbody> Risk Ranking Percentage Range 1 <10% 2 10-20%...

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545} </style>I’m trying to create a Monte Carlo simulation using Excel for an engineering project management situation. I have 100 or so project risks that threaten my project. Each one of...

Apologies in advance as I think there are some threads covering similar topics, but I have been unable to get the vba in them to work as needed, as I'm pretty new to it. I am creating a risk register table (in a worksheet called Risk Register) with values added and updated from an input macro...

Hi I'm trying to sort data in excel (see example below) that has gaps. I have tried grouping by individual risks and then sorting, but it still doesn't seem to keep the information together. How can I sort this info (sorry, I'm not an excel superuser so please explain in basic terms) so that...

Hello, I need the Column R to be search to see if it contains the value in Column C and for each row that does not contain the value in Column C to have the row deleted. The below is a sample of the data: CR Number FRS Type FRS ID Business Risk GxP Risk Other Regulatory Risk FRS Name Doc...

Hi All, I have a table with a number of risks in it across 50+ departments. I have a formula which provides me with the top 5 risks (based on risk score) across the entire building as a whole, however, I want to adapt this so that when I change the department via a combo box with a Cell Link...