tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852593d1702572917-need-help-getting-this-formula-to-pull-date-from-c2-and-everything-before-scheduling-12132023
Sheet: Fabrivu

Fabric |  | Total hours |  |  |  |  | 45260 |  | 0.499525462962963
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | FAB | For production quote- [NAME]
 | 231235 | 1 | Fred | 1 | 45 | 58 | PAP-SO-0017 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | FAB
 | 232445 | 2 | [NAME] | 4 | 30 | 30 | PAP-SO-1332 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | FAB
 | 243556 | 3 | Gregory | 25 | 33 | 20 | ART-4443 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | FAB
 | 243557 | 2 | Gregory | 300 | 24 | 36 | ART-3232 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | FAB
 |  |  | [NAME] | 15 | 22 | 22 | PAP-SO-2263 - WHITE STATIC CLING 29.5X20.5 | 1 | FU or [NAME] | 2023-12-12 00:00:00 |  | FAB
 |  |  | [NAME] | 128 | 25 | 27 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass | 2023-12-13 00:00:00 |  | FAB
 |  |  | [NAME] | 552 | 9 | 11 | PAP-SO-2191 - CARDSTOCK 18PT CIS 48X96 | 2 | 4 Pass | 2023-12-10 00:00:00 |  | FAB
Spreadsheet: 812187d1673010483-find-result-between-two-dates-based-on-multiple-criteria-find-result-between-two-dates-based-on-multiple-criteria
Sheet: Feuil1

ID | leave | Return | Type |  | ID | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-05 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-11 00:00:00 | 2023-02-12 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-18 00:00:00 | 2023-02-19 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-25 00:00:00 | 2023-02-26 00:00:00 | 2023-02-27 00:00:00 | 2023-02-28 00:00:00 | 2023-03-01 00:00:00 | 2023-03-02 00:00:00
E001 | 2023-02-01 00:00:00 | 2023-02-15 00:00:00 | LO |  | E001 | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO | LO |  |  | MI | MI | MI | MI | MI | MI | MI | MI
E002 | 2023-02-06 00:00:00 | 2023-02-10 00:00:00 | LO |  | E002 |  |  |  |  |  | LO | LO | LO | LO | LO |  |  |  |  |  |  |  | MI | MI | MI | MI | MI | MI | MI | MI | MI | MI | MI
E001 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | MI |  | E003
E002 | 2023-02-18 00:00:00 | 2023-02-28 00:00:00 | MI |  | E004
Spreadsheet: 37738d1235753760-reformating-data-layout-bangemd
Sheet: Sheet1

Fld1 | Fld2
a | 2
a | 3
a | 4
a | 6
b | 1
b | 3
b | 4
c | 1
c | 2
c | 3
c | 5
Spreadsheet: 49288d1248607777-specific-data-collection-chimero
Sheet: Report

 | Repporting Month |  | 2009-03-01 00:00:00 |  | Opening Balance |  |  |  | Purchases |  |  |  | Issues to Production |  |  |  | Closing Balance
 | Item Code | Item Description | Open Bal | Unit Cost | Total |  |  |  | Total Prod (Qty) | Unit Cost (Sr) | Total (Sr) |  | Total Prod (Qty) | Unit Cost (Sr) | Total (Sr) |  | Total Prod (Qty) | Unit Cost (Sr) | Total (Sr)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 1 | ITEM A | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-01 00:00:00 | 2 | ITEM B | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00 | 3 | ITEM C | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 | 4 | ITEM D | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00 | 5 | ITEM E | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00 | 6 | ITEM F | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00 | 7 | ITEM G | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00 | 8 | ITEM I | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00 | 9 | ITEM H | BAG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 | GRAND TOTAL |  |  |  | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 157714d1337853760-excel-2007-help-with-comparing-cells-examplesheet3
Sheet: Sheet1

A |  | 1 |  | 2 |  | 1 | I want the formula to count the times each number from a letter is lower than the other letter
A |  | 4 |  | 1 |  | 1 | So the formula in B1 would compare the two in C1 and C2 as they are both in A rows and as C1 is smaller than C2 would give a 1
B |  | 3 |  | 6 |  | 0 | But then the same formula moved down to B2 would be a 0 as C2 is larger than C1
B |  | 2 |  | 3 |  | 2 | If possible it would be good if the one formula also did the E column of numbers, but if it needs a seperate formula to keep it simple that's fine
C |  | 5 |  | 4 |  | 2 | The G column is just to show what the numbers would be if the formula is done exactly as I want it
C |  | 6 |  | 5 |  | 0
Spreadsheet: 822271d1679230063-if-function-formula-art_excel-example
Sheet: Sheet1

Time
58 day(s), 12 hour(s), 32 minute(s)
3 day(s), 17 hour(s), 33 minute(s)
0 day(s), 0 hour(s), 33 minute(s)
0 day(s), 2 hour(s), 21 minute(s)