Trending in Formulas and Functions
-
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
-
MAX children date if another children column is not blank
I am having an issue with a formula. I need to capture the children's max date for Closed Date only if all children's Location cells that are not blank have a Close date. With the sample below Currently, the Parent Close date would be blank as not all of the Locations 1-4 have a Close Date. If all four locations had dates,…
-
Identify MAX Date for each employee
I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that? The…