I'm building an exercise tracker with DATE, EXERCISE, VALUE column. I'm racking my brain to come up with a formula that could populate a new column with the last maximum value of each exercise according to date. i.e.
So in this case, my performance history for exercise A is:
Last maxes should be
So far, I've managed to sort the VALUE by last largest (though cells that are not MAX are "", instead of filling with last MAX value) with
but can't figure out how to discriminate and track last largest of individual exercise. I can also