Feb 19 2022 08:28 AM
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.
Feb 19 2022 08:50 AM
@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.
