Results 1 to 2 of 2

Thread: How to trace the last non-zero value line in a report

  1. #1

    How to trace the last non-zero value line in a report



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I need help on excel formula. I have attach a sample report..
    Appreciate your time and help!

    Thanks
    Carol
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    try
    Code:
    =LOOKUP(99^99;B:B)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Tags for this Thread

Posting Permissions

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