tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124722d1318567575-insert-and-remove-data-automatically-with-the-date-insert-and-remove-data-automatically-with-the-date-
Sheet: Φύλλο1

october | MONDAY | TUESDAY | WEDNESDAY | Thursday | Friday | Saturday | Sunday | MONDAY | TUESDAY | WEDNESDAY | Thursday | Friday | Saturday
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
anna | ΑΑ | ΑΑ | ΑΑ | ΑΑ | ΑΑ
george |  |  |  | ΑΔ | ΑΔ | ΑΔ |  |  | ΑΔ | ΑΔ | ΑΔ
petros |  |  |  |  |  |  |  |  |  |  |  |  | ΚΜ
 |  |  |  |  |  |  |  |  | george | 2011-09-10 00:00:00 | 3 | ΑΔ | 2011-11-10 00:00:00
Spreadsheet: 52581d1252438836-conditional-format-range-based-on-date-samplecf
Sheet: Holidays

Company Holidays |  |  | 2010
New Year's Day | 1st Day in January | 2011-01-01 00:00:00
Memorial Day | Last Monday in May | 2011-05-31 00:00:00
Independence Day | 4th Day of July | 2010-07-04 00:00:00
Labor Day | 1st Monday in September | 2010-09-06 00:00:00
Thanksgiving Day | 4thThursday in November | 2010-11-25 00:00:00
Christmas Day | 25th Day of December | 2010-12-25 00:00:00
Spreadsheet: 856612d1705807077-match-and-extract-lambda-map-filter-extract_3
Sheet: L3

 |  |  |  |  | Match |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Extract >> | <<< Extract >> |  |  | <<< Extract >>
 |  |  |  |  | B-1/2/3 | fsf | vfsdfs | gdsf | dfgsd | fas | sfasdf | afs | asdfeas | fasdf | asdf | asdf | dasf | asdf | asdf |  |  |  |  |  |  | x | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-2/5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | x | x | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | x | x | 0
 |  |  |  |  | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | x | x | 0
 |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0
 |  |  |  |  | S-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0
 |  |  |  |  | ab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0
Spreadsheet: eric_saibi__9916__102601
Sheet: Beckjord 01&02

Owner Name |  | Cinergy Corporation
Station Name |  | [NAME]
Unit Name |  | Beckjord 01&02
NERC Region |  | ECAR
State |  | OH
Fuel Type |  | Coal
Capacity |  | 100 MW 01&100 MW 02
Start Date |  | 2001-10-26 00:00:00
End Date |  | 2001-10-29 00:00:00
Comments |  | These two units are online, but running at reduced capacity 30% due to bad coal that is not burning as efficiently as normal. Should have problem resolved by Mon.
SIC |  | 4911
Plant ID |  | 1013762
Unit ID |  | 01-1003870, 02-1003871
Outage ID
Spreadsheet: 37744d1235755780-how-to-link-different-dropdown-lists-example-1
Sheet: Sheet1

Teams | Doncaster | Sheffield | Rotherham | Barnsley | Force |  | Pick Team | Pick Code
Doncaster | A | AB | ABA | BB | A |  | Doncaster | AB
Sheffield | B | AC | ABB | CC | B
Rotherham | C | AD | ABC | DD | C
Barnsley | D | AE | ABD | EE | D
Force | E | AF | ABE | FF | E
 | F | AG |  | GG | F
 | G | AH |  | HH | G
 | H | AI |  |  | H
 | I | AJ |  |  | I
 | J | AK |  |  | J
 |  | AL |  |  | AB
 |  | AM |  |  | AC
 |  | AN |  |  | AD
 |  | AO |  |  | AE
 |  | AP |  |  | AF
 |  | AQ |  |  | AG
 |  | AR |  |  | AH
 |  | AS |  |  | AI
 |  | AT |  |  | AJ
 |  | AU |  |  | AK
 |  |  |  |  | AL
 |  |  |  |  | AM
 |  |  |  |  | AN
 |  |  |  |  | AO
 |  |  |  |  | AP
 |  |  |  |  | AQ
 |  |  |  |  | AR
 |  |  |  |  | AS
 |  |  |  |  | AT
 |  |  |  |  | AU
 |  |  |  |  | ABA
 |  |  |  |  | ABB
 |  |  |  |  | ABC
 |  |  |  |  | ABD
 |  |  |  |  | ABE
 |  |  |  |  | BB
 |  |  |  |  | CC
 |  |  |  |  | DD
 |  |  |  |  | EE
 |  |  |  |  | FF
 |  |  |  |  | GG
 |  |  |  |  | HH
Spreadsheet: 707010d1606999774-how-to-find-the-column-with-the-max-value-and-return-the-column-title-find-max-value-return-column-title
Sheet: Sheet1

 |  |  | A | B | C | D | MAX
 |  |  | 0 | 0 | 1 | 2 | D
 |  |  | 2 | 0 | 0 | 1 | A
 |  |  | 0 | 1 | 0 | 2 | D
Spreadsheet: 690160d1596903119-unique-list-of-entries-sample-49-ans2
Sheet: Sheet2

 | PO | 45
 |  | Descriptions |  |  |  |  |  | Qty | Unit | Rate | Amount |  |  |  | Helper
 |  | Product | Make | Size | Code no | Shade | Thickness
Spreadsheet: 682103d1591901615-how-to-assign-dates-by-date-range-example
Sheet: Time Details

Employee | Date | Date Range
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-06-01 00:00:00
[NAME] | 2020-06-01 00:00:00
[NAME] | 2020-06-02 00:00:00
[NAME] | 2020-06-02 00:00:00
[NAME] | 2020-06-03 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-24 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-26 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-27 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-28 00:00:00
[NAME] | 2020-05-29 00:00:00
[NAME] | 2020-05-29 00:00:00
Spreadsheet: acf67ab7-4a47-4f01-a846-4cfd2ad1068f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FRFSF | Test | FRFSF | Rheumatoid Factor, LA, Synovial Fluid | Rheumatoid Factor, Synovial Fluid | Latex Agglutination |  |  |  |  |  | Send 1 mL synovial fluid refrigerated in a plastic vial. | 1 mL | Hemolysis:	NA Thawing:	Cold OK, Warm reject Lipemia:	NA Icterus:	NA Other:	Fluids other than Synovial | Reference Range: <1:5  Interpretive Criteria:	<1:5 Rheumatoid factor not detected > or = 1:5 Rheumatoid factor detected  Test Performed by:	Focus Diagnostics, Inc. 			5785 Corporate Avenue 			Cypress, CA 90630-4750 | Monday through Friday | 1 - 4 days | 3 - 9 days | 1 | 86431 |  |  |  |  | Focus Diagnositics, Inc.
FRFSF | [NAME] | SYNOVIAL | Synovial Fluid |  |  |  | Refrigerated | 14 days
FRFSF | Result | Z3065 | RF, LA, Synovial Fluid | RF, LA, Synovial Fluid | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 848080d1698876039-extract-and-separate-text-split_data
Sheet: Sheet1

 | 5 Happy Soul | 8/1 b |  |  | 5 Happy Soul | 8/1
 | 11 Watch This [NAME] 12/1 | L |  |  | 11 Watch This [NAME] | 12/1
 | 4 Music Festival 10/1 | L |  |  | 4 Music Festival | 10/1
 | 12 Perfect Prankster | 15/1 |  |  | 12 Perfect Prankster | 15/1
 | 7 Workislife 20/1 |  |  |  | 7 Workislife | 20/1
 | 13 Take Time to Dream 3/1 L |  |  |  | 13 Take Time to Dream | 3/1
 | 3 Icicles 6/1 Lb |  |  |  | 3 Icicles | 6/1
 | 1 Crushed Ice 8/1 L |  |  |  | 1 Crushed Ice | 8/1
 | 2 Devil Blue Dress | 9/2 [NAME] |  |  | 2 Devil Blue Dress | 9/2
 | 6 Three Polks 4/1 L |  |  |  | 6 Three Polks | 4/1
 | 10 Honky Tonk Highway10/1 |  |  |  | 10 Honky Tonk Highway | 10/1
 | 9 Surf City | 8/1 |  |  | 9 Surf City | 8/1
 | 8 Let's Go Mark | 30/1È |  |  | 8 Let's Go Mark | 30/1
Spreadsheet: gerald_nemec__11509__011201 HPL
Sheet: Injection Report

ENRON
 | CORP |  |  |  |  |  |  | Interoffice
 |  |  |  |  |  |  |  | Memorandum
 | To: |  | CHARLIE THOMPSON
 | From: |  | BAMMEL OPERATOR |  |  |  |  | Deparatment: | BAMMEL
 | Subject: |  | WEEKLY [NAME] REPORT |  |  |  |  | Date: | 2001-01-11 00:00:00
 | 2001-01-05 00:00:00
 |  |  | MIN INJ | 0 |  | Net change | -660
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 419
 |  |  | MAX W/D | 1166
 |  |  | MIN INJ | 0 |  | Net change | -627
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 499
 |  |  | MAX W/D | 891
 |  |  | MIN INJ | 0 |  | Net change | -305
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 123
 |  |  | MAX W/D | 843
 |  |  | MIN INJ | 0 |  | Net change | -344
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 227
 |  |  | MAX W/D | 373
 |  |  | MIN INJ | 0 |  | Net change | -481
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 206
 |  |  | MAX W/D | 633
 |  |  | MIN INJ | 0 |  | Net change | -383
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 233
 |  |  | MAX W/D | 842
 |  |  | MIN INJ | 0 |  | Net change | -454
 |  |  | MAX INJ | 0
 |  |  | MIN W/D | 317
 |  |  | MAX W/D | 584
 |  |  |  | Total Net Reservoir Change
 |  |  |  |  | GIP |  | 82.5 | BCF
Spreadsheet: 790758d1659978608-calculate-number-of-occurences-based-on-range-of-days-entered-example-attendance-tracker
Sheet: List of Employees

 | List of Employees
 | Employee Names | Role | Team Lead
 | Agent 1 | Agent
 | Agent 2 | Agent
 | Agent 3 | Sr. Agent
 | Agent 4 | Sr. Agent
 | Agent 5 | Agent
 | Agent 6 | Agent
 | Agent 7 | Sr. Agent
 | Agent 8 | Agent
 | Agent 9 | Sr. Agent
 | Agent 10 | Sr. Agent
 | Agent 11 | Sr. Agent
 | Agent 12 | Sr. Agent
 | Agent 13 | Agent
 | Agent 14 | Agent
 | Agent 15 | Agent
 | Agent 16 | Agent
 | Agent 17 | Agent
 | Agent 18 | Agent
 | Agent 19 | Agent
 | Agent 20 | Agent
 | Agent 21 | Agent
 | Agent 22 | Agent
 | Agent 23 | Sr. Agent
 | Agent 24 | Agent
 | Agent 25 | Agent
 | Agent 26 | Agent
 | Agent 27 | Agent
 | Agent 28 | Agent
 | Agent 29 | Agent
 | Agent 30 | Sr. Agent
 | Agent 31 | Agent
 | Agent 32 | Sr. Agent
 | Agent 33 | Agent
 | Agent 34 | Agent
 | Agent 35 | Sr. Agent
 | Agent 36 | Agent
 | Agent 37 | Agent
 | Agent 38 | Sr. Agent
 | Agent 39 | Agent
 | Agent 40 | Agent
 | Agent 41 | Sr. Agent
 | Agent 42 | Agent
 | Agent 43 | Sr. Agent
 | Agent 44 | Agent
 | Agent 45 | Agent
 | Agent 46 | Agent
 | Agent 47 | Agent
 | Agent 48 | Sr. Agent
 | Agent 49 | Sr. Agent
 | Agent 50 | Agent
 | Agent 51 | Agent
 | Agent 52 | Agent
 | Agent 53 | Sr. Agent
 | Agent 54 | Agent
 | Agent 55 | Agent
 | Agent 56 | Agent
 | Agent 57 | Agent
Spreadsheet: ac12cc5b-5a59-45ab-9d26-8cb47fa43e96
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | TRAIL'S END POPCORN SALE | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  | FALL 2012 |  |  |  |  |  |  |  | SHOW & SELL / SHOW & DELIVER SALE(S) ORDER FORM
 |  |  | SHOW & SELL / SHOW & DELIVER SALE(S) ORDER FORM
PRICE PER ITEM | ITEMS PER CASE | ITEM | CASE PRICE | TOTAL CASES ORDERED |  |  |  | TOTAL ITEMS RETURNED
40 | 1 | Sweet and Savory Collection | 40 | ________     Case(s) |  |  |  | ________      Item(s)
30 | 1 | Cheese Lover's Collection | 30 | ________     Case(s) |  |  |  | ________      Item(s)
25 | 8 | White Chocolatey Pretzels Tin | 200 | ________     Case(s) |  |  |  | ________      Item(s)
22 | 6 | 18 Pack - Kettle Corn | 132 | ________     Case(s) |  |  |  | ________      Item(s)
19 | 6 | 18 Pack - "Unbelievable Butter" | 114 | ________     Case(s) |  |  |  | ________      Item(s)
19 | 6 | 18 Pack - Butter Light | 114 | ________     Case(s) |  |  |  | ________      Item(s)
18 | 8 | [NAME] | 144 | ________     Case(s) |  |  |  | ________      Item(s)
18 | 8 | Caramel Corn with almonds, cashews and pecans. | 144 | ________     Case(s) |  |  |  | ________      Item(s)
18 | 8 | Butter Toffee Caramel corn | 144 | ________     Case(s) |  |  |  | ________      Item(s)
15 | 8 | Cheddar Cheese Corn | 120 | ________     Case(s) |  |  |  | ________      Item(s)
10 | 12 | Caramel Corn | 120 | ________     Case(s) |  |  |  | ________      Item(s)
PLEASE PRINT |  |  |  |  | Pack |  |  | FOR COUNCIL USE:
 |  |  |  |  | Troop |  |  | This unit has returned the popcorn indicated above.
Order placed by: _______________________________ |  |  |  |  | Team | # _____
 | Signature |  |  |  | Crew
Name : _____________________________________ |  |  |  |  | Post |  |  | _____________________
 |  |  |  |  |  |  |  | Signature
Phone #  : _______________________________________
 |  |  |  |  |  |  |  | _____________________
Address : _____________________________________ |  |  |  |  |  |  |  | Date
_____________________________________________
[NAME] address : _______________________________
DUE NO LATER THAN AUGUST 31, 2012
CASE ORDERS ONLY
 |  | This form may be FAXed to the Council Service and Training Center at (570)-207-1232.
Units may return Show and Sell popcorn early to the office for redistribution.  The Northeastern Pennsylvania Council reserves the right to adjust unit orders as needed. Units with a prior sales history may INITIALLY order popcorn product based on a 10% percent increase                                                                                                                                                 over last year’s actual Show and Sell product sales.   Units with no prior sales history may INITIALLY order popcorn based on $100 of product per registered [NAME]. Additional products will be available for sale in the event the unit runs short or out of product.
Spreadsheet: 115348d1310998974-transferring-results-and-drop-down-lists-hospitalformdata
Sheet: Input Tab 2011

 |  | HOSPITAL
 |  | NUMBER | HOSPITAL NAME |  |  |  |  | Result 1 | Result 2
 |  |  | . | ID # | DATE |  | Data 1 | 2010 | 2010 | Data 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMMENTS
 | 1 | 000001 | Hospital A | 11 | 2011-12-31 00:00:00 | Y
 | 2 | 000002 | Hospital B | 22 | 2011-12-31 00:00:00 | Y
 | 3 | 000003 | Hospital C | 33 | 2011-12-31 00:00:00
 | 4 | 000004 | Hospital D | 44 | 2011-12-31 00:00:00
 | 5 | 000005 | Hospital E | 55 | 2011-12-31 00:00:00 | Y
 | 6 | 000006 | Hospital F | 66 | 2011-12-31 00:00:00 | Y
Spreadsheet: 876750d1723482731-grouping-students-in-order-of-preference-sort-students-according-to-their-voting-preferences-in-groups-of-3
Sheet: Sheet2

Student | Preference 1 | Preference 2 | Preference 3 |  | Student Preference 1 | Student Preference 2 | Student Preference 3
Daphne Green | Tuesday 10-11:30 | Wednesday 10-11:30 | Friday 10-11:30
[NAME] | Wednesday 16-17:30 | Wednesday 10-11:30 | Wednesday 14-15:30 |  |  |  |  |  | Preferences in columns B, C and D
Sophie Boulder | Friday 10-11:30 | Thursday 16-17:30 | Wednesday 14-15:30
Student 04 | Wednesday 14-15:30 | Tuesday 16-17:30 | Friday 10-11:30 |  |  |  |  |  | 3 helper columns in F, G and H
Student 05 | Tuesday 16-17:30 | Friday 14-15:30 | Friday 14-15:30 |  |  |  |  |  | F2=TEXTJOIN(" ",TRUE,TRANSPOSE(SORT(TRANSPOSE($A2:B2))))
Student 06 | Friday 10-11:30 | Thursday 10-11:30 | Friday 14-15:30 |  |  |  |  |  | G2=TRIM(SUBSTITUTE(TEXTJOIN(" ",TRUE,TRANSPOSE(SORT(TRANSPOSE($A2:C2)))),B2,""))
Student 07 | Friday 14-15:30 | Tuesday 16-17:30 | Friday 10-11:30 |  |  |  |  |  | H2=TRIM(SUBSTITUTE(SUBSTITUTE(TEXTJOIN(" ",TRUE,TRANSPOSE(SORT(TRANSPOSE($A2:D2)))),B2,""),C2,""))
Student 08 | Tuesday 16-17:30 | Thursday 10-11:30 | Friday 14-15:30
Student 09 | Thursday 10-11:30 | Friday 14-15:30 | Friday 10-11:30 |  |  |  |  |  | Conditional formatting applies to range: =$[NAME]
Student 10 | Friday 10-11:30 | Wednesday 14-15:30 | Thursday 10-11:30 |  |  |  |  |  | CF formula 1 for direct matching: ==COUNTIFS(F$2:F$27,F2)>1
Student 11 | Wednesday 14-15:30 | Friday 10-11:30 | Friday 14-15:30 |  |  |  |  |  | CF formula 2 for indirect matching: ==COUNTIFS($F$2:$H$27,F2)>1
Student 12 | Friday 14-15:30 | Friday 10-11:30 | Friday 14-15:30
Student 13 | Friday 10-11:30 | Thursday 10-11:30 | Friday 14-15:30
Student 14 | Wednesday 14-15:30 | Thursday 10-11:30 | Thursday 14-15:30
Student 15 | Thursday 14-15:30 | Wednesday 14-15:30 | Thursday 10-11:30
Student 16 | Wednesday 14-15:30 | Thursday 10-11:30 | Thursday 14-15:30
Student 17 | Tuesday 16-17:30 | Friday 14-15:30 | Wednesday 14-15:30
Student 18 | Thursday 10-11:30 | Wednesday 14-15:30 | Thursday 14-15:30
Student 19 | Thursday 14-15:30 | Friday 10-11:30 | Tuesday 16-17:30
Student 20 | Friday 14-15:30 | Thursday 14-15:30 | Tuesday 10-11:30
Student 21 | Tuesday 10-11:30 | Tuesday 16-17:30 | Wednesday 14-15:30
Student 22 | Wednesday 14-15:30 | Friday 10-11:30 | Tuesday 10-11:30
Student 23 | Thursday 14-15:30 | Tuesday 10-11:30 | Friday 14-15:30
Student 24 | Tuesday 16-17:30 | Friday 14-15:30 | Wednesday 14-15:30
Student 25 | Friday 10-11:30 | Thursday 14-15:30 | Wednesday 14-15:30
Student 26 | Friday 14-15:30 | Thursday 14-15:30 | Wednesday 14-15:30
Sort students according to their voting preferences to work together
https://www.excelforum.com/excel-general/1402352-trying-to-sort-students-according-to-their-voting-preferences-to-work-together.html
 | Timetable
 | Tuesday 10-11:30 | Wednesday 10-11:30 | Thursday 10-11:30 | Friday 10-11:30
 | Tuesday 14-15:30 | Wednesday 14-15:30 | Thursday 14-15:30 | Friday 14-15:30
 | Tuesday 16-17:30 | Wednseday 16-17:30 | Thursday 16:17:30
Spreadsheet: 224485d1364582468-automatic-updating-list-of-current-members-from-table-of-all-time-members-pandora-level-tracker
Sheet: Apr 2013

 | Unique | Name Of | Member | Merit And Levels |  |  |  |  |  |  |  |  |  | Miscellaneous |  |  |  |  |  | Class Count
 | Identifier | Member | Class | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Notes
 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Class
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Assassin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Barbarian
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Blademaster
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Cleric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Mystic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Psychic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Seeker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Venomancer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Wizard
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Total Members
Spreadsheet: 791417d1660328551-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Budget

Expense | Allocated Cost | YTD Spent
Fuel | 2400 |  | <<-----
Cell
Cable | 2400
 |  |  |  | Feb
 |  |  |  | Mar
 |  |  |  | Apr
 |  |  |  | May
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
Spreadsheet: 216916d1361919729-problem-with-functional-argument-testworkbook
Sheet: sheet 2

 |  | Data Source |  |  |  | Compliance Test |  |  |  |  | Contact
Number | DoC | abc | JS | CORD A | CORD B | A | CORD | WA | DS | Location | Name | Phone | [NAME] | seq
A56Q9Z27LL654 | A56Q9Z2 | Yes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | a |  |  |  |  | The value in cell O4 should be "-" and I cannot figure out why the function isn't working.  Any suggestions?
A56Q9Z27LL730 | [NAME] | 0 | Yes | 0 | 0 | 0 | 0 | 0 | 0 | b | Palmer, [NAME] | 123 | ([EMAIL])
A56Q9Z27LL655 | A56Q9Z5 | No | No | Yes | 0 | 0 | 0 | 0 | 0 | q
Spreadsheet: edae582c-5c60-4e4a-b5b0-e80a3a152119
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40802335 | 2014-04-02 00:58:30 | ALLIES | 1 | 6 | 2 | 1236841 | bravo2zrow | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
40802446 | 2014-04-02 01:15:17 | AXIS | 0 | 2 | 6 | 1236841 | bravo2zrow | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
40844777 | 2014-04-05 00:31:38 | AXIS | 1 | 7 | 5 | 1541945 | Wonto | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40962351 | 2014-04-12 23:25:43 | ALLIES | 1 | 7 | 3 | 1341332 | WiffleWaffle | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40962546 | 2014-04-12 23:53:00 | AXIS | 0 | 3 | 7 | 1341332 | WiffleWaffle | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40962876 | 2014-04-13 00:18:08 | ALLIES | 0 | 5 | 6 | 27020 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40963140 | 2014-04-13 00:41:29 | AXIS | 1 | 6 | 4 | 27020 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40977309 | 2014-04-13 22:15:22 | ALLIES | 0 | 5 | 7 | 1542223 | guy.warmoes | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40977594 | 2014-04-13 22:35:35 | AXIS | 0 | 5 | 7 | 1542223 | guy.warmoes | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40977902 | 2014-04-13 22:51:35 | ALLIES | 0 | 4 | 7 | 1228328 | Woodrow Call | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40978122 | 2014-04-13 23:15:10 | AXIS | 0 | 6 | 7 | 1228328 | Woodrow Call | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 46730d1245673464-a-vlookup-problem-returning-multiple-matches-example-3
Sheet: Overview

Name | Date | Price
AKBM01 | 2009-06-19 00:00:00 | 80
AKBM01 | 2009-06-19 00:00:00 | 80
AKBM01 | 2009-06-19 00:00:00 | 81
AKBM01 | 2009-06-21 00:00:00 | 82
AKER01 | 2009-06-19 00:00:00 | 70
AKER01 | 2009-06-20 00:00:00 | 75
AKER02 | 2009-06-19 00:00:00 | 60
AKBM01 | 2009-06-22 00:00:00 | 83
AKBM01 | 2009-06-23 00:00:00 | 80
AKER01 | 2009-06-20 00:00:00 | 76
AKER02 | 2009-06-20 00:00:00 | 63