Results 1 to 3 of 3

Thread: Find the 2nd 3rd, 4th value over zero in a range

  1. #1

    Find the 2nd 3rd, 4th value over zero in a range



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

    Hello,

    I have a range of data looking like this over multiple rows


    A 0 0 0 2 3 5
    B 0 1 3 5 8 9
    C 0 0 2 8 10 12

    I need a formula that is going to bring back the 1st, 2nd, 3rd value for each row greater than zero.

    So I need it to look like this

    1st value over 0 2 value over zero 3 value over zero

    A
    B
    C

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    900
    Articles
    0
    Excel Version
    Excel 2013

    List all non-zero values from row

    Quote Originally Posted by SuzanneHA View Post
    1st value over 0 2 value over zero 3 value over zero
    See solution in attached example
    Attached Files Attached Files
    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

  3. #3
    Thank you!


Posting Permissions

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