Excell Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3187961%22%20slang%3D%22en-US%22%3EExcell%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3187961%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20with%20names%20and%20the%20time%20it%20takes%20them%20to%20play%20a%20round%20of%20golf.%20I%20want%20to%20know%20if%20there%20is%20a%20formula%20where%20I%20can%20find%20their%20fastest%20and%20slowest%20time%20to%20play%20a%20round%20of%20golf%20by%20their%20last%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3187961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3188040%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3188040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1312325%22%20target%3D%22_blank%22%3E%40Ben_Weaver%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSMALL(IF(%24A%242%3A%24A%2424%3DD2%2C%24B%242%3A%24B%2424)%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DLARGE(IF(%24A%242%3A%24A%2424%3DD2%2C%24B%242%3A%24B%2424)%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BMaybe%20with%20these%20formulas%20as%20in%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnter%20formulas%20with%20ctrl%2Bshift%2Benter%20if%20you%20don't%20work%20with%20Office365%20or%202021.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a list with names and the time it takes them to play a round of golf. I want to know if there is a formula where I can find their fastest and slowest time to play a round of golf by their last name.

1 Reply

@Ben_Weaver 

=SMALL(IF($A$2:$A$24=D2,$B$2:$B$24),1)
=LARGE(IF($A$2:$A$24=D2,$B$2:$B$24),1)

 Maybe with these formulas as in the attached file.

 

Enter formulas with ctrl+shift+enter if you don't work with Office365 or 2021.