Hi there,
Basically I've got a spreadsheet with 2 tabs. The first is a list of queries created for various restaurants, each of these restaurants has a number. The second tab has the restaurant number alongside a divison that it's a part of. How can I find out the total queries created by division. I'm stumped on how to connect the correct division back to the corresponding restaurant on the queries tab. Thanks
Basically I've got a spreadsheet with 2 tabs. The first is a list of queries created for various restaurants, each of these restaurants has a number. The second tab has the restaurant number alongside a divison that it's a part of. How can I find out the total queries created by division. I'm stumped on how to connect the correct division back to the corresponding restaurant on the queries tab. Thanks
excel file.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Number | Created | Month Created | Restaurant Number | ||
5 | PQS1160998 | 13-05-21 17:18 | May | 1001 | ||
6 | PQS1160971 | 13-05-21 17:01 | May | 1001 | ||
9 | PQS1165398 | 18-05-21 11:06 | May | 1001 | ||
11 | PQS1172770 | 25-05-21 17:46 | May | 1001 | ||
12 | PQS1172770 | 25-05-21 17:46 | May | 1001 | ||
13 | PQS1179289 | 03-06-21 09:49 | June | 1001 | ||
14 | PQS1185835 | 09-06-21 14:51 | June | 1001 | ||
20 | PQS1188138 | 11-06-21 22:10 | June | 1001 | ||
23 | PQS1188138 | 11-06-21 22:10 | June | 1001 | ||
24 | PQS1194371 | 20-06-21 15:18 | June | 1001 | ||
31 | PQS1185829 | 09-06-21 14:48 | June | 1001 | ||
32 | PQS1149827 | 27-04-21 16:05 | April | 1002 | ||
33 | PQS1161534 | 14-05-21 11:50 | May | 1002 | ||
34 | PQS1171612 | 24-05-21 17:13 | May | 1002 | ||
35 | PQS1171572 | 24-05-21 16:45 | May | 1002 | ||
36 | PQS1177527 | 01-06-21 14:41 | June | 1002 | ||
37 | PQS1178936 | 02-06-21 16:49 | June | 1002 | ||
39 | PQS1196364 | 22-06-21 14:22 | June | 1002 | ||
40 | PQS1197316 | 23-06-21 14:08 | June | 1002 | ||
41 | PQS1214507 | 15-07-21 10:45 | July | 1002 | ||
48 | PQS1190034 | 14-06-21 16:56 | June | 1002 | ||
52 | PQS1176776 | 31-05-21 21:11 | May | 1003 | ||
61 | PQS1185619 | 09-06-21 12:31 | June | 1003 | ||
66 | PQS1197597 | 23-06-21 18:37 | June | 1003 | ||
67 | PQS1152077 | 03-05-21 11:44 | May | 1004 | ||
68 | PQS1155104 | 06-05-21 22:48 | May | 1004 | ||
70 | PQS1158147 | 11-05-21 11:54 | May | 1004 | ||
71 | PQS1163046 | 16-05-21 18:00 | May | 1004 | ||
72 | PQS1167990 | 20-05-21 13:23 | May | 1004 | ||
75 | PQS1168143 | 20-05-21 14:58 | May | 1004 | ||
78 | PQS1171758 | 24-05-21 20:35 | May | 1004 | ||
80 | PQS1205867 | 03-07-21 23:01 | July | 1004 | ||
81 | PQS1212814 | 13-07-21 10:51 | July | 1004 | ||
82 | PQS1163755 | 17-05-21 11:44 | May | 1005 | ||
83 | PQS1172933 | 26-05-21 08:22 | May | 1005 | ||
85 | PQS1171696 | 24-05-21 18:51 | May | 1005 | ||
90 | PQS1170126 | 23-05-21 19:43 | May | 1005 | ||
Queries |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C90,C85,C80:C83,C78,C75,C70:C72,C66:C68,C61,C52,C48,C39:C41,C31:C37,C23:C24,C20,C11:C14,C9,C5:C6 | C5 | =TEXT(MONTH(B5)*29,"Mmmm") |
excel file.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | restaurant No | restaurant Name | Division | ||
2 | 1001 | restaurant 1 | Divison A | ||
3 | 1002 | restaurant 2 | Division B | ||
4 | 1003 | restaurant 3 | Division C | ||
5 | 1004 | restaurant 4 | Division C | ||
6 | 1005 | restaurant 5 | Divison A | ||
7 | 1006 | restaurant 6 | Division B | ||
8 | 1007 | restaurant 7 | Division C | ||
9 | 1008 | restaurant 8 | Divison A | ||
10 | 1009 | restaurant 9 | Division B | ||
11 | 1010 | restaurant 10 | Division C | ||
12 | 1011 | restaurant 11 | Divison A | ||
13 | 1012 | restaurant 12 | Division B | ||
14 | 1013 | restaurant 13 | Division C | ||
15 | 1014 | restaurant 14 | Division B | ||
16 | 1015 | restaurant 15 | Division C | ||
17 | 1016 | restaurant 16 | Division C | ||
18 | 1017 | restaurant 17 | Divison A | ||
19 | 1018 | restaurant 18 | Division B | ||
20 | 1019 | restaurant 19 | Division C | ||
21 | 1020 | restaurant 20 | Division C | ||
22 | 1021 | restaurant 21 | Division C | ||
23 | 1022 | restaurant 22 | Divison A | ||
restaurant |