Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 543
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi, we have posted this question on the following url but in this there are some change in requirement, we have around 100-200 entry and taking the result in new sheet
only for example we have used the same sheet.
we have the following sheet where we want to get the some result
Data Sheet
Result Sheet
only for example we have used the same sheet.
Filter or Formula for Processing Work
HI, we have the following sheet where we want to check the steps where are work is pending, kindly provide any excel formula we have the excel 2007, 2010 sheet ABCDEFGHIJKLMNOPQRS1WorkStep 1Step 2Step 3Step 4Step 5Step...
www.mrexcel.com
we have the following sheet where we want to get the some result
Data Sheet
New Microsoft Excel Worksheet - Copy.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | Work | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | ||||||||||||||
2 | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | Date | Status | Late | |||
3 | John | 21/08/2012 | Done | 23/08/2012 | Done | 26/08/2012 | Done | 28/08/2012 | Done | 30/08/2012 | |||||||||||
4 | Dan | 24/08/2012 | Done | 26/08/2012 | Done | 27/08/2012 | Done | 28/08/2012 | |||||||||||||
5 | Ronshi | 24/08/2012 | Done | 26/08/2012 | Done | 27/08/2012 | |||||||||||||||
6 | Pome | 21/09/2012 | Done | 23/09/2012 | Done | 26/09/2012 | Done | 28/09/2012 | Done | 30/09/2012 | Done | 1/10/2012 | |||||||||
Sheet6 |
Result Sheet
New Microsoft Excel Worksheet - Copy.xlsx | ||||
---|---|---|---|---|
A | B | |||
17 | Status of Step | |||
18 | Dan | Step 4 | ||
19 | John | Step 5 | ||
20 | Pome | Step 6 | ||
21 | Ronshi | Step 3 | ||
Sheet6 |