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.
Values go to the values area. You have two values: check in time and check out time. Change the function to Min. and Max. resp. Standard function would be Sum.