I'm trying to take a list of values in Column A, then in Column B define which ones are "high ranked" and which are "low ranked" So if I have the table shown below, I 'd like to take the top two values in column A and in column B label those as "high" and the bottom two should show as...
Greetings all - and Merry Christmas, Happy Holidays and a wonderful whatever else you may choose to celebrate at this tail end of the year.
I have been trying accomplish this below, and google, this site and many others have led me close, but I just can’t find the right bit to get it done...
I nead to know if this is possilbe, I have 7 Pdf files ond each one have+- 6500 pages, on each page there is certain info that I need to put in an one excel sheet.
it looks like this
VMSA-2015-0007: VMware ESXi OpenSLP Remote Code...
This is my first post and I'm really stuck on a formula. any help would be really appreciated.
I've got a column of results from various checks across my spreadsheet, and each of these checks will come back with a result of High, Medium or blank.
What I'm trying to do is create a...
I'm working on a spreadsheet that we use to record Supervisor safety contacts (when Supervisors have a "safety moment" with an employee). The contacts fall into different categories/topics (ie: PPE, egonomics, etc.).
Each department (packaging, production, etc.) has a different list of...
I have a horizontal line chart that contains numerous high and low points (with time and date stamps). I am trying to write a formula (or find a function) that would calculate the distances between each high and low point for each of the drops (sometimes numerous ups and downs per...
I am looking to perform the following but cannot figure out what to do with the middle IF statement?
I know there is a simple solution, hopefully.
I'm lost on this one and been trying different things but still can't get it to work.
I have a workbook setup, the first sheet pulls totals from other sheets. I have everything working accept one thing.
On the 1st sheet, I need the account balance to increase when there has...
Need to Automatically distribute Items based on priority level and type set for different People.
Find sample below
I have the following code (its in word but figure its still vba) could this be written better, i expect so but my skills are limited. Any ideas?
Private WithEvents App As Word.Application
Public Sub LiklihoodCombos(pcb1 As ComboBox)
.Value = "Select."
If .ListIndex =...
I have office 2013 and 2016. The option for 'Default Resolution' as High Fidelity does not show up for me. Any ideas how to show it?
The link from...
Could you please help over this formula where I need to have separate logical test where if two certain cells contains special text like medium or high an x should be replaced in other certain cell
formula is like but not working...
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...
Good evening I have a sample of data below. I have about 200,000 rows. I am looking for a formula or subroutine that will find the school month and calculate the frequency like below. Here is an example I would like to check Lincoln School in the SEPT column and count how many cells are 1 to 4...
I have a VERY large file that I in summary need to find a number between a range of cells. So Column A I have a low number Column B I have a high number (goes to row 1,000) and need to know if this other number (column C) falls between ANY of those ranges. See below for a small snipbit...
I'm trying to create a nested formula in cell Y1 that will return the values of HIGH or LOW depending on a few criteria.
1) First off - I want the cell to return a blank value of nothing applies
2) Looking to have the value of HIGH or LOW returned depending on if the value in...
Would anyone know how to work out the weighted average P Year based on the Area field for any given Species in the table below where Land Use can be either High Forest or Windblow and Forecast can only be F?
I can do this with sumproduct but am not sure how to have more than one allowable...
I have two tables, one with "source" data as follows:
Apples & Oranges
Apples & Pears
High Apples & Pears
Help would be great people.
Could someone point me in the right direction with a formula that would calculate the aggregated Total (Col B) for South Location (Col C)? The answer should be 14.
And if it's not too much, the Total for South Location where the Severity is High? Should b 9.