@jameskbw ,
It took me a while, but I think I have it figured out. Im happy you have 365, as this is only in that (and maybe 2021 excel).
but take a look. it is a wide mini workbook. I did not name the "named range" identified at the bottom, I guess excel does that on it its own. it is an Let function with Filter array formulas Even if this doesnt work for you, I've learned with this!
Let me know and I'll crunch some more if I need to.
Mr Excel Questions 3.xlsm |
---|
|
---|
| A | B | C | D | E | F | G |
---|
1 | Contact ID | Contact Role | Account ID | Statement Delivery | Contact ID | Contact Role | Account ID |
---|
2 | 003DJ00000dVZxNYAW | Billing; Statement Delivery; Technical; Non-Operational; Operations | 0014y01102ZsOcA | | 003DJ00000dVZxOYAW | Non-Operational; International Compliance | 0014y02202RDeA7 |
---|
3 | 003DJ00000dVZxOYAW | Non-Operational; International Compliance | 0014y02202RDeA7 | | 003DJ00000dVZxPYAW | Non-Operational | 0014y02202RDeA7 |
---|
4 | 003DJ00000dVZxPYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxQYAW | Non-Operational | 0014y02202RDeA7 |
---|
5 | 003DJ00000dVZxQYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxRYAW | Non-Operational | 0014y02202RDeA7 |
---|
6 | 003DJ00000dVZxRYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxSYAW | Non-Operational | 0014y02202RDeA7 |
---|
7 | 003DJ00000dVZxSYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxYYAW | Non-Operational | 0014y02202RDeA7 |
---|
8 | 003DJ00000dVZxYYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxxYAG | Non-Operational | 0014y02202RDeDS |
---|
9 | 003DJ00000dVZxxYAG | Non-Operational | 0014y02202RDeDS | | 003DJ00000dVZxZYAW | Non-Operational | 0014y02202RDeA7 |
---|
10 | 003DJ00000dVZxZYAW | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxaYAG | Non-Operational | 0014y02202RDeA7 |
---|
11 | 003DJ00000dVZxaYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxbYAG | Non-Operational | 0014y02202RDeA7 |
---|
12 | 003DJ00000dVZxbYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxcYAG | Non-Operational | 0014y02202RDeA7 |
---|
13 | 003DJ00000dVZxcYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxdYAG | Non-Operational | 0014y02202RDeA7 |
---|
14 | 003DJ00000dVZxdYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxeYAG | Non-Operational | 0014y02202RDeA7 |
---|
15 | 003DJ00000dVZxeYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxfYAG | Non-Operational | 0014y02202RDeA7 |
---|
16 | 003DJ00000dVZxfYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxgYAG | Non-Operational | 0014y02202RDeA7 |
---|
17 | 003DJ00000dVZxgYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxhYAG | Non-Operational | 0014y02202RDeA7 |
---|
18 | 003DJ00000dVZxhYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxiYAG | Non-Operational; International Compliance | 0014y02202RDeA7 |
---|
19 | 003DJ00000dVZxiYAG | Non-Operational; International Compliance | 0014y02202RDeA7 | | 003DJ00000dVZxjYAG | Non-Operational | 0014y02202RDeA7 |
---|
20 | 003DJ00000dVZxjYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxkYAG | Non-Operational | 0014y02202RDeA7 |
---|
21 | 003DJ00000dVZxkYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxlYAG | Billing | 0014y02202RDeA7 |
---|
22 | 003DJ00000dVZxlYAG | Billing | 0014y02202RDeA7 | | 003DJ00000dVZxmYAG | Non-Operational | 0014y02202RDeA7 |
---|
23 | 003DJ00000dVZxmYAG | Non-Operational | 0014y02202RDeA7 | | 003DJ00000dVZxvYAG | Non-Operational | 0014y01102RDeDR |
---|
24 | 003DJ00000dVZxnYAG | Billing; Statement Delivery | 0016001100omi13 | | 003DJ00000dVZxwYAG | Non-Operational | 0014y01102RDeDR |
---|
25 | 003DJ00000dVZxoYAG | Non-Operational | 0016001100omi13 | | 003DJ00000dVZxyYAG | Non-Operational | 0014y02202RDeDS |
---|
26 | 003DJ00000dVZxpYAG | Non-Operational | 0016001100omi13 | | 003DJ00000dVZxzYAG | Non-Operational | 0014y02202RDeDS |
---|
27 | 003DJ00000dVZxqYAG | Non-Operational | 0016001100omi13 | | 003DJ00000dVZy0YAG | Non-Operational | 0014y02202RDeDS |
---|
28 | 003DJ00000dVZxrYAG | Non-Operational | 0016001100omi13 | | | | |
---|
29 | 003DJ00000dVZxsYAG | Non-Operational | 0016001100omi13 | | | | |
---|
30 | 003DJ00000dVZxtYAG | Non-Operational | 0016001100omi13 | | | | |
---|
31 | 003DJ00000dVZxuYAG | Non-Operational | 0016001100omi13 | | | | |
---|
32 | 003DJ00000dVZxvYAG | Non-Operational | 0014y01102RDeDR | | | | |
---|
33 | 003DJ00000dVZxwYAG | Non-Operational | 0014y01102RDeDR | | | | |
---|
34 | 003DJ00000dVZxyYAG | Non-Operational | 0014y02202RDeDS | | | | |
---|
35 | 003DJ00000dVZxzYAG | Non-Operational | 0014y02202RDeDS | | | | |
---|
36 | 003DJ00000dVZy0YAG | Non-Operational | 0014y02202RDeDS | | | | |
---|
37 | | | | | | | |
---|
38 | | | | | | | |
---|
39 | | | | | | | |
---|
|
---|