In sheet Apr 17 I have shown a possible formula in column C. Note that Supervisor and user are defined names (Press Formulas on the Ribbon, then Name Manager). I have also added an IFERROR to your formulas in columns F and J. You can delete the IFERROR construction again if you want to see the error messages. If you like what I have done you can make something similar in sheets May 17 and Jun 17.
I hope Q1 now shows what you expected.
|