I have a simple three column sorted list of customers(a), dates(b), and revenue(c). I'm looking for a way to sum each customers revenue by week (monday to sunday) starting 2018-01-01, and accounting for instances of weeks with no data by inserting a row. Essentially turning this...
I'm trying to work on a formula which has me stumped.
I have a table which contains Names in one Column(A), and Dates in a second Column(B).
I only want to return column B DATE if the Column A Name is Bob
But it has to be the last Row that has Bob in it