+ Reply to Thread
Results 1 to 2 of 2

choose maximum number from list and then take cell data from another list close by

  1. #1
    Registered User
    Join Date
    05-11-2011
    Location
    Malta
    MS-Off Ver
    Excel 2007/2010
    Posts
    7

    choose maximum number from list and then take cell data from another list close by

    hi

    i have a list here:

    A....B....C....D
    73 4 565 -273
    29 17 220 273
    31 13 318 85
    30 14 296 124
    23 20 133 327
    29 17 220 273
    28 18 196 308
    24 19 164 292

    I need a formula which states:

    Check what is the largest number from column D (K21:K28, which is 327) and then get the number represented in column A (H21:H28, which is 23).

    If for example the largest number would be 292 (last one in list) then the final result would be 24.

    How can I produce this formula?

    Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,309

    Re: choose maximum number from list and then take cell data from another list close b

    =INDEX(A1:A8,MATCH(MAX(D1:D8),D1:D8,0))

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1