hi, Excel any formula that can sort out based on the highest score? Thanks
O Oscarr Member Feb 7, 2020 #1 hi, Excel any formula that can sort out based on the highest score? Thanks Attachments simple.xlsx 8.7 KB · Views: 10
P Peter Bartholomew Well-Known Member Feb 7, 2020 #2 Results = CHOOSE( SIGN(teamA-teamB)+2, "Joe", "Tie", "Jack" ) or basic stats = SUM( SIGN(teamA>teamB) ) = SUM( SIGN(teamA<teamB) ) Last edited: Feb 7, 2020
Results = CHOOSE( SIGN(teamA-teamB)+2, "Joe", "Tie", "Jack" ) or basic stats = SUM( SIGN(teamA>teamB) ) = SUM( SIGN(teamA<teamB) )
O Oscarr Member Feb 7, 2020 #3 Peter Bartholomew said: Results = CHOOSE( SIGN(teamA-teamB)+2, "Joe", "Tie", "Jack" ) or basic stats = SUM( SIGN(teamA>teamB) ) = SUM( SIGN(teamA<teamB) ) Click to expand... Hi @Peter Bartholomew thanks for help...it work
Peter Bartholomew said: Results = CHOOSE( SIGN(teamA-teamB)+2, "Joe", "Tie", "Jack" ) or basic stats = SUM( SIGN(teamA>teamB) ) = SUM( SIGN(teamA<teamB) ) Click to expand... Hi @Peter Bartholomew thanks for help...it work