Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Take Value To Left Of Maximum Value In A Column

  1. #1
    Join Date
    22nd November 2005
    Location
    Wollongong, Australia
    Posts
    33

    Take Value To Left Of Maximum Value In A Column

    Trying to grab the value to the left of the max value in a range of cells.

    Wasn't sure if I needed to use the offset function, I tried the vlookup function but the value i'm searching for is in the 2nd column, not the first.

    I can't download files at work, so if you could examine the example spreadsheet i uploaded, and then type the formula I should use in the post, that would be highly appreciated.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    22nd November 2005
    Location
    Wollongong, Australia
    Posts
    33

    Re: Take Value To Left Of Maximum Value In A Column

    I think i solved it, but I'd like to make sure that the function I'm using would be the most desirable...

    =OFFSET(B7,MATCH(MAX(C7:C52),C8:C52,0),0)

    The references are different to the example I posted, simply because I was working off my main spreadsheet... it pulls up the desired location, is this solved?

    Thanks for any insight.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Take Value To Left Of Maximum Value In A Column

    Try,

    =INDEX(B2:B13,MATCH(MAX(C2:C13),C2:C13,0))

    HTH

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Return Heading Of Column With Maximum Value
    By Elmura in forum Excel General
    Replies: 4
    Last Post: September 17th, 2007, 11:09
  2. Add Column To Left
    By Smarty_Great in forum Excel General
    Replies: 4
    Last Post: June 19th, 2007, 16:05
  3. Looking Up Cell Of Maximum Value In Another Column
    By SamBlacker in forum Excel General
    Replies: 3
    Last Post: April 26th, 2007, 20:10
  4. Add to Maximum in Column
    By rexy_sti555 in forum Excel General
    Replies: 10
    Last Post: July 10th, 2006, 13:36
  5. search for maximum value in a column
    By kiz in forum Excel General
    Replies: 16
    Last Post: October 17th, 2005, 22:37

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
  •  
porno