+ Reply to Thread
Results 1 to 3 of 3

2 columns of data matching highest with highest

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    glasgow
    MS-Off Ver
    Excel 2007
    Posts
    1

    2 columns of data matching highest with highest

    Hi, i have two columns of data e.g

    A B
    1 5
    3 4
    2 3
    3 5

    What i need to do is match cloumn B highest number (5), with the highest number in column A, this should be (3) but i dont know how to do this. any help would be most welcome

  2. #2
    Registered User
    Join Date
    07-17-2012
    Location
    Borrby, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: 2 columns of data matching highest with highest

    Hi
    I guess you have the 1 in A1 cell and 5 in B1 cell and so on...then if you put =MAX(A1:A4) in the A6 cell and =MAX(B1:B4) in the B6 cell it wil find the highest numers in the colums

    hope this will get you going

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: 2 columns of data matching highest with highest

    You can use this array formula

    =MAX(IF(B1:B4=MAX(B1:B4),A1:A4))

    confirmed with Ctrl+Shift+Enter (instead of just Enter)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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