• 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.

Find the next 3 values in a column with empty cells

dv0x

New Member
Hi Ninjas,

I've encountered another obstacle which I cannot google my way out of. I've included a clear example of what I'm trying to accomplish as putting it into words gets a little messy.

First: It needs to be be determined whether columns A B C are blank
Second: If the column(s) are not blank, then I want to know the next 3 values in column D

It sounds simple enough, but there are blanks in column D, which have made it difficult for me to solve this problem.

THANK YOU!
 

Attachments

  • Sample2.xlsx
    12.1 KB · Views: 0
Narayan,

This appears to have solved my problem. I'll come back if I have any questions.

THANK YOU!
 
Back
Top