tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 808106d1670289345-vlookup-to-find-last-5-digits-and-return-multiple-results-s666-pq-find-last-5-digits-and-return-multiple-results
Sheet: Sheet1

Sheet 1 |  |  | Sheet 2
 |  |  | Location number | 13611 | DBA |  | Location | DBA |  |  |  | Location number |  | DBA |  | Ctrl+Alt+F5
SUNLIFE-13611 | 2755067 |  |  |  |  |  | SUNLIFE-13611 | 2755067 |  |  |  | 13611 |  | 2755067
DOC - 13611 | 2755071 |  |  |  |  |  | DOC - 13611 | 2755071 |  |  |  |  |  | 2755071
TAP2eat - 13611 | 2755074 |  |  |  |  |  | TAP2eat - 13611 | 2755074 |  |  |  |  |  | 2755074
Spreadsheet: 744264d1629116800-formula-to-count-unique-customer-by-month-test
Sheet: Planilha1

 |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  |  | EXPECTED |  | 2 | 4 | 8 | 1 | 5 | 9
 |  |  |  |  |  | REALITY | 2 | 0 | 5 | 0 | 0 | 5 | 12
DATE | MÊS | ID CLIENTS
2021-01-27 00:00:00 |  | 25
2021-01-27 00:00:00 |  | 24
2021-02-24 00:00:00 |  | 23
2021-02-25 00:00:00 |  | 25
2021-03-15 00:00:00 |  | 25
2021-03-15 00:00:00 |  | 22
2021-03-25 00:00:00 |  | 25
2021-03-31 00:00:00 |  | 31
2021-03-31 00:00:00 |  | 32
2021-04-09 00:00:00 |  | 24
2021-04-14 00:00:00 |  | 21
2021-04-14 00:00:00 |  | 20
2021-04-14 00:00:00 |  | 29
2021-04-14 00:00:00 |  | 49
2021-04-14 00:00:00 |  | 14
2021-04-14 00:00:00 |  | 25
2021-04-14 00:00:00 |  | 33
2021-04-17 00:00:00 |  | 25
2021-05-22 00:00:00 |  | 36
2021-06-01 00:00:00 |  | 63
2021-06-08 00:00:00 |  | 15
2021-06-11 00:00:00 |  | 16
2021-06-24 00:00:00 |  | 11
2021-06-30 00:00:00 |  | 19
2021-07-02 00:00:00 |  | 22
2021-07-13 00:00:00 |  | 48
2021-07-09 00:00:00 |  | 24
2021-07-15 00:00:00 |  | 78
2021-07-28 00:00:00 |  | 3
2021-07-28 00:00:00 |  | 17
2021-07-28 00:00:00 |  | 24
2021-07-29 00:00:00 |  | 25
2021-07-30 00:00:00 |  | 11
2021-07-30 00:00:00 |  | 22
2021-07-30 00:00:00 |  | 33
2021-07-08 00:00:00 |  | 22
Spreadsheet: 841662d1693838985-sum-without-certain-values-04_09_excelhelp
Sheet: Plantes

 | RÉFÉRENCES TAXREF V16 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | STATUTS
 | Nom scientifique | Nom(s) vernaculaire(s) | CD_REF | Type biologique | T.B. Simplifié | Floraison | Lumière | Température | Continentalité | Humidité  atmosphérique | Humidité édaphique | pH | Niveau trophique | Salinité | Texture | Matière  organique | Indigénat | Spontanéité | Directive  Habitats | Protection  Nationale | Protection  Régionale | LRUICN Nat | LRUICN Bzh | EEE Bzh | Dét. ZH |  | LUMIÈRE |  | 1 : hypersciaphiles (10 lux)
 | Agrostis canina L., 1753 [nom. et typ. cons.] | Agrostide des chiens, Agrostide canine, Traînasse, Agrostis des chiens | 80590 | hsto | [NAME]. | juin-aou | 7 | 5 | 5 | 8 | 8 | 3 | 2 | 0 | 2 | 9 | I | Spont. |  |  |  |  |  |  | Oui |  |  |  | 2 : aéroxérophiles (20%)
 | Agrostis gigantea [NAME], 1788 | Agrostide géante, Fiorin, Agrostis géante | 80639 | hsto | [NAME]. |  | 7 | 5 | 5 | 8 | 7 | 7 | 6 | 0 | 1 | 8 | I | Spont. |  |  |  |  |  |  | Oui |  |  |  | 6 : aéromésohygroclines (60%)
 | Cirsium palustre (L.) Scop., 1772 | Cirse des marais, [NAME]-du-diable | 91382 | Hbis | [NAME]. | juil-sep | 7 | 4 | 4 | 8 | 7 | 3 | 6 | 0 | 1 | 8 | I | Spont. |  |  |  |  |  |  | Oui
 | Epilobium tetragonum [NAME], 1753 | Épilobe à tige carrée, Épilobe à quatre angles, Épilobe tétragone | 96271 | [NAME] | [NAME]. | juin-sept | 6 | 5 | 5 | 7 | 6 | 7 | 6 | 0 | 1 | 8 | I | Spont.
 | Filipendula ulmaria ([NAME]) Maxim., 1879 | Reine-des-prés, [NAME], [NAME] ulmaire | 98717 | Hros | [NAME]. | juin-aou | 7 | 4 | 5 | 8 | 7 | 5 | 6 | 0 | 1 | 8 | I | Spont. |  |  |  |  |  |  | Oui
 | Galium mollugo [NAME], 1753 | Gaillet commun, Gaillet Mollugine, Caille-lait blanc | 99473 | hsto | [NAME]. | juin-aou | 8 | 5 | 5 | 5 | 5 | 7 | 6 | 0 | 3 | 2 | I | Spont.
 | Holcus lanatus [NAME], 1753 | Houlque laineuse, Blanchard | 102900 | hces | [NAME]. | mai-aou | 7 | 5 | 5 | 5 | 5 | 4 | 6 | 1 | 3 | 3 | I | Spont.
 | Holcus x hybridus Wein, 1913 | Houlque hybride | 102906 |  |  |  |  |  |  |  |  |  |  |  |  |  | I | Spont.
 | Juncus acutiflorus Ehrh. ex Hoffm., 1791 | Jonc à fleurs aiguës, [NAME] à tépales aigus, [NAME] acutiflore | 104101 | Grhi | Geo. | juin-aou | 8 | 5 | 4 | 8 | 8 | 4 | 3 | 0 | 2 | 9 | I | Spont. |  |  |  |  |  |  | Oui
 | [NAME] effusus L., 1753 | [NAME] épars | 104173 | grhi | Geo. | juin-sept | 7 | 5 | 4 | 8 | 7 | 4 | 4 | 0 | 2 | 9 | I | Spont. |  |  |  |  |  |  | Oui
 | [NAME], 1753 [nom. et typ. cons.] | Patience oseille, [NAME] des prés, Rumex oseille, Grande oseille, [NAME] commune, Surelle | 119418 | hros | [NAME]. |  | 8 | 5 | 5 | 5 | 5 | 5 | 6 | 0 | 3 | 3 | I | Spont.
Spreadsheet: 149885d1334172743-counting-same-values-in-a-column-countsamevaluesnew
Sheet: Sheet1

1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
Spreadsheet: 732656d1621106850-split-up-rs-232-data-to-different-columns-rs-232
Sheet: Sheet1

Sent    Receive |  |  | #s | #B | #M | #I
#s
 | #s2
#[NAME]
 | #D3156
#Z
 | #Z148
#B
 | #B11
#M
 | #[NAME]
#I
 | #[NAME]
#s
#[NAME]
 | #s2
 | #D3156
#Z
 | #Z147
#B
 | #B11
#M
 | #[NAME]
#I
 | #[NAME]
#s
 | #s2
#[NAME]
 | #D3156
#Z
 | #Z147
Spreadsheet: 192895d1352614540-combining-of-3-pivot-tables-datas-into-1-how-sales-datas
Sheet: Plant-1-Pivot

Plant | (All)
 | G/L Code | Values
 | QA10101110 |  | QA10101140 |  | QA10101145 |  | QA10105110 |  | QA10105140 |  | Total Sum of Qty | Total Sum of Amount
Material Group | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount
CNDKDRSCC |  |  |  |  |  |  | -192 | -7123200 |  |  | -192 | -7123200
FNDADRKCC | -15 | -447214.8 |  | -4290 |  | -217.2 |  |  |  |  | -15 | -451722
FNDADRSCC | -15 | -464480.55 |  | -4290 |  | -225.45 |  |  |  |  | -15 | -468996
FNSBDRKSC | -2 | -53259.56 |  | -572 |  | -25.88 |  |  |  |  | -2 | -53857.44
SPPFDRKCC |  |  |  |  |  |  | -96 | -3561600 |  |  | -96 | -3561600
SPRADRSCC |  |  |  |  |  |  |  |  |  | -31274.25 |  | -31274.25
SPRFDRSCC |  |  |  |  |  |  | -96 | -3790560 |  |  | -96 | -3790560
SPSADRSCC | -33 | -1220324.82 |  | -5148 |  | -143.44 | -65 | -2200528.2 |  | -87594.5 | -98 | -3513738.96
Grand Total | -65 | -2185279.73 |  | -14300 |  | -611.97 | -449 | -16675888.2 |  | -118868.75 | -514 | -18994948.65
Spreadsheet: 49953d1249380110-retrieve-only-one-value-according-to-another-value-sample5
Sheet: Sheet1

COMP | MC | NAME
c34 | 1 | grass
 | 5 | paper
c55 | 2 | hse
c34 | 1 | grass
c55 | 2 | hse
 | 5 | paper
c55 | 2 | hse
c55 | 2 | hse
c34 | 1 | grass
 | 5 | paper
c32 | 5 | paper
c34 | 1 | grass
Spreadsheet: 216976d1361951728-dissemination-of-informatin-based-on-sheet-title-participation-levels
Sheet: Total 

S.N. | Input Marketing | Output Marketing | Services | Seed Production | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet7

Row Labels | Count of Status
Didn't join after selection | 1
Duplicate | 6
No Show | 11
Not Interested | 13
Not Suitable | 16
Offer Accepted | 1
[NAME] | 3
Rejected (1st) | 32
Rejected (2nd) | 5
Scheduled | 4
(blank)
Grand Total | 92
Spreadsheet: 214960d1361211606-find-add-and-return-values-from-multiple-worksheets-example
Sheet: Sheet3

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent
Adam | Science | 2 | Maths | 1 | English | 1
Eve | History | 2 | French | 1 | Maths | 2
[NAME] | Maths | 2 | Science | 1 | Geography | 3
Spreadsheet: 469501d1467958899-help-with-difficult-unique-countifs-oeldere2-469424d1467910295-help-with-difficult-unique-countifs-helpie-
Sheet: Blad1

Date | Status | help
2015-01-02 00:00:00 | Paid |  |  |  |  | Aantal van help | Kolomlabels
2015-01-02 00:00:00 | No |  |  |  |  | Rijlabels | No | Paid | Called owner | Eindtotaal
2015-01-05 00:00:00 | No |  |  |  |  | jan | 8 | 8 | 1 | 17
2015-01-05 00:00:00 | Paid |  |  |  |  | feb | 4 | 3 |  | 7
2015-01-08 00:00:00 | Paid |  |  |  |  | mrt | 1 | 3 |  | 4
2015-01-10 00:00:00 | No |  |  |  |  | Eindtotaal | 13 | 14 | 1 | 28
2015-01-10 00:00:00 | Paid
2015-01-11 00:00:00 | Paid
2015-01-15 00:00:00 | Paid
2015-01-15 00:00:00 | No
2015-01-19 00:00:00 | No
2015-01-21 00:00:00 | No |  |  |  | copy the data
2015-01-21 00:00:00 | Paid |  |  |  | data => remove duplicates on column C (help)
2015-01-25 00:00:00 | No |  |  |  | after that a pivot table
2015-01-29 00:00:00 | No
2015-01-29 00:00:00 | Paid |  |  |  | See the attached file.
2015-02-02 00:00:00 | Paid
2015-02-02 00:00:00 | No
2015-02-07 00:00:00 | No
2015-02-14 00:00:00 | No
2015-02-14 00:00:00 | Paid
2015-02-16 00:00:00 | No
2015-02-22 00:00:00 | Paid
2015-03-08 00:00:00 | No
2015-03-08 00:00:00 | Paid
2015-03-11 00:00:00 | Paid
2015-03-13 00:00:00 | Paid
2016-01-14 00:00:00 | Called owner
Spreadsheet: 118bd417-6985-4853-9ec4-873a1b7e5e8f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Annual Rate for Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2013
 |  | Data Extracted on: November 28, 2014 (4:48 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002 | 858654 | 862338 | 844551 | 858240 | 850935 | 846777 | 847129 | 839008 | 832134 | 839690 | 844697 | 855921
2003 | 863855 | 859225 | 851132 | 859459 | 866814 | 880865 | 891264 | 901839 | 911589 | 925732 | 925985 | 948491
2004 | 938826 | 938656 | 960946 | 967761 | 974158 | 983072 | 1006119 | 1013724 | 1012290 | 1015562 | 1023210 | 1037684
2005 | 1036187 | 1056492 | 1065262 | 1058365 | 1078586 | 1089505 | 1109691 | 1119782 | 1131739 | 1145663 | 1156977 | 1178305
2006 | 1183861 | 1199767 | 1213270 | 1183485 | 1180059 | 1172932 | 1165093 | 1158193 | 1151104 | 1139292 | 1137488 | 1153491
2007 | 1149899 | 1156008 | 1167402 | 1159124 | 1168195 | 1166892 | 1154018 | 1160593 | 1165162 | 1152511 | 1127558 | 1108958
2008 | 1106498 | 1092911 | 1095194 | 1092939 | 1091569 | 1075482 | 1067380 | 1058675 | 1056892 | 1051176 | 1031004 | 994216
2009 | 965270 | 962482 | 956133 | 931610 | 914093 | 903987 | 901735 | 891278 | 881340 | 870697 | 852896 | 832484
2010 | 818468 | 798063 | 807437 | 825626 | 817745 | 817869 | 790519 | 793090 | 800329 | 802013 | 799636 | 779919
2011 | 757900 | 754970 | 763454 | 772469 | 774148 | 797272 | 789632 | 801183 | 805565 | 806849 | 809833 | 817198
2012 | 823583 | 825774 | 834810 | 842898 | 861913 | 873069 | 864687 | 868246 | 876091 | 883853 | 879539 | 882637
2013 | 869232 | 879609 | 871888 | 884966 | 896603 | 900334 | 906644 | 915286 | 924153 | 939933 | 952531 | 961158
Spreadsheet: 796081d1663090270-spill-range-with-countifs-of-unique-rows-2022-09-13-oeldere-marbleking-countifs_unique
Sheet: Sheet1

Date_1 | Date_2 | Date_3 |  |  | Date_1 | Date_2 | Date_3 |  |  | COUNTIFS |  | COUNTIFS |  | COUNTIFS
2019-07-30 00:00:00 | 2019-06-25 00:00:00 | 2019-08-01 09:44:12 |  |  |  | 2019-06-25 00:00:00 | 2019-08-01 09:44:12
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 1 |  | #[NAME]!
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  | 1 |  | #[NAME]!
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-22 00:00:00 | 2019-07-31 00:00:00 | 2019-09-20 06:54:36 |  |  | 1 |  | #[NAME]!
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-09-03 00:00:00 | 2019-08-07 00:00:00 | 2019-09-05 12:57:23 |  |  | 1 |  | #[NAME]!
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  | 1 |  | #[NAME]!
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  |  |  |  |  |  | 1 |  | #N/A
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  |  |  |  |  |  | 1 |  | #N/A
2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  |  |  |  |  |  | 2 |  | #N/A
2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  |  |  |  |  |  | 2 |  | #N/A
2019-08-22 00:00:00 | 2019-07-31 00:00:00 | 2019-09-20 06:54:36 |  |  |  |  |  |  |  | 2 |  | #N/A
2019-09-03 00:00:00 | 2019-08-07 00:00:00 | 2019-09-05 12:57:23 |  |  |  |  |  |  |  | 3 |  | #N/A
2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  |  |  |  |  |  | 4 |  | #N/A
2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  |  |  |  |  |  | 4 |  | #N/A
Spreadsheet: 744823d1629470503-matching-1-column-with-another-caseload
Sheet: Sheet1

Jobseeker's Allowance with rates and proportions | Jobseeker's Allowance with rates and proportions
ONS Crown Copyright Reserved [from Nomis on 20 August 2021] | ONS Crown Copyright Reserved [from Nomis on 20 August 2021]
sex | sex
item name | item name |  | want to check the data match by foruml J9 NOT working correctly
postcode sector | postcode sector
W  3 0 | W3 | 0 |  | W3 6 | W3 6
W  3 3 | W3 | 3 |  | W3 7 | W3 7
W  3 6 | W3 | 6 |  | W3 8 | W3 8
W  3 7 | W3 | 7 |  | W3 9 | W3 9
W  3 8 | W3 | 8 |  | W3 0 | W3 0
W  3 9 | W3 | 9 |  | W4 1 | W4 1
W  4 5 | W4 | 5 |  | W4 2 | W4 2
W  4 9 | W4 | 9 |  | W4 3 | W4 3
W  4 1 | W4 | 1 |  | W4 4 | [NAME]
W  4 2 | W4 | 2 |  | W4 5 | W4 5
W  4 3 | W4 | 3 |  | W5 1 | W5 1
W  4 4 | W4 | 4 |  | W5 2 | W5 2
W  5 1 | W5 | 1 |  | W5 3 | W5 3
# These figures are suppressed as value is 1 or 2. | # These figures are suppressed as value is 1 or 2.
From May 2013 onwards [NAME] is no longer classed as a National Statistic as it is no longer a full count of those claiming unemployment related benefits. Users should instead use the Claimant Count datasets for a more accurate coverage of claimants. | From May 2013 onwards [NAME] is no longer classed as a National Statistic as it is no longer a full count of those claiming unemployment related benefits. Users should instead use the Claimant Count datasets for a more accurate coverage of claimants.
Spreadsheet: 794363d1662010448-sumif-formula-with-or-function-example-sum-with-conditions-hd-other-interpretation
Sheet: Sheet1

1 | [NAME] | Bonus
2 | [NAME] | Bonus
4 | [NAME]
8 | [NAME] |  | black
16 | [NAME] | Bonus | white
32 | [NAME] | Green | White
64 | [NAME] | Bonus | white
Sum  column A, If anywhere in column B the name is "[NAME]" AND (if in column C is "Bonus" OR if column D is blank)
 | <<----
Spreadsheet: 66754d1267454633-searching-in-excel-with-a-table-search
Sheet: Sheet1

Search List | Return List |  | Search Within | Return
Apple | Ap |  | I bought some Apples | Ap | Ap
[NAME] | Ba |  | My favourite cocktail is banana daquiri | Ba | Ba
Pear | Pe |  | I've got a lovely pear of grapefruit | Gr | Gf
Melon | Me |  | a tomato a day keeps the doctor away | #N/A | #N/A
Grape | Gr
Grapefruit | Gf
Spreadsheet: e682f581-b707-4e56-8843-4a7ff4f5490c
Sheet: FTSE Summary

Average Total Expenditure per Full-Time Student Equivalent (FTSE)
Institution | Annual State Funded Semester Credit Hours | Total FTSE | Total Expenditure | Average Expenditure per FTSE
Alamo | 998865
Alvin | 92788
Amarillo | 178668
Angelina | 94431
[NAME] | 637122
Blinn | 328749
Brazosport | 66827
Central Texas | 261238
Cisco | 71870
[NAME] | 25155
Coastal Bend | 63382
College Of The Mainland | 71997
Collin | 412203
Dallas | 1151165
Del Mar | 204427
El Paso | 471363
[NAME] | 26276
Galveston | 40208
[NAME] | 82457
Hill | 70448
Houston | 846337
[NAME] | 61090
Kilgore | 115663
Laredo | 154193
[NAME] | 125718
Lonestar | 832324
[NAME] | 174178
Midland | 111509
Navarro | 165450
North Central Texas | 145014
Northeast Texas | 52949
Odessa | 85524
Panola | 40729
Paris | 90017
Ranger | 18238
San Jacinto | 476825
South Plains | 192922
South Texas | 375255
Southwest Texas | 93303
Tarrant | 728201
Temple | 95894
Texarkana | 87473
Texas Southmost | 189835
Trinity Valley | 131916
Tyler | 205968
Vernon | 57233
Victoria | 74015
Weatherford | 91593
Western Texas | 41029
[NAME] | 120743
TSTC-Harlingen | 110187
TSTC-West Texas | 39449
TSTC-Marshall | 16611
TSTC-Waco | 122169
Lamar-IOT | 57077
[NAME] | 42154
[NAME] | 44993
Total for Instutions Reporting Expense
Spreadsheet: 129447d1321619081-compare-columns-and-detect-changes-videobeispiel
Sheet: itemlist1

BMK | Page
-WD5007 | 172
-WD5011 | 180
-WD5012 | 180
-WD5013 | 180
-WD5014 | 180
-WD5015 | 180
[NAME] | 180
-WDz5036 | 171
-Wz3031 | 171
-Wz3031 | 171
Spreadsheet: 100003d1298494352-how-do-i-import-data-from-another-sheet-to-match-certain-criteria-test-page-excel-assistance
Sheet: Sheet X

Region | Emp. Number | Name | Date | Code | Hours
LC | 451321 | Rita | 2010-04-01 00:00:00 | A | 8
LC | 451321 | Rita | 2010-04-02 00:00:00 | A | 8
LC | 451321 | Rita | 2010-04-03 00:00:00 | A | 8
LC | 486512 | [NAME] | 2010-04-01 00:00:00 | A | 4
LC | 486512 | [NAME] | 2010-04-02 00:00:00 | A | 4
LC | 498498 | [NAME] | 2010-04-01 00:00:00 | U | 0.8
LC | 498498 | [NAME] | 2010-04-02 00:00:00 | A | 8
LC | 498498 | [NAME] | 2010-04-03 00:00:00 | A | 8
UC | 484948 | Alonzo | 2010-04-01 00:00:00 | A | 4
UC | 484948 | Alonzo | 2010-04-02 00:00:00 | R | 6
UC | 484948 | Alonzo | 2010-04-03 00:00:00 | A | 8
UC | 498516 | [NAME] | 2010-04-01 00:00:00 | A | 8
UC | 498516 | [NAME] | 2010-04-02 00:00:00 | A | 8
UC | 498516 | [NAME] | 2010-04-03 00:00:00 | A | 8
UC | 433212 | [NAME] | 2010-04-01 00:00:00 | A | 4
UC | 433212 | [NAME] | 2010-04-02 00:00:00 | A | 4
UC | 468988 | [NAME] | 2010-04-01 00:00:00 | A | 8
UC | 468988 | [NAME] | 2010-04-02 00:00:00 | A | 4
UC | 468988 | [NAME] | 2010-04-03 00:00:00 | A | 8
DC | 489321 | Christina | 2010-04-01 00:00:00 | A | 6
DC | 489321 | Christina | 2010-04-02 00:00:00 | A | 6
DC | 489321 | Christina | 2010-04-03 00:00:00 | T | 6
DC | 489321 | Christina | 2010-04-04 00:00:00 | A | 8
DC | 489302 | [NAME] | 2010-04-01 00:00:00 | A | 8
DC | 489302 | [NAME] | 2010-04-02 00:00:00 | A | 8
DC | 489302 | [NAME] | 2010-04-03 00:00:00 | A | 8
DC | 456898 | [NAME] | 2010-04-01 00:00:00 | A | 8
DC | 456898 | [NAME] | 2010-04-02 00:00:00 | A | 4
DC | 456898 | [NAME] | 2010-04-03 00:00:00 | A | 6
DC | 456898 | [NAME] | 2010-04-04 00:00:00 | A | 8
DC | 489877 | [NAME] | 2010-04-01 00:00:00 | A | 8
DC | 489877 | [NAME] | 2010-04-02 00:00:00 | T | 0.75
DC | 489877 | [NAME] | 2010-04-03 00:00:00 | A | 6
DC | 489877 | [NAME] | 2010-04-04 00:00:00 | A | 6
Spreadsheet: 749352d1632749993-auto-plotting-risk-ids-in-a-matrix-table-thank-you-book1
Sheet: Sheet1

ID | Impact | Liklihood
1 | 1 | 1
2 | 1 | 2
3 | 1 | 1
4 | 3 | 3
5 | 1 | 1
6 | 3 | 3
 |  |  | Impact | 3 |  |  | 4, 6
 |  |  |  | 2
 |  |  |  | 1 | 1, 3, 5 | 2
 |  |  |  |  | 1 | 2 | 3
 |  |  |  |  | Liklihood
Spreadsheet: 544827d1509043608-how-to-populate-sheets-with-information-from-other-sheets-example-34-
Sheet: MA

description | size | barcode | Quantity
Mazda Tribute | SM | 1341763416923605 | 1
Mazda Miata | ME | 2719283255308755 | 5
Mazda 929 | LG | 694321991538779 | 0
Mazda 626 | XL | 6438427676283899 | 0
Mazda RX7 | XXL | 5456832702244069 | 0
Mazda RX8 | XXXL | 1136147159619950 | 0
Mazda MX3 | SM | 2117423089074606 | -3
Mazda Protoge5 | ME | 1210986581924867 | 17
Mazda Protoge5 | LG | 6988925321821862 | 16
Mazda Protoge5 | XL | 7332729747470930 | 56
Spreadsheet: 719162d1613534020-conditional-formating-nightmare-desertmj-example-for-conditional-formating
Sheet: Sales by store

 |  |  |  |  | sales latest four weeks |  |  |  |  |  |  |  |  |  | details
 | store | address | city | state | apples | bananas | oranges | grapes |  |  |  | store | Item | Type | Authorized | [NAME]
 | 1 | 123 Main Drive | [NAME] | NC | 1.5 | 2 | 2.5 | 2 |  |  |  | 1 | Apples | Red | A
 | 2 | 345 Town Square | [NAME] | NC | 1.25 | 2.25 | 3 | 1.75 |  |  |  | 1 | Bananas | Yellow | A
 | 3 | 678 Cobble Street | [NAME] | NC | 2.25 | 5 | 3.25 |  |  |  |  | 1 | Oranges | Blood | A
 | 4 | 910 [NAME] | [NAME] | NC | 1.75 |  | 1.9 |  |  |  |  | 1 | Grapes | Green Seedless | A
 | 5 | 111 Old Pond Road | [NAME] | NC |  | 1.5 | 1.25 |  |  |  |  | 2 | Apples | Red | A
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Bananas | Yellow | O
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Oranges | Blood | U
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Grapes | Green Seedless | A
 |  |  |  | Need the cells in the box conditionally formatted |  |  |  |  |  |  |  | 3 | Apples | Red | A
 |  |  |  | to show they are: |  |  |  |  |  |  |  | 3 | Bananas | Yellow | A
 |  |  |  | "A" authorized but no sales |  |  |  |  |  |  |  | 3 | Oranges | Blood | U
 |  |  |  | "U" unauthorized but sales |  |  |  |  |  |  |  | 3 | Grapes | Green Seedless | U
 |  |  |  | "O" either with or without sales |  |  |  |  |  |  |  | 4 | Apples | Red | A
 |  |  |  |  |  |  |  |  |  |  |  | 4 | Bananas | Yellow | A
 |  |  |  |  |  |  |  |  |  |  |  | 4 | Oranges | Blood | A
 |  |  |  |  |  |  |  |  |  |  |  | 4 | Grapes | Green Seedless | A
 |  |  |  |  |  |  |  |  |  |  |  | 5 | Apples | Red | A
 |  |  |  |  |  |  |  |  |  |  |  | 5 | Bananas | Yellow | A
 |  |  |  |  |  |  |  |  |  |  |  | 5 | Oranges | Blood | A
 |  |  |  |  |  |  |  |  |  |  |  | 5 | Grapes | Green Seedless | A