Hello my Dear ,I want Your Help For Correct Function to get Hotel Name for every Guide by The largest number of repeats for this hotel ..Note The Correct Results In Column K from Total Sheet and the Functon will be in J Column ..Mistake In The Red Cells
Code:
=INDEX(Basic!$T$2:$T$1444,MATCH(MAXIFS(Basic!$S$2:$S$1444,Basic!$P$2:$P$1444,$G2),Basic!$S$2:$S$1444, 0))