-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
INDEX COLLECT MIN
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
-
Count of Distinct Users in a Date Range
I am working on a metrics formula. It worked when I wrote it, I was using the data in a graph, which worked, I changed the graph type, and suddenly the data went to zero. Now, all o my formulas set up like this are all returning a value of 0. Trying to determine what went wrong. I am attempting to count the number of…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
Sumifs formula shows wrong value
Hi., I have two sheets: one is the Master Sheet, where multiple people enter and update their status, and the other is a Report Sheet, which summarizes the data using a SUMIFS formula. I’ve been using this setup and formula for about two years without any issues. However, for the past two days, the summary sheet has been…
-
Creating an Invoice
Good afternoon, I hope this makes sense. I know I have done this before in Excel but cannot remember how I did it. I am assuming it will involve some helper columns. I have a list of 100 people. These people can submit any number of timesheets for the month (though typically 0-4). They submit one timesheet per project for…
-
Return a value when one date is less than another
I'm trying to project the amount of non-bill hours we plan to spend on a project between the non-bill approval date and the contract end date. I'm getting an invalid operation error when using this formula: =IF([Column2]1 <= [Contract End Date]@row , [Approved Hours per week]@row , "") Here's my column setup: I've…
-
Average Collect Unparseable Error
I'm getting an Unparseable error with my average(collect) formula and can't figure out what's wrong with it. =average(Collect({Days to Approval}, {Level}, CONTAINS("Level 1", @cell ), {Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row )) All the references within "{}" brackets are columns…
-
SUMIFS Formula, Criterion change based on row
I am working on an attendance tracker that counts the points "Occurrence" someone "Employee Name" gets for missing work in a rolling 12 month span "Rolling 12 Months?". I am attempting to use a SUMIFS formula to create a running total "YTD" of the points someone has accumilated, using the criteria of their name, in the…
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…