tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882201d1730465822-need-formula-to-return-names-in-a-list-example-list
Sheet: Sheet1

 | Basic data:
 | Wk/Name | 2024-45 | 2024-46 | 2024-47 | 2024-48 | 2024-49 | 2024-50 | 2024-51 | 2024-52 | 2025-01 | 2025-02
 | Name 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 | Name 2 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Name 3 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
 | Name 4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1
 | Name 5 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Name 6 | x | 0 | 1 | 1 | 1 | x | x | x | x | x
 | Name 7 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0
 | Need a formula to return the zero values i whatever kind of list that is suitable (want this list to occur in another spreadsheet):
 |  | 2024-45 | 2024-46 | 2024-47 | 2024-48 | 2024-49 | 2024-50 | 2024-51 | 2024-52 | 2025-01 | 2025-02
 |  | Name 3 | Name 3 | Name 5 | Name 2 | Name 2 | Name 4 | Name 4 |  | Name 1 | Name 1
 |  |  | Name 6 |  | Name 5 | Name 4 |  | Name 7 |  | Name 3 | Name 7
 |  |  |  |  |  | Name 5 |  |  |  | Name 7
 |  |  | 2024-46 | 2024-47 | 2024-48 | 2024-49 | 2024-50 | 2024-51 | 2024-52 | 2025-01 | 2025-02
 |  | Name 3 | Name 3 | Name 5 | Name 2 | Name 2 | Name 4 | Name 4 |  | Name 1 | Name 1
 |  |  | Name 6 |  | Name 5 | Name 4 |  | Name 7 |  | Name 3 | Name 7
 |  |  |  |  |  | Name 5 |  |  |  | Name 7
Spreadsheet: 81ef0790-b8bb-4380-a7b6-95e37e5a889c
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 10/21/2014 8:29:07 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
District 45 | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 777373d1650356520-return-values-text-from-one-sheet-into-multiple-sheets-by-comparing-three-columns-book1gk
Sheet: Calculation

[NAME] | Items | ID | Price
[NAME] | Apples - Red 019 | 67301/0 | Discounted
[NAME] | Oranges - Dark 013 | 69498/0 | Discounted
[NAME] | Bananas - Yellow 017 | 69173/0 | Discounted
[NAME] | Bananas - Skin 013 | 69638/0 | Full
Mark | Bananas - Yellow 017 | 69637/0 | Discounted
Mark | Apples - Gold 011 | 68590/0 | Discounted
[NAME] | Oranges - Light 010 | 69494/0 | Discounted
[NAME] | Apples - Red 019 | 69499/0 | Discounted
Mark | Apples - Brown 000 | 68629/0 | Full
[NAME] | Apples - Brown 000 | 69464/0 | Full
[NAME] | Oranges - Light 010 | 69500/0 | Full
[NAME] | Bananas - Skin 013 | 69469/0 | Full
Spreadsheet: 178508d1346819687-how-to-use-vlookup-in-excel-sample-worksheet-included-sample-excel-help1
Sheet: Sheet1

Raw Data
SKU # | Location | Quantity
1 | Houston | 40
2 | [NAME] | 50
3 | Dallas | 60
4 | San Antonio | 70
5 | Dallas | 32
6 | Dallas | 28
7 | Houston | 56
8 | Tulsa | 89
Desired Format
Location Horizontal | Houston | [NAME] | Dallas | San Antonio | Tulsa
SKU #
1 | 40
2 |  | 50
3 |  |  | 60
4 |  |  |  | 70
5 |  |  | 32
6 |  |  | 28
7 | 56
8 |  |  |  |  | 89
I need to be able to read the location for the column, output correct SKU quantity in the appropriate SKU row. Please Help. Thanks!!
Spreadsheet: 78009d1278468546-excel-count-function-excluding-duplicate-values-sample1
Sheet: List of Species

Family | [NAME] | Genus | species
Actinidiaceae | Tinalupak | Saurauia | involucrata
Anacardiaceae | Balinghasai | Buchania | arborescene
Anacardiaceae | Kamiring | Semecarpus | philippinensis
Anacardiaceae | [NAME] | Spondias | pinnata
Anacardiaceae | Pahutan | [NAME] | altisima
[NAME] | [NAME] | Anthrophyllum | ahernianum
[NAME] | [NAME] | Polyscias | [NAME]
Araucariaceae | Almaciga | Agathis | philippinensis
Bignoniaceae | Pinka-pinkahan | Oroxylon | indicum
[NAME] | Pagsahingin | Canarium | asperum
[NAME] | Piling-liitan | Canarium | luzonicum
Cannabaceae | Magabuyo | [NAME] | luzonica
Cannabaceae | [NAME] | [NAME] | philippensis
Clethraceae | Apiit | Clethra | luzonica
Clusiaceae | Bitanghol | Calophyllum | blancoi
Clusiaceae | Bitaog | Calophyllum | inophyllum
Clusiaceae | [NAME] | Calophyllum | obliquinervum
Clusiaceae | [NAME] | Garcinia | venulosa
Clusiaceae | [NAME] | Garcinia | cordata
Clusiaceae | Paguringon | Cratoxylum | celebicum
Spreadsheet: 808327d1670418360-the-average-of-a-second-row-gemiddelde-waarden-rl-nederlandse-zomer
Sheet: Juli 22

[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 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME]  °C | 24.3 | 24.3 | 19.6 | 21.4 | 20.6 | 25 | 19.6 | 22.8 | 21.8 | 21.5 | 25.2 | 28.7 | 24.6 | 23.6 | 21.8 | 22.2 | 24.8 | 32.7 | 33 | 25.6 | 19.4 | 21.1 | 25.5 | 29.2 | 22 | 20.3 | 21 | 22 | 24.3 | 25.4 | 22.8
Laagste RL [%] | 44 | 44 | 57 | 51 | 46 | 48 | 58 | 48 | 57 | 48 | 39 | 31 | 56 | 33 | 46 | 46 | 40 | 23 | 30 | 58 | 71 | 57 | 51 | 42 | 61 | 52 | 46 | 45 | 44 | 43 | 75
[NAME]
Nuttige dagen | 2
Spreadsheet: 849450d1699926942-help-with-formulas-please-classes-example-righonstorm
Sheet: MASTER

Code | Name | Gender | ENGLISH | SCIENCE
11 | [NAME] | F
22 | [NAME] | M
33 | Mark | M
44 | Tania | F
55 | [NAME] | F
66 | [NAME] | M
77 | [NAME] | M
88 | Bec | F
99 | [NAME] | M
0 | [NAME] | M