Range using COUNTA

  • Re: Range using COUNTA


    I am wanting to set the print range and delete all rows below.
    Example the range is A5 and E ??.
    So I was going to use COUNTA to find how far down I should go. COUNTA formula is count if E5:E30 >0
    If COUNTA has 16, then my range would be "(A5:E16) and delete all rows below E16.

  • Re: Range using COUNTA


    Hello,


    If you are looking for the last used non empty row ...


    =SUMPRODUCT(MAX((ROW(E1:E30))*(E1:E30<>"")))


    HTH

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Re: Range using COUNTA


    Quote from JohnDrew;786814

    Thanks, that's what I need


    Thanks ... for your thanks ... :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!