• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

count 1st and last nonblank

Hello

I have done the same column wise and using Index and Array formulas, I could get the first and last non blank cell values.

Thanks,
Ramesh Kumar.P
 

Attachments

  • hurdle (1).xlsx
    10.2 KB · Views: 0
You can use the following formula as well to identify the last non blank value

Code: 
=LOOKUP(2,1/($D5:$J5<>""),$D5:$J5)

Thanks
 
You must log in or register to reply here.
Back
Top