Results 1 to 5 of 5

Excel 2007 : lookup match for highest value from 1 row and lowest in 2nd out of the 1st

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    Ledyard, CT
    MS-Off Ver
    Excel 2007
    Posts
    3

    lookup match for highest value from 1 row and lowest in 2nd out of the 1st

    I am trying to create a formula that allows me took look at two rows

    for example
    first row 5, 7, 9, 7, 9
    second row 1,2,3,1,5

    I want the formula to look at the first row which is range of numbers and figure out the highest value in that row, in this case the two 9s and then determine from the numbers below them in the second row which of these is lesser in value. which would be the 3 since the 5 is the other number that would be valid.
    This can be either shown via a number (1) or word (this one) or a color.

    Any help is appreciated.
    Thanks
    Last edited by t7soccer; 09-30-2010 at 04:07 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