Using function to referance different cells.
Using function to referance different cells.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Using function to referance different cells.

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    San Diego
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am trying to use the max function to find the max in a column and then return the value in the column to the left of it. I'm thinking it will involve using max within the lookup function, but can't seem to get it to work. I'm trying to use this in the middle of a macro using VB so if you can help me figure it out that way it would be great.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If your values are in column B you could use =OFFSET(B1,MATCH(MAX(B:B),B:B,0)-1,-1).

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com