jhomai2026
New Member
- Joined
- Jul 24, 2019
- Messages
- 2
Hello Sir,
I need your help, i need to count my 1st revision result as per 2nd revision status.
i really hope someone can give me light on this formula.
the answer should be
AWC R&R
AWC 1 2
R&R 1
Thank you so much in advance
I need your help, i need to count my 1st revision result as per 2nd revision status.
i really hope someone can give me light on this formula.
A | B | C | |||||
1 | Unique Number | Revision | Status | ||||
2 | A | 1 | awc | ||||
3 | A | 2 | awc | ||||
4 | B | 1 | awc | ||||
5 | B | 2 | R&R | ||||
6 | C | 1 | R&R | ||||
7 | C | 2 | AWC | ||||
8 | D | 1 | AWC | ||||
9 | D | 2 | R&R | ||||
10 | The answer should be this | ||||||
11 | 1st Revision | 2nd Revision | 1st Revision | 2nd Revision | |||
12 | AWC | R&R | |||||
13 | AWC | AWC | 1 | 2 | |||
14 | R&R | R&R | 1 |
the answer should be
AWC R&R
AWC 1 2
R&R 1
Thank you so much in advance
Last edited by a moderator: