Hi,
I have a set of data (table below) assuming data start from A1. Basically I am looking to match multiple criteria (Team1=Team1) & (Low = Low) & (Full Time = Full Time) and when matched, return values vertically (Skip empty rows).
<tbody>
</tbody>
<tbody>
</tbody>
Attached is link of sample data
Thank you in advanced
Aton
I have a set of data (table below) assuming data start from A1. Basically I am looking to match multiple criteria (Team1=Team1) & (Low = Low) & (Full Time = Full Time) and when matched, return values vertically (Skip empty rows).
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
1 | | Team1 | Team1 | Team1 | Team1 | Team1 | Team1 | Team1 | Team1 | Team1 | Team2 | Team2 | |||
2 | Team | Job Type | Task | Criticality | Tom | John | kel | mat | Sue | jan | hay | matt | moon | Am1 | hel1 |
3 | Team1 | Full Time | Task1 | Low | 73 | 22 | 93 | 20 | 29 | 90 | 86 | 26 | 93 | 26 | 78 |
4 | Team1 | Hourly | Task2 | Low | 56 | 90 | 71 | 99 | 68 | 84 | 61 | 35 | 27 | 88 | 23 |
5 | Team1 | Part Time | Task3 | Low | 67 | 20 | 96 | 61 | 50 | 36 | 96 | 85 | 50 | 65 | 20 |
6 | Team2 | Hourly | Task4 | Low | 27 | 72 | 25 | 64 | 43 | 33 | 75 | 42 | 74 | 20 | 50 |
7 | Team2 | Hourly | Task5 | High | 40 | 25 | 33 | 71 | 36 | 79 | 95 | 63 | 48 | 26 | 37 |
8 | Team2 | Full Time | Task6 | Low | 74 | 37 | 79 | 40 | 64 | 76 | 79 | 32 | 89 | 99 | 79 |
9 | Team3 | Full Time | Task6 | Mid | 66 | 93 | 99 | 36 | 27 | 70 | 52 | 70 | 55 | 47 | 30 |
10 | Team1 | Part Time | Task7 | High | 98 | 90 | 89 | 35 | 24 | 91 | 53 | 42 | 42 | 93 | 52 |
11 | Team3 | Full Time | Task8 | Low | 29 | 61 | 33 | 25 | 68 | 96 | 46 | 31 | 24 | 70 | 61 |
12 | Team3 | Hourly | Task9 | High | 23 | 88 | 40 | 23 | 65 | 99 | 69 | 49 | 74 | 47 | 47 |
13 | Team3 | Hourly | Task10 | Mid | 24 | 93 | 64 | 34 | 70 | 89 | 25 | 93 | 83 | 45 | 45 |
14 | Team1 | Part Time | Task11 | High | 21 | 100 | 40 | 51 | 53 | 69 | 85 | 60 | 69 | 25 | 45 |
15 | Team3 | Full Time | Task12 | Low | 34 | 90 | 50 | 60 | 81 | 87 | 51 | 51 | 40 | 47 | 50 |
16 | Team2 | Hourly | Task13 | Low | 90 | 35 | 87 | 78 | 62 | 31 | 57 | 60 | 46 | 47 | 71 |
17 | Team4 | Full Time | Task14 | High | 64 | 68 | 76 | 26 | 42 | 83 | 39 | 41 | 50 | 51 | 57 |
18 | Team4 | Part Time | Task15 | High | 67 | 63 | 54 | 54 | 65 | 96 | 25 | 29 | 70 | 57 | 70 |
19 | Team4 | Hourly | Task16 | High | 43 | 21 | 81 | 53 | 45 | 29 | 44 | 53 | 29 | 64 | 40 |
20 | Team4 | Full Time | Task17 | Mid | 52 | 60 | 21 | 81 | 58 | 80 | 71 | 29 | 23 | 79 | 96 |
21 | Team4 | Full Time | Task18 | Low | 96 | 92 | 74 | 24 | 39 | 66 | 73 | 46 | 94 | 23 | 76 |
<tbody>
</tbody>
Attached is link of sample data
Thank you in advanced
Aton
Last edited: