tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 696090d1600611373-solved-sumif-through-two-drop-down-list-test-liemster-
Sheet: Data

 | Week1 |  |  |  |  |  |  | Week2 |  |  |  |  |  |  | Week3 |  |  |  |  |  |  | Week4
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
apple | 48 | 713 | 284 | 638 | 906 | 84 | 714 | 364 | 856 | 478 | 879 | 936 | 948 | 165 | 116 | 134 | 841 | 709 | 834 | 889 | 983 | 677 | 404 | 51 | 789 | 225 | 886 | 980
orange | 283 | 768 | 17 | 570 | 357 | 237 | 20 | 516 | 325 | 164 | 608 | 356 | 615 | 483 | 920 | 300 | 230 | 243 | 557 | 364 | 916 | 751 | 175 | 909 | 734 | 113 | 730 | 126
banana | 776 | 384 | 359 | 996 | 333 | 734 | 301 | 714 | 639 | 280 | 899 | 636 | 351 | 720 | 646 | 611 | 405 | 749 | 448 | 704 | 790 | 728 | 385 | 525 | 218 | 161 | 144 | 503
peach | 530 | 352 | 495 | 289 | 363 | 673 | 289 | 386 | 358 | 242 | 796 | 304 | 819 | 845 | 707 | 440 | 814 | 10 | 656 | 880 | 236 | 702 | 778 | 15 | 445 | 58 | 656 | 626
Week1 | Sunday
Week2 | Monday
Week3 | Tuesday
Week4 | Wednesday
 | Thursday
 | Friday
 | Saturday
Spreadsheet: 791107d1660154987-how-do-i-combine-duplicate-entries-and-add-numbers-sample-
Sheet: Sheet1

Account | Category | # |  | Account | Category | #
Customer 1 | Discontinued | 5 |  |  | Discontinued
Customer 1 | Product A | 7 |  | Customer 1 | Product A
Customer 1 | Product B | 8 |  | Customer 1 | Product B
Customer 1 | Product B | 8 |  | Customer 2 | Discontinued
Customer 1 | Product B | 8 |  | Customer 2 | Product A
Customer 2 | Discontinued | 4
Customer 2 | Product A | 20
Customer 2 | Product A | 4
Customer 2 | Product A | 11
Spreadsheet: 668751d1585025944-auto-update-the-cell-data-from-row-into-columns-for-a-document-record-book-ledger
Sheet: Sheet1

NORMAL SHEET
 |  |  |  |  |  |  |  |  | B |  |  |  |  | C |  |  |  |  | D
S/N | Discipline | Document Number | Document Title | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME] | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME]
1 | Engg | [NAME] | DOCUMENT REGISTER | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 4
2 | Procedure | ASD2 | PID | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3 | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3 | C | 2019-03-04 00:00:00 | QW004 | 2019-03-20 00:00:00 | 3 | D | 2019-04-28 00:00:00 | QW006 | 2019-06-24 00:00:00 | 3
3 | Engg | ASD3 | GAD | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 2 | B | 2019-07-01 00:00:00 | QW003 | 2019-10-17 00:00:00 | 3 | C | 2019-12-11 00:00:00 | QW004 | 2020-01-12 00:00:00 | 3 | D | 2020-01-14 00:00:00 | [NAME] | 2020-02-07 00:00:00 | 3
4 | Procedure | [NAME] | [NAME] | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3 | B | 2019-02-13 00:00:00 | QW002 | 2019-03-03 00:00:00 | 2 | C | 2019-06-18 00:00:00 | QW003 | 2019-12-18 00:00:00 | 3 | D | 2019-12-24 00:00:00 | [NAME] | 2020-01-14 00:00:00 | 3
 |  | REQUIRED FORMAT
 |  | Document Number | Document Title | Rev | Doc. Submission date | Transmittal Ref. no | Doc. return date | [NAME]
 |  | [NAME] | DOCUMENT REGISTER | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 4
 |  | [NAME] | DOCUMENT REGISTER | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3
 |  | ASD2 | PID | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
 |  | ASD2 | PID | B | 2019-02-07 00:00:00 | QW002 | 2019-02-28 00:00:00 | 3
 |  | ASD2 | PID | C | 2019-03-04 00:00:00 | QW004 | 2019-03-20 00:00:00 | 3
 |  | ASD2 | PID | D | 2019-04-28 00:00:00 | QW006 | 2019-06-24 00:00:00 | 3
 |  | ASD3 | GAD | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 2
 |  | ASD3 | GAD | B | 2019-07-01 00:00:00 | QW003 | 2019-10-17 00:00:00 | 3
 |  | ASD3 | GAD | C | 2019-12-11 00:00:00 | QW004 | 2020-01-12 00:00:00 | 3
 |  | ASD3 | GAD | D | 2020-01-14 00:00:00 | [NAME] | 2020-02-07 00:00:00 | 3
 |  | [NAME] | [NAME] | A | 2018-12-25 00:00:00 | QW001 | 2019-01-13 00:00:00 | 3
 |  | [NAME] | [NAME] | B | 2019-02-13 00:00:00 | QW002 | 2019-03-03 00:00:00 | 2
 |  | [NAME] | [NAME] | C | 2019-06-18 00:00:00 | QW003 | 2019-12-18 00:00:00 | 3
 |  | [NAME] | [NAME] | D | 2019-12-24 00:00:00 | [NAME] | 2020-01-14 00:00:00 | 3
Spreadsheet: 128577d1321056569-compare-two-ranges-and-count-numbers-that-are-greater-or-less-by-8-ignore-duplicate-differences
Sheet: Sheet1

 |  |  | 0 | 0 | 1 | 2 | 2 | 3 | 5
 |  |  | 0 | 0 | 0 | 1 | 2 | 4 | 5
 |  |  | The count of numbers with a difference 1, when avoiding duplicates, is 8
 |  |  | The difference between D6 with F5 is 1.
 |  |  | E6 with F5= 1
 |  |  | F6 with F5=1
 |  |  | The difference of G6 with  D5 =1. But G6 then should not be compared with E5 as it will be a duplicate
 |  |  | Similarly, [NAME] should be compared to either G5 or H5 but not both, to avoid duplicate counting.
Spreadsheet: 784486d1655759286-pull-associated-value-from-hierachical-tree-using-formula-2022-06-20-oeldere-mancolt-genus-species-data
Sheet: Blad1

Pelecaniformes |  |  | Pelecaniformes
Aelecaniformes |  |  | Threskiomithidae
Belecaniformes |  |  | Geronticus
 |  |  | Geronticus eremita | Pelecaniformes | Threskiomithidae | Geronticus
 |  |  | Geronticus calvus | Pelecaniformes | Threskiomithidae | Geronticus
 |  |  | Bostrychia
 |  |  | Bostrychia olivacea | Pelecaniformes | Threskiomithidae | Bostrychia
 |  |  | Bostrychia bocagei | Pelecaniformes | Threskiomithidae | Bostrychia
 |  |  | Bostrychia rara | Pelecaniformes | Threskiomithidae | Bostrychia
 |  |  | Bostrychia hagedash | Pelecaniformes | Threskiomithidae | Bostrychia
 |  |  | Bostrychia carunculata | Pelecaniformes | Threskiomithidae | Bostrychia
 |  |  | Theristicus
 |  |  | Theristicus caerulescens | Pelecaniformes | Threskiomithidae | Theristicus
 |  |  | Theristicus caudatus | Pelecaniformes | Threskiomithidae | Theristicus
 |  |  | Theristicus melanopis | Pelecaniformes | Threskiomithidae | Theristicus
 |  |  | Aelecaniformes
 |  |  | Ahreskiomithidae
 |  |  | Aeronticus
 |  |  | aeronticus eremita
 |  |  | aeronticus calvus
Spreadsheet: 148917d1333616727-kindof-h-v-lookup-with-multiple-values-character-fun
Sheet: ITEM LIST

 | Bread | Water | Plant | Chicken | Stone | Gem | Wood | Bottle | Fish | CHECK
[NAME] | 1 |  |  | 2 |  | 1
Collin |  | 7 |  |  |  |  |  | 3
[NAME] |  |  |  | 12
[NAME] |  | 7 | 2 |  |  |  | 3
Victor |  | 4 |  |  |  | 4
[NAME] | 8 | 2 |  | 6 | 5
Cat |  |  |  | 6 | 4 |  |  |  | 78
Spreadsheet: 2a1b4976-9cbb-4f70-83e7-4fea0b2d199a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
รายละเอียดการโอนค่าน้ำประปาให้สำนักงาน/สาขา /ส่วนแยก/อำเภอ เมื่อวันที่ 13 กันยายน 2555
ชื่อ - นามสกุล | [NAME] | จำนวนเงิน
สำนักงานที่ดินจังหวัด สาขาหาดใหญ่ | 936-0-02492-9 | 2606.61
สำนักงานที่ดินจังหวัดสงขลา ส่วนแยกคอหงส์ | 902-0-33529-4 | 689.92
สำนักงานที่ดินจังหวัดสงขลา สาขาสทิงพระ | 923-1-27072-9 | 150
สำนักงานที่ดินจังหวัดสงขลา สาขาระโนด | 923-0-03731-1 | 645.04
สำนักงานที่ดินจังหวัดสงขลา สาขานาทวี | 928-0-05338-8 | 874.32
สำนักงานที่ดินจังหวัดสงขลา สาขารัตภูมิ | 368-1-13299-2 | 115
นางเนตรอนงค์  จันทร์ดวง | 901-1-46035-9 | 1104.78
นางสาวธัญชนก  นวลศรี | 901-0-76806-6 | 180
นายศิวโรจน์   วัชรอดิศัย | 901-1-42189-2 | 15
นายพงษ์ศักดิ์  จันทรักษ์ | 901-1-88238-5 | 280
Spreadsheet: 682995d1592417740-what-is-the-best-formula-book2
Sheet: LIA - Jan - Leader In Action - 

Week Ending | 1 | 2 | 3 | 4 | Total Points
Week 1 |  |  |  | 0
Week 2 |  |  |  | 0
Week 3 |  |  |  | 0
Week 4 |  |  |  | 0
TOTAL
 | If any of these Totals equal 0; we want F7 to 0 in red. | If none equal zero, total B7:E7 in F7
Spreadsheet: 772705d1647439082-excel-formula-consolidate-data-in-columns-and-create-new-rows-two-criteria-test-workbook
Sheet: Sheet1

Value | Amount | Type | Type C? |  | Distinct Values | Sum Of |  | "Distinct" Values | Sum Of |  | Option 1 (using helper in D) |  |  | Option 2 (helper in P)
1 | 12 | A9014 |  |  |  |  |  | 1 | 123.5 |  |  | 123.5 |  |  | 0
1 | 44.5 | B2435 |  |  |  |  |  | 2 | 85 |  | 2 | 85 |  | 2 | 0
1 | 45 | A |  |  |  |  |  | 3 | 82.25 |  | 3 | 82.25 |  | 3 | 0
1 | 17 | A |  |  |  |  |  | 4 | 134.75 |  | 4 | 134.75 |  | 4 | 0
2 | 21 | A |  |  |  |  |  | 1 | 72.5 |  | 1 | 72.5 |  | 1 | 1
2 | 1 | A |  |  |  |  |  | 3 | 32.5 |  | 3 | 32.5 |  | 3 | 1
1 | 13 | C127 |  |  |  |  |  | 4 | 3 |  | 4 | 3 |  | 4 | 1
1 | 15.5 | C3453
1 | 17 | C
3 | 82.25 | A
3 | 0.5 | C |  |  | Currently ^ |  |  | What I want ^
1 | 27 | C
3 | 13 | C
3 | 19 | C
4 | 3 | C
1 | 5 | A
4 | 55 | A
2 | 63 | A
4 | 79.75 | A
Spreadsheet: 184613d1349324954-of-accumulated-sub-total-in-pivot-table-pivot-sample
Sheet: Data

Month | Branch | Item | Sold out
2012-01-01 00:00:00 | Singapore | Apple | 85
2012-01-01 00:00:00 | Singapore | Orange | 224
2012-01-01 00:00:00 | Singapore | Lemon | 362
2012-01-01 00:00:00 | Hong Kong | Apple | 476
2012-01-01 00:00:00 | Hong Kong | Orange | 72
2012-01-01 00:00:00 | Hong Kong | Lemon | 228
2012-01-01 00:00:00 | Taiwan | Apple | 67
2012-01-01 00:00:00 | Taiwan | Orange | 148
2012-01-01 00:00:00 | Taiwan | Lemon | 397
2012-02-01 00:00:00 | Singapore | Apple | 174
2012-02-01 00:00:00 | Singapore | Orange | 56
2012-02-01 00:00:00 | Singapore | Lemon | 338
2012-02-01 00:00:00 | Hong Kong | Apple | 242
2012-02-01 00:00:00 | Hong Kong | Orange | 241
2012-02-01 00:00:00 | Hong Kong | Lemon | 307
2012-02-01 00:00:00 | Taiwan | Apple | 315
2012-02-01 00:00:00 | Taiwan | Orange | 61
2012-02-01 00:00:00 | Taiwan | Lemon | 127
2012-03-01 00:00:00 | Singapore | Apple | 343
2012-03-01 00:00:00 | Singapore | Orange | 240
2012-03-01 00:00:00 | Singapore | Lemon | 117
2012-03-01 00:00:00 | Hong Kong | Apple | 15
2012-03-01 00:00:00 | Hong Kong | Orange | 186
2012-03-01 00:00:00 | Hong Kong | Lemon | 339
2012-03-01 00:00:00 | Taiwan | Apple | 449
2012-03-01 00:00:00 | Taiwan | Orange | 268
2012-03-01 00:00:00 | Taiwan | Lemon | 477
2012-04-01 00:00:00 | Singapore | Apple | 340
2012-04-01 00:00:00 | Singapore | Orange | 449
2012-04-01 00:00:00 | Singapore | Lemon | 175
2012-04-01 00:00:00 | Hong Kong | Apple | 305
2012-04-01 00:00:00 | Hong Kong | Orange | 229
2012-04-01 00:00:00 | Hong Kong | Lemon | 397
2012-04-01 00:00:00 | Taiwan | Apple | 118
2012-04-01 00:00:00 | Taiwan | Orange | 137
2012-04-01 00:00:00 | Taiwan | Lemon | 17
2012-05-01 00:00:00 | Singapore | Apple | 359
2012-05-01 00:00:00 | Singapore | Orange | 188
2012-05-01 00:00:00 | Singapore | Lemon | 153
2012-05-01 00:00:00 | Hong Kong | Apple | 377
2012-05-01 00:00:00 | Hong Kong | Orange | 372
2012-05-01 00:00:00 | Hong Kong | Lemon | 363
2012-05-01 00:00:00 | Taiwan | Apple | 57
2012-05-01 00:00:00 | Taiwan | Orange | 93
2012-05-01 00:00:00 | Taiwan | Lemon | 322
2012-06-01 00:00:00 | Singapore | Apple | 385
2012-06-01 00:00:00 | Singapore | Orange | 245
2012-06-01 00:00:00 | Singapore | Lemon | 242
2012-06-01 00:00:00 | Hong Kong | Apple | 289
2012-06-01 00:00:00 | Hong Kong | Orange | 222
2012-06-01 00:00:00 | Hong Kong | Lemon | 46
2012-06-01 00:00:00 | Taiwan | Apple | 3
2012-06-01 00:00:00 | Taiwan | Orange | 165
2012-06-01 00:00:00 | Taiwan | Lemon | 444
Spreadsheet: theresa_staab__39600__Independent email
Sheet: Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Independent Production Company, Inc.
 |  |  |  |  | Bank: U.S. Bank National Association
 |  |  |  |  | ABA:  102000021 | Due Date:
 |  |  |  |  | Acct:  [PHONE] | 2001-12-26 00:00:00
 |  |  |  |  | Contact:  [NAME]
 |  |  |  |  | Tel:  (303) 595-8829 X27 | Payment Method:
 |  | Contact:  [NAME] |  |  |  | Wire
 |  | Tel:  (303) 575-6485 |  |  |  | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (303) 595-3653 | 25th of month following production
Delivery Period: | Contract # | Meter # / Meter Name
 | 96023736 | 0814015-Independent 47N73WSec.9
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
11/01/01 - 11/30/01 | CIG GD
 | IF NGPL-Midcont.
 | IF CIG - Rockies
 |  | Fuel Loss | $             0.00 |  |  | $                                        0.00
Total
 | Hanover Compression Charges |  |  |  |  | 0
 | Field Services Fee |  |  |  |  | -15000
Prior Month Adjustments
 |  |  |  |  | Adjustment
 |  |  | TOTAL PAYMENT
Spreadsheet: 877735d1724593724-help-please-neryoneil-mio-audit-pnc-1-2016-aligw
Sheet: GP NOT POSTED

Batch Number | Voucher Number | Vendor ID | [NAME] | Document Type | Document Date | Document Number | Document Amount | Shipping Method | Voucher | GP NOT POSTED VENDOID | PNC Vendor number | GP NOT POSTED Doc Number value2 | PNC Inv number2 | Check | [NAME] | Check2 | APA Inv date | Check3 | [NAME] | Check4 | Check5 | Check6 | Comments |  | Checked
 | VCH0000000241347 | 03310 |  | Invoice | 2024-06-01 00:00:00 | MI18153 | 108.74
 | VCH0000000241348 | 03310 |  | Invoice | 2024-06-15 00:00:00 | MI18943 | 87.87
 | [NAME] | 03310 |  | Invoice | 2024-08-10 00:00:00 | MI21459 | 514.81
082124NO-01 | VCH0000000241350 | 00304 |  | Invoice | 2024-04-01 00:00:00 | [PHONE] | 1879.19
082124NO-01 | VCH0000000241351 | 00304 |  | Invoice | 2024-08-11 00:00:00 | [PHONE] | 988.95
082124NO-01 | VCH0000000241352 | 01433 | [NAME] CONTROLS | Invoice | 2024-03-22 00:00:00 | 24035649 | 606
082124NO-01 | VCH0000000241353 | 02102 | ITW GSE INC | Invoice | 2024-05-30 00:00:00 | 112181 | 5017.89 | DELIVERY
082124NO-01 | VCH0000000241354 | 02102 | ITW GSE INC | Invoice | 2024-08-08 00:00:00 | 113724 | 3209.4 | DELIVERY
082324NO-01 | VCH0000000241464 | 02261 | MAVICH LLC | Credit  Memo | 2024-08-01 00:00:00 | [PHONE] | 21.27
082324NO-01 | VCH0000000241465 | 02261 | MAVICH LLC | Credit  Memo | 2024-08-13 00:00:00 | [PHONE] | 68.14
Spreadsheet: 0082ef6c-2d1a-421e-927d-33a4a3bccb52
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
2014 Region III Boys ODP
State Team Information/Payment Voucher
State:
 |  |  |  | Cost |  | Total |  | Combined
97's | Number of Players |  | 0 | 500 | = | 0 | 97's | 0
 | Number of Staff |  | 0 | 475 | = | 0
98's | Number of Players |  | 0 | 500 | = | 0 | 98's | 0
 | Number of Staff |  | 0 | 475 | = | 0
99's | Number of Players |  | 0 | 500 | = | 0 | 99's | 0
 | Number of Staff |  | 0 | 475 | = | 0
00's | Number of Players |  | 0 | 500 | = | 0 | 00's | 0
 | Number of Staff |  | 0 | 475 | = | 0
01's | Number of Players |  | 0 | 500 | = | 0 | 01's | 0
 | Number of Staff |  | 0 | 475 | = | 0
* these numbers represent all individuals staying on campus at BODP trials
 | Check # |  |  |  |  | Total check |  | 0
This form and the check made payable to: US Youth Region III ODP                                                                             MUST BE SENT No later than June 16, 2014.
US Youth Soccer, Region III ODP, 9220 World Cup Way, Frisco, TX  75035 Attn: J Parker
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Essex-Genesis

 |  |  | 2014 Essex & Genesis F.E.  Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | 2nd & 4th Fridays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 113648d1309472804-return-a-value-if-the-date-lands-between-a-row-of-dates-example-modiifed-
Sheet: Sheet1

 | 2011-06-10 00:00:00
 | Quarter Ending |  |  |  |  |  |  |  |  |  | Original Credit Facility
 | Deals |  | Sale Date | $ [NAME] | $ [NAME] |  |  |  |  |  | $ [NAME]
 |  |  | 2011-06-10 00:00:00 | -20064 |  |  |  |  |  |  | 0
 |  |  | 2011-06-17 00:00:00 | -2483317 |  |  |  |  |  |  | 0
 |  |  | 2011-06-21 00:00:00 | -4836244 |  |  |  |  |  |  | 0
 |  |  | 2011-06-28 00:00:00 | -27171663 |  |  |  |  |  |  | 17957383
 |  |  | 2011-06-28 00:00:00 | -1204151 |  |  |  |  |  |  | 0
 |  |  | 2011-06-29 00:00:00 | -45808783 |  |  |  |  |  |  | 0
 |  |  | 2011-06-30 00:00:00 | -1660345 |  |  |  |  |  |  | 0
 |  |  | 2011-06-30 00:00:00 | -4028624 |  |  |  |  |  |  | 0
 |  |  | 2011-09-30 00:00:00 | -48773962 |  |  |  |  |  |  | 32177509
 |  |  | 2011-09-30 00:00:00 | -49746371 |  |  |  |  |  |  | 32985923
 |  |  | 2011-09-30 00:00:00 | -16742802 |  |  |  |  |  |  | 11046110
 |  |  | 2011-12-31 00:00:00 | -58782010 |  |  |  |  |  |  | 39022519
 |  |  | 2011-12-31 00:00:00 | -40721455 |  |  |  |  |  |  | 26836679
 |  |  | 2011-12-31 00:00:00 | -23544777 |  |  |  |  |  |  | 15618285
 |  |  | 2012-03-31 00:00:00 | -28037507 |  |  |  |  |  |  | 18692906
 |  |  | 2012-03-31 00:00:00 | -41877124 |  |  |  |  |  |  | 27797498
 |  |  | 2012-06-30 00:00:00 | -43831256 |  |  |  |  |  |  | 29129393
 |  |  | 2012-06-30 00:00:00 | -28583651 |  |  |  |  |  |  | 0
 |  |  | 2011-09-30 00:00:00 | -7073596 |  |  |  |  |  |  | 0
 |  |  | 2011-09-30 00:00:00 | -28251425 |  |  |  |  |  |  | 0
 |  |  | 2012-03-31 00:00:00 | -13954467 |  |  |  |  |  |  | 0
 |  |  | 2011-12-31 00:00:00 | -19724426 |  |  |  |  |  |  | 0
 |  |  | 2011-03-31 00:00:00 | -18942505 |  |  |  |  |  |  | 0
 |  |  | 2011-09-30 00:00:00 | -20486002 |  |  |  |  |  |  | 0
 |  |  | 2011-12-31 00:00:00 | -32305939 |  |  |  |  |  |  | 0
 |  |  | 2011-09-30 00:00:00 | -17566565 |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | Total Distributions End of Period
Spreadsheet: 480771d1474047457-sorting-letters-before-numbers-book4
Sheet: Sheet1

X | Lv 1 | Lv2
85315-06140
85315-06220
85315-0R030
85315-47060
85315-47140
85315-52440
85315-60390
85315-AA040
88710-04171
88710-0C090
SU003-05810
SU003-05811
Spreadsheet: 300229d1393420113-search-multiple-criteria-for-corresponding-data-excel-help
Sheet: Feuil1

 | Database
 | M | E | I&C | Equip
 | m3 | ee1 | nc |  |  | I would like a formula to identifying all the cells of column E that corresponds with criteria in B3, [NAME] and D3. Thank you very much.
 | M level | E level | I&C level | Code
 | m1 | H | - | r2
 | nc | ee1 | - | r1
 | nc | EE1 | E1B | r3
 | NC | d2 | - | RA
 | - | - | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | NC | - | - | RA
 | - | - | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | NC | - | - | RA
 | m3 | ee1 | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | NC | - | - | RA
 | - | - | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | m3 | ee1 | NC | RA
 | - | - | NC | RA6
 | NC | - | - | BH
 | NC | - | - | RA
 | - | - | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | NC | - | - | RA
 | - | - | NC | RA4
 | - | - | NC | RA6
 | - | NC | NC | RAM
 | - | - | - | yy
 | - | - | - | yy
 | - | EE2 | E2 | yy
 | NC | - | - | SD
 | m3 | ee1 | NC | MPL
 | NC | - | - | SD
 | NC | - | - | MPL
 | m3 | ee1 | NC | SD
 | NC | - | - | MPL
 | NC | - | - | SD
 | NC | - | - | MPL
 | NC | - | - | SD
Spreadsheet: 468217d1467187528-choose-content-column-based-on-row-filling-hotel_test
Sheet: Sheet1

Hotels
Hotel A |  |  | Hotel B |  |  | Hotel C
Adult | Child | Infant | Adult | Child | Infant | Adult | Child | Infant | Inv Hotel
 |  |  | 1 | 0 | 0 |  |  |  | Hotel B
2 | 0 | 0 |  |  |  |  |  |  | Hotel A
 |  |  |  |  |  | 1 | 1 | 0 | Hotel C
3 | 1 | 1 |  |  |  |  |  |  | Hotel A
 |  |  | 2 | 0 | 0 |  |  |  | Hotel B
Spreadsheet: 169033d1342687889-excel-2007-finding-minimum-between-2-variable-date-ranges-min-between-2-variable-dates
Sheet: Sheet1

date | value
7/18/2012 | 2028.0001
7/17/2012 | 1999.5001
7/16/2012 | 2021.9999
7/13/2012 | 2045.0001
7/12/2012 | 2010
7/11/2012 | 2055.5
7/10/2012 | 2059
7/9/2012 | 2042.4999
7/6/2012 | 2104
7/5/2012 | 2163
7/4/2012 | 2140
7/3/2012 | 2154.5
7/2/2012 | 2109
6/29/2012 | 2088.5
6/28/2012 | 2039 |  |  |  |  |  | 2039 | <<formula required to return minimum value from column B for date range between 2 "CROSS" indicators in column G
6/27/2012 | 2040.5001
6/26/2012 | 2041.5001
6/25/2012 | 2009.4999
6/22/2012 | 2065.5
6/21/2012 | 2101
6/20/2012 | 2215
6/19/2012 | 2170
6/18/2012 | 2128.5
6/15/2012 | 2130
6/14/2012 | 2092
6/13/2012 | 2131.5
6/12/2012 | 2096
6/11/2012 | 2069.5
6/8/2012 | 2074
6/7/2012 | 2133
6/6/2012 | 2091
6/1/2012 | 1955.5 |  |  |  |  |  | 1955.5 | <<formula required to return minimum value from column B for date range between 2 "CROSS" indicators in column G
5/31/2012 | 1970.9999
5/30/2012 | 1983.4999 |  |  |  |  |  | 1983.5 | <<formula required to return minimum value from column B for date range between 2 "CROSS" indicators in column G
5/29/2012 | 2058
5/28/2012 | 2017
5/25/2012 | 2001
5/24/2012 | 2026
5/23/2012 | 2005.5
5/22/2012 | 2087.5
5/21/2012 | 2024
5/18/2012 | 2019
5/17/2012 | 2045.9999
5/16/2012 | 2089.5
5/15/2012 | 2085.5
5/14/2012 | 2119
5/11/2012 | 2187
5/10/2012 | 2186
5/9/2012 | 2178.5
5/8/2012 | 2172.5
5/4/2012 | 2263
5/3/2012 | 2365 | 2365 | 2365 | -33.59 | 15.52