Requiring a little help with two formulas and hoping someone can help without the use of powerquery or programming.
Column A employee names Column B sale date Column C sale amount Column D each employee's cumulative sales
We also have a sales target ($15 in example).
Column D and column J are what I'm searching for (Imgur link). Helper columns are fine!
Column D = cumulative sales for each individual, restarting when the employee changes.
Column J = xlookup the date when the sales target was reached for each employee.
I only care about the date where the target was reached. Cumulative sales don't matter. There are thousands of lines of data, each employee has a different number of li

