Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All Excel Gurus
I was wondering if anyone could help me out. I am trying to automate a manual process of running a bowling bracket sheet. I was able to compare to scores and get the higher score, but, instead of the score, how can I get the name associated with that score? Listed below is an example of the bracket sheet with cell D5 and H5 having the formula enumerated. 1 2 3 4 5 A Name Score Name B ----------------------------------------- C John 212 D =max(c3,e3) ' this will give me 213, I would like the name E Jane 213 F G Hulk 189 H =max(g3,I3) ' this will give me 200, I would like the name I Hogan 200 Any and all help in this matter is greatly appreciated. Argus |