Hi all! I have a file attached. It is a risk assessment with Level 1-5 risk levels. Level 1 and 2 are in A2 on both tabs.
A few risks have numbers under column E and column F, some do not.
What I want to do is open a third tab, and pop a formula in that will extract only the risks with a number under Column E and Column F.
For example, in tab 1..3 of the risks have a number under Column E (Impact) and Column F (Likelihood).
I would want a formula (in different columns of tab 3 which I would add), that will extract all the information and the associated risk level information.
So the first row of information would read
Donuts; Donuts Flavor; Eating; Utensil; Fork; Risk of eating donuts with a fork and making a mess; 3; 3
Does that make sense?? I really need your expertise on this and THANK YOU!!!
Bookmarks