Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Lastrow without useing VBA (RESOLVED)

  1. #11
    New Member
    Join Date
    Apr 2002
    Location
    East Texas
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Aladin for all the help. That solved my problem.

    Jotting down things like that... No wonder??

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

    Default


    Jotting down things like that... No wonder??


    I was referring to my sloppiness...

    By the way, you could also use:

    =OFFSET(V9,SUMPRODUCT(MAX((V9:V37>0)*(ROW(V9:V37))))-ROW(V9),0,1,1)

    Aladin

    PS. Your question marks made me nervous about the expression I used. Webster says:

    to write briefly or hurriedly

    I meant of course: writing up in a hurry.



  3. #13
    New Member
    Join Date
    Apr 2002
    Location
    East Texas
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I thought that you might have ment that i need to go into a little more detail with my question so everyone would know what i was looking for.

    Anyway, Thanks again for all the help.
    Two Thumbs Up for 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
  •