Originally Posted by
martindwilson
add another column in f8 =MAX(B8:E8) use that for your match
helo martin,thanks for replying. but thats not i want, like in example Bryce should show in champion 2 and 3, because got the larger. so supporting column wont do that.
Originally Posted by
Sindhus
If you want a solution without supporting column, you can try this array formula
Enter with Ctrl+Shift+Enter
Thank you Sindhus, you solved my problem,,
and another question, how about if theres same point for the winner 4 and winner 5 got same point but only show 1 name, Attachment updated with example
Bookmarks