Home

How to get the highest value PER name in list?

%3CLINGO-SUB%20id%3D%22lingo-sub-339414%22%20slang%3D%22en-US%22%3EHow%20to%20get%20the%20highest%20value%20PER%20name%20in%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339414%22%20slang%3D%22en-US%22%3EI%20have%20a%20list%20of%20names.%20A%20person%20can%20appear%20several%20times%20in%20column%20a.%20Column%20B%20has%20the%20check%20in%20time%20(all%20different%20for%20each%20name%20instance).%20Column%20C%20has%20the%20check%20out%20time%20(again%2C%20all%20different).%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20I%20request%20the%20earliest%20and%20latest%20check%20in%2Fout%20time%20per%20person%3F%20(Column%20C%20and%20D)%20This%20data%20is%20for%20one%20day.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-339414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elist%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ename%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esort%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339577%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20the%20highest%20value%20PER%20name%20in%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339577%22%20slang%3D%22en-US%22%3E%3CP%3EValues%20go%20to%20the%20values%20area.%20You%20have%20two%20values%3A%20check%20in%20time%20and%20check%20out%20time.%20Change%20the%20function%20to%20Min.%20and%20Max.%20resp.%20Standard%20function%20would%20be%20Sum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339438%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20the%20highest%20value%20PER%20name%20in%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339438%22%20slang%3D%22en-US%22%3EAnd%20what%20values%20go%20where%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339433%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20the%20highest%20value%20PER%20name%20in%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339433%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20a%20pivot%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dragon_Claw
Occasional Contributor
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.
3 Replies

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.