Return a Value in a Series of 3 or more Consecutive Values

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

In C1:

Please Login or Register  to view this content.

and pull down.

That formula meets the 3 criteria you listed:

Originally Posted by Jonathan78

The formula needs to return a true value in column C if the following conditions are met:
1 | a series of 3 or more consecutive N-values in column B
2 | the value on the same row in column B is empty
3 | the value on the same row in column A is not equal to empty

What are the logical conditions you left out of OP?

IF The trigger to return TRUE is a blank row and D in column A then this will work
Enter in C3 and fill down to return N at the last N in column C if there are at least 3 in a row. This is a helper column.

Formula:

Please Login or Register  to view this content.

Enter in D2 and fill down

Formula:

Please Login or Register  to view this content.

If the above is not correct, the last formula should be ignored. This will leave TRUE beside the last N in a series of 3 or more.

EDIT:@Jonathan

My point is that the picture you posted of you desired results do not match the criteria you listed in the text of your first post, describing the formula you wanted.

You need to figure out what the criteria you left implicit -- what you did not describe -- are.

The difference between the image you posted and what you described is enough that I cannot guess what information you left out, I need you to tell me.