tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767313d1644408805-list-of-people-that-i-want-to-calculate-how-many-days-they-have-left-until-end-date-enddate-ans
Sheet: English

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-09-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30 |  |  | The maximum is 30 days
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0 |  |  | If the end date has arrived then it should be calculated and if it is> but Calculation day then max 30
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 30 |  |  | Sometimes there is a End date that is more than a month in advance, but the maximum in that case will be 30, exept if it is less then month in atvansed
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30 |  |  | The formula must be such that it works on all parties and also that if the names / dates are changed, the formula works on them
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 2
 |  |  |  |  |  |  |  |  | Red is wrong and is not working
Oktobere
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be |  |  | If the End date has passed, an error occurs
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 30
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 0
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 0
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 0
Spreadsheet: 133500d1324424418-excel-2007-menu-greyed-out-productdb
Sheet: 08 Recessed Lights

EAD SKU # | Power, Watts | Items/cs | Weight, kg/Case | Cost Price, $ | Sell Price, Case | Image | Source
EA0801 | 3 | 24 | 8.5 | 4.6 |  |  | 7
EA0802 | 3 | 24 | 8.5 | 3.3 |  |  | 7
EA0803 | 3 | 24 | 8.5 | 4.8 |  |  | 7
EA0804 | 1 | 24 | 7 | 2.75 |  |  | 7
EA0805 | 6 | 24 | 16.5 | 10.6 |  |  | 7
EA0806 | 9 | 24 | 20.5 | 15.5 |  |  | 7
EA0807 | 7 | 24 | 22 | 8.9 |  |  | 7
EA0808 | 9 | 24 | 20.5 | 13.7 |  |  | 7 | 8
EA0809 | 15 | 24 | 16.5 | 19.2 |  |  | 7
EA0810 | 18 | 24 | 33 | 23.7 |  |  | 7
EA0811 | 3 | 24 | 8.5 | 4.9 |  |  | 7
EA0812 | 9 | 24 | 20.5 | 10.9 |  |  | 7
EA0813 | 12 | 24 | 18.5 | 30.6 |  |  | 7
EA0814 | 3 | 24 | 8.5 | 5.95 |  |  | 7
EA0815 | 7 | 24 | 22 | 11.1 |  |  | 7
EA0816 | 6 | 24 | 21 | 8.15 |  |  | 7
EA0817 | 7 | 24 | 22 | 8.6 |  |  | 7
EA0818 | 21 | 24 | 66 | 31.5 |  |  | 7
EA0819 | 12 | 24 | 42 | 15.8 |  |  | 7
EA0820 | 18 | 24 | 43 | 28.6 |  |  | 7
EA0821 | 15 | 24 | 16.5 | 25.7 |  |  | 7
EA0822 | 45 | 24 | 52 | 38.3 |  |  | 7
Spreadsheet: 004456cc-57a0-4443-87cf-59b327eeac79
Sheet: External

Transaction Activity Report
SD_DATRANSACT_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Transaction Identifiers |  | Location
Trading Interval | ISO-NE Schedule ID | Transaction Type | Originating Location ID | Originating Location Name | Originating Location Type | Destination Location ID | Destination Location Name | Destination Location Type | Delivered Amount | Up to Congestion
Hour End | Number | String | Number | String | String | Number | String | String | MWh | $/MWh
Spreadsheet: 736c27bc-5a2b-49ab-9683-18d78c67b071
Sheet: Sheet1

Title | Upload Date | Module | Authors | Print Publication Date | DOI | ISBN | Sub-discipline | LINK | Site Module Name
Chances and Choices | Sep-12 | Psychology of Music | Pitts | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199838752 | Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
Community Music | Sep-12 | Psychology of Music | [NAME] | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199777839 | Music, Ethnomusicology, World Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
Hearing in Time | Sep-12 | Psychology of Music | London | 2012 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780199744374 | Music, Psychology of Music, Theory, Analysis, Composition | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
MENC Handbook of Musical Cognition and Development | Oct-11 | Psychology of Music | Colwell | 2006 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195304565 | Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
Praxial Music Education | Jan-10 | Psychology of Music | [NAME] | 2009 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195385076 | Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
Psychology for Musicians | Oct-11 | Psychology of Music | [NAME], Sloboda, Woody | 2007 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195146103 | Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
The Science & Psychology of Music Performance | Oct-11 | Psychology of Music | Parncutt, [NAME] | 2002 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195138108 | Music, Psychology of Music | [NAME] | muspsy
Ways of Listening | May-08 | Psychology of Music | Clarke | 2005 | 10.1093/acprof:oso/[PHONE].001.0001 | 9780195151947 | Music, Psychology of Music | http://www.oxfordscholarship.com/view/10.1093/acprof:oso/[PHONE].001.0001/acprof-[PHONE] | muspsy
Spreadsheet: 91237d1290993682-display-multiple-texts-from-a-column-when-condition-a-and-b-are-met-how-to-display-multiple-texts-within-a-cell-in-col-c-when-2-conditions-are-met
Sheet: Example

 | Company | [NAME]? | Date Approved
 | Spring | Yes | 2010-10-31 00:00:00
 | Summer | Yes | 2010-09-26 00:00:00
 | Autumn | Yes | 2010-08-20 00:00:00
 | Winter | Yes | 2010-11-27 00:00:00
 | Water | Yes | 2010-09-15 00:00:00
 | Earth | Yes | 2010-09-17 00:00:00
 | Metal | Yes | 2010-08-17 00:00:00
 | Air | Yes | 2010-09-30 00:00:00
 | Fire | Yes | 2010-10-07 00:00:00
 | Red | Yes | 2010-07-27 00:00:00
 | Blue | Yes | 2010-06-09 00:00:00
 | White | Yes | 2010-10-05 00:00:00
 | Black | Yes | 2010-11-05 00:00:00
Total approved |  | 13
 | Monthly Total | Desired results in this exact format (multi lines within a cell)
June | 1 | Blue
July | 1 | Red
August | 2 | Autumn, Metal
September | 4 | Summer Water, Earth, Air
October | 3 | Spring, Fire, White
November | 2 | Black Winter
Total | 13
Spreadsheet: f765e806-e312-447c-acab-a6348ddda8ef
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] I/Dresden II - Bautzen II - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 90143 | 100037 | 108753 | 111487
20 - 40 | 178966 | 171995 | 161128 | 147728
40 - 60 | 150759 | 148568 | 153358 | 156427
60 - 80 | 125026 | 127424 | 122944 | 128290
80 und mehr | 31944 | 36642 | 48332 | 53520
Insgesamt | 576838 | 584666 | 594515 | 597452
%
unter 20 | 15.62709114170703 | 17.11011072988681 | 18.29272600354911 | 18.660411212951
20 - 40 | 31.02534853806441 | 29.4176504192137 | 27.10242802957033 | 24.72633784806143
40 - 60 | 26.13541410239964 | 25.41074733266515 | 25.79548034952861 | 26.18235439834497
60 - 80 | 21.67436958036745 | 21.79432359672018 | 20.67971371622247 | 21.47285472305725
80 und mehr | 5.537776637461471 | 6.267167921514163 | 8.129651901129492 | 8.958041817585345
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 91289d1291057457-if-any-numbers-repeat-off-duty-details-equalization-form-sample
Sheet: Page 2

 |  |  | Company Name
 |  |  | Company Phone Number
 |  |  | Company FAX Number
 |  |  | Contact date/Person:
 |  |  | [NAME] Number:
 |  |  | Date of Detail
 | Units Assigned:
(C = Cancelled [NAME])
(NUA = No Units Available)
Units Contacted -No Answer
Date Billed / Total Hours
Payment Received
HP-125 Received
Sign Up Sheet Posted
Units Signed Up on Sheet
If Cancelled, enter date of cancellation:
Employee | Date appointed [NAME]. | Phone | [NAME]. No.
 |  |  |  | Response | Number | Response | Number | Response | Number | Response | Number | Response | Number
 |  |  | 14 |  |  | I | 13 |  | 0
 |  |  | 6 |  |  | I | 5 |  | 0
 |  |  | 12 |  |  | I | 11 |  | 0
 |  |  | 4 |  |  | I | 3 |  | 0
 |  |  | 5 |  |  | I | 4 |  | 0
 |  |  | 16 |  |  | I | 15 |  | 0
 |  |  | 9 |  |  | I | 8 |  | 0
 |  |  | 10 |  |  | I | 9 |  | 0
 |  |  | 15 |  |  | I | 14 |  | 0
 |  |  | 13 |  |  | I | 12 |  | 0
 |  |  | 1 |  |  | I | 18 |  | 1
 |  |  | 7 |  |  | I | 6 |  | 0
 |  |  | 11 |  |  | I | 10 |  | 0
 |  |  | 2 |  |  | I | 1 |  | 18
 |  |  | 18 |  |  | I | 1 |  | 18
 |  |  | 17 |  |  | I | 16 |  | 0
 |  |  | 8 |  |  | I | 7 |  | 0
 |  |  | 3 |  |  | I | 2 |  | 0
Codes - A=Accepted [NAME]; D=Declined [NAME]; I=On-Duty, Training, Court, [NAME], OIL, CB, Dis, No Answer;  C=Detail Cancelled; N=No Units Available
Spreadsheet: 131187d1322776809-where-is-the-formula-book1
Sheet: Sheet1

Sum | Data
3 | 1 | 1 | 1
3 | 1 | 1 | 1
3 | 1 | 1 | 1
6 | 2 | 2 | 2
9 | 3 | 3 | 3
6 | 2 | 2 | 2
Spreadsheet: 80534d1280766550-matching-data-matching-data
Sheet: 2

Product/Client | Sales | Cost
Client 1
b | 100
d | 65
c | 30
a | 10
Client 2
a | 120
b | 80
d | 30
c | 12
Spreadsheet: 493872d1481921733-copy-data-while-skipping-rows-stat-sample
Sheet: Instructions

INSTRUCTIONS TAB
 | This Page
STATS TAB
 | Enter the Flight Name in B1
 | Enter the number of players per team in B3
 | Enter Stats beginning in column K. Each Match Card goes in it's own "Match" box even if it leaves blanks
TEAMS TAB
 | Paste Team Names & Ratings Starting In A2.
 | F2 computes the number of byes. The list starts in seeded order
 | Starting at the top of the list in column C, put in an x for teams getting a bye (based on the number in F2)
 | After adding the bye markers highlight all three columns and sort by column A. This will
 | put teams in alphabetical order by location name
PRINT STATS TAB
 | On the Stats Tab Left-Click on the number to the left of the team name
 | Drag down to the last row for that team - Five Rows (one is hidden)
 | Copy
 | Switch to the Print Stats tab
 | Click in cell A2
 | Right-Click and choose 'Paste Special'. Pick 'Values'
 | Click OK
 | Click the Office Button and choose 'Print'
RATING CHART TAB
 | O1 and Cricket Rating Chart
 | Can Be Printed
Spreadsheet: 675414d1588273472-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-lizsantiago07_demo
Sheet: DFster

Barnes, [NAME] | 1
[NAME], [NAME] | 2
Castillo, [NAME] | 3
CHARLES, SEPHORA STACY | 0
[NAME], [NAME] | 1
[NAME], [NAME] | 2
[NAME], Vanesa | 2
Gaviria - Henao, [NAME] | 3
Glinton, [NAME] | 3
[NAME], [NAME] | 0
Leal, [NAME] | 1
Lopez, [NAME] | 2
Martinez Tirado, Ixzel | 2
Matthews, Justice [NAME] | 3
Mies, [NAME] | 0
[NAME], [NAME] | 1
RODRIGUEZ, JESHUA NATHANIEL | 2
Roman, [NAME] | 3
VANBOXTEL, ISABELLA ROSE | 0
[NAME], [NAME] | 1
Zamora, Yarangely Orlanis | 2
Spreadsheet: 19bc9265-2bec-49e4-8bbd-1e769b9cab23
Sheet: Sheet1

Category | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD 2006-2007
Vols add
subscr. | 50 | 67 | 66 | 78 | 71 | 69 | 79 | 54 | 52 | 42 | 50 | 50 | 728
binding | 291 | 342 | 128 | 199 | 503 | 187 | 362 | 377 | 447 | 283 | 342 | 223 | 3684
firm ord | 308 | 197 | 348 | 454 | 447 | 359 | 450 | 388 | 273 | 267 | 206 | 14 | 3711
stand ord | 15 | 14 | 14 | 23 | 0 | 5 | 22 | 5 | 15 | 8 | 16 | 3 | 140
gifts | 120 | 534 | 849 | 148 | 4 | 37 | 188 | 279 | 42 | 11 | 4 | 253 | 2469
approvals | 404 | 162 | 156 | 200 | 214 | 222 | 202 | 202 | 184 | 299 | 301 | 0 | 2546
total | 1188 | 1316 | 1561 | 1102 | 665 | 879 | 1303 | 874 | 1013 | 910 | 919 | 543 | 12273
withdraw | 290 | 584 | 16 | 68 | 0 | 212 | 23 | 11 | 3 | 13 | 6 | 2 | 1228
Non-book
mfilm | 0 | 27 | 8 | 13 | 3 | 6 | 35 | 8 | 14 | 11 | 23 | 6 | 154
media | 33 | 8 | 40 | 107 | 112 | 25 | 10 | 11 | 96 | 31 | 17 | 0 | 490
III activity
bib new | 3 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 6
bib upd | 969 | 1370 | 827 | 944 | 892 | 1229 | 1056 | 1288 | 1073 | 656 | 915 | 824 | 12043
bib del | 179 | 106 | 41 | 36 | 33 | 126 | 33 | 124 | 13 | 17 | 33 | 11 | 752
item new | 561 | 244 | 279 | 337 | 246 | 150 | 470 | 759 | 336 | 468 | 1037 | 517 | 5404
item upd | 332 | 139 | 470 | 450 | 248 | 338 | 324 | 1127 | 568 | 406 | 780 | 649 | 5831
item del | 424 | 633 | 38 | 78 | 53 | 402 | 31 | 169 | 13 | 61 | 20 | 6 | 1928
ord new | 613 | 496 | 600 | 686 | 759 | 543 | 601 | 474 | 587 | 363 | 584 | 183 | 6489
ord upd | 1346 | 1273 | 1182 | 1170 | 959 | 735 | 1091 | 665 | 953 | 589 | 656 | 500 | 11119
[NAME] | 396 | 308 | 308 | 0 | 2 | 2 | 3 | 1 | 9 | 3 | 3 | 20 | 1055
checkin | 820 | 1386 | 1118 | 1327 | 1211 | 938 | 1421 | 1113 | 978 | 920 | 1369 | 990 | 13591
Cataloging
LC | 619 | 550 | 668 | 539 | 536 | 326 | 633 | 560 | 378 | 553 | 554 | 467 | 6383
edit | 347 | 481 | 414 | 301 | 263 | 210 | 497 | 335 | 202 | 205 | 310 | 272 | 3837
original | 146 | 143 | 401 | 248 | 105 | 117 | 123 | 136 | 96 | 175 | 137 | 106 | 1933
Inventory
bcod scan | 0 | 0 | 0 | 0 | 0 | 0 | 657 | 0 | 0 | 0 | 22 | 0 | 679
corr. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 51 | 133 | 74 | 66 | 372
item fnd | 25 | 6 | 0 | 0 | 0 | 0 | 1 | 18 | 5 | 4 | 3 | 7 | 69
no bcod | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 10 | 4 | 17 | 23 | 12 | 77
no item | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 13 | 11 | 11 | 16 | 91
Processing
Processing | 2090 | 2114 | 1193 | 1752 | 1026 | 538 | 1199 | 1394 | 739 | 979 | 1382 | 1372 | 15778
temp. bd | 338 | 409 | 0 | 1 | 16 | 0 | 1 | 130 | 47 | 135 | 31 | 25 | 1133
mend | 244 | 47 | 8 | 1 | 7 | 0 | 20 | 20 | 9 | 15 | 14 | 43 | 428
Spreadsheet: 61858d1262774383-water-tank-level-formula-last-5-days-water-tank-level-5-
Sheet: Numbers

Date Range Spanning 4 Days | Upper Water Level | Lower Water Level | 0
2010-01-01 00:00:00 | 50 | 80
2010-01-05 00:00:00 | 48 | 94
Average Change Per Day | -0.5 | 3.5
Projected Days Remaining | 96 | Surplus
Consecutive Entry Dates | Five Most Recent Water Level Entries Below
2010-01-01 00:00:00 | 50 | 80
2010-01-02 00:00:00 | 40 | 74
2010-01-03 00:00:00 | 60 | 71
2010-01-04 00:00:00 | 55 | 68
2010-01-05 00:00:00 | 48 | 94
Average Change Per Day | -0.5 | 3.5
Projected Days Remaining | 96 | Surplus
 | 96 | 96
Average level is based on 5 entries | Average 50.6 | Average 77.4
Date | Upper Water Level | Lower Water Level
2010-01-01 00:00:00 | 50 | 80
2010-01-02 00:00:00 | 40 | 74
2010-01-03 00:00:00 | 60 | 71
2010-01-04 00:00:00 | 55 | 68
2010-01-05 00:00:00 | 48 | 94
Spreadsheet: 126424d1319687442-referencing-a-non-integer-or-generating-a-consecutive-integer-example
Sheet: Sheet2

1 |  | Column A is the goal of the formula generation.
2 | [NAME] should begin here.
3
4
5
6
7
7.8
9
10
11
12
12.35
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 714091d1611084988-formula-for-recognising-dates-between-and-outside-a-range-of-start-and-end-times-monthly-staff-costs-projections
Sheet: Monthly Staff Costs

MONTHLY STAFF COSTS
 |  |  |  |  | PROBLEM = I won't know an employees END DATE? How to make this formula work for BLACK spaces in the END DATE input?
 |  |  | START | END | [NAME] | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | YEAR
PARTNER SALARY COSTS
 |  |  |  | 2021-11-30 00:00:00 | 100
 |  |  |  | 2021-12-31 00:00:00 | 100
 |  |  | 2021-12-01 00:00:00 |  | 100
 |  |  |  |  | 100
Spreadsheet: 268503d1380658277-average-last-three-number-with-vlookup-example-excel-sheet
Sheet: Data

Name | Date | Amount
A | 2013-10-01 00:00:00 | 24
A | 2013-10-02 00:00:00 | 7
A | 2013-10-03 00:00:00 | 12
A | 2013-10-04 00:00:00 | 48
A | 2013-10-05 00:00:00 | 9
A | 2013-10-06 00:00:00 | 19 |  | Actual Last 3 Average
A | 2013-10-07 00:00:00 | 26
B | 2013-10-01 00:00:00 | 24
B | 2013-10-02 00:00:00 | 2
B | 2013-10-03 00:00:00 | 3
B | 2013-10-04 00:00:00 | 37
B | 2013-10-05 00:00:00 | 30
B | 2013-10-06 00:00:00 | 34
B | 2013-10-07 00:00:00 | 34
B | 2013-10-08 00:00:00 | 42 |  | Actual Last 3 Average
B | 2013-10-09 00:00:00 | 33
C | 2013-10-01 00:00:00 | 13
C | 2013-10-02 00:00:00 | 37
C | 2013-10-03 00:00:00 | 6
C | 2013-10-04 00:00:00 | 23
C | 2013-10-05 00:00:00 | 46
C | 2013-10-06 00:00:00 | 24
C | 2013-10-07 00:00:00 | 24
C | 2013-10-08 00:00:00 | 28 |  | Actual Last 3 Average
C | 2013-10-09 00:00:00 | 32
Spreadsheet: 888130d1738565947-extract-multiple-employee-id-based-on-project-name-from-one-sheet-to-another-using-formula-punnam-sample-350-spill-365-aligw
Sheet: Required 

 | Project-1 | Name-1 | Name-3 | Name-6
2 | Project-2 | Name-1 | [NAME] | Name-5
3 | Project-3 | Name-1 | Name-3
4 | Project-4 | Name-4
5 | Project-5 | [NAME] | Name-4 | Name-5
6 | Project-6 | Name-4 | Name-6
7 | Project-8 | Name-6
8 | Project-9 | Name-3 | Name-6
9 | Project-10 | [NAME] | Name-3 | Name-4 | Name-5
10 | Project-11 | [NAME] | Name-5
11 | Project-12 | Name-7 | Name-8
12 | Project-13 | Name-8
Spreadsheet: 136836d1326838540-count-formula-question-excel
Sheet: Sheet1

Birmingham
Date | H/A | Opposition | Ranking | Team Goals | Opposition Goals | 1st Half Team Goals | 1st Half Opp Goals | 2nd Half Team Goals | 2nd Half Opp Goals | Points | Half with Most Goals | Over 2.5 Goals | Total Goals | BTS | [NAME]
1 | A | Derby County |  | 1 | 2 | 1 | 2
2 | H | Coventry City |  | 1 | 0 | 0 | 0
3 | H | Burnley
4 | A | Middlesbrough |  | 1 | 3 | 1 | 0
5 | A | Watford |  | 2 | 2 | 1 | 0
6 | H | Millwall |  | 3 | 0 | 1 | 0
7 | A | Southampton |  | 1 | 4 | 0 | 3
8 | H | Barnsley |  | 1 | 1 | 0 | 1
9 | H | [NAME] |  | 0 | 1 | 0 | 1
10 | A | Nottm Forest |  | 3 | 1 | 0 | 1
11 | H | Leicester City |  | 2 | 0 | 0 | 0
12 | A | Hull City |  | 1 | 2 | 1 | 0
13 | A | Bristol City |  | 2 | 0 | 1 | 0
14 | H | Brighton |  | 0 | 0 | 0 | 0
15 | H | Ipswich Town |  | 0 | 1 | 0 | 0
16 | A | Reading |  | 0 | 1 | 0 | 1
17 | H | Peterborough |  | 1 | 1 | 1 | 0
18 | A | Blackpool |  | 2 | 2 | 1 | 1
19 | H | Portsmouth |  | 0 | 1 | 0 | 0
20 | A | Cardiff City |  | 0 | 1 | 0 | 0
21 | H | Doncaster |  | 2 | 1 | 0 | 0
22 | A | Crystal Palace |  | 0 | 1 | 0 | 0
23 | H | West Ham Utd |  | 1 | 1 | 0 | 1
24 | H | Blackpool |  | 3 | 0 | 1 | 0
25 | A | Peterborough |  | 1 | 1 | 0 | 1
26 | A | Millwall
27 | H | Watford
28 | A | [NAME]
29 | H | Southampton
30 | A | Barnsley
31 | H | Hull City
32 | A | Leicester City
33 | H | Nottm Forest
34 | H | Derby County
35 | A | Burnley
36 | A | Coventry City
37 | H | Middlesbrough
38 | A | Portsmouth
39 | H | Cardiff City
40 | A | Doncaster
41 | H | Crystal Palace
42 | A | West Ham Utd
43 | H | Bristol City
44 | A | Ipswich Town
45 | A | Brighton
46 | H | Reading
- |  |  | -
Spreadsheet: 882848d1731335124-stock-file-stock-file-jt-
Sheet: Sheet1

 |  |  | Item Code | Opening | Purchase | Sales | Closing
 |  |  | A. Junior 1 | 32 | 0 | 18 | 14 |  | 1) All values should be - Summarize Values By: Sum
 |  |  | B. Junior 2 Reg | 46 | 0 | 0 | 46 |  | 2) To ensure borders "stick" to the PivotTable > PivotTable Tools > Design > PivotTable Styles > Modify > Whole Table > Format > all borders
 |  |  | C. Junior 2 | 4 | 20 | 6 | 18
 |  |  | D. Junior 3 | 6 | 20 | 0 | 26
 |  |  | E. Junior 4 | 4 | 12 | 0 | 16
 |  |  | F. Foundation 1 | 96 | 0 | 4 | 92
 |  |  | G. Foundation 2 | 9 | 54 | 0 | 63
 |  |  | H. Foundation 3 | 0 | 0 | 0 | 0
 |  |  | I. Foundation 4 | 6 | 0 | 21 | -15
 |  |  | [NAME] | 6 | 9 | 0 | 15
 |  |  | [NAME] | 0 | 15 | 3 | 12
 |  |  | [NAME] 3 | 6 | 6 | 4 | 8
 |  |  | [NAME] 4 | 0 | 0 | 0 | 0
 |  |  | N.GMA | 4 | 0 | 4 | 0
 |  |  | O.GMB | 0 | 0 | 4 | -4
 |  |  | P.GMC | 4 | 0 | 4 | 0
 |  |  | Q.Bag | 28 | 0 | 0 | 28
 |  |  | R.Abacus | 28 | 0 | 0 | 28
 |  |  | S.Pouch | 28 | 0 | 0 | 28
 |  |  | [NAME] | 28 | 0 | 0 | 28
 |  |  | U.Dic Green | 22 | 0 | 0 | 22
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C17

Local 12
Nom:
Numéro de téléphone:
[NAME]:
Paiement dû le:
[NAME]:
Réservé:
Prix:
Payé: | NON
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 271f973a-7c29-41f2-a2eb-fa612eab09ab
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Miss.SW |  |  |  | GRAND CHAMPIONSHIPS
[NAME] | SAT |  |  |  | Division: Intermediate II
 | 9:00 AM    6
FRI | D2
6:30 PM    1 |  |  |  |  | Location: Milverton
D1
 |  | SAT |  |  | Date: July 27-29, 2012
Ajax |  | 3:00 PM   11
 |  | D1 |  |  | Diamonds: Arand - D1, D2
Windsor
FRI |  |  |  |  | (name of park revised - 6/29/2012)
6:30 PM    2
D2
[NAME] |  |  | SAT
 | Milverton |  | 7:00 PM  15
 |  |  | D1
 | SAT
 | 9:00 AM    5
 | D1
 | Mitchell
Nia. Falls |  | SAT
 |  | 5:00 PM  13
FRI |  | D1
8:30 PM   3
D1
Ancaster | SAT
 | 11:00 AM  7
Pickering | D1
FRI
8:30 PM   4 |  |  |  |  | SUN
D2 |  |  |  |  | 1:00 PM  20
 |  |  |  |  | D1
St. Catharines
 | Loser 7
 | SAT
Loser 1 | 3:00 PM  12 |  |  | Loser 15 |  | SUN
SAT | D2 | SAT |  |  |  | 3:00 PM      21
11:00 AM   8 |  | 9:00 PM  16 |  |  |  | D1
D2 |  | D1 |  | SUN
Loser 2 |  | Loser 11 |  | 11:00 AM  19
 |  |  |  | D1
Loser 3 |  |  | SUN
SAT |  |  | 9:00 AM  18
1:00 PM     9 |  |  | D1
D1 |  |  |  |  |  | (if first loss)
Loser 4 |  |  |  |  |  | Loser 20
 | SAT 5:00 PM  14
Loser 5 | D2 | SAT
SAT |  | 9:00 PM  17
1:00 PM   10 |  | D2
D2 |  | Loser 13
Loser 6
Spreadsheet: 742031d1627482798-unique-values-with-criteria-example
Sheet: Updated Template

Job # | 1919011. |  | Job Descriptions |  | Goal: | Referencing the job # in cell B5 and refrenching in column E of the LaborDetail sheet, I'm trying to pull in every unique job description that is showing for this job #.
Spreadsheet: 207029d1358350159-compile-non-empty-cells-into-one-column-excel-question
Sheet: Sheet1

 |  |  | Section A | Section B | Section C | Section D | Section E |  | All Sections
 |  | length | 9 | 22 | 3 | 16 | 35 |  | 85
 |  | Increment | 1 | 2 | 1 | 4 | 7
 |  |  | 0 | 11 | 32 | 38 | 57 |  | 0
 |  |  | 1 | 13 | 33 | 42 | 64 |  | 1
 |  |  | 2 | 15 | 34 | 46 | 71 |  | 2
 |  |  | 3 | 17 |  | 50 | 78 |  | 3
 |  |  | 4 | 19 |  |  | 85 |  | 4
 |  |  | 5 | 21 |  |  |  |  | 5
 |  |  | 6 | 23 |  |  |  |  | 6
 |  |  | 7 | 25 |  |  |  |  | 7
 |  |  | 8 | 27 |  |  |  |  | 8
 |  |  | 9 | 29 |  |  |  |  | 9
 |  |  |  | 31 |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  | 85