Tenspeed39355
07-18-2010, 06:04 PM
Hi guys. I have stock symbols in column A.
In column B I have numbers. I need to find the MAX number in column B and the matching symbol in column
A.
Example:
APB 11.80% APF 10.57% CAF -30.49% CHN 28.91% GCH -1.29% GRR 24.83% IAE 5.20% IF 44.46% IFN 43.22% IIF 34.29% JEQ 6.42% JFC 10.93% JOF 5.91%
The result in this case is IF 43.22%
How do I set up a formula for this result
Thanks for your help with this.
Max
In column B I have numbers. I need to find the MAX number in column B and the matching symbol in column
A.
Example:
APB 11.80% APF 10.57% CAF -30.49% CHN 28.91% GCH -1.29% GRR 24.83% IAE 5.20% IF 44.46% IFN 43.22% IIF 34.29% JEQ 6.42% JFC 10.93% JOF 5.91%
The result in this case is IF 43.22%
How do I set up a formula for this result
Thanks for your help with this.
Max