PDA

View Full Version : Solved: finding MAX number and matching symbol



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

TrippyTom
07-18-2010, 06:29 PM
put the column of tickers AFTER the percentages, then use a vlookup (see attached).

Bob Phillips
07-19-2010, 12:27 AM
As setup

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Tenspeed39355
07-19-2010, 05:29 AM
TrippyTom That will do it. Thanks again for all you guys do

Max:clap: