Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    Formula returns Fx, I want Ax

    A = Dates
    F = numbers
    Formula = Max(F:F)
    I want to return the corresponding "A" or date of the max number.

    EX)
    A1= 1/1/2014 F1= 10
    A2= 1/7/2014 F2= 50
    A3= 1/20/2014 F3= 16

    Max(F:F) = 50 [F2]
    I want 1/7/2014 [A2]

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    SkiPro,

    How about: =INDEX(A1:A3,MATCH(MAX(F1:F3),F1:F3,0),1)
    exce;fx.JPG
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    RG,
    Just what I needed but could not quite get correct. Thanks.

Posting Permissions

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