Results 1 to 4 of 4

Thread: Find Value Based On MAX Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member Beaker Rex's Avatar
    Join Date
    Aug 2011
    Posts
    2
    Rep Power
    0

    Find Value Based On MAX Value

    Hello All,
    Major noob here, I'm trying to find the cell in Column A that corresponds with a max formula in the B column. if you look at the attachment, you see at B34 the max for B column is "12.43". I need to find the cell in A column that will tell me the "Date" of that max. If the max changes I would like the date to change with it.

    Thanks in advance

    Mike
    Attached Files Attached Files

Similar Threads

  1. Replies: 4
    Last Post: 04-05-2013, 12:08 PM
  2. Sum Ifs Formula needed with Max Date range
    By trankim in forum Excel Help
    Replies: 2
    Last Post: 09-19-2012, 09:50 AM
  3. Find Value Based On Criteria
    By excel_learner in forum Excel Help
    Replies: 10
    Last Post: 07-30-2011, 10:27 AM
  4. Replies: 4
    Last Post: 04-07-2011, 07:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •