+ Reply to Thread
Results 1 to 6 of 6

worksheet function

  1. #1
    Registered User
    Join Date
    04-19-2007
    Posts
    4

    worksheet function

    First off this is a really nice forum, and since this is my first post here I'll try not to be such a noob.

    The question is simple I have 2 colums.
    column 1 = 1,2,3,4
    Column 2 = 12,67,30,90

    What I want excel to do is pick the max value from column 2 and tell me which number it was associated with. In this example its 4. I cant seem to wrap my brain around this one. Any help would be greatly appreciated!
    -Nathan

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    =INDEX(column1,MATCH(MAX(column2),column2,0),0)

    Hope that helps...

  3. #3
    Registered User
    Join Date
    04-19-2007
    Posts
    4
    I thought I should add that I have multiple colums after colummn 2, all with 4 values which I would like to find the MAX then tell me the value in column 1 from the row the MAX came from.

  4. #4
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    Just change the MATCH(MAX(column 2), column2,0) to MATCH(MAX(columnx),columnx,0)

    Hope that helps...

  5. #5
    Registered User
    Join Date
    04-19-2007
    Posts
    4
    It works, but dosn't autofill very well. I have 50+ columns of data and It will constantly change the column1 data which I want fixed (I want to constantly compare to column 1. Thanks for the help this far the index function was new to me.

  6. #6
    Registered User
    Join Date
    04-19-2007
    Posts
    4
    nevermind, I got it, I just generated copies of column 1 above the dataset so it would autofull. Thanks!

+ 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