Hi,
Wonder if you could help me with the following:
I want to count the number of Room Types each day as the example. Thanks for your help
Wonder if you could help me with the following:
I want to count the number of Room Types each day as the example. Thanks for your help
Arrival Grid 2.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
1 | 12-Jan-22 | 23-Jan-22 | CheckIn Date | CheckOut Date | Room Type 2 | ||||||||||||||||
2 | 12-Jan-22 | 13-Jan-22 | 14-Jan-22 | 15-Jan-22 | 16-Jan-22 | 17-Jan-22 | 18-Jan-22 | 19-Jan-22 | 20-Jan-22 | 21-Jan-22 | 22-Jan-22 | 23-Jan-22 | 24-Jan-22 | 15-Jan-22 | 19-Jan-22 | TDXG | |||||
3 | OSUG | 13-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
4 | O1SG | 13-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
5 | KSUG | 14-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
6 | KDXG | 2 | 6 | 18 | 18 | 20 | 20 | 20 | 10 | 6 | 14-Jan-22 | 20-Jan-22 | KDXG | ||||||||
7 | KWRG | 14-Jan-22 | 20-Jan-22 | TDXG | |||||||||||||||||
8 | TDXG | 1 | 2 | 2 | 2 | 2 | 1 | 14-Jan-22 | 20-Jan-22 | KDXG | |||||||||||
9 | TWSG | 14-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
10 | TOTG | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 15-Jan-22 | 20-Jan-22 | TDXG | ||||||
11 | KOTG | 15-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
12 | TVUG | 15-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
13 | KEXG | 15-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
14 | KFTG | 15-Jan-22 | 20-Jan-22 | KDXG | |||||||||||||||||
15 | XKLG | 15-Jan-22 | 21-Jan-22 | KDXG | |||||||||||||||||
16 | XOTG | 15-Jan-22 | 21-Jan-22 | KDXG | |||||||||||||||||
17 | XBUG | 17-Jan-22 | 21-Jan-22 | KDXG | |||||||||||||||||
18 | XLXG | 17-Jan-22 | 21-Jan-22 | KDXG | |||||||||||||||||
19 | XLOG | 15-Jan-22 | 22-Jan-22 | KDXG | |||||||||||||||||
20 | XFTG | 15-Jan-22 | 22-Jan-22 | KDXG | |||||||||||||||||
21 | XEXG | 15-Jan-22 | 22-Jan-22 | KDXG | |||||||||||||||||
22 | 1 | 3 | 8 | 21 | 21 | 23 | 23 | 22 | 11 | 7 | 1 | 15-Jan-22 | 22-Jan-22 | KDXG | |||||||
23 | 15-Jan-22 | 22-Jan-22 | KDXG | ||||||||||||||||||
24 | 12-Jan-22 | 23-Jan-22 | TOTG | ||||||||||||||||||
25 | 15-Jan-22 | 23-Jan-22 | KDXG | ||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | C1 | =MIN('[Arrival Grid.xlsx]RL Temp w CC '!C2:C25) |
D1 | D1 | =MAX('[Arrival Grid.xlsx]RL Temp w CC '!D2:D25) |
C2 | C2 | =C1 |
D2:P2 | D2 | =IF(C2<=$D$1,C2+1,"") |
C22:M22 | C22 | =SUM(C3:C21) |