Catherine Coleltt
New member
- Joined
- Sep 14, 2020
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Location
- United Kingdom
- Excel Version(s)
- 2019 & Google Sheets
i'VE CREATED A SPREADSHEET FOR TEAM POINTS IN SCHOOL
i'VE PUT IN THE FOLLOWING FORMULA TO LOOK AT THE TEAM POINTS AND DELIVER ME THE WINNING TEAM IN A SPECIFIC CELL.
=INDEX(B$2:E$2, 1, MATCH(MAX(B3:E3), B33, 0))
BUT IT ONLY DELIVERS ME ONE TEAM. TWO OF THE TEAMS ARE TIED SO HOW DO I GET IT TO DELIVER 2 NAMES??
THANKYOU
i'VE PUT IN THE FOLLOWING FORMULA TO LOOK AT THE TEAM POINTS AND DELIVER ME THE WINNING TEAM IN A SPECIFIC CELL.
=INDEX(B$2:E$2, 1, MATCH(MAX(B3:E3), B33, 0))
BUT IT ONLY DELIVERS ME ONE TEAM. TWO OF THE TEAMS ARE TIED SO HOW DO I GET IT TO DELIVER 2 NAMES??
THANKYOU