Awesome. Very helpful.
Now, a new issue.
(Q5) is reading an error because (Q4) is a formula that calculates the average of (Q1-Q3) and its result contains a number to the millionth, which the VLookup in (Q5) cannot find. Obviously, I cannot include all possible divisions between 1 and 5 inside (A8:B21).
(Q4) formula reads: =IF(COUNT(
Q1:Q3)>0,AVERAGE(
Q1:Q3),"")
See picture, below.
Screen Shot 2016-11-07 at 8.01.33 PM.png