Good evening friends. I am working on a spreadsheet that includes "initiatives" that have been bucketed into a pseudo-Eisenhower Matrics (Do first, Do next, Do later, Delete). The spreadsheet layout is something like below (Initiatives in column A, Priority in column J and E.Sort in column N). I...
I have a list of multi-leg airplane routes/destinations. I'd like to have table banding/shading by route number (is an actual number). So some bands might be 1 or 2 rows high while others might be up to 5. How should I go about this? Conditional formatting may be the answer but it's not a...
As per the title.
The issue is column Q
Cell Q10 shows Dog
Cell Q156 also shows Dog if i change the text to Cat then the Red high light is gone
Now these two cells are high lighted Red ?
I do have a code on this form which looks for duplicated entries in Column A for...
In tab1, I have a table with the end user will complete:
In tab2, Column B is what I'm attempting to get as an end result. I can't...
I am trying to construct an IF Function for the following problem:
5 collums of data (A,B,C,D,E) and 33 participants.
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...
I want a formula to count when a number is between a range and another column has the appropriate text.
It will be similar to =COUNTIFS(I10:I328, "H = High ", L10:L328, "Closed") except where I10:I328, "H = High " is a number range instead.
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...
Hello. Within an Excel workbook I have a worksheet that has 30 columns and more than 50,000 rows. Below, I’ve have copied 7 of the columns and 29 of the rows (not including the two column heading rows). Let’s call this worksheet 201617. On another worksheet (also below), which I will call...
It may be easier to explian in a diagram below what I am trying to acheive.
Any help would be much appreciated.
Idea 101 Low
Cell reads whether text in Idea 101 Low, is Low, Medium or High and dispalys that...
I'm trying to generate a bubble quadrant chart, but need to further refine my data. The quadrant will have Impact along the X axis and Timing along the Y axis. The size of the bubble should be the quantity of the Category. My data looks like the below:
Category Issue Description impact...
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:
Projects Benefits Complexity...
I have a workbook that records new files saved into a folder and generates a hyperlink to that file.
In each workbook file that is saved there is one cell that advises if the value is Low, Medium or High ( in this instance cell is D3).
I need my workbook that stores these hyperlinked...
I’m a bit out of my depth with this one!
Effectively what I am trying to do is calculate the time commitment of each employee based on a number of criteria. <o:p></o:p>
Each employee is allocated to a number of jobs – the time commitment for...
I have a formula that looks up a project id and returns values "very high", "high", medium, low.
I want the formula to look up the project id and when the value is Very High, display VH in the cell instead of Very High, H instead of High, M instead of Medium and L instead of L. Is that possible...
I have a bunch of IP Addresses in Column C that are in consecutive order containing duplicates. In Column D I have a text value that could be 1 of 4 items (Critical, High, Medium, Low). I need to delete the Duplicate IPs and Sum the occurrences of the criteria in another Worksheet to the same...
Good afternoon fellow peeps.
I am struggling bit time with this one, and no amount of research online is assisting me with the correct formula
I have as follows
High Tide Minus 15 minutes
High Tide Plus 15 Minutes
I have cell K12 in which a summed value is displayed. There are thresholds (reflected by CF colouring). That's by the by I realise. These relates to subjective descriptions of low, medium, high, extra high.
In the cell below (in K13) what do I need to put in to get, depending on the score, the...
So I am trying to put a formula/spreadsheet together that does the following. % return...