I have 4 groups of 4 names, given points and totalled up, then ranked according to point numbers, Searching for a formula which checks Group1 for Ranking 1 and inserts name in cell, then checks Group3 for 2nd ranking to play against Group. As shown in the attached file. All support appreciated in providing the formula to do this. I could do it manually but would look good for now and in the future to do it automatically.
Thanks
Phil
Bookmarks