I have a table showing different sales persons visiting different places and their period of stay in those places. Now, I want to find out which salespersons visited more than one city within a given range of dates. Sample sheet has been attached. My results should look like the cells colored in 'green' (i.e. in the range: H2:N2)
Thanks in advance.
Thanks in advance.
Sample.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Name | Place | Arrival Date | Departure Date | Period From | Period To | Davis | Henry | John | Kate | Mitchel | Naomi | Peter | |||
2 | Peter | London | 01-02-2021 | 03-02-2021 | 01-02-2021 | 28-02-2021 | Yes | No | No | Yes | Yes | No | No | |||
3 | Davis | Kairo | 04-02-2021 | 07-02-2021 | ||||||||||||
4 | Naomi | New York | 02-01-2021 | 06-01-2021 | ||||||||||||
5 | Henry | London | 03-01-2021 | 05-01-2021 | ||||||||||||
6 | Kate | Singapore | 12-01-2021 | 17-01-2021 | ||||||||||||
7 | Davis | Dubai | 10-02-2021 | 12-02-2021 | ||||||||||||
8 | Peter | Paris | 15-01-2021 | 19-01-2021 | ||||||||||||
9 | Kate | New Delhi | 05-02-2021 | 08-02-2021 | ||||||||||||
10 | John | Dubai | 04-05-2021 | 08-05-2021 | ||||||||||||
11 | Mitchel | London | 18-02-2021 | 21-02-2021 | ||||||||||||
12 | Henry | Paris | 07-01-2021 | 12-01-2021 | ||||||||||||
13 | Naomi | New Delhi | 08-01-2021 | 15-01-2021 | ||||||||||||
14 | Peter | London | 24-02-2021 | 28-02-2021 | ||||||||||||
15 | Mitchel | Dubai | 23-02-2021 | 24-02-2021 | ||||||||||||
16 | Mitchel | London | 26-02-2021 | 28-02-2021 | ||||||||||||
17 | Naomi | Singapore | 12-02-2021 | 16-02-2021 | ||||||||||||
18 | Kate | New Delhi | 21-02-2021 | 25-02-2021 | ||||||||||||
19 | Henry | Paris | 15-01-2021 | 20-01-2021 | ||||||||||||
20 | Davis | London | 25-02-2021 | 28-02-2021 | ||||||||||||
21 | Kate | Dubai | 12-02-2021 | 18-02-2021 | ||||||||||||
Sheet1 |