tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8fb8bc22-9f34-4824-98ab-c224c4cda32a
Sheet: Sheet1

GROUP / COUNTRY / FIPS CODE | Unnamed: 1 | Electricity | Nuclear | Conventional Thermal | Renewables | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | [NAME]
 |  |  |  |  | Renewables | Hydroelectricity | Non-Hydroelectric Renewables
 |  |  |  |  |  |  | Non-Hydroelectric Renewables | Geothermal | Solar, Tide, and Wave |  |  | Wind | Biomass and Waste
 |  | Total Electricity Capacity |  | Total [NAME] | Total Renewables | Hydroelectric | Total Non-Hydroelectric Renewables |  | Solar, Tide and Wave | Solar | Tide and Wave
ASIA & OCEANIA |  | 1649.434 | 82.519 | 1195.687 | 328.297 | 286.443 | 41.854 | 4.166 | 2.779 | 2.779 | 0 | 26.425 | 8.484 | 42.931
Japan | JA | 279.876 | 47.278 | 179.324 | 27.785 | 21.852 | 5.933 | 0.532 | 2.144 | 2.144 | 0 | 1.756 | 1.501 | 25.489
IEA |  | 2422.093 | 307.948 | 1533.796 | 485.249 | 332.435 | 152.814 | 4.089 | 13.132 | 12.871 | 0.261 | 95.914 | 39.679 | 95.1
Japan | JA | 279.876 | 47.278 | 179.324 | 27.785 | 21.852 | 5.933 | 0.532 | 2.144 | 2.144 | 0 | 1.756 | 1.501 | 25.489
OECD-ASIA AND OCEANIA |  | no val | no val | no val | no val | no val | no val | no val | no val | no val | no val | no val | no val | no val
Japan | JA | 279.876 | 47.278 | 179.324 | 27.785 | 21.852 | 5.933 | 0.532 | 2.144 | 2.144 | 0 | 1.756 | 1.501 | 25.489
OECD |  | 2514.274 | 309.914 | 1601.772 | 507.488 | 352.256 | 155.232 | 5.629 | 13.155 | 12.894 | 0.261 | 96.118 | 40.33 | 95.1
Japan | JA | 279.876 | 47.278 | 179.324 | 27.785 | 21.852 | 5.933 | 0.532 | 2.144 | 2.144 | 0 | 1.756 | 1.501 | 25.489
Spreadsheet: andy_zipper__558__11_19_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 260 | 26 | 28 | 84.7 | 91.3 | 14.38 | 2001-11-19 12:01:00
 | NG F2 | 285 | 58 | 60 | 80.6 | 83.4 | 14.69 | 2001-11-19 12:01:00
 | NG G2 | 285 | 74 | 77 | 75.2 | 78.3 | 13.75 | 2001-11-19 12:01:00
 | NG H2 | 290 | 78 | 81 | 66.1 | 68.6 | 12.28 | 2001-11-19 12:01:00
 | NG J2 | 285 | 73 | 77 | 55.6 | 58.7 | 10.24 | 2001-11-19 12:01:00
 | NG K2 | 290 | 76 | 80 | 51.2 | 53.9 | 9.58 | 2001-11-19 12:01:00
 | NG M2 | 295 | 83 | 87 | 50.2 | 52.7 | 9.54 | 2001-11-19 12:01:00
 | NG N2 | 295 | 91.5 | 93 | 51.9 | 52.8 | 9.71 | 2001-11-19 12:01:00
 | NG Q2 | 300 | 97 | 102 | 50.8 | 53.5 | 9.84 | 2001-11-19 12:01:00
 | NG U2 | 305 | 104 | 110 | 50.8 | 53.8 | 10.03 | 2001-11-19 12:01:00
 | NG V2 | 305 | 108 | 115 | 50.4 | 53.8 | 9.99 | 2001-11-19 12:01:00
 | NG X2 | 325 | 120 | 128 | 50.2 | 53.7 | 10.61 | 2001-11-19 12:01:00
 | [NAME] |  |  |  |  |  |  | 2001-11-19 10:21:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 356737d1415198803-using-vlookup-direct-and-dropdowns-to-populate-cells-vlookup-with-name-range
Sheet: Sheet1

 |  |  |  |  |  | Week 1
 | Select Week | Select Type | [NAME] |  |  | apple | 5 |  | F3:G5 is named "week1"
 | week2 | orange |  |  |  | orange | 4
 |  |  |  |  |  | pears | 8
 | Is there a way to make the dropdown in B4 appear as 'Week 1' rather than 'week1' i.e. has a space between week and 1 |  |  |  |  | Week 2
 |  |  |  |  |  | apple | 5 |  | F9:[NAME] is named "week2"
 |  |  |  |  |  | orange | 4
 |  |  |  |  |  | pears | 8
 |  |  |  |  |  | Week 3
 |  |  |  |  |  | apple | 5 |  | F14:G16 is named "week3"
 |  |  |  |  |  | orange | 4
 |  |  |  |  |  | pears | 8
 |  |  |  |  |  | Week 4
 |  |  |  |  |  | apple | 5 |  | F19:G21 is named "week4"
 |  |  |  |  |  | orange | 4
 |  |  |  |  |  | pears | 8
 |  |  |  |  |  | week1 |  | G25:G27 is used for week dropdown
 |  |  |  |  |  | week2
 |  |  |  |  |  | week3
 |  |  |  |  |  | week4
Spreadsheet: 162308d1339789670-custom-map-chart-of-location-deer
Sheet: Sheet1 (2)

 |  |  |  |  | Location
 |  |  | 100
ID | Date | Location
100 | 2012-05-03 00:00:00 | 1
101 | 2012-05-04 00:00:00 | 3
100 | 2012-05-06 00:00:00 | 2
100 | 2012-05-10 00:00:00 | 3
101 | 2012-05-23 00:00:00 | 1
102 | 2012-05-25 00:00:00 | 3
100 | 2012-05-30 00:00:00 | 4
101 | 2012-06-05 00:00:00 | 1
100 | 2012-06-08 00:00:00 | 2
102 | 2012-06-10 00:00:00 | 2
101 | 2012-06-12 00:00:00 | 1
101 | 2012-06-15 00:00:00 | 3
100 | 2012-06-18 00:00:00 | 1
101 | 2012-06-20 00:00:00 | 1
102 | 2012-06-22 00:00:00 | 2
Spreadsheet: 146114d1331904951-extract-from-1-sheet-to-many-sum-total-not-working-extract-from-1-sheet-to-many-sheets
Sheet: IAN BROWN

SAMPLE CYCLE TEST RUNS
[NAME] | TECHNICIAN | CYCLE A |  | CYCLE B |  | CYCLE C |  | CYCLE D |  | CYCLE E |  | CYCLE F
 |  | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart
RUN 3 | IAN BROWN | 5 | 14.A | 30 | 9.A | 22 | 4.DA | 24 | 11.AC |  | 7.ZA | 24 | 12.AE
RUN 8 | IAN BROWN | 15 | 17.BB | 80 | 11.CB | 47 | 7.ZZ | 49 | 12.GB | 51 | 9.ZH |  | 14.FY
TOTALS |  | 20 |  | 110 |  | 69 |  | 73 |  | 51 |  | 24
Spreadsheet: 813638d1673891191-how-to-use-cf-based-on-specific-dates-daily-count_russkris
Sheet: Ticket Count

Service Now Tickets
 |  | Open |  |  | Created |  |  | Closed
Month | Date | Total | Incident | Request | Total2 | Incident2 | Request2 | Total3 | Incident3 | Request3
 | 2023-01-01 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-02 00:00:00 | 0 |  |  | 4 | 3 | 1 | 7 | 5 | 2
 | 2023-01-03 00:00:00 | 7 | 6 | 1 | 6 | 0 | 6 | 5 | 0 | 5
 | 2023-01-04 00:00:00 | 7 | 6 | 1 | 5 | 0 | 5 | 4 | 2 | 2
 | 2023-01-05 00:00:00 | 8 | 4 | 4 | 14 | 1 | 13 | 11 | 0 | 11
 | 2023-01-06 00:00:00 | 10 | 5 | 5 | 4 | 0 | 4 | 7 | 0 | 7
 | 2023-01-07 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-08 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-09 00:00:00 | 7 | 5 | 2 | 13 | 4 | 9 | 6 | 2 | 4
 | 2023-01-10 00:00:00 | 14 | 5 | 9 | 10 | 1 | 9 | 11 | 2 | 9
 | 2023-01-11 00:00:00 | 12 | 6 | 6 | 9 | 0 | 9 | 5 | 2 | 3
 | 2023-01-12 00:00:00 | 16 | 4 | 12 | 12 | 3 | 9 | 11 | 1 | 10
 | 2023-01-13 00:00:00 | 18 | 6 | 12 | 1 | 0 | 1 | 0 | 0 | 0
 | 2023-01-14 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-15 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-16 00:00:00 | 18 | 6 | 12 | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-17 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-18 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-19 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-20 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-21 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-22 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-23 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-24 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-25 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-26 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-27 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-28 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-29 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-30 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 2023-01-31 00:00:00 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 8c9ab656-a336-414b-ad9a-c39e2c4aaaad
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0034987 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Bladen | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | SUB1
 |  |  |  |  |  | Area (acres): |  | 3.23 |  | Area (acres): |  | 2.29 |  | Area (acres): |  | 3.21 |  | Area (acres): |  | 4.56
 |  |  |  |  |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME] |  | Cover Crop: |  | [NAME]
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  | Annual Rate (in): |  | 21.2 |  | Annual Rate (in): |  | 21.2 |  | Annual Rate (in): |  | 21.2 |  | Annual Rate (in): |  | 21.2
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 41344d1239813158-vlookup-with-unique-multiple-criteria-excel-example
Sheet: Sheet1

File | Date | ID |  |  | File # | Start | Stop | id
2 | 15 | B102 |  |  | 2 | 9 | 13 | [NAME]
2 | 11 | [NAME] |  |  | 2 | 14 | 16 | B102
2 | 7 | C103 |  |  | 2 | 1 | 8 | C103
2 | 6 | C103 |  |  | 1 | 8 | 15 | D104
1 | 4 | E105 |  |  | 1 | 1 | 7 | E105
1 | 17 | F106 |  |  | 1 | 16 | 19 | F106
3 | 8 | G101 |  |  | 3 | 2 | 9 | G101
3 | 16 | K101 |  |  | 3 | 10 | 14 | J101
 |  |  |  |  | 3 | 15 | 17 | K101
Spreadsheet: 732297d1620874353-pivot-tables-show-report-filter-pages-greyed-out-pivottables-show-filters
Sheet: Summary

Customer Name | All
Row Labels | Sum of Sales Value
Men crop top black | 4600
Men dress shirt black | 1050
Men dress shirt grey | 496
Men Shorts | 1272
Men shorts black | 1500
Men shorts grey | 1172
Men type T simple black | 10652
Men type T simple white | 8304
Men's tank top white | 156
Smartphone case diamond | 13628
Smartphone case simple | 2744
Travel bag black | 11024
Travel bag red | 12496
Grand Total | 69094
Spreadsheet: 109675d1306455369-3d-vlookup-copy-2010_11-09m3-results-file-for-forum
Sheet: Tiers_Years

L3to5_2005
L3to5_2006
L3to5_2007
L3to5_2008
L3to5_2009
L3to5_2010
L4to6_2005
L4to6_2006
L4to6_2007
L4to6_2008
L4to6_2009
[NAME]
L5to7_2005
L5to7_2006
L5to7_2007
L5to7_2008
L5to7_2009
[NAME]
L6to8_2005
L6to8_2006
L6to8_2007
[NAME]
L6to8_2009
L6to8_2010
Spreadsheet: 850241d1700616256-3-variable-lookup-3v-lookup
Sheet: Sheet2

 | Table | Older Age | Younger Age | Rate
 | B | 73 | 68
 | Table | Older | Younger | Rate
 | A | 73 | 68 | 0.051
 | B | 73 | 68 | 0.052
 | C | 73 | 68 | 0.053
 | A | 75 | 71 | 0.064
 | B | 75 | 71 | 0.065
 | C | 75 | 71 | 0.066
Spreadsheet: 873188d1719613273-highlight-data-based-on-matching-concantenated-criteria-go3go3go-matching
Sheet: ProgramAccNumbers

Customer | Brand | Cust# & Brand
102538 | BR | 102538BR
1293493 | BR | 1293493BR
131128 | BR | 131128BR
89273 | KD | 89273KD
89352 | KD | 89352KD
89353 | KD | 89353KD
89353 | MX | 89353MX
89356 | MX | 89356MX
89363 | MX | 89363MX
1213919 | NX | 1213919NX
130096 | NX | 130096NX
1308261 | NX | 1308261NX
230617 | NX | 230617NX
Spreadsheet: 135580d1326131113-how-to-make-summary-from-many-sheets-students
Sheet: Math

No | Student Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Average
1 | Student1 | 36 | 74 | 14 | 50 | 17 | 92 | 98 | 52 | 64 | 15 | 46 | 95
2 | Student2 | 67 | 82 | 92 | 45 | 56.99999999999999 | 11 | 52 | 4 | 97 | 79 | 77 | 47
3 | Student3 | 92 | 95 | 2 | 35 | 28 | 5 | 55.00000000000001 | 50 | 66 | 80 | 20 | 26
4 | Student4 | 24 | 20 | 71 | 55.00000000000001 | 53 | 71 | 98 | 93 | 60 | 81 | 93 | 7.000000000000001
5 | Student5 | 26 | 53 | 87 | 25 | 31 | 96 | 94 | 86 | 79 | 72 | 40 | 0
6 | Student6 | 74 | 48 | 75 | 63 | 46 | 64 | 47 | 85 | 12 | 68 | 24 | 81
7 | Student7 | 19 | 21 | 52 | 21 | 64 | 93 | 13 | 85 | 48 | 2 | 41 | 33
8 | Student8 | 42 | 9 | 30 | 55.00000000000001 | 26 | 3 | 87 | 88 | 20 | 89 | 89 | 33
9 | Student9 | 44 | 20 | 55.00000000000001 | 68 | 18 | 7.000000000000001 | 92 | 29 | 5 | 60 | 99 | 92
10 | Student10 | 47 | 70 | 62 | 11 | 35 | 89 | 6 | 52 | 62 | 4 | 57.99999999999999 | 59
11 | Student11 | 68 | 11 | 72 | 68 | 0 | 2 | 26 | 69 | 47 | 54 | 26 | 13
12 | Student12 | 43 | 12 | 12 | 5 | 75 | 16 | 13 | 75 | 37 | 46 | 5 | 22
13 | Student13 | 38 | 5 | 2 | 28 | 80 | 89 | 49 | 28 | 87 | 26 | 76 | 1
14 | Student14 | 84 | 75 | 83 | 6 | 54 | 25 | 30 | 47 | 0 | 59 | 53 | 53
15 | Student15 | 5 | 42 | 37 | 77 | 12 | 73 | 42 | 77 | 51 | 30 | 80 | 67
16 | Student16 | 98 | 45 | 46 | 23 | 34 | 67 | 90 | 93 | 68 | 52 | 46 | 6
17 | Student17 | 89 | 7.000000000000001 | 55.00000000000001 | 7.000000000000001 | 94 | 72 | 31 | 65 | 54 | 51 | 59 | 14
18 | Student18 | 9 | 41 | 34 | 6 | 69 | 82 | 60 | 44 | 15 | 47 | 76 | 67
19 | Student19 | 36 | 2 | 59 | 64 | 99 | 53 | 59 | 44 | 84 | 73 | 85 | 52
20 | Student20 | 86 | 68 | 17 | 72 | 12 | 73 | 54 | 88 | 14 | 26 | 5 | 79
Average
Spreadsheet: 287893d1389026173-conditional-formatting-one-cell-based-on-the-value-of-another-conditional-20formatting-20question-1-
Sheet: Sheet1

Target | 245 | 245 | 245 | 245
Achieved | 146 | 184 | 245 | 278
As above, conditional formatting should show: | 245 | 245 | 245 | 245
 | 146 | 184 | 245 | 278
If Target is later changed, formatting should then show: | 184 | 184 | 184 | 184
 | 146 | 184 | 245 | 278
Spreadsheet: 266358d1379591979-how-to-extract-company-name-from-row-example
Sheet: Sheet1

Rank;"Virksomhed";"Branche";"OmsÃ¦tning";"Resultat";"Ansatte"
1;"A.P. Møller - Mærsk";"Konglomerat";"322520000";"18083000";"117080"
2;"Danske Bank";"Finans og forsikring";"115197000";"1723000";"21320"
3;"ISS";"Rådgivning og service";"77644000";"-507000";"533573"
4;"United Shipping & Trading";"Energi og forsyning";"68433855";"290799";"904"
5;"Novo Nordisk";"Medicinal og biotek";"66346000";"17097000";"31499"
6;"Wrist Group";"Energi og forsyning";"65488775";"263346";"1429"
7;"Carlsberg";"Levnedsmidler ";"63561000";"5692000";"42670"
8;"DONG Energy";"Energi og forsyning";"58437000";"4250000";"5966"
9;"Arla Foods";"Levnedsmidler ";"54893000";"1332000";"17417"
10;"Danish Crown";"Levnedsmidler ";"51754000";"1762000";"23557"
11;"DSV";"Transport";"43710000";"1449000";"21445"
12;"Vestas Wind Systems";"Teknologi og maskinindustri";"43481702";"-1236800";"22926"
13;"Nykredit";"Finans og forsikring";"43410000";"260000";"4139"
14;"DLG";"Engroshandel";"40841793";"390551";"5386"
15;"Coop Danmark";"Detailhandel";"39569000";"397000";"12828"
16;"Danfoss";"Teknologi og maskinindustri";"33904000";"1314000";"24133"
17;"Nordea Bank";"Finans og forsikring";"30696000";"2188000";"7885"
18;"Scandinavian Tobacco Group";"Konglomerat";"27348300";"509100";"13577"
19;"TDC";"IT | tele og elektronik";"26304000";"2808000";"10106"
20;"Statoil Refining";"Energi og forsyning";"25295397";"-1346404";"421"
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: RBC Heritage

 |  | WEEK 2 RBC Heritage
 |  | Total Earnings |  |  |  | Rankings Through Week 2 | Total
 | [NAME] | 4000 |  | 1 |  | [NAME] | 4000
 | [NAME] | 4000 |  | 2 |  | [NAME] | 4000
 | [NAME] | 4000 |  | 3 |  | [NAME] | 4000
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | [NAME] |  | YTD
Allenby, [NAME] |  |  |  | 4000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 4000
[NAME]
Allenby, [NAME] |  |  |  | 4000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 4000
[NAME]
Allenby, [NAME] |  |  |  | 4000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 4000
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 777037d1650092229-how-to-merge-multiple-sheets-with-each-table-headers-start-from-second-row-master
Sheet: C

STORE | 2022-03-07 00:00:00 | PC | [NAME] | 2022-03-28 00:00:00 | PC | [NAME] | 2022-04-04 00:00:00 | PC | [NAME]
K
L
M
N
O
P
Q
R
S
T
U
V
W
AA
BB
CC
DD
EE
FF
GG
Spreadsheet: 792910d1661223315-summary-of-employee-data-for-meeting-of-quota-analysis-excelforumexample-v2-1-
Sheet: Payroll Sheet

 | Employee Name: | Emp1 |  | Pay Period Ending: | 2022-08-13 00:00:00
 |  | Hours Worked | L/W/R Count | Total Lines | Lines per Hour
 | BWX
 | DR
 | KHS
 | LGR
 | LCCB
 | LCG
 | LET
 | NEU
 | PD
 | PS
 | AB
 | Breaks
 | CBC
 | DT
 | FQ
 | Lunch
 | Downtime
 | PTO/Sick
 | Total Hours Worked
 | Total Hours Paid
 | Difference
 | % in System
Spreadsheet: 547198d1510390112-mortgage-paydown-projection-table-mortgage-paydown-projection-table-rental-valuation-breakdown
Sheet: Schedule

Weekly pmt
Year | Int | Prin
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
Spreadsheet: 790089d1659533809-10-day-rolling-values-on-chart-book1
Sheet: Sheet1

2022-01-01 00:00:00 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
Spreadsheet: 882425d1730813939-wert-bleibt-dauerhaft-in-zelle-wenn-bedienung-erf-llt-x-kontrolle-automatisch
Sheet: Kalenderwoche

 | 2024-11-04 00:00:00 |  |  | 2024-11-05 00:00:00 |  |  | 2024-11-06 00:00:00 |  |  | 2024-11-07 00:00:00 |  |  | 2024-11-08 00:00:00
 | Kontrolle | [NAME]. Nr | Firma | Kontrolle | [NAME]. Nr | Firma | Kontrolle | [NAME]. Nr | Firma | Kontrolle | [NAME]. Nr | Firma | Kontrolle | [NAME]. Nr | Firma
 |  | 1000 | a |  | 1020 | a |  | 1030 | a |  | 1048 | a |  | 1066 | a
 |  | 1001 | b |  | 1021 | b |  | 1031 | b |  | 1049 | b |  | 1067 | b
 |  | 1002 | c |  | 1022 | c |  | 1032 | c |  | 1050 | c |  | 1068 | c
 |  | 1003 | d |  | 1023 | d |  | 1033 | d |  | 1051 | d |  | 1069 | d
 |  | 1004 | e |  | 1024 | e |  | 1034 | e |  | 1052 | e |  | 1070 | e
 |  | 1005 | f |  | 1025 | f |  | 1035 | f |  | 1053 | f |  | 1071 | f
 |  | 1006 | g |  | 1026 | g |  | 1036 | g |  | 1054 | g |  | 1072 | g
 |  | 1007 | h |  | 1027 | h |  | 1037 | h |  | 1055 | h |  | 1073 | h
 |  | 1008 | i |  | 1028 | i |  | 1038 | i |  | 1056 | i |  | 1074 | i
 |  | 1009 | j |  | 1029 | j |  | 1039 | j |  | 1057 | j |  | 1075 | j
 |  | 1010 | k |  |  |  |  | 1040 | k |  | 1058 | k |  | 1076 | k
 |  | 1011 | l |  |  |  |  | 1041 | l |  | 1059 | l |  | 1077 | l
 |  | 1012 | m |  |  |  |  | 1042 | m |  | 1060 | m |  | 1078 | m
 |  | 1013 | n |  |  |  |  | 1043 | n |  | 1061 | n |  | 1079 | n
 |  | 1014 | o |  |  |  |  | 1044 | o |  | 1062 | o
 |  | 1015 | p |  |  |  |  | 1045 | p |  | 1063 | p
 |  | 1016 | q |  |  |  |  | 1046 | q |  | 1064 | q
 |  | 1017 | r |  |  |  |  | 1047 | r |  | 1065 | r
 |  | 1018 | s
 |  | 1019 | t
Spreadsheet: 156656d1337370589-help-with-tat-and-sla-sample-for-dc1387
Sheet: Sheet2

SR Number | Task Type Example | Created Date | Due Date | Closed Date |  | TAT (Days) | in SLA?
[PHONE] | AAAA | 2012-05-04 00:00:00 | 2012-05-04 00:00:00 | 2012-05-08 00:00:00
[PHONE] | AAAA | 2012-05-14 00:00:00 | 2012-05-14 00:00:00 | 2012-05-14 00:00:00
[PHONE] | AAAA | 2012-05-14 00:00:00 | 2012-05-14 00:00:00 | 2012-05-14 00:00:00
[PHONE] | DDDD | 2012-05-08 00:00:00 | 2012-05-08 00:00:00 | 2012-05-08 00:00:00
[PHONE] | EEEE | 2012-05-08 00:00:00 | 2012-05-08 00:00:00 | 2012-05-08 00:00:00
[PHONE] | EEEE | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-11 00:00:00
[PHONE] | EEEE | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-11 00:00:00
[PHONE] | EEEE | 2012-05-09 00:00:00 | 2012-05-11 00:00:00 | 2012-05-11 00:00:00
Task type | # of Tasks | Average TAT (Days) | % Within SLA
AAAA | 3
DDDD | 1
EEEE | 4
Totals MTD: | 8
Spreadsheet: 158491d1338281629-if-statement-with-3-vlookups-if-statement-with-3-vlookups
Sheet: Sheet1

Despite yesterday' help (thanks again [NAME], Icestationzbra and zbor) I've been unable to embed multiple nested 'IF" formulas in VLOOPKUP
The following 3 sheets (2, 3 and 4) contain data regarding the 600+ names, here illustrated as 6 names ([NAME], [NAME], [NAME], [NAME], [NAME] and [NAME])
sheet 2 | [NAME] data (sheet 2) | [NAME] data (sheet 2) |  | [NAME] data (sheet 2) |  | [NAME] data (sheet 2)
sheet 3 |  | [NAME] data (sheet 3) |  |  | [NAME] data (sheet 3)
sheet 4 |  |  | [NAME] data (sheet 4) |  |  | [NAME] data (sheet 4)
Sheet 2 is the most recent info, then sheet 3, sheet 4 contains the oldest data
What I want to obtain in sheet is: if data in sheet 1 is available, get it from sheet 1, if not available, take it from sheet 2, if not available from sheet 3, if not from sheet 4
I can't apply a simple 'IF' formula, since [NAME], [NAME] etc. since there are 600+ names and they are not on the same rows.
I've tried VLOOKUP, but got error message: =IF(VLOOKUP(A15,Sheet2!$A$1:$B$8,2,0)<>"",VLOOKUP(A15,Sheet2!$A$1:$B$8,2,0), IF(VLOOKUP(A15,Sheet3!$A$1:$B$8,2,0)<>"",VLOOKUP(A15,Sheet3!$A$1:$B$8,2,0), IF(VLOOKUP(A15,Sheet4!$A$1:$B$8,2,0)<>"",VLOOKUP(A15,Sheet4!$A$1:$B$8,2,0))))
Sheet 1 | Want to achieve
[NAME] | [NAME] data (sheet 2)
[NAME] | [NAME] data (sheet 3)
[NAME] | [NAME] data (sheet 4)
[NAME] | [NAME] data (sheet 2)
[NAME] | [NAME] data (sheet 3)
[NAME] | [NAME] data (sheet 2)
I've tried IFERROR but got the error message "too many arguments" =IFERROR(VLOOKUP(A15,Sheet2!$A$1:$B$8,2,0),VLOOKUP(A15,Sheet2!$A$1:$B$8,2,0), IFERROR(VLOOKUP(A15,Sheet3!$A$1:$B$8,2,0),VLOOKUP(A15,Sheet3!$A$1:$B$8,2,0), IFERROR(VLOOKUP(A15,Sheet4!$A$1:$B$8,2,0),VLOOKUP(A15,Sheet4!$A$1:$B$8,2,0)))
I hope someone can help me, thank you in advance,