tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 229158d1366312024-how-to-copy-cell-formatting-and-forumulas-to-cells-when-number-is-entered-in-other-cell-start
Sheet: Sheet1

 |  | Set 1 (day/month/year) |  |  | Set 2 (day/month/year)
 |  |  | Average Score → |  |  | Average Score →
Name | Student ID | Total Questions=9 | Correct Answers | Score | Total Questions=5 | Correct Answers | Score
[NAME] | 1 |  | 2
[NAME] | 2 |  | 3
bob | 3 |  | 4
[NAME] | 4 |  | 5
jill | 5 |  | 6
[NAME] | 6 |  | 40
Spreadsheet: 453549d1459356903-rotating-roster-move-cell-down-based-on-date-rota-from-10-april-2016
Sheet: Rota

 | Rota from w/c Sunday 10 April
 | Line | [NAME] (10Apr) | Day, Duty and Times
 |  |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 | 1 | [NAME] | 0800 SP |  | 0800 - 1630 | 1 | 0700 PD SP |  | 0600 SP |  | 0800 - 1630 | 1 | OFF |  | OFF
 | 2 | [NAME] | OFF |  | OFF |  | 1000 - 1830 | 2 | 1000 - 1830 | 2 | Driving SPL |  | Driving SPL |  | 1000 - 1830 | 2
 | 3 | [NAME] | OFF |  | Driving SPL |  | 0800 - 1630 | 1 | OFF |  | 0700 PD SP |  | 0600 SP |  | 0830 - 1700 | 1
 | 4 | [NAME] | 0900 - 1730 | 1 | 0700 PD SP |  | OFF |  | 0700 PD SP |  | 1000 - 1830 | 2 | 0700 PD SP |  | OFF
 | 5 | [NAME] | OFF |  | 0600 SP |  | 0600 SP |  | 0800 - 1630 | 1 | 0600 SP |  | 0800 - 1630 | 1 | OFF
 | 6 | Danyelle | OFF |  | 1000 - 1830 | 2 | Driving SPL |  | Driving SPL |  | OFF |  | 1000 - 1830 | 2 | 0800 SP
 | Please coordinate breaks so that people are not all absent from posts at same period of time.
 | Rota allows for break of 42 minutes within duty (pay 7:48)
 |  |  |  |  |  |  |  |  |  |  | Planned Absences:
 | Duties:
 | 1
 | 1
 | 2
 | 1
 | 2
Spreadsheet: 94027d1293804590-moving-data-from-a-row-to-column-based-on-dup-example
Sheet: Sheet1

Company Name | Firstname1 | LastName1 | Firstname2 | Lastname2 | Firstname3 | Lastname3
Company A | [NAME] | Smith
Company A | [NAME] | [NAME]
Company A | [NAME] | [NAME]
Company B | [NAME] | [NAME]
Company B | [NAME] | Franks
Spreadsheet: 886100d1736108414-sales-sheet-if-command-example-sheet
Sheet: Sheet1

Wiktoria -  Booking Management Sheet
D2D |  |  |  | Yes |  |  |  | Umbrella
LT |  |  |  | No |  |  |  | PAYE
Line | Booking Type | Client Full Name | Candidate Full Name | Days | On Quba? | Job title | Which days worked? | Finish Date | Umbrella - PAYE | Pay | Charge |  | Total Pay | Total Charge | GM for week | Notes
W/E Friday 8-11 |  |  |  |  |  |  |  |  |  |  |  | Margin
1 | D2D | St Stephen School | [NAME] | 5 | Yes |  | M/T/W/T/F |  | Umbrella | 100 | 150
2 |  |  |  |  |  |  |  |  |  | 0 | 0
3 |  |  |  |  |  |  |  |  |  | 0 | 0
4 |  |  |  |  |  |  |  |  |  | 0 | 0
5 |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 484583d1476338333-could-please-help-me-on-one-of-excel-formula-excel-question
Sheet: Sheet1

 |  |  |  |  | NON-CATALOG | CATALOG | NON-CATALOG | NON-CATALOG | NON-CATALOG | CATALOG | NON-CATALOG | CATALOG
 |  |  | Last 6 WK |  | 42548 | 42555 | 42562 | 42569 | 42576 | 42583 | 42590 | 42597
 |  |  | CATALOG | NON-CATALOG | 42554 | 42561 | 42568 | 42575 | 42582 | 42589 | 42596 | 42603
Company | Product Class | Item No |  |  | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34
 |  |  |  |  | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016
 |  |  |  |  | 272016 | 282016 | 292016 | 302016 | 312016 | 322016 | 332016 | 342017
XYZ | AB | 1195
XYZ | Type G Restraints | 8005 |  |  | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 0
XYZ | Nursery Accessories | 1195 |  |  | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0
 |  |  |  |  |  | SUM(F9:ZP9)-SUM(F9:[NAME]:ZP9)-7))
Spreadsheet: 119567d1314573002-how-to-build-a-stacked-column-charts-with-secondary-y-axis-and-different-scale-book1
Sheet: Sheet1

date | up | down | down1
2011-08-29 00:00:00 | 396 | 0.001 | -0.001
2011-08-30 00:00:00 | 200 | 0.01 | -0.01
2011-08-31 00:00:00 | 205 | 0.015 | -0.015
2011-09-01 00:00:00 | 237 | 0.02 | -0.02
2011-09-02 00:00:00 | 313 | 0.025 | -0.025
2011-09-03 00:00:00 | 379 | 0.03 | -0.03
2011-09-04 00:00:00 | 394 | 0.035 | -0.035
2011-09-05 00:00:00 | 210 | 0.04 | -0.04
2011-09-06 00:00:00 | 366 | 0.045 | -0.045
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T29

Boeing Tour - AM |  |  |  |  | 2009-06-05 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 1

 | November 22 | November 29 | December 6 | December 13 | December 20
Total Interest Rate* | 333271155 | 328917440 | 330112957 | 370754708 | 368660208
Cleared** | 204094707 | 205021628 | 200134924 | 224495803 | 224410384
Uncleared | 129176448 | 123895812 | 129978033 | 146258905 | 144249824
Total Cross-Currency | 13516888 | 11709155 | 12146360 | 14183751 | 14012142
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 13516888 | 11709155 | 12146360 | 14183751 | 14012142
Total Credit | 9419352 | 9456107 | 9284295 | 9297635 | 8870927
Cleared | 2276704 | 2387796 | 2191267 | 2038936 | 2066271
Uncleared | 7142648 | 7068311 | 7093028 | 7258699 | 6804656
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 393777395 | 387652702 | 389113612 | 431806094 | 429113277
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Mar

 |  |  |  |  |  | CALENDAR MONTH | [NAME]
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 696398d1600793052-formula-to-match-based-on-date-with-debit-and-credit-amount-data
Sheet: Sheet1

Vendor ID | Document Type | Document Date | Document Number | Amount | Result
AJKL1 | Payment | 2018-02-20 00:00:00 | 300 | -180000 | -180000
AJKL1 | Invoice | 2018-03-31 00:00:00 | 100 | 234269.09 | Match
AJKL1 | Invoice | 2018-06-30 00:00:00 | 101 | 225265 | Match
AJKL1 | Credit note | 2018-09-12 00:00:00 | 201 | -4365.6 | Match
AJKL1 | Payment | 2019-02-01 00:00:00 | 301 | -183366.23 | Match
AJKL1 | Invoice | 2019-03-31 00:00:00 | 102 | 33.42 | Match
AJKL1 | Invoice | 2019-03-31 00:00:00 | 103 | 15532.21 | Match
AJKL1 | Return | 2019-05-03 00:00:00 | 401 | -2354 | Match
AJKL1 | Invoice | 2019-05-14 00:00:00 | 104 | 4590 | Match
AJKL1 | Payment | 2019-06-27 00:00:00 | 302 | -229500 | Match
AJKL1 | Credit note | 2019-10-31 00:00:00 | 202 | -40467.6 | Match
AJKL1 | Invoice | 2020-03-31 00:00:00 | 105 | 1084229.17 | 826487.6900000001
AJKL1 | Payment | 2020-05-27 00:00:00 | 303 | -43463.98 | Match
AJKL1 | Payment | 2020-05-27 00:00:00 | 304 | -78651 | Match
AJKL1 | Payment | 2020-07-20 00:00:00 | 305 | -119803.69 | Match
AJKL1 | Credit note | 2020-07-30 00:00:00 | 203 | -35459.1 | Match
AJKL1 | Invoice | 2020-08-31 00:00:00 | 106 | 3000 | 3000
NETINNUSINC001 | Invoice | 2018-10-08 00:00:00 | 108 | 21.6 | Match
NETINNUSINC001 | Invoice | 2019-06-12 00:00:00 | 124 | 32.65 | Match
NETINNUSINC001 | Credit Note | 2019-06-20 00:00:00 | 243 | -100 | -45.75
NETINNUSINC001 | Payment | 2019-06-22 00:00:00 | 341 | -25
NETINNUSINC001 | Invoice | 2019-07-11 00:00:00 | 129 | 315 | Match
NETINNUSINC001 | Invoice | 2020-06-08 00:00:00 | 145 | 4 | Match
NETINNUSINC001 | Payment | 2020-06-17 00:00:00 | 309 | -5112878.06 | -5112559.06
NBDOMINICA001 | Invoice | 2018-02-23 00:00:00 | 190 | 400 | 267
NBDOMINICA001 | Payment | 2018-10-03 00:00:00 | 317 | -133 | Match
NBDOMINICA001 | Invoice | 2019-10-08 00:00:00 | 145 | 206.43 | 206.43
NBDOMINICA001 | Invoice | 2020-01-08 00:00:00 | 189 | 432 | 432
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 4.2(LA) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(LA): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | LA - Liberal Arts
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 0 | 2 | 0 | 0
 |  | Part Time | 0 | 1 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 3 | 19 | 0 | 1
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 2 | 8 | 0 | 1
Bachelor's Degree |  |  | 0 | 1 | 0 | 0
 | [NAME]. graduates admitted to graduate school |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 1 | 0 | 0
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | m | m | m | m
Notes:
na = not offered; m = not tracked;
Spreadsheet: 882185d1730446161-generate-reports-for-students-in-a-school-reports-test
Sheet: Sheet2

 | Level Mark | Progress | Behaviour
 | 1 | is making excellent progress in Spanish this session. | He always behaves extremely well in class.
 | 2 | is making very good progress in Spanish this session. | He almost always behaves well in class.
 | 3 | is making good progress in Spanish this session. | He usually behaves well in class.
 | 4 | is making quite good progress in Spanish this session. | He behaves well in most classes.
 | 5 | is making some progress in Spanish this session. | Behaviour can be a concern at times.
 | 6 | is making limited progress in Spanish this session. | His behaviour is often a concern.
Spreadsheet: 844573d1696346589-countifs-with-arrays-of-different-widths-example-copy
Sheet: Example

State | Topic 1 | Topic 2 | Topic 3 | Topic 4 | Topic 5 |  |  | CA - California | CO - Colorado | OH - Ohio | WA - Washington
WA - Washington | Board Transparency and Authority and Obligations | Building Inspections and Maintenance | Election Procedures | Fees Charged for Resale Disclosure Packets/Estoppel Certificates | Foreclosures |  | Accessory Dwelling Units
OH - Ohio | Building Inspections and Maintenance | Construction Defects | Electronic Voting | Insurance and Risk Management | Being a 20+ year old community we have some building and surface water issues that are comming up more and more. |  | Affordable Housing
WA - Washington | Electric Vehicle Charging Stations | Electronic Voting | Landscaping Requirements | Leasing (long-term) | Natural gas and electric future |  | Amendment Process to Remove Discriminatory Restrictive Covenants
WA - Washington | Board Transparency and Authority and Obligations | Building Inspections and Maintenance | Insurance and Risk Management | Manager [NAME] | Reserve Studies/Funding |  | Assistance Animals and Pets
WA - Washington | Assistance Animals and Pets | Board Transparency and Authority and Obligations | Building Inspections and Maintenance | Insurance and Risk Management | Reserve Studies/Funding |  | Board Transparency and Authority and Obligations
CO - Colorado | Dispute Resolution: Mediation and/or Alternative Dispute Resolution | Electronic Voting | Fees Charged for Resale Disclosure Packets/Estoppel Certificates | Manager [NAME] | Reserve Studies/Funding |  | Building Inspections and Maintenance
CA - California | Board Transparency and Authority and Obligations | Building Inspections and Maintenance | Construction Defects | Dispute Resolution: Mediation and/or Alternative Dispute Resolution | Political Signs and Freedom of Speech |  | Construction Defects
Spreadsheet: 678580d1589968104-matching-with-variable-identifier-kind-of-test-book-copy
Sheet: Region codes

Postcode identifier | Region code
BH24 3 | BH24
BH24 4 | BH24
SP6 1 | BH24
SP6 2 | BH24
SP6 3 | BH24
BH25 5 | BH25
BH25 6 | BH25
BH25 7 | BH25
BL0 0 | BL00
BL0 9 | BL00
BL1 1 | BL01
[NAME] | BL01
BL1 3 | BL01
NP44 4 | NP44
NP44 5 | NP44
NP44 6 | NP44
NP44 7 | NP44
NP44 8 | NP44
NR1 1 | NR01
NR1 2 | NR01
NR1 3 | NR01
NR1 4 | NR01
NR2 1 | [NAME]
Spreadsheet: 33206d1229515349-formatting-date-imported-from-oracle-dates-2
Sheet: Sheet2

 | Opening Date |  | Date
 | 29/01/2008 |  | 2008-01-29 00:00:00
 | 2008-01-02 00:00:00 |  | 2008-01-02 00:00:00
 | 20/02/2008 |  | 2008-02-20 00:00:00
 | 25/02/2008 |  | 2008-02-25 00:00:00
 | 27/02/2008 |  | 2008-02-27 00:00:00
 | 2008-01-03 00:00:00 |  | 2008-01-03 00:00:00
 | 2008-01-03 00:00:00 |  | 2008-01-03 00:00:00
 | 2008-03-03 00:00:00 |  | 2008-03-03 00:00:00
 | 2008-11-03 00:00:00 |  | 2008-11-03 00:00:00
 | 2008-12-03 00:00:00 |  | 2008-12-03 00:00:00
 | 13/03/2008 |  | 2008-03-13 00:00:00
 | 14/03/2008 |  | 2008-03-14 00:00:00
 | 14/03/2008 |  | 2008-03-14 00:00:00
 | 18/03/2008 |  | 2008-03-18 00:00:00
 | 21/03/2008 |  | 2008-03-21 00:00:00
 | 2008-08-04 00:00:00 |  | 2008-08-04 00:00:00
 | 2008-09-04 00:00:00 |  | 2008-09-04 00:00:00
 | 2008-10-04 00:00:00 |  | 2008-10-04 00:00:00
 | 15/04/2008 |  | 2008-04-15 00:00:00
 | 17/04/2008 |  | 2008-04-17 00:00:00
 | 18/04/2008 |  | 2008-04-18 00:00:00
 | 18/04/2008 |  | 2008-04-18 00:00:00
 | 18/04/2008 |  | 2008-04-18 00:00:00
 | 22/04/2008 |  | 2008-04-22 00:00:00
 | 23/04/2008 |  | 2008-04-23 00:00:00
 | 25/04/2008 |  | 2008-04-25 00:00:00
 | 28/04/2008 |  | 2008-04-28 00:00:00
 | 29/04/2008 |  | 2008-04-29 00:00:00
 | 29/04/2008 |  | 2008-04-29 00:00:00
 | 30/04/2008 |  | 2008-04-30 00:00:00
Spreadsheet: 44458d1243227887-skip-blank-cells-seroleh-2-amd
Sheet: Sheet1

 |  | data
 |  | No | Name | Word | Good | Excel | Good
1 | 1 | 631 | [NAME] | 1 |  | 1
 |  | 632 | Beckham |  | 1 | 1 | 1
 |  | 633 | [NAME] | 1 | 1
 |  | 634 | Lampard | 1
 |  | 635 | Gerrard |  | 1 | 1 | 1
 |  | 636 | [NAME] |  |  | 1
 |  | 637 | [NAME] | 1 | 1
 |  | solution
 |  | No | Name
 |  |  | I don't want the #0 on D15, [NAME] and [NAME]. skip it. List down all the name that have 1 at course(word and excel) and their rating(good) in second column in one sheet. Using excel code. I want Like this:
 |  |  | Word |  |  |  | Excel
 |  |  | Name | Good |  |  | Name | Good
 |  | 1 |  |  |  | 1
 |  | 2 |  |  |  | 2
 |  | 3 |  |  |  | 3
 |  | 4 |  |  |  | 4
Spreadsheet: 677359d1589313881-adding-amount-from-2-different-tables-help3
Sheet: Sheet3

 |  | this is the data
 |  | HOUSE | OUT |  | HOUSE | OUT
 |  | 38 COUNCIL TAX | 10 |  | 04 COUNCIL TAX | 15
 |  | 38 MORTGAGE | 15 |  | 04 MORTGAGE | 20
 |  | 38  ENERGY | 20 |  | 04  ENERGY | 30
 |  | 38 BUILDING INSURANCE | 25 |  | 04 BUILDING INSURANCE | 40
 |  | 38 HOME CARE | 30 |  | 04 WATER | 90
 |  | 38 SKY TV | 45 |  | REPAIR 38, 04 | 20
 |  | 38 TV LICENSE | 50 |  | TOTAL
 |  | 38 [NAME] MEDIA | 55
 |  | 38 WATER | 60
 |  | REPAIR 38, 04 | 15
 |  | TOTAL
TOTAL AMOUNT IS CALCULATED MANUALLY SELECTING EACH ROW MANUALLY
I WOULD LIKE FORMULA FOR THIS PLEASE, MAYBE TWO SEPARATE FORMULA ADDING TOGETHER
 |  | NAME | TOTAL AMOUNT
 |  | COUNCIL TAX
 |  | MORTGAGE
 |  | ENERGY
 |  | BUILDING INSURANCE
 |  | HOME CARE
 |  | SKY TV
 |  | TV LICENSE
 |  | [NAME] MEDIA
 |  | WATER
 |  | REPAIR 38, 04
Spreadsheet: 886891d1736985680-formula-for-cost-based-on-a-multiple-formula-for-cost-based-on-a-multiple
Sheet: Sheet1

 | # Tickets | Total Cost |  | # Tickets | Total Cost | # Sets | Total # Tickets | Total Cost |  | [NAME]
 |  |  |  | 1 | 3
 |  |  |  | 2 | 4
 |  |  |  | 5 | 10
 |  |  |  | 12 | 20
 |  |  |  |  |  |  |  |  |  | Assuming 1 ticket costs $3 and customers can buy > 12 tickets
Spreadsheet: 878226d1725288835-golf-pairs-team-admin-tool-c-team-pairings-2025
Sheet: League Table

[NAME]
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  |  | Player 1
 |  |  | Player 2
 |  |  | Player 3
 |  |  | Player 4
 |  |  | Player 5
 |  |  | Player 6
 |  |  | Player 7
 |  |  | Player 8
 |  |  | Player 9
 |  |  | Player 10
 |  |  | Player 11
 |  |  | Player 12
 |  |  | Player 13
 |  |  | Player 14
 |  |  | Player 15
 |  |  | Player 16
 |  |  | Player 17
 |  |  | Player 18
 |  |  | Player 19
 |  |  | Player 20
 |  |  | Player 21
 |  |  | Player 22
 |  |  | Player 23
 |  |  | Player 24
 |  |  | Player 25
 |  |  | Player 26
 |  |  | Player 27
 |  |  | Player 28
 |  |  | Player 29
 |  |  | Player 30
 |  |  | Player 31
 |  |  | Player 32
 |  |  | Player 33
 |  |  | Player 34
 |  |  | Player 35
 |  |  | Player 36
Spreadsheet: 718411d1613136056-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Names

Student Name | System | Site
Student 1 | System 1 | Site 1
Student 2 | System 6 | Site 2
Student 3 | System 7 | Site 3
Student 4 | System 5 | Site 1
Student 5 | System 8 | Site 2
Student 6 | System 2 | Site 3
Student 7 | System 7 | Site 1
Student 8 | System 3 | Site 2
Student 9 | No System | Site 3
Student 10 | System 8 | Site 1
Student 11 | System 3 | Site 2
Student 12 | System 10 | Site 3
Student 13 | System 9 | Site 1
Student 14 | System 5 | Site 2
Student 15 | No System | Site 3
Student 16 | System 8 | Site 1
Student 17 | System 9 | Site 2
Student 18 |  | Site 3
Student 19 |  | Site 1
[NAME] |  | Site 2
Spreadsheet: 807713d1670005120-calculate-easy-when-i-add-a-form-ef1597_mileage-in-parish
Sheet: Sheet1

Column1 | CPSB | MC/SP | FLE | FUE | FJH | FHS | CEC | CPA | VHS | VJH | VUE | VLE | MHS | HS C | HS V |  | From: | To: | [NAME]
CPSB | 0 | 2.5 | 7.5 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3.5 | 3 | 3 | 26 | 13 | 0.5 |  | FHS | MHS
MC/SP | 2.5 | 0 | 10 | 9 | 9 | 9.5 | 9.5 | 7.5 | 2 | 0.5 | 0.5 | 0.5 | 25 | 16 | 2.5
FLE | 7.5 | 10 | 0 | 2.5 | 2.5 | 1.5 | 3 | 4 | 8 | 10.5 | 10.5 | 10.5 | 21 | 6.5 | 8
FUE | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FJH | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FHS | 7 | 9.5 | 1.5 | 2.5 | 2.5 | 0 | 2 | 4.5 | 8 | 10.5 | 10 | 10 | 20.5 | 6.5 | 7.5
CEC | 7 | 9.5 | 3 | 0.5 | 0.5 | 2 | 0 | 4 | 8 | 10.5 | 10 | 10 | 20 | 8.5 | 7.5
CPA | 5 | 7.5 | 4 | 3 | 3 | 4.5 | 4 | 0 | 6 | 8.5 | 8 | 8 | 23 | 10 | 5
VHS | 1 | 2 | 8 | 7.5 | 7.5 | 8 | 8 | 6 |  | 2.5 | 2 | 2 | 26.5 | 14.5 | 1
VJH | 3.5 | 0.5 | 10.5 | 10 | 10 | 10.5 | 10.5 | 8.5 | 2.5 | 0 | 1 | 1 | 24.5 | 17 | 3
VUE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0 | 0.5 | 25 | 16.5 | 3
VLE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0.5 | 0 | 25.5 | 16.5 | 3
MHS | 26 | 25 | 21 | 20 | 20 | 20.5 | 20 | 23 | 26.5 | 24.5 | 25 | 25.5 |  | 26 | 25.5
HS C | 13 | 16 | 6.5 | 8 | 8 | 6.5 | 8.5 | 10 | 14.5 | 17 | 16.5 | 16.5 | 26 | 0 | 13
HS V | 0.5 | 2.5 | 8 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3 | 3 | 3 | 25.5 | 13 | 0
Spreadsheet: 686313d1594492678-dependent-drop-down-list-dependent-drop-down-list_example
Sheet: Tables

 | _Country | Vietnam | England | China | Australia | Brazil |  | Country / Segment | Vietnam_Plant | Vietnam_HQ | Vietnam_DC | England_Plant | England_DC | China_Plant | Australia_Plant | Australia_DC | Brazil_DC | Can Tho | [NAME] | Da Nang
 | Vietnam | Plant | Plant | Plant | Plant | DC |  | Vietnam_Plant | Can Tho | Hanoi | [NAME] | Bradford | Bristol | Bozhou | Brisbane | Melbourne | [NAME] | Cating | Moulding | Forming
 | England | HQ | DC |  | DC |  |  | Vietnam_HQ | [NAME] |  | [NAME] | Brighton | Canterbury | Fuyang | Perth | Sidney | Salvador | Labeling |  | Machining
 | China | DC |  |  |  |  |  | Vietnam_DC | Da Nang |  | [NAME] | Cambridge |  | Chuzhou | Adelaide |  | Manaus
 | Australia |  |  |  |  |  |  | England_Plant
 | Brazil |  |  |  |  |  |  | England_DC
 |  |  |  |  |  |  |  | China_Plant
 |  |  |  |  |  |  |  | Australia_Plant
 |  |  |  |  |  |  |  | Australia_DL
 |  |  |  |  |  |  |  | Brazil_DC
 | _Country |  |  |  |  |  |  | _Country_Segment
 | =INDEX(TblVal1[Country],1,1):INDEX(TblVal1[Country],COUNTA(TblVal1[Country])) |  |  |  |  |  |  | =INDEX(TblVal2[Country_Segment],1,1):INDEX(TblVal2[Country_Segment],COUNTA(TblVal2[Country_Segment]))
 | _MainList1 |  |  |  |  |  |  | _MainList2
 | =INDEX(TblVal1,0,MATCH(INDEX(TblData1[@],COLUMN()-COLUMN(TblData1)),TblVal1[#Headers],0)) |  |  |  |  |  |  | =INDEX(TblVal2,0,MATCH(INDEX(TblData2[@],COLUMN()-COLUMN(TblData2)),TblVal2[#Headers],0))
 | _UseList1 |  |  |  |  |  |  | _UseList2
 | = INDEX(_MainList1,1,1):INDEX(_MainList1,COUNTA(_MainList1)) |  |  |  |  |  |  | = INDEX(_MainList2,1,1):INDEX(_MainList2,COUNTA(_MainList2))