I have a list os scores in cells E13:E17 with a name next to tem from cells F13:G17
then cells H13:H17 i have the word Vs
Cells I13:I17 have names in and cells J13:J17 have points in.
The table looks abit like this
Points............Name.......................................Name..................Points
20...............PlayerA................vs..................PlayerB..................17
22...............PlayerC................vs..................PlayerD..................35
18...............PlayerE................vs..................PlayerF...................40
and so on
No i need something to search all the cells with points in and the person with the highest number points i want their name to display in Cell G29
in this case G29 would display PlayerF because they have the highest number of points!
then cells H13:H17 i have the word Vs
Cells I13:I17 have names in and cells J13:J17 have points in.
The table looks abit like this
Points............Name.......................................Name..................Points
20...............PlayerA................vs..................PlayerB..................17
22...............PlayerC................vs..................PlayerD..................35
18...............PlayerE................vs..................PlayerF...................40
and so on
No i need something to search all the cells with points in and the person with the highest number points i want their name to display in Cell G29
in this case G29 would display PlayerF because they have the highest number of points!