-
Identify Duplicates with 2 criteria
Hello, I am trying to flag duplicates that meet 2 criteria. I have a sheet that has Request type actions (Add, Revise, Delete, etc.) and also a Part ID column. I am trying to identify duplicate Part ID that also have the same Request type. See screenshot. Ex: Row 1 and 4 should flag as duplicates as they are the same part…
-
Invalid Value Error with New Year
Hello! I have created a formula for 4 months after a specified date column. The problem is, when that 4 months goes into next year, I receive the "#INVALID VALUE" error. For example, if my formula is using the date of 08/31/19, I receive the proper formulated response of 12/31/19...but if I change the date to 09/01/19, I…
-
At Risk Flag Formula
I have tried searching and figuring out what my formula should be, but I just can't get it. I want my flag to be red when there are 3 days or less to due date. Frustrated. See screenshot.
-
Calculate the MEDIAN and MODE from a list of numbers
Hi there Does anyone know the formula to caluculate the following (based on a list of numbers within a cell range)? MEDIAN - The middle number when the numbers are put in order MODE - Most frequently occuring number Thanks in advance Phil
-
Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
-
Help With Getting a IF statement to work when using columns referenced from another sheet
Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references. I am having trouble getting this to work when using a range of items. When I use the COUNTIFS function, using areferenced…
-
Converting result from an Index & Match formula from date to text
Hello all, I am trying to work on a formula to make it easier for me to work on Global Updates in Control Center easier in the future. I currenly have a formula that coverts the data from Date to Text instead of just a simple link to the (lets say) the Start Date column; I had to do this because of the Global differences…
-
Cell formula that will highlight a task expired if any of its sub tasks are expired
Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks