Good day gentlemen. I hope I can ask this in a way that will 1) make sense and will 2) generate a solution.
I have a worksheet that gives me a numerical value for Team A vs. Team B. Whichever value is higher is the team with the advantage. In this example I have the Rangers at 6.366 and the Mariners and 3.812.
I have a "MAX" formula set up to automatically tell me which team has the higher value in the next row. (6.366)
That being said, how do I set up a formula to insert the word "Rangers" right next to the cell that contains the 6.366 MAX formula value?
Any help would be greatly appreciated.
I have a worksheet that gives me a numerical value for Team A vs. Team B. Whichever value is higher is the team with the advantage. In this example I have the Rangers at 6.366 and the Mariners and 3.812.
I have a "MAX" formula set up to automatically tell me which team has the higher value in the next row. (6.366)
That being said, how do I set up a formula to insert the word "Rangers" right next to the cell that contains the 6.366 MAX formula value?
Any help would be greatly appreciated.