Consulting

Results 1 to 4 of 4

Thread: Solved: finding MAX number and matching symbol

  1. #1

    Solved: finding MAX number and matching symbol

    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

  2. #2
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    put the column of tickers AFTER the percentages, then use a vlookup (see attached).
    Office 2010, Windows 7
    goal: to learn the most efficient way

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    As setup

    =INDEX(A:A,MATCH(MAX(B:B),B:B,0))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  4. #4
    TrippyTom That will do it. Thanks again for all you guys do

    Max

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •