How to get the highest value PER name in list?

[Dragon_Claw]

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.

[#2]

Hi

Use a pivot table.

[#3]

And what values go where?

[#4]

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.