Results 1 to 9 of 9

How to find the cooresponding value of a Max Value

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    tulsa, ok
    MS-Off Ver
    Excel 2003
    Posts
    20

    How to find the cooresponding value of a Max Value

    If Column A5:A60 is a date (example A5 = 01-01-2012 and so on) and column C5:C60 has a number.

    I can use the Max function to find the highest number in C5 through C60 but how can I find the corresponding date in Column A?


    Thanks.
    Last edited by johnsoncj2002; 11-23-2011 at 04:04 PM. Reason: Solved

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