+ Reply to Thread
Results 1 to 3 of 3

Find MIN location, show cell next to it

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    Chicagoland
    Posts
    21

    Question Find MIN location, show cell next to it

    I imagine this is pretty simple but for the life of me I can't figure it out.

    Here's what I want to do...

    Find MIN in Column F
    After finding the MIN in F (let's pretend F222 is the current min)
    Show the text in the field next to it (in this case display text from E222)

    Thanks a lot!

    Craig
    Last edited by canonelan2; 10-04-2008 at 08:09 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    =Index(E:E,Match(Min(F:F),F:F,0))
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-23-2008
    Location
    Chicagoland
    Posts
    21
    Quote Originally Posted by NBVC View Post
    Try:

    =Index(E:E,Match(Min(F:F),F:F,0))
    You rock my world! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight Selected Cell When Using FIND
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-10-2016, 02:53 PM
  2. Update Screen Location based on cell address
    By ItsMillerTime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2008, 02:29 AM
  3. Multiple Cell find and replace?
    By Mark121 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2007, 12:22 PM
  4. Make a MsgBox show the value of a cell in a closed workbook
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2006, 10:52 AM
  5. Paste to location based on Cell contents
    By RMT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2006, 04:35 AM

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