Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I'll give it a shot. Thanks!
Having multiple values appear in one cell.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hello! So I have recently gotten into excel and have been using it for everything. I am putting together a football score system. This is what it looks like
Im using a super simple Max formula for Score
And using a nested If formula to display the weeks winner
What I didnt take into account is a tie in points. Currently the winner row will prioritize the first row with the highest value. So if James scored 10 points and Garret also scored 10 points it will display Garret as the winner. I was wondering if there is a way to get multiple names to display in the winner cell if two or more people tie at first.
Microsoft 365 and Office | Excel | Other | Other
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2022-09-09T22:08:01+00:00 -
HansV 462.6K Reputation points2022-09-09T19:40:57+00:00 In B13:
=TEXTJOIN(", ", TRUE, IF(B3:B13=B14, $A$3:$A$12, ""))
If you have Excel 2019, confirm the formula with Ctrl+Shift+Enter.
Fill to the right to T13.