I am really confused about what to use for this data.I have included the instructions for the task as well.Any help would be appreciated.
i cant upload a sample output right now,i ll try to explain as well as i can.
the aim is to automate the calculations that are required to fill the light green fields in sheet 3.
for example if I enter the name of my trainer against his trainer id in sheet 2..based on the data from sheet 1 the calculations have to be made and the fields in sheeyt 3 have to be filled.
Also please note that the entries with status value "error"should be ignored for the calculations but have to be considered for the bottom table count.