Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi,
Please check the following and update how can we do that
Sample data
Excel 2010 32 bit
Result Data
Excel 2010 32 bit
help pls
Please check the following and update how can we do that
Sample data
Excel 2010 32 bit
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Sample | | | | |
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | 1 | | | | |
7 | 2 | ||||
8 | 3 | ||||
9 | 4 | Yes | | | |
10 | 5 | Yes | | | |
11 | 6 | Yes | Yes | | |
12 | 7 | Yes | Yes | | |
13 | 8 | Yes | Yes | | |
14 | 9 | | Yes | | |
15 | 10 | | Yes | | |
16 | 11 | ||||
17 | 12 | ||||
18 | 13 | ||||
19 | 14 | ||||
20 | 15 | | | | |
21 |
Sheet: Sheet1 |
Result Data
Excel 2010 32 bit
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Result in same cells B6:D20 | | | | |
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | 1 | | | | |
7 | 2 | ||||
8 | 3 | ||||
9 | 4 | Yes 5 | | | |
10 | 5 | Yes 4 | | | |
11 | 6 | Yes 3 | Yes 5 | | |
12 | 7 | Yes 2 | Yes 4 | | |
13 | 8 | Yes 1 | Yes 3 | | |
14 | 9 | Yes Ad | Yes 2 | | |
15 | 10 | Yes Ad | Yes 1 | | |
16 | 11 | Yes Ad | Yes Ad | ||
17 | 12 | Yes Ad | Yes Ad | ||
18 | 13 | Yes Ad | Yes Ad | ||
19 | 14 | Yes Ad | Yes Ad | ||
20 | 15 | Yes Ad | Yes Ad | | |
21 |
Sheet: Sheet1 |
help pls
Last edited: