What I am currently doing in this example is in N3 give me the Symbol value in "K" of the Corn contract with the largest Open Interest. In this case it would be "ZCK17". As you can see i am setting the max to D2:D9. This sheet works just fine until i get a new sheet with more data and heaven forbid the corn is not in the right spot.
Ideally what i want is for the program to search for all "CORN" and give the max value so i can say search for the highest corn value in A1:I28.
Thanks for your help.
Bookmarks