Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: I need to always select the last populated cell of a column.

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Chattanooga, TN
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok, now that i'm registered, i'll try the question again...

    My question:

    I need to have a cell at the top of my sheet always show me what the value is in the last populated cell of one particular column. The value of the cell is numeric... actually a formula accruing vacation and sick time for employees of my company.

    Can this be done with a formula? I have tried everything I can think of and looked everywhere I know. Please help!

    Thanks,
    Meg.

    [ This Message was edited by: megslow on 2002-03-11 14:01 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-03-11 13:54, megslow wrote:
    ok, now that i'm registered, i'll try the question again...

    My question:

    I need to have a cell at the top of my sheet always show me what the value is in the last populated cell of one particular column. The value of the cell is numeric... actually a formula accruing vacation and sick time for employees of my company.

    Can this be done with a formula? I have tried everything I can think of and looked everywhere I know. Please help!

    Thanks,
    Meg.
    Meg,

    See my reply to your anonymous post.

    Aladin


  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Chattanooga, TN
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If the column in question is "F", do I replace the "B" in the following formula with "F"?
    =INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
    (if so, i tried and it didn't work)

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-03-11 14:01, megslow wrote:
    If the column in question is "F", do I replace the "B" in the following formula with "F"?
    =INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
    (if so, i tried and it didn't work)
    Yes, Meg. B:B becomes F:F. You need to enter the formula in F1.

    Aladin

    [ This Message was edited by: Aladin Akyurek on 2002-03-11 14:04 ]

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    Chattanooga, TN
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, I tried the formula with the "F"s in cell F1 at home with sample data and it worked. However I cannot get it to work here at work where I need it. I am using Excel 2000 (home is XP). Will that make a difference? Also, there is some text in some of the cells in column F. Will that mess up the formula?

    Thanks so much for your help so far...
    Meg.

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Chattanooga, TN
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    new issue: the formula works in some workbooks but not others... weird. but the point is that i DID get it to work.
    thank you, thank you, thank you!

    (and any tips on why it may not work in some workbooks - like settings? - would be appreciated!!!)

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    > Ok, I tried the formula with the "F"s in cell F1 at home with sample data and it worked.

    > However I cannot get it to work here at work where I need it. I am using Excel 2000 (home is XP). Will that make a difference?

    It works in Excel 2000. Glad to hear that it does work in XP.

    > Also, there is some text in some of the cells in column F. Will that mess up the formula?

    Match ignores text and blanks, so don't worry.

    > Thanks so much for your help so far...

    You're welcome.

    Aladin

Some videos you may like

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
  •