Only display the last entry in a range - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Only display the last entry in a range

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,772
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

     
    On 2002-03-01 06:44, Drew wrote:
    Aladin,
    Would the idex/match function work just as well? Just wondering.

    =INDEX(B3:G3,MATCH 9.99999999999999E+307,B3:G3))

    Drew
    Drew,

    You're darn right. I wonder why I forget my own tricks. Thanks for the reminder.

    Allow me to slightly modify it:

    =INDEX(3:3,MATCH(9.99999999999999E+307,B3:G3)+1)

    Bobefax: Forget that expensive formula and use this instead.

    Aladin

  2. #12
    New Member
    Join Date
    Feb 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Drew/Aladin.

    MANY MANY THANKS.

    The Last thing was just what it needed.

    Thanks again......

    Bobefax

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