We require a few formulas to be created in Excel. The sheet is attached.
We require the following:
A) !ExtPackTrack F: Column. Need to know if this data will be TRUE or FALSE based on checking StudentID in Column A, Day in Column E against the same StudentID on !ExtPackDays and whether or not Mon, Tue, Wed, Thur, Fri is present is matching StudentID E:I columns.
B) !ExtPackTrack G: Column. If F:ExtPack = TRUE, value is 0.
If F:ExtPack = FALSE, Value is gotten from matching Timestamp with Class of !ExtFalseTimeCalculation
Hello sir!
I'm seeing your project details carefully and I’m very considering your job such as these capabilities.
I'm ready to start now, Can you please contact me so we can chat more for this project.
Thank you
Best rewards
Barun
hello
i have done excl advance course. so familiar with the formulas and also doing teaching job so know about the type of data required in education field.
Throughout my career I have prided myself on being punctual and having good time management; I am able to priorities tasks and to work to deadlines. I am also independent and work well under my own direction whilst maintaining a high standard of work.