if or filter or any other formula/code

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
394
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
Hi All,

Thanks in advance, we have the following sheet

Item CodeWork 1Work 2Work 3Work 4
P-1P-2P-3P-1P-2P-3P-1P-2P-3P-1P-2P-3
A-405fsxvxv
A-820fdsfdfdfokvxvx
A-440fdsffdsokvxvxfsdssfokfdaf
A-650vxvvxvokxcvvgsdsokvcxxvvxcokgdg
A-260cxzccxok vcxvxvxcok cvvvxcvokdgdggdgdgok


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-405Work 1 - Pendingor we can show the value B3 here
A-820Work 2 - Pendingor we can show the value E4 here
A-440Work 3 - Pendingor we can show the value H5 here
A-650Work 4 - Pendingor we can show the value K6 here


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

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
394
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
394
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
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
ABCDEFGHIJKLM
1Item CodeWork 1Work 2Work 3Work 4
2P-1P-2P-3P-1P-2P-3P-1P-2P-3P-1P-2P-3
3A-405fsxvxv
4A-820fdsfdfdfokvxvx
5A-440fdsffdsokvxvxfsdssfokfdaf
6A-650vxvvxvokxcvvgsdsokvcxxvokgdggdfgdok
7A-260cxzccxok vcxvxvxcok cvvvxcvokdgdggdgdgok
8
9Item Code
10A-405
11A-820
12A-440
13A-650
Sheet1
Cell Formulas
RangeFormula
A10:A13A10=IF(C3="",A3,IF(F3="",A3,IF(I3="",A3,IF(L3="",A3))))
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
394
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
we are also asking this in other forum
 

Watch MrExcel Video

Forum statistics

Threads
1,108,952
Messages
5,525,854
Members
409,667
Latest member
jwieting

This Week's Hot Topics

Top