Hello,
I have an array of data that shows scores for a game. Colum A has the names of the players and row one has the weeks. I am already using a function that shows the Min and Max values in the array using a simple =MIN(B2:H16). What I am trying to do is get the X and the Y values for the returned score. So rather then just getting the Min. value I will get the Min value, the week it occurred and player got the score.
Thanks.
Bookmarks