TABLE1 data source table
TABLE2 Find the highest scores of different subjects, if there are 2 or 3 people with the highest score, it must be listed
Can someone please help me ? It would be much appreciated. Thanks in advance
TABLE1 data source table
TABLE2 Find the highest scores of different subjects, if there are 2 or 3 people with the highest score, it must be listed
Can someone please help me ? It would be much appreciated. Thanks in advance
Last edited by choletseng; 10-10-2021 at 07:22 PM.
In F5 (remove ALL data in this column first):
=UNIQUE($B$2:$B$31)
In E5 copied down:
=TEXTJOIN(",",1,FILTER($A$2:$A$31,($B$2:$B$31=F5)*($C$2:$C$31=G5),""))
Last edited by AliGW; 10-10-2021 at 08:57 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Cell F5 formula
Cell E5 formula , Drag downHTML Code:
HTML Code:
Problem solved, Both are great
AliGW and wk9128 Thanks you very much
@choletseng You're Welcome. Glad to help . Thank You for the feedback
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks