Results 1 to 5 of 5
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Last value in column (2007)

    How can I find the last value (entry) in a column?
    A1-B?? (the last entry in column
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Last value in column (2007)

    Do you want to use a formula of VBA code?

    If you want to use a formula and if column B contains numeric values, you can use this formula:

    =INDEX(B:B,MATCH(9.99999999999999E+307,B:)

    9.99999999999999E+307 is the largest value you can enter in an Excel cell, so presumably all values in your column B are smaller. The MATCH function will keep on searching until it reaches the last filled cell in column B, and return its row number. INDEX uses this to return the value of that cell.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Last value in column (2007)

    Thanks Hans, that works quite well!
    (hopefully the max number you mentioned will not be exceeded. . .this is for my weight loss program) <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Last value in column (2007)

    That depends on the unit... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  5. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Last value in column (2007)

    LOL <img src=/S/woops.gif border=0 alt=woops width=58 height=36>
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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