Results 1 to 6 of 6

Find the max value in one column and retreive the name of cell in corresponding row

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2009
    Location
    Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    3

    Find the max value in one column and retreive the name of cell in corresponding row

    Hello,

    I spent couple of hours trying to figure this out, but without success. Please check the attached example. I need a formula that will find the max value (number of views in English anguage) in the column "I" and display the corresponding "Headline" value in the column "B". In the example it is "Headline 5". I can not change position of the columns, i.e. "B" must remain "B" and "I" must remain "I".
    I experimented with Index and vlookup but to no success. I have outlook 2003.

    Thx in advance
    Attached Files Attached Files
    Last edited by NBVC; 02-10-2009 at 09:00 AM.

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