Please help with worksheet formula

[Andries]

Hi All

I need a code or function that must look at table 1 and return the SUBJECT CODE to table 2 but when there is a "O/B" status in column C then it should carry on in the green block for argument sake.

In the first table at cell B9 you find a subject with an O/B status...the code or function should then skip cells B9-12 because it is still part of the "81"row range and continue in cells B13 as shown in table 2.

This is the function that is currently used but it is not doing what I want

"=IF(AND(ROWS(F$3:F3)<11,C3="O/B"),"",B3)"

These tables are only snippets of a big file

Thank you in advance

Dries

Excel Workbook
	A	B	C	D	E	F	G
1	BLOCK/ROW/SEAT	SUBJECT CODE	STATUS	*	BLOCK/ROW/SEAT	SUBJECT CODE	STATUS
2	w2-81-1	A	*	*	w2-81-1	A	*
3	w2-81-2	B	*	*	w2-81-2	B	*
4	w2-81-3	C	*	*	w2-81-3	C	*
5	w2-81-4	D	*	*	w2-81-4	D	*
6	w2-81-5	E	*	*	w2-81-5	E	*
7	w2-81-6	F	*	*	w2-81-6	F	*
8	w2-81-7	G	O/B	*	w2-81-7	*	*
9	w2-81-8	H	O/B	*	w2-81-8	*	*
10	w2-81-9	I	O/B	*	w2-81-9	*	*
11	w2-81-10	J	O/B	*	w2-81-10	*	*
12	w2-82-1	K	O/B	*	w2-82-1	K	*
13	w2-82-2	L	O/B	*	w2-82-2	L	*
14	w2-82-3	M	O/B	*	w2-82-3	M	*
15	w2-82-4	N	O/B	*	w2-82-4	N	*
16	w2-82-5	O	O/B	*	w2-82-5	O	*
17	w2-82-6	P	O/B	*	w2-82-6	P	*
18	w2-82-7	Q	O/B	*	w2-82-7	Q	*
19	w2-82-8	R	O/B	*	w2-82-8	R	*
20	w2-82-9	S	O/B	*	w2-82-9	S	*
21	w2-82-10	T	O/B	*	w2-82-10	T	*
22	w2-83-1	U	*	*	w2-83-1	U	*
23	w2-83-2	V	*	*	w2-83-2	V	*
24	w2-83-3	W	*	*	w2-83-3	W	*
25	w2-83-4	X	*	*	w2-83-4	X	*
Sheet1

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=541398

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).