Look up last dates with values

mrbouwer

New Member
Joined
Sep 23, 2014
Messages
1
Dear Pro Excel Mates,

For my project I need to derive the last recorded Self Grade and SV (Supervisor) Grade.

A little background: employees get evaluated and each row is an entry.

If they evaluate themselves, the Self_Average is recorded (the AVG of all criteria scores) and no Supervisor grades are recorded.
If evaluated by their Supervisor (SV), the self criteria are blank, just as the Self_Average, but all the SV criteria grades are recorded, as well as the SV_Average.
If its an Annual Appraisal, both the Employee and SV will grade.

I want to have a formula that gives me the last Self_Average and one for the last SV_Average, according to date.

I also want a formula that gives me the "Till date" Self_Average (so all AVGs of Self_Average, apologize for ambiguous wording) as well as for the Supervisor "Till date" SV_average.

Thank you very much!

Testdata link: http://www.filedropper.com/testdata
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,857
Members
409,840
Latest member
priyanshu270
Top