Formula auto fill for sequence problem

Your requirement is not clear, perhaps this in AF2 and fill down.

Note that the data needs to start in row 2 for this to work, the parts of the formula that refer to row 1 need to look above the first row of data.

=IF(S2="TAK";"OK";IF(COUNTIFS(S$1:S1;"NIE";W$1:W1;W2);"-";"OK"))

Jason - unfortunately it doesn't work as intendent.

I need to fill cells in AF column with "OK" if in one number sequence for example from 1-6 one cell for example 3 is "TAK". Whole sequence from 1-6 should be filled with "OK".

Originally Posted by Sambo kid

Would you please change your post title per forum rule #1.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this request is fulfilled, as per Forum Rule 6)

Title changed - thanks.

Please don't bother with column (S) and column (W) - these are my data calculated from different logics.

3rd set of NIE:

TAK 1 OK
NIE 2 OK

It's ok because numbers are in order (1 then 2 - this time 1 is TAK)

4th set of NIE:

NIE 1 OK
TAK 2 OK

It's ok because numbers are in order (1 then 2 - this time 2 is TAK)

5h set of NIE:

NIE 1 -
TAK 1 OK

It's "-" because following number is again 1 not 2 and its "NIE"
It's "OK" because it's TAK.