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). ...
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.
