How can I return the lowest score in a list?
Hi there!
My friends and I play Music League and I've collated all our rounds into Google Sheets. I have a summary page with some quick pivot tables to tell us what overall scores are etc., but I'd like to be able to return everyone's worst song submissions.
My data looks like this:
| Round Name | Song Title | Artist | Submitter | Score |
|---|---|---|---|---|
| Round 1 | Title 1 | Artist A | Jane | 1 |
| Round 1 | Title 2 | Artist B | John | 2 |
| Round 2 | Title 3 | Artist C | Jane | 3 |
| Round 3 | Title 4 | Artist D | Jane | 4 |
Is there a formula that could return the best and worst song titles by score? So the end result would look like:
| Jane | Title 1 |
I'm sure it's something around INDEX, MATCH and SMALL but I cannot figure it out.
Posted Aug 4, 2025, 4:25 PM UTC
116