Forum Discussion
How to get the highest value PER name in list?
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.
How can I request the earliest and latest check in/out time per person? (Column C and D) This data is for one day.
Hi
Use a pivot table.
- And what values go where?
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.
