tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693223d1598871666-filter-and-sort-out-a-list-into-data-input-sheet-except-a-blank-cells-copy-of-resource-sheet
Sheet: Input Sheet

S.No. | Activity Description | Qty. Prod. assumed per day | UOM | Remarks
1
 | 2000 Pile
 | Load Test
 | Modular Wall
 | Pier erect scaffold
 | Pile [NAME]
 | Pile Cap Concreting
 | Pile Cap Deshuttering/Curing
 | Pile Cap Excavation
 | Pile [NAME]
 | Pile Cap Steel Fixing
 | Pile [NAME] Stage 1
 | Pile Cap Waterproofing Stage 2
 | Pile Head Preparation
 | RCC Wall
 | [NAME] (all activities)
 | [NAME]
 | RCC Wall Excavation
 | RCC WP
 | [NAME]
 | Soil Nail
 | Traffic Diversion
 | Utility
Spreadsheet: 135974d1326347638-if-statement-new-to-excel-and-this-forum-book2
Sheet: What i am trying to do

2012-01-16 00:00:00
Name | Present | Month
[NAME] | Yes | 2012-01-16 00:00:00
[NAME] | Yes | 2012-01-16 00:00:00
[NAME] | No
2012-01-17 00:00:00
Name | Present | Month
[NAME] | Yes | 2012-01-17 00:00:00
2012-01-18 00:00:00
Name | Present | Month
[NAME] | No
[NAME] | Yes | 2012-01-18 00:00:00
Spreadsheet: 741978d1627468405-if-formula-searching-for-text-dinner-bookings
Sheet: Pete_uk

Name | Class | Main | Absent | Home Sandwiches | Main 1 | Vegetarian | Jacket Potato | Choice
Fred | 1 | Home Sandwiches
[NAME] | 1 | Sausage & Mash
[NAME] | 1 | Sausage & Mash
[NAME] | 1
Annabelle | 1 | Sausage & Mash
Sky | 1 | Home Sandwiches
[NAME] | 1 | Sausage & Mash
Sophie | 1 | Home Sandwiches
[NAME] | 1 | Home Sandwiches
[NAME] | 1 | Sausage & Mash
Isabelle | 1 | Home Sandwiches
May | 1 | Sausage & Mash
Ella | 1 | Sausage & Mash
[NAME] | 1 | Home Sandwiches
[NAME] | 1
Lloyd | 1 | Sausage & Mash
George | 1
Spreadsheet: 769366d1645511490-highlight-a-cell-when-two-dates-overlap-excelforum22feb
Sheet: Sheet1

 | Current Date Today |  | Preferred display of highlight dates
 |  |  |  | Current Date Today
Starting date at work | 3 months after the starting date
2021-07-05 00:00:00 |  |  | Starting date at work | 3 months after the starting date
2016-04-01 00:00:00 |  |  | 2021-07-05 00:00:00
2016-01-01 00:00:00 |  |  | 2016-04-01 00:00:00
2015-11-01 00:00:00 |  |  | 2016-01-01 00:00:00
2014-01-01 00:00:00 |  |  | 2015-11-01 00:00:00
2019-10-01 00:00:00 |  |  | 2014-01-01 00:00:00
2019-02-01 00:00:00 |  |  | 2019-10-01 00:00:00
2020-07-01 00:00:00 |  |  | 2019-02-01 00:00:00
2021-08-01 00:00:00 |  |  | 2020-07-01 00:00:00
2021-03-01 00:00:00 |  |  | 2021-08-01 00:00:00
2020-11-02 00:00:00 |  |  | 2021-03-01 00:00:00
2021-03-01 00:00:00 |  |  | 2020-11-02 00:00:00
2021-08-23 00:00:00 |  |  | 2021-03-01 00:00:00
2021-08-28 00:00:00 |  |  | 2021-08-23 00:00:00
2022-01-01 00:00:00 |  |  | 2021-08-28 00:00:00
2022-02-01 00:00:00 |  |  | 2022-01-01 00:00:00
2022-01-14 00:00:00 |  |  | 2022-02-01 00:00:00
2022-01-13 00:00:00 |  |  | 2022-01-14 00:00:00
2010-12-01 00:00:00 |  |  | 2022-01-13 00:00:00
2012-01-01 00:00:00 |  |  | 2010-12-01 00:00:00
2014-07-01 00:00:00 |  |  | 2012-01-01 00:00:00
2014-04-01 00:00:00 |  |  | 2014-07-01 00:00:00
2014-01-01 00:00:00 |  |  | 2014-04-01 00:00:00
2017-08-01 00:00:00 |  |  | 2014-01-01 00:00:00
2011-10-01 00:00:00 |  |  | 2017-08-01 00:00:00
2018-04-28 00:00:00 |  |  | 2011-10-01 00:00:00
 |  |  | 2018-04-28 00:00:00
Spreadsheet: 852653d1702609684-formula-to-locate-data-in-the-same-column-but-on-different-rows-and-place-data-ina-new-sheet-addressbookreport
Sheet: Data

Address Book Report
Name:
Organization:
Speciality:
Title |  | First Name | [NAME] | Family Name |  |  |  |  |  | [NAME] | +xxxxxxxxxx | office@xxxxx
[NAME] |  | Council No. |  | Affiliation |  | Specialty |  |  | JKL Company | [NAME] | +xxxxxxxxxx | reception@xxxx
Organization | ABC Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax |  |  | XYZ Company | [NAME] | +xxxxxxxxxx
Healthlink Mailbox |  | [NAME] | office@xxxxx | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Title |  | First Name | [NAME] | Family Name
[NAME] |  | Council No. |  | Affiliation |  | Specialty
Organization | JKL Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax | 67594297
Healthlink Mailbox |  | [NAME] | reception@xxxx | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Title |  | First Name | [NAME] | Family Name
[NAME] |  | Council No. |  | Affiliation |  | Specialty
Organization | XYZ Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax | 92381973
Healthlink Mailbox |  | [NAME] |  | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Requested Outcome to display like this
Spreadsheet: 686583d1594698780-stock-allocation-example-1-4-
Sheet: Sheet1

 | Stock |  |  |  | Rank |  |  |  |  |  |  |  |  |  |  | Qty to Fulfill
Code | WH1 | WH2 | WH3 |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10 |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10
K-123 | 4 | 3 | 1 |  | 1 | 2 | 6 | 4 | 5 | 3 | 8 | 7 | 9 | 10 |  | 2 | 3 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0
[NAME] | 5 | 2 | 4 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K-125 | 4 | 1 | 2 |  | 2 | 3 | 4 | 5 | 6 | 1 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
[NAME] | 2 | 0 | 0 |  | 4 | 5 | 6 | 1 | 2 | 3 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
K-127 | 1 | 0 | 0 |  | 3 | 4 | 5 | 6 | 2 | 1 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0
INPUT |  |  |  |  |  |  |  |  | WH STOCK |  |  |  |  |  |  | Qty left
 |  |  |  |  |  |  |  |  | BEGGINNING |  |  | ENDING |  |  |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10
CODE | FROM | TO | QTY |  |  |  |  |  | WH1 | WH2 | WH3 | WH1 | WH2 | WH3
Expected
CODE | FROM | TO | QTY
K-123 | WH1 | Store 1 | 2
K-123 | WH1 | Store 2 | 2
K-123 | WH2 | Store 2 | 1
K-123 | WH2 | Store 6 | 2
K-123 | WH3 | Store 6 | 1
[NAME] | WH1 | Store 1 | 5
[NAME] | WH2 | Store 1 | 1
K-125 | WH1 | Store 6 | 2
[NAME] | WH1 | Store 4 | 1
[NAME] | WH1 | Store 5 | 1
K-127 | WH1 | Store 6 | 1
Spreadsheet: 758603d1638968156-taking-the-higher-value-from-a-list-based-on-criteria-hours-adjustment
Sheet: Sheet1

ID | Date | Department | ID & Date | Hours | Hours Max |  |  |  |  | Department | Rate Hourly
1057054 | 2021-07-01 00:00:00 | Sales |  | 10 |  |  |  |  |  | HR | 21
1057054 | 2021-07-01 00:00:00 | HR |  | 10 |  |  |  |  |  | Sales | 23
1638281 | 2021-07-25 00:00:00 | IT |  | 8 |  |  |  |  |  | Business development | 24
1057054 | 2021-07-01 00:00:00 | IT |  | 5 |  |  |  |  |  | IT | 27
1945479 | 2021-07-15 00:00:00 | Sales |  | 5
1852509 | 2021-07-18 00:00:00 | Business development |  | 5
1726381 | 2021-07-10 00:00:00 | IT |  | 2
1852509 | 2021-07-18 00:00:00 | HR |  | 10
1057054 | 2021-07-01 00:00:00 | Business development |  | 3
1945479 | 2021-07-15 00:00:00 | HR |  | 12
Spreadsheet: kate_symes__18896__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-21 00:00:00 |  | 441.52 | 3680 | 243.61 | 720
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560 | 483.98 | 1040 | 363.65 | 1000
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | 2001-03-10 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 294.74 | 950 | 265.54 | 925
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 366.94 | 1070 | 296.17 | 1600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 266766d1379720985-aggregate-the-time-data-mm-dd-yyyy-hh-mm-ss-into-the-3-hours-range-frequency
Sheet: Sheet1

Array | Bins | Frequency
2013-08-09 23:46:41 | 2013-09-08 00:00:00 |  |  | 2013-08-09 03:00:00 | 0
2013-08-09 23:50:19 | 2013-09-08 03:00:00 | 0 |  | 2013-08-09 06:00:00 | 0
2013-08-09 23:50:46 | 2013-09-08 06:00:00 | 0 |  | 2013-08-09 09:00:00 | 0
2013-09-09 00:27:04 | 2013-09-08 09:00:00 | 0 |  | 2013-08-09 12:00:00 | 0
2013-09-09 00:45:20 | 2013-09-08 12:00:00 | 0 |  | 2013-08-09 15:00:00 | 0
2013-09-09 00:45:21 | 2013-09-08 15:00:00 | 0 |  | 2013-08-09 18:00:00 | 0
2013-09-09 00:45:21 | 2013-09-08 18:00:00 | 0 |  | 2013-08-09 21:00:00 | 0
2013-09-09 00:45:21 | 2013-09-08 21:00:00 | 0 |  | 2013-08-10 00:00:00 | 3
2013-09-09 00:45:21 | 2013-09-09 00:00:00 | 0 |  | 2013-09-09 03:00:00 | 13
2013-09-09 00:45:21 | 2013-09-09 03:00:00 | 13 |  | 2013-09-09 06:00:00 | 0
2013-09-09 00:45:21
2013-09-09 00:45:21
2013-09-09 00:45:21
2013-09-09 00:45:21
2013-09-09 00:45:21
2013-09-09 00:45:21
Spreadsheet: 07e1b4e3-21f1-4eb4-9ff7-9635d077dcb0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Mr. [NAME]'s Personalised Introductions | Unnamed: 4 | Unnamed: 5
 |  |  | THE CHOICES BELOW IN YELLOW ARE ONE'S THAT
 |  |  | ARE COMMONLY PICKED OR HAVE BEEN USED OFTEN
Pick from one of the following or if you have your own idea and or cd, let us know
STAR WARS-EMPIRE STRIKES BACK-RETURN OF THE JEDI-PHANTOM MENACE
STAR TREK
[NAME]
ANDY GRIFFITH
AT LEAST 20 DIFFERENT WWF-WCW-NWO WRESTLING THEMES
A-TEAM
BATMAN |  |  |  |  | ADAM-12
BEAUTIFUL DAY-(BY U2) |  |  |  |  | ADAMS FAMILY
BLUES BROTHERS |  |  |  |  | AUSTIN POWERS
BONANZA |  |  |  |  | BEVERLY HILLBILLIES
CHICAGO BULLS |  |  |  |  | FAR & AWAY
DALLAS |  |  |  |  | GET SMART
[NAME] |  |  |  |  | GREEN ACRES
DYNASTY |  |  |  |  | LOST IN SPACE
E.T. |  |  |  |  | MASH
FAT ALBERT |  |  |  |  | MUNSTERS
GILLIGANS ISLAND |  |  |  |  | [NAME]
[NAME] |  |  |  |  | WECOME BACK KOTTER
GREATEST AMERICAN HERO
HILL STREET BLUES
HOOK-PETER PAN
[NAME] BOND-007
JURASIC PARK-FLINSTONES |  |  |  |  | HAVE A QUESTION?
L.A.LAW |  |  |  |  | JUST GIVE US A CALL AT 815-690-MRDJ
LE'TS GET THE PARTY STARTED-(BY PINK) |  |  |  |  | OR E-MAIL US AT [EMAIL]
MEN IN BLACK
MISSION IMPOSSIBLE |  |  |  |  | WE DO HAVE MORE JUST ASK
OLIMPIC FANFARE-GYMNASTIC THEME |  |  |  |  | 50's-60's & 70's TV HITS & MOVIES TOO
OVER 10 DIFFERENT HALLOWEEN THEMES |  |  |  |  | AND OF COARSE SONG TITLES,
[NAME]
PINK PANTHER
PULP FICTION
RAIDERS OF THE LOST ARC
ROMEO & JULIET
SAVING PRIVATE RYAN
SCOOBY DOO
SECRET ANGENT MAN
[NAME] OF FIRE
SUPERMAN
TITANIC-JAWS
TOP GUNN
WE LIKE TO PARTY-(BY THE VEGA BOYS)
Spreadsheet: 857289d1706293099-conditional-formatting-excel-help-conditional-formatting-template
Sheet: Sheet1

Follow Up | State | Client Name | CAR
 | WY | [NAME], [NAME] | 2023-01-22 00:00:00
 | WY | Jordan, [NAME] | 2021-11-12 00:00:00
 | WY | [NAME], [NAME] | 2023-02-12 00:00:00
 | WY | [NAME], [NAME]
 | WY | Doe, [NAME] | 2024-01-10 00:00:00
 | WY | [NAME], [NAME]
 | WY | Gump, Forest | 2022-10-11 00:00:00
Spreadsheet: 67523d1268139962-excel-2007-macro-help-copy-from-one-sheet-to-another-regnskab-revideret
Sheet: Jan. FP Income

Code | Account | Description | VAT % | Net £ | VAT £ | Gross £
12 | 1245 | Church Magazine | 17.5 | 10 | 1.75 | 11.75 |  | Test Row
 |  |  |  |  |  |  |  | NB!  The information entered in row 3 from "Jan. Income" sheet is copied into the first available row on this sheet.
 |  |  |  |  |  |  |  | Row 2 has the information that was entered in row 3.
Total
 | Bank | Cash | Credit Card
Income
Expenses
[NAME]
Spreadsheet: kevin_ruscitti__20264__NSS 2001 Rights
Sheet: RFP Responses

enovate Field Area Balancing Service Proposal Responses
Company | Contact | Bid | Total Dollars | Unit Price | MSV | Term | Location | Notification | fuel | Negative Balance | Other terms
PGE | [NAME] | .08/mo |  |  | 1000000 | April - October | LA | 10:00:00 | 0.017 | no
Nicor Exchange | [NAME] | 0.4 |  |  | 1000000 | April - December | TexOK (East) | 10:45:00 | 0.017 | no | .02 /MMBtu for volumes nominated after 10:45 deadline
Duke | [NAME] | .02/mo |  |  | 1000000 | April - October | LA | 10:00:00 | 0.017 | no
Cinergy |  | 0.1 |  |  | 1000000 | April - October | LA | 10:00:00 | 0.017 | no | may add incremental value for Nov-Dec and negative balance
Sempra | [NAME] | 0.08 | 80000 |  | 1000000 | April - October | LA | 10:00:00 | 0.017 | yes
Conoco | [NAME] | 0.05 |  |  | 1000000 | April - October | STX | 10:00:00 | 0.017 | no
enovate Field Area Summary
Company | Contact | Bid | Total Dollars | Unit Price | MSV | Term | Location | Notification | fuel | Negative Balance | Other terms
PGE | [NAME] | .08/mo |  |  | 1000000 | April - October | LA | 10:00:00 | 0.017 | no
Nicor Exchange | [NAME] | 0.4 | 165000 |  | 500000 | April - December | TexOK (East) | 10:45:00 | 0.017 | no
Coral | [NAME] | .02/mo | 400000 |  | 1000000 | April - December | LA | 10:30:00 | 0.017 | no
Spreadsheet: 758927d1639156845-distribution-of-values-up-to-10-quoziente
Sheet: Foglio1

 |  |  |  | 15 | 23 | 32 | 36 | 33 | 19 | 14
1
1
1
1
2
1
3
1
2
1
1
1
1
Spreadsheet: 686442d1594632133-timesheet-have-few-problem-ldc-tms
Sheet: new

DATE | DAY | SHIFT | TIME |  | BREAKS | SHIFT DETAILS |  |  |  | OVER TIME |  | ALLOWANCE |  | REASON |  | DATE | DAY | SHIFT | TIME |  | BREAKS | SHIFT DETAILS |  |  |  | OVER TIME |  | ALLOWANCE |  | REASON
 |  |  | IN | OUT |  | NORMAL | LATE | EARLY OUT | ACTUAL | OT 1.5 | OT 2.0 | INCENTIVE | MEAL |  |  |  |  |  | IN | OUT |  | NORMAL | LATE | EARLY OUT | ACTUAL | OT 1.5 | OT 2.0 | INCENTIVE | MEAL
3076 | B72 |  |  |  | NAME : |  |  |  |  |  | PERIOD : 01-03-2020 TO 30-03-2020 |  |  |  |  | 3076 | B72 |  |  |  | NAME : |  |  |  |  |  | PERIOD : 01-03-2020 TO 30-03-2020
2020-03-01 00:00:00 | SUNDAY | MOR | 06:32:00 | 17:02:00 | 1 | - | - | - |  | - |  | - | - |  |  | 2020-03-01 00:00:00 | SUNDAY | MOR | 06:32:00 | 17:02:00 | 1 | - | - | - | 8 | - |  | - | -
2020-03-02 00:00:00 | MONDAY | MOR | 08:00:00 | 15:29:00 | 1 |  | - | 1.52 |  |  | - | - | - |  |  | 2020-03-02 00:00:00 | MONDAY | MOR | 08:00:00 | 15:29:00 | 1 | 6.48 | - | 1.52 | 6.48 | - | - | - | -
2020-03-03 00:00:00 | TUESDAY | MOR | 07:23:00 | 22:00:00 | 1 |  | - | - |  |  | - | - | 3 |  |  | 2020-03-03 00:00:00 | TUESDAY | MOR | 07:23:00 | 22:00:00 | 1 |  | - | - | 13 | 5 | - | - | 3
2020-03-04 00:00:00 | WEDNESDAY | MOR | 08:00:00 | 17:00:00 | 1 |  | - | - |  |  | - | - | - |  |  | 2020-03-04 00:00:00 | WEDNESDAY | MOR | 08:00:00 | 17:00:00 | 1 |  | - | - | 8 | - | - | - | -
2020-03-05 00:00:00 | THURSDAY | MOR | 07:50:00 | 17:15:00 | 1 |  | - | - |  |  | - | - | - |  |  | 2020-03-05 00:00:00 | THURSDAY | MOR | 07:50:00 | 17:15:00 | 1 |  | - | - | 8 | - | - | - | -
2020-03-06 00:00:00 | FRIDAY | NIG | 19:15:00 | 05:16:00 | 1 |  | - | - |  |  | - | - | - |  |  | 2020-03-06 00:00:00 | FRIDAY | NIG | 19:15:00 | 05:16:00 | 1 | 8 | - | - | 8 | - | - | - | -
2020-03-07 00:00:00 | SATURDAY | NIG | 21:00:00 | 07:00:00 | 1 |  | - | - |  |  | - | - | - |  |  | 2020-03-07 00:00:00 | SATURDAY | NIG | 21:00:00 | 07:00:00 | 1 | 8 | - | - | 8 | 1 | - | - | -
2020-03-08 00:00:00 | SUNDAY | MOR |  |  |  | - | - | - |  | - | - | - | - | REST |  | 2020-03-08 00:00:00 | SUNDAY | MOR |  |  |  | - | - | - | - | - | - | - | - | REST
2020-03-09 00:00:00 | MONDAY | NIG | 20:53:00 | 04:32:00 | 1 |  | - | 0.47 |  |  | - | - | - |  |  | 2020-03-09 00:00:00 | MONDAY | NIG | 20:53:00 | 04:32:00 | 1 | 7.53 | - | 0.47 | 7.53 | - | - | - | -
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | a) Punch in earlier than 8:00 / 21:00 doesn't count as overtime.
 | b) Actual time have to deduct 1 hour for the lunch break.
 | c) Night shift normal hour formula have problem.
 | d) Overtime worker more than 6 hour will entitle for $3.00 meal allowance.
Spreadsheet: 816628d1675755861-how-do-i-stack-multiple-columns-into-one-column-in-excel-365-mac-transpose
Sheet: Sheet2

Column1 | Column2 | Column3 |  |  | Value
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | Mark | [NAME] |  |  | [NAME]
[NAME] | [NAME] | George |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Mark
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | George
Spreadsheet: 880236d1727868963-help-with-vertical-to-horizontal-sorting-sorting-help
Sheet: Sheet1

 | Table 1 |  |  | Table 2
 | Part # | Gauge |  | Part # | Gauge
 | 1 | A |  | 1 | A | B | C | D
 | 1 | B |  | 2 | A | B | C | D
 | 1 | C |  | 3 | A | B | C
 | 1 | D |  | 4 | A | B | C | D
 | 2 | A |  | 5 | A | B | C | D
 | 2 | B |  | 6 | A | B | C | D | E
 | 2 | C |  | 7 | A | B | C | D
 | 2 | D |  | 8 | A | B | C | D
 | 3 | A |  | 9 | A | B | C | D
 | 3 | B |  | 10 | A | B
 | 3 | C |  | 11 | A | B | C | D | E | F
 | 4 | A
 | 4 | B
 | 4 | C
 | 4 | D
 | 5 | A
 | 5 | B
 | 5 | C
 | 5 | D
 | 6 | A
 | 6 | B
 | 6 | C
 | 6 | D
 | 6 | E
 | 7 | A
 | 7 | B
 | 7 | C
 | 7 | D
 | 8 | A
 | 8 | B
 | 8 | C
 | 8 | D
 | 9 | A
 | 9 | B
 | 9 | C
 | 9 | D
 | 10 | A
 | 10 | B
 | 11 | A
 | 11 | B
 | 11 | C
 | 11 | D
 | 11 | E
 | 11 | F
Spreadsheet: 161278d1339468640-excel-2007-return-values-from-different-worsheets-according-to-month-and-data-list-sample
Sheet: ESTSR

[NAME]
HOJA DE NOTAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | agosto
ESCUELA : |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | septiembre
GRUPO: |  | 2ndo R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | octubre
MAESTRO: |  | [NAME] |  |  |  |  |  | Firma del padre o encargado |  |  |  |  |  |  | _____________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | noviembre
CLASE DE: |  | Ingles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | diciembre
HORA: |  |  |  |  |  |  |  | Entregado en la libreta en la fecha: |  |  |  |  |  |  |  | ________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | enero
AÑO: |  | 2012-2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | febrero
Número del estudiante |  |  | 1 |  | [NAME]: | agosto |  |  | Nombre del Estudiante: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | marzo
Puntos Total de Trabajo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abril
[NAME] obtenida |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mayo
Puntos Total de Exam o Proyectos
[NAME] obtenida
Is it possible to select the month here    and have a formula to look for the values of a cell according to the date in the different worksheets?
For example, I have in N1SR, H11  a total of 10  for the month of august and I also have in N1SR, I11 another 10 pints both for august  so what I want is that if
I select "agosto"  or any other month, the formula looks in all my worksheets (the complete workbook has 19 es in total)  what is on H11 and put it on D10 according to the month,
 |  |  |  |  |  |  | whats on I11 put it on E10 and so on …
Spreadsheet: 189767d1351332049-multiple-criteria-search-between-two-numbers-using-vba-r2
Sheet: Sheet2

 | Store | Location | Product | Product Code | Price
 | AB | Waterbury | A123 | T105 | 35
 | BC | Hamden | B234 | G589 | 79
 | CD | Camden | C345 | F810 | 15
 | EF | [NAME] | D456 | R478 | 97
 | GH | Leyton | E567 | S566 | 51
 | IJ | Wembly | F678 | E451 | 27
 | KL | Houston | G789 | W005 | 44
 | MN | Watrbury | D456 | R478 | 77
 | OP | [NAME] | B234 | G589 | 35
 | QR | Chicago | E567 | S566 | 30
 | ST | New Jersy | F678 | E451 | 45
Spreadsheet: 66865d1267550201-if-statements-trickedlookuproundup
Sheet: Sheet1

0 | 1.5
25 | 2.5 |  |  | Value | Response
33 | 4 |  |  | 55 | 10
44 | 6 |  |  | 78 | 16
56 | 10 |  |  | 79 | 25
78 | 16
99 | 25
131 | 35
162 | 50
197 | 70
251 | 95
304 | 120
353 | 150
406 | 185
463 | 240
546 | 300
628 | 400
Spreadsheet: 242201d1370931451-how-to-filter-cell-by-color-in-office-2003-both-background-color-and-text-color-color-change-format
Sheet: TEXT COLOR FILTER

VENDOR | DATE | INVOICE | ETD | REMARKS
ACRO GAIN | 2013-05-15 00:00:00 | RECEIVED | 2013-06-22 00:00:00 | RECEIVED
AVERY DENNISON | 2013-05-15 00:00:00 | RECEIVED | 2013-06-23 00:00:00 | RECEIVED
C T LABEL | 2013-05-15 00:00:00 | RECEIVED | 2013-06-24 00:00:00
[NAME] | 2013-05-15 00:00:00 | RECEIVED | 2013-06-25 00:00:00
DURAFLEX | 2013-05-15 00:00:00 | RECEIVED | 2013-06-26 00:00:00 | RECEIVED
DURAFLEX | 2013-05-15 00:00:00 |  | 2013-06-27 00:00:00
EVERGREEN | 2013-05-15 00:00:00 |  | 2013-06-28 00:00:00
LEEJO | 2013-05-15 00:00:00 | RECEIVED | 2013-06-29 00:00:00 | RECEIVED
NUWA | 2013-05-15 00:00:00 |  | 2013-06-30 00:00:00 | RECEIVED
PCK | 2013-05-15 00:00:00 | RECEIVED | 2013-07-01 00:00:00
PCK | 2013-05-15 00:00:00 |  | 2013-07-02 00:00:00
PCK | 2013-05-15 00:00:00 |  | 2013-07-03 00:00:00
Spreadsheet: 858445d1707141150-create-list-based-on-top-10-highest-scores-with-criteria-book1-top-3-ans
Sheet: Sheet1

Student | Score | Subject | Helper
Bianca [NAME] | 75 | Sport |  | TOP 3 Total Score in English |  |  |  |  | Sport
[NAME] | 65 | Sport |  |  | Name | Score |  |  | Name | Score
[NAME] | 45 | Sport |  | 1 | [NAME] |  |  | 1
[NAME] | 28 | Sport |  | 2 | [NAME] |  |  | 2
Bianca [NAME] | 98 | Science |  | 3 | Finna L |  |  | 3
[NAME] | 88 | Science |  |  |  |  |  | 4
[NAME] | 87 | Science
[NAME] | 69 | Science
[NAME] | 75 | English
Bianca [NAME] | 80 | English
[NAME] | 75 | English
Finna L | 80 | English
Finna L | 40 | English
[NAME] | 78 | English
[NAME] | 45 | English
[NAME] | 38 | English
[NAME] | 78 | English
[NAME] | 58 | English
[NAME] | 28 | English
[NAME] | 78 | English