May 9, 2019
December 7, 2016
April 21, 2015
Can't help you with all three questions, but fixed the last one. @Anders: I think he is looking for formulas and that's why they can't be found in his sheet. The questions are in the sheet.
Mohamed: I splitted the cells back to normal in your columns I and J and put a MIN and MAX (with conditions, don't know how they are called in English, but you'll find them in the cells). That'll do.
There is a trick for your other two questions, I saw recently on Sumit Bansals website (Trump Excel), but can't remember how to do it. Maybe you can look yourself there, or somebody here helps you.
June 25, 2016