Hi all,
My problem is this:
I have two columns:
Column B is stock symbols
Column F is percentage growth
B F
- -
AAAE 1.0%
BAC 2.67%
BKC 3.8%
WEN -5.7%
I would like to use a max function to first find the maximum value in column F. I then want to return the corresponding stock ticker from column B.
What I have so far (which is clearly not working) is this: =VLOOKUP(MAX(F1:F4),1,B1:F4)
Any ideas? Thank you for your time. :-)
Bookmarks