Results 1 to 9 of 9

find highest number only if two names matched in columns?

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    NS, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    20

    find highest number only if two names matched in columns?

    Hi all,

    I'm trying to set up a formula in Excel that looks at another worksheet, and shows the highest number in a column, ONLY IF a specific name is in one column AND a different specific name is in another column.

    The data looks like this:

    Column C on the other worksheet is one list of names (the "winners").
    Column D on the other worksheet is another list of names (the "losers").
    Column E on the other worksheet is the winner's score.

    So, I'm trying to find the highest winning score in matches between two specific players, where one specific player was the winner. The other worksheet is named "RESULTS".

    On the worksheet I'm working in, named "STATS", the names of the players I'm trying to check against are in B23 and B25. I want to find the highest winning score where B23 was the winner and B25 was the loser. I've got this formula for the cell:

    {=IF(AND(RESULTS!C:C=$B$25,RESULTS!D:D=$B$23),MAX(RESULTS!E:E))}

    But all that shows in my cell is "FALSE".

    Can anyone shed some light on what I might be doing wrong?

    Thanks!
    Attached Files Attached Files
    Last edited by canadave; 02-06-2011 at 01:13 PM.

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