Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
Thanks in advance, we have the following sheet
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
can we do this through formula, if not then code pls,
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,