-
Is it possible to look-up information from a different sheet with more criteria?
Hi all, hope everyone is doing fine here. I'm working on a sheet to specify information from a larger sheet. I was wondering if it is possible to vlook-up information with more lookup values? Hope you can help me out! Jordi
-
Countif with Dates and Criteria
I am trying to do a count of a symbol (red dot) by each month. I have a column for the month "Date" and four columns (Missing Mentoring Form, Missing Training Course, SharePoint Error, Skillset Does Not Appear on Training Matrix). When there user selects a drop down to red i would like it to be counted. I have that running…
-
Formulas seems not to be calculated
I have a big sheet of ~11000rows by 30 columns (an asset register) I added 2 columns to calculate the duplicates =IF(COUNTIF([L2]$1:[L2]@row, [L2]@row) > 1, 1, 0) and to select the rows to show in a filter =IF(AND([DuplicateL2]@row = 0, NOT([L2]@row = "")), 1, 0) Copying/pasting or Selecting + CTRL+D the formulas has been…
-
How can I pull a report- or write a forumula to show me Rows with a specific status?
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing…
-
If formula for RGYB balls
Hi All, I want to create a column so when i change the colour of the ball it changes to a set word. So Green will say "install" for column 7 Red will say "work needed" for column 7 Yellow will say "At VC" for column 7 Blue will say "Back from VC" in column
-
Column Reference Formula Returning Incorrect Answer
I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that are not installed or closed to determine how many are "in process". This formula which…
-
Copy INDEX formula down for the rest of the column
Hi all, I want to autopopulate the first column of sheet B with the data from the first column in Sheet A I got it to a point with using the INDEX formula to reference, but now I cannot drag the formula down to apply this for the entire column. This is for row 1 "=INDEX({Sheet A MUR TN}, 1, 1)" I think I am missing…
-
Counting Checkboxes in a row and then showing the average %
I am trying to find the average of checkboxes in a row. At row: "Clear pads as needed..." I want the % to add up as each box is checked. What is the formula? Appreciate the help.
-
SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned. =SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed]) However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to…
-
Count IF on System-Generated Column
Is there any reason why this formula would be totaling a different number than what I am seeing here? I am counting 17, however, the formula keeps returning 30. I am counting 17, however, the formula keeps returning 30.