Hi everyone. I need some help with something if you dont mind. Here's the situation (please refer to the image):

\1

On the worksheet, I have a pivot table. Basically, I need to determine the Symbol with the biggest value for each date in the pivot table (excluding the Grand Total) and have it appear appropriately under column H.

So, for example. For December 11, 2000, I need to find the Symbol with the largest value from the pivot table in the row of December 11,2000. This happens to be the symbol AAA which has a value of 46. Now, I need AAA to show up in cell H3. I then need to do this for the rest of the dates.

Any advice would be great. Thanks!