Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 543
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
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
Required Result Sheet
thanks
we have the excel 2007, 2010
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 |
Required Result Sheet
New Microsoft Excel Worksheet - Copy.xlsx | ||||
---|---|---|---|---|
A | B | |||
26 | Status of Step | |||
27 | John | Step 5 | ||
28 | Dan | Step 4 | ||
29 | Ronshi | Step 3 | ||
30 | Pome | Step 6 | ||
Sheet6 |
thanks