if or filter or any other formula/code

[Vishaal]

Hi All,

Thanks in advance, we have the following sheet

Item Code	Work 1			Work 2			Work 3			Work 4
	P-1	P-2	P-3	P-1	P-2	P-3	P-1	P-2	P-3	P-1	P-2	P-3
A-405	fs			xvxv
A-820	fdsf	dfdf	ok	vxvx
A-440	fdsf	fds	ok	vxvx	fsdssf	ok	fdaf
A-650	vxv	vxv	ok	xcvv	gsds	ok	vcxxv	vxc	ok	gdg
A-260	cxzc	cx	ok	vcxv	xvxc	ok	cvv	vxcv	ok	dgdg	gdgdg	ok

and want to do following work

Process - In a new sheet we want to check only work which is not done, we mean

1. We will check first "Work 1" done or not, you can see that D3 is not o.k., so it will show in new sheet with item code
2. if work 1 done than We will check second "Work 2" done or not, you can see that G4 is not o.k., so it will show in new sheet with item code
3. if work 1 and work 2 done than We will check second "Work 3" done or not, you can see that J5 is not o.k., so it will show in new sheet with item code
4. if work 1, work2 and work 3 done than We will check second "Work 4" done or not, you can see that M6 is not o.k., so it will show in new sheet with item code

i have the headings work 1 to Work 25, how can we do that, help pls

Sample result is

Item Code
A-405	Work 1 - Pending	or we can show the value B3 here
A-820	Work 2 - Pending	or we can show the value E4 here
A-440	Work 3 - Pending	or we can show the value H5 here
A-650	Work 4 - Pending	or we can show the value K6 here

can we do this through formula, if not then code pls,

 

[Vishaal]

Thanks shaowu459 for your help,

but we we have still one problem and that is we need to drag the formula, every time when any new data add in new row, can we do that it will check column C,F,I,L and if find any blank cell then it will show column "A" value

 

[Vishaal]

I have tried and find a solution but we need to drag (also tried Array formula but we in that case we cant use that column, if we use it will reflect error)

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Item Code	Work 1			Work 2			Work 3			Work 4
2		P-1	P-2	P-3	P-1	P-2	P-3	P-1	P-2	P-3	P-1	P-2	P-3
3	A-405	fs			xvxv
4	A-820	fdsf	dfdf	ok	vxvx
5	A-440	fdsf	fds	ok	vxvx	fsdssf	ok	fdaf
6	A-650	vxv	vxv	ok	xcvv	gsds	ok	vcxxv		ok	gdg	gdfgd	ok
7	A-260	cxzc	cx	ok	vcxv	xvxc	ok	cvv	vxcv	ok	dgdg	gdgdg	ok
8
9	Item Code
10	A-405
11	A-820
12	A-440
13	A-650
Sheet1

Cell Formulas
Range	Formula
A10:A13	A10	=IF(C3="",A3,IF(F3="",A3,IF(I3="",A3,IF(L3="",A3))))

 

[Vishaal]

we are also asking this in other forum

Getting result if any one condition match [SOLVED]

Hi All, Thanks in advance, we have attached a sheet in that we want to if in column C,F,I,L have any blank cell then it will show column "A" value, we are getting the value with "if" formula and also getting the value with "Arrayformula" but if we use IF function then we need to drag and...

www.excelforum.com