-
Need Formula to Match Names in 2 Different Sheets
I have a list of people in one sheet and I need to know if the names in another sheet are included on the main sheet. What's the easiest way to go about this? The tricky part is on the source sheet I have a column for first and last name, and the supplemental sheet that I need to check against has separate columns for…
-
How can I change the color of a cell if five certain columns all contain "Located" or "Clear"?
I have a column named "Ready". I want to change the color of the cell in that column to green if the cells in these five other columns all contain "Located" or "Clear". I've figured out how to check a box if any of these columns contain "Delayed" but I want a visual representation if the row is completely ready. I've tried…
-
Need to flag an entry that is a duplicate of a previous entry that includes time
I have created a solution for our staff to reserve desks when they are coming in to the office. They select the desk, the day and if they want it for the AM, PM or All Day. By using formulas and helper columns I can get the solution to let a person know when their reservation is double booked based on the desk and date…
-
Help with Anniversary Formula
I have a sheet where I would like a [Next Anniversary] column to display and automatically update the next upcoming anniversary of [Hire Date]. I don't want the [Next Anniversary] column to display the date and month with the current year, because some of the dates have already passed. (ex. if [Hire Date] is 2/5/19, I…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
How to calculate number of days a project is at a certain status?
Hi all, I am looking for a way to calculate the number of days a project is on hold based on a change of status. In my theoretical planner, I set a project start date and input an estimated project duration. This calculates a predicted end date. I have a column where I can define the project status, these are "In…
-
Using COUNTIFS with AND in Summary Sheet
Current Formula is for # Enrolled =COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course") I need a formula for Enrolled AND # Late Status Red X
-
Count If Current Week
Hi Everyone, I have some daily data with dates and I want to get the week to date numbers off that data (Monday - Sunday of current week). I know countif is needed but I'm not sure how to go thru the rest. Your help is appreciated.
-
use a reference sheet to gather data for another sheet the rows will differ between 2 sheets
Hi All, I've been pulling my hair out and I'm hoping someone has advice. Bing Copilot is running me in circles because it doesn't understand. I have a sheet with SAP appeals that all steps have been completed (SAP completed sheet) going forward in the example. If the student turns in an appeal to the decision then they are…
-
is there a way to generate incremental number to name that is listed more than once
I have a store number; each store has a monthly store visit date. I am looking to use the store number and add the number to show how many previous visits there were before. I have a formula to add an incremental number, but it did not represent the number for the specific store's visit. Is there a formula that can get me…
