I have a spreadsheet that has grouped repeating numbers in column B. There are times associated with those numbers. I need the last number in the group minus the first number in the group to be in column M on the last row in that grouping.
Sounds confusing, but I've attached a spreadsheet to make it easier. I know that I can do this with VBA but I would much rather use a formula.