I have a list of names. A person can appear several times in column a. Column B has the check in time (all different for each name instance). Column C has the check out time (again, all different).
How can I request the earliest and latest check in/out time per person? (Column C and D) This data is for one day.