tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123298d1317531227-vlookup-help-sample
Sheet: Sheet1

Company Name | Tracking number | Ticket number / PO number | Date | Item shipped
XYZ 1 | 1Z456789456 | TN123456   PO456725 | 09.09.2011 | Pen
XYZ 2 | 1Z456789457 | TN123457   PO456726 | 09.09.2012 | Station |  |  |  | Search function
XYZ 3 | 1Z456789458 | TN123458   PO456727 | 09.09.2013 | shirt |  |  |  | Ticket Number
[NAME] | 1Z456789459 | TN123459       PO456728 | 09.09.2014 | car |  |  |  | TN123499
XYZ 5 | 1Z456789460 | TN123460   PO456729 | 09.09.2015 | motorcycle
XYZ 6 | 1Z456789461 | [NAME] | 09.09.2016 | Pen
XYZ 7 | 1Z456789462 | TN123462       PO456731 | 09.09.2017 | Station
[NAME] 8 | 1Z456789463 | TN123463       PO456732 | 09.09.2018 | shirt |  |  |  |  |  | Tracking number
XYZ 9 | 1Z456789464 | TN123464   PO456733 | 09.09.2019 | car
XYZ 10 | 1Z456789465 | TN123465   PO456734 | 09.09.2020 | motorcycle
XYZ 11 | 1Z456789466 | TN123466   PO456735 | 09.09.2021 | Pen |  |  |  |  |  | Company Name
XYZ 1 | 1Z456789467 | TN123467   PO456736 | 09.09.2022 | Station
XYZ 2 | 1Z456789468 | [NAME] | 09.09.2023 | shirt
XYZ 3 | 1Z456789469 | TN123469   PO456738 | 09.09.2024 | car |  |  |  |  |  | What was shipped
[NAME] | 1Z456789470 | TN123470       PO456739 | 09.09.2025 | motorcycle
XYZ 5 | 1Z456789471 | TN123471       PO456740 | 09.09.2026 | Pen
XYZ 6 | 1Z456789472 | TN123472   PO456741 | 09.09.2027 | Station
XYZ 7 | 1Z456789473 | TN123473   PO456742 | 09.09.2028 | shirt
[NAME] 8 | 1Z456789474 | TN123474   PO456743 | 09.09.2029 | car
XYZ 1 | 1Z456789475 | TN123475       PO456744 | 09.09.2030 | motorcycle
XYZ 2 | 1Z456789476 | TN123476       PO456745 | 09.09.2031 | Pen
XYZ 3 | 1Z456789477 | TN123477       PO456746 | 09.09.2032 | Station
[NAME] 8 | 1Z456781111 | PO456721 TN456421 | 12.12.2011 | Laptop
XYZ 1 | 1Z456123451 | PO451232       TN123499 | 12.13.2011 | computer
XYZ 2 | 1Z789542154 | O4572345  TN7894231 | 04.05.2011 | bag
XYZ 3 | 1Z456789478 | TN123478       PO456747 | 09.09.2033 | shirt
XYZ 5 | 1Z456789479 | TN123479       PO456748 | 09.09.2034 | car
XYZ 6 | 1Z456789480 | TN123480       PO456749 | 09.09.2035 | motorcycle
XYZ 7 | 1Z456789481 | TN123481       PO456750 | 09.09.2036 | Pen
What about an instance if the ticket number has two entries ?
XYZ 7 | 1Z456789499 | TN123481       PO456756 | 09.10.2036 | boat
Spreadsheet: 143753d1330548099-vlookup-requiring-2-columns-to-match-before-presenting-data-may-include-multiple-rows-agency-test-spreadsheet-1-
Sheet: Timesheet costs

Staff ID | Timesheet W/E | Surname | Net | Invoice charges to date
1 | 2012-01-29 00:00:00 |  | 0
1 | 2012-02-05 00:00:00 |  | 430.54
1 | 2012-02-12 00:00:00 |  | 4651
1 | 2012-02-19 00:00:00 |  | 3500
1 | 2012-02-26 00:00:00 |  | 321
2 | 2012-01-29 00:00:00 |  | 0
2 | 2012-02-05 00:00:00 |  | 650
2 | 2012-02-12 00:00:00 |  | 0
2 | 2012-02-19 00:00:00 |  | 0
2 | 2012-02-26 00:00:00 |  | 0
3 | 2012-01-29 00:00:00 |  | 0
3 | 2012-02-05 00:00:00 |  | 411
3 | 2012-02-12 00:00:00 |  | 546.554
3 | 2012-02-19 00:00:00 |  | 0
3 | 2012-02-26 00:00:00 |  | 0
4 | 2012-01-29 00:00:00 |  | 0
4 | 2012-02-05 00:00:00 |  | 651
4 | 2012-02-12 00:00:00 |  | 0
4 | 2012-02-19 00:00:00 |  | 0
4 | 2012-02-26 00:00:00 |  | 0
5 | 2012-01-29 00:00:00 |  | 0
5 | 2012-02-05 00:00:00 |  | 978
5 | 2012-02-12 00:00:00 |  | 0
5 | 2012-02-19 00:00:00 |  | 0
5 | 2012-02-26 00:00:00 |  | 0
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 173271 | 176394
2 | 177225 | 188500
3 | 173559 | 172558
4 | 188978 | 195274
5 | 184605 | 181847
6 | 191169 | 192336
7 | 213637 | 217025
8 | 195649 | 195210
9 | 198999 | 197970
10 | 195598 | 203483
11 | 189560 | 188209
12 | 197789 | 206944
13 | 207921 | 206540
14 | 227933 | 227895
15 | 200491 | 215379
16 | 201563 | 211642
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 0
2000-12-16 00:00:00
Spreadsheet: 35572d1233172641-rand-time-problem-observ-test
Sheet: Aug 18-22

 | Gr Lv | Day | Date | Time | Content Observed | Comments
17 | 2 | Monday | 2008-08-18 00:00:00 | 13:30:00 | Establishing Good Reading Habits | Reading |  |  | 08:30:00
21 | 1 | Monday | 2008-08-18 00:00:00 | 12:00:00 | Introduction to mathematical materials and processes. Emphasis placed on sharing and explaining student strategies using pictures, numbers, and words to show work. | Math |  |  | 09:00:00
26 | VE/Inclusion | Tuesday | 2008-08-19 00:00:00 | 12:30:00 |  |  |  |  | 09:30:00
20 | K | Tuesday | 2008-08-19 00:00:00 | 11:00:00 | How to Read a Book; Choosing a Favorite Place to Read | Reading |  |  | 10:00:00
11 | K | Wednesday | 2008-08-20 00:00:00 | 13:00:00 | Explore aspects of number, data, and geometry. Explore pattern blocks, color tiles, interlocking cubes, and Geoblocks for use in counting, sorting, and pattern-making activities. | Math |  |  | 10:30:00
12 | 1 | Wednesday | 2008-08-20 00:00:00 | 08:30:00 | How to Read a Book; Choosing a Favorite Place to Read | Reading |  |  | 11:00:00
1 | 5 | Thursday | 2008-08-21 00:00:00 | 11:00:00 | Explore a wide range of strategies for computation and estimation, especially with multiplication and division. | Math |  |  | 11:30:00
21 | 1 | Thursday | 2008-08-21 00:00:00 | 09:30:00 | Introduction to mathematical materials and processes. Emphasis placed on sharing and explaining student strategies using pictures, numbers, and words to show work. | Math |  |  | 12:00:00
7 | SC | Friday | 2008-08-22 00:00:00 | 08:30:00 | Model lesson for beginning teacher. | Math |  |  | 12:30:00
1 | 5 | Friday | 2008-08-22 00:00:00 | 12:30:00 | America’s Land,  The land and climate of America are very diverse and provide many benefits and challenges. | Social Studies |  |  | 13:00:00
 |  |  |  |  |  |  |  |  | 13:30:00
Spreadsheet: 50219d1249590710-vlookup-on-2-values-hot-water-tank-selection
Sheet: Sheet2

HOT WATER DEMAND PER FIXTURE FOR VARIOUS TYPES OF BUILDINGS (GPH/FIXTURE)
 | APARTMENT/HOUSE | CLUB | GYM | HOSPITAL | HOTEL | INDUSTRIAL PLANT | OFFICE | PRIVATE RESIDENCE | SCHOOL | YMCA
PRIVATE LAV | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
PUBLIC LAV | 4 | 6 | 8 | 6 | 8 | 12 | 6 | 0 | 15 | 8
BATHTUBS | 20 | 20 | 30 | 20 | 20 | 0 | 0 | 20 | 0 | 30
DISHWASHERS | 15 | 100 | 0 | 100 | 150 | 50 | 0 | 15 | 50 | 50
FOOT BASINS | 3 | 3 | 12 | 3 | 3 | 12 | 0 | 3 | 3 | 12
KITCHEN SINK | 10 | 20 | 0 | 20 | 30 | 20 | 20 | 10 | 20 | 20
LAUNDRY SINK | 20 | 28 | 0 | 28 | 28 | 0 | 0 | 20 | 0 | 28
PANTRY SINK | 5 | 10 | 0 | 10 | 10 | 0 | 10 | 5 | 10 | 10
SHOWERS | 30 | 150 | 225 | 75 | 75 | 225 | 30 | 30 | 225 | 225
SERVICE SINK | 20 | 20 | 0 | 20 | 30 | 20 | 20 | 15 | 20 | 20
HYDROTHERAPEUTIC SHOWERS | 0 | 0 | 0 | 400 | 0 | 0 | 0 | 0 | 0 | 0
HUBBARD BATHS | 0 | 0 | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 0
LEG BATHS | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0
ARM BATHS | 0 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0
SITZ BATHS | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] FLOW BATHS | 0 | 0 | 0 | 165 | 0 | 0 | 0 | 0 | 0 | 0
CIRCULAR WASH SINKS | 0 | 0 | 0 | 20 | 20 | 30 | 20 | 0 | 30 | 0
SEMICIRCULAR WASH SINKS | 0 | 0 | 0 | 10 | 10 | 15 | 10 | 0 | 15 | 0
DEMAND FACTOR | 0.3 | 0.3 | 0.4 | 0.25 | 0.25 | 0.4 | 0.3 | 0.3 | 0.4 | 0.4
STORAGE CAPACITY FACTOR | 1.25 | 0.9 | 1 | 0.6 | 0.8 | 1 | 2 | 0.7 | 1 | 1
Spreadsheet: 274632d1383166660-vlookup-between-workbooks-data-with-vlookup
Sheet: Sheet1

2010-Oct-01 04:00:00.000 | 1057.197 | 69.47 | 89.264
2010-Oct-02 04:00:00.000 | 1117.905 | 79.521 | 128.992
2010-Oct-03 04:00:00.000 | 1059.862 | 63.09 | 101.369
2010-Oct-04 04:00:00.000 | 1001.974 | 63.68 | 92.563
2010-Oct-05 04:00:00.000 | 1008.651 | 64.465 | 93.604
2010-Oct-06 04:00:00.000 | 981.942 | 61.43 | 94.457
2010-Oct-07 04:00:00.000 | 981.86 | 67.774 | 99.831
2010-Oct-08 04:00:00.000 | 1018.09 | 78.544 | 97.243
2010-Oct-09 04:00:00.000 | 1030.171 | 81.227 | 91.699
Spreadsheet: 719035d1613479805-calculate-the-frequency-of-answers-per-column-of-all-columns-sample-for-forum
Sheet: MAIN

F1 | F2 | F2.1
2 | 18 | 2 |  | F1 Value | Frequency
2 | 38 | 4 |  | 1
2 | 26 | 3 |  | 2
1 | 76 | 7
2 | 66 | 7 |  | THE ABOVE IS WHAT I WANT. I DID IT MANUALLY FOR COLUMN A USING A COUNTIF FUNCTION. HOWEVER, I WANT IT DONE FOR ALL COLUMNS (OVER 70 IN THE ORIGINAL FILE)
2 | 33 | 3
1 | 34 | 3
2 | 56 | 6
1 | 48 | 5
2 | 72 | 7
1 | 72 | 7
2 | 59 | 6
1 | 31 | 3
2 | 52 | 6
2 | 66 | 7
1 | 25 | 3
1 | 42 | 4
1 | 74 | 7
1 | 57 | 6
2 | 35 | 4
2 | 56 | 6
2 | 56 | 6
2 | 65 | 7
2 | 43 | 4
2 | 43 | 4
2 | 47 | 5
2 | 33 | 3
2 | 42 | 4
2 | 48 | 5
1 | 55 | 6
2 | 37 | 4
1 | 18 | 2
1 | 61 | 6
2 | 33 | 3
1 | 52 | 5
2 | 25 | 3
1 | 54 | 5
2 | 22 | 2
2 | 60 | 6
2 | 70 | 7
2 | 33 | 3
1 | 73 | 7
1 | 52 | 5
2 | 63 | 6
2 | 81 | 7
2 | 58 | 6
1 | 35 | 4
2 | 29 | 3
2 | 36 | 4
2 | 33 | 3
2 | 64 | 6
1 | 64 | 6
1 | 31 | 2
1 | 28 | 3
1 | 19 | 2
1 | 36 | 4
2 | 84 | 7
1 | 30 | 3
1 | 63 | 6
2 | 78 | 7
1 | 76 | 7
1 | 21 | 2
2 | 21 | 2
1 | 70 | 7
1 | 47 | 5
1 | 79 | 7
2 | 47 | 5
1 | 28 | 3
2 | 23 | 2
2 | 56 | 6
1 | 23 | 2
1 | 48 | 5
2 | 50 | 5
1 | 77 | 7
1 | 43 | 4
2 | 47 | 5
2 | 47 | 5
2 | 37 | 3
2 | 79 | 7
2 | 50 | 5
2 | 36 | 4
2 | 62 | 6
2 | 39 | 4
1 | 44 | 4
2 | 27 | 3
1 | 60 | 6
2 | 52 | 5
2 | 44 | 4
2 | 53 | 5
1 | 69 | 7
1 | 68 | 7
1 | 62 | 6
2 | 42 | 4
2 | 81 | 7
2 | 57 | 6
2 | 64 | 6
2 | 59 | 6
1 | 44 | 4
2 | 58 | 6
2 | 44 | 4
2 | 55 | 6
2 | 59 | 6
2 | 34 | 3
1 | 47 | 5
1 | 34 | 3
2 | 50 | 5
2 | 51 | 5
2 | 81 | 7
1 | 52 | 5
1 | 23 | 2
2 | 56 | 6
2 | 35 | 4
1 | 32 | 3
Spreadsheet: 106009d1303243415-problems-with-if-formula-to-lookup-a-table-example
Sheet: Sheet1

 | Expected Start date | Size |  |  | SQM Cost |  |  | Store Size & Rent oer month
 | 2011-07-01 00:00:00 | 25 |  |  | 875 |  |  | Small | 50 | 5000
 | 2011-07-01 00:00:00 | 25 |  |  |  |  |  | Medium | 250 | 7000
 | 2011-05-01 00:00:00 | 50 |  |  |  |  |  | Large | 400 | 10000
 | 2011-06-01 00:00:00 | 250
 | 2011-09-01 00:00:00 | 400
 | 2011-10-01 00:00:00 | 50
 | 2011-11-01 00:00:00 | 400
 | 2011-06-01 00:00:00 | 250
 | 2011-12-01 00:00:00 | 150
 | 2012-01-01 00:00:00 | 150
 | 2012-02-01 00:00:00 | 150
 |  |  | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00
 |  | Cost per month
 |  | Rent Per month
Spreadsheet: 878164d1725194488-help-with-filter-formula-usd-payments-etaf
Sheet: USD Payments

I respectfully request an Excel formula to filter the US$ and Cash - US$ Bank transactions from the Transactions sheet, while excluding transactions associated with Group Code "D10".
The specified columns for extraction are Date, Bank, Account, Group Code, Reference, USD Debit, and USD Credit. Thank you for your assistance.
col1 | [NAME] | col5 | 7 | 11 | 16 | 17
Date | Bank | Account | Group Code | Reference | USD Debit | USD Credit
2024-01-28 00:00:00 | US$ | Fees | C1 | 16802 | 0 | 200 |  |  |  |  | US$ | Fees | C1 | 16802 | 0 | 200
2024-01-30 00:00:00 | US$ | Fees | C1 | 16803 | 0 | 200 |  |  |  | 2024-01-30 00:00:00 | US$ | Fees | C1 | 16803 | 0 | 200
2024-01-31 00:00:00 | US$ | Vehicle Maintenance | P1 | 2161 | 80 | 0 |  |  |  | 2024-01-31 00:00:00 | US$ | Vehicle Maintenance | P1 | 2161 | 80 | 0
2024-01-31 00:00:00 | US$ | Sundry Expenses | P1 | 2173 | 50 | 0 |  |  |  | 2024-01-31 00:00:00 | US$ | Sundry Expenses | P1 | 2173 | 50 | 0
2024-01-31 00:00:00 | Cash - US$ | Fees | C1 | 16642 | 0 | 20 |  |  |  | 2024-01-31 00:00:00 | Cash - US$ | Fees | C1 | 16642 | 0 | 20
2024-02-01 00:00:00 | Cash - US$ | Feeding Programme | P1 | 2160 | 4 | 0 |  |  |  | 2024-02-01 00:00:00 | Cash - US$ | Feeding Programme | P1 | 2160 | 4 | 0
2024-02-06 00:00:00 | Cash - US$ | Vehicle Maintenance | P1 | 2168 | 1 | 0 |  |  |  | 2024-02-06 00:00:00 | Cash - US$ | Vehicle Maintenance | P1 | 2168 | 1 | 0
2024-02-08 00:00:00 | US$ | Salaries & Wages | P2 | 2178 | 833 | 0 |  |  |  | 2024-02-08 00:00:00 | US$ | Salaries & Wages | P2 | 2178 | 833 | 0
2024-02-09 00:00:00 | US$ | Feeding Programme | P1 | 2181 | 100 | 0 |  |  |  | 2024-02-09 00:00:00 | US$ | Feeding Programme | P1 | 2181 | 100 | 0
Spreadsheet: 265499d1379302705-how-to-adjust-data-date-range-based-on-analysis-range-downtime-data-analysis
Sheet: Downtime Data Pivot

Row Labels | Sum of Duration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Duration
G10CR03, Cone, Loose | 1695 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G20BN01, Level Sensors, Full | 3865
G25SC01, Motor, Trip / Overload | 1662 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10CR01, [NAME], Blocked | 1103
G10CR01, [NAME], Planned Maintenance | 1566 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G25CS01, Chute, No Feed | 1050
G20ML01, liners, [NAME] | 915 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G25CS01, Pipe, Blocked | 994
G10CV01, Belt, Planned Maintenance | 873 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10CV01, Belt, Contaminated | 555
G10SC02, Frame, Cracked/Torn/Holed | 720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10BN01, Level Sensors, No Feed | 458
G10CR02, Frame, Contaminated | 709 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10MG02, Magnet, Contaminated | 425
G10CR03, Cone, Planned Maintenance | 690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10CR02, Cone, Gap Check | 317
G10CR02, Motor, Excessive Vibration | 540 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10CV04, Belt, Contaminated | 235
G10CR03, Cylinder, Internal Wear | 520 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G10CR01, [NAME], Gap Check | 229
Spreadsheet: 194917d1353357299-how-to-change-graph-axis-name-automatically-charts
Sheet: Sheet1

 | Data 12 | Data 13 |  | Data 13
Jan | 2 | 9
Feb | 8 | 7
Mar | 7 | 7
Apr | 4 | 4
May | 9 | 5
Jun | 3 | 10
Jul | 4 | 9
Aug | 4 | 8
Sep | 8 | 7
Oct | 10 | 8
Nov | 3 | 9
Dec | 1 | 8
Spreadsheet: 690977d1597404392-grouped-numbers-average-book1
Sheet: Sheet1

 |  |  |  | No1 | No2 | No3 | No4 |  | AVERAGE
 |  |  |  | 150 | 75 | 150 | 150 |  | 150
 |  |  |  | 125 | 75 | 0 | 100 |  | 100
 |  |  |  | 50 | 0 | 0 | 0 |  | 0
 |  |  |  | 30 | 15 | 10 | 10 |  | 11.66
 |  |  |  | 30 | 40 | 30 | 50 |  | 33.33
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 4Replace Costs-Results 11-15

Table 5.2.35.  Replacement Costs (Years 11 to 15)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15
 |  |  | Total Present Value of Replacement Costs (Years 11 to 15):
Spreadsheet: 838309d1690907642-total-a-column-where-the-name-to-the-left-is-x-book1-32-
Sheet: Sheet1

 | Week 1 |  |  | Week 2 |  |  | etc
Items | 2 | Ian |  | 545 | Ian |  | 5454 | Ian
 | 56 | Fred |  | 56 | Fred |  | 23 | Fred
 | 23 | [NAME] |  | 23 | [NAME] |  | 1 | [NAME]
 | 7 | [NAME] |  | 100 | [NAME] |  | 55 | [NAME]
 | 59 | Fred |  | 59 | Fred |  | 111 | Fred
 | 25 | [NAME] |  | 25 | [NAME] |  | 28 | [NAME]
 | 5000 | Ian |  | 500 | Ian |  | 23265 | Ian
 |  |  |  |  |  |  | 55 | [NAME]
 |  |  |  |  |  |  | 31 | [NAME]
Totals |  | Ian |  |  | Ian |  |  | Ian
 | 115 | Fred |  | 115 | Fred |  | 134 | Fred
 | 30 | [NAME] |  | 23 | [NAME] |  | 56 | [NAME]
 | 25 | [NAME] |  | 100 | [NAME] |  | 28 | [NAME]
 |  |  |  | 25 | [NAME] |  | 55 | [NAME]
 |  |  |  |  |  |  | 31 | [NAME]
Names change all the time, so must work off whatever names it finds
Spreadsheet: 841856d1693998821-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-slatad-
Sheet: Price_details

[NAME] Price List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product List |  | Qty List
Company |  | Product |  | Quantity |  | MRP |  | DLP
Castrol |  | Edge 5w40 |  | 4L
Spreadsheet: 40464d1238770392-formula-to-select-value-that-satisfies-conditions-after203w-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | After 3W
 | G | Date |  | Opp | W/L | MP | FG |  | [NAME] end result | FG | Example
 | 1 | 2008-10-29 00:00:00 | @ | ORL | W | 240 | 38
 | 2 | 2008-11-01 00:00:00 |  | PHI | W | 240 | 39
 | 3 | 2008-11-05 00:00:00 | @ | NOH | W | 240 | 34
 | 4 | 2008-11-07 00:00:00 |  | TOR | W | 240 | 44
 | 5 | 2008-11-09 00:00:00 | @ | OKC | W | 240 | 29
 | 6 | 2008-11-11 00:00:00 | @ | CHI | W | 240 | 39
 | 7 | 2008-11-12 00:00:00 | @ | BOS | L | 240 | 31
 | 8 | 2008-11-14 00:00:00 | @ | NJN | L | 240 | 38
 | 9 | 2008-11-15 00:00:00 |  | NJN | L | 240 | 35
 | 10 | 2008-11-18 00:00:00 | @ | IND | L | 240 | 36
 | 11 | 2008-11-19 00:00:00 |  | WAS | W | 240 | 33
 | 12 | 2008-11-21 00:00:00 |  | CHA | W | 240 | 29
 | 13 | 2008-11-22 00:00:00 | @ | CLE | L | 240 | 36
 | 14 | 2008-11-26 00:00:00 |  | MIL | W | 240 | 35
 | 15 | 2008-11-28 00:00:00 | @ | TOR | L | 240 | 35
 | 16 | 2008-11-29 00:00:00 | @ | WAS | W | 240 | 37
 | 17 | 2008-12-03 00:00:00 |  | MEM | L | 240 | 40
 | 18 | 2008-12-05 00:00:00 |  | NYK | L | 240 | 39
 | 19 | 2008-12-06 00:00:00 | @ | DAL | W | 240 | 34
 | 20 | 2008-12-09 00:00:00 | @ | HOU | W | 240 | 34
 | G | Date |  | Opp |  | MP | FG
 | 21 | 2008-12-10 00:00:00 | @ | SAS | W | 240 | 36
 | 22 | 2008-12-12 00:00:00 | @ | MIA | L | 240 | 28
 | 23 | 2008-12-13 00:00:00 |  | CLE | W | 240 | 30
 | 24 | 2008-12-15 00:00:00 |  | CHA | W | 240 | 35
 | 25 | 2008-12-17 00:00:00 |  | BOS | W | 240 | 29
 | 26 | 2008-12-19 00:00:00 |  | [NAME] | W | 240 | 44
 | 27 | 2008-12-21 00:00:00 |  | DET | W | 240 | 31
Spreadsheet: 326776d1403262191-count-and-sum-in-filtered-data-count-and-sum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Here i would like to count No. Of phases balance (Where the balance is more than Zero in Column P) | 1) I would like to put sum formula Below 2) I would like to put Count formula (excluding the Zeroes) below
 |  |  |  |  |  |  |  |  |  |  |  | COUNT
 |  |  |  |  |  |  |  |  |  |  |  | SUM
Work | [NAME]. | Ph. | Work Bal. | State-1 | State-2 | State-3 | [NAME] | State-5 | State-6 |  |  |  |  |  | Values
3515 | D1 | 1 |  | 2.86 | 1.11 | 50.245 | 88.1 | 0 | 0 |  |  | Work | [NAME]. | Ph. | Sum of Work Bal. | Sum of State-1 | Sum of State-2 | Sum of State-3 | Sum of State-4 | Sum of State-5 | Sum of State-6
3515 | D1 | 2 |  | 30.826 | 0 | 0 | 0 | 0 | 0 |  |  | 3515 | D1 | 1 | 142.315 | 2.86 | 1.11 | 50.245 | 88.1 | 0 | 0
3515 | D1 | 3 |  | 0 | 4.8811 | 20.1808 | 19.80799 | 0 | 9.624 |  |  |  |  | 2 | 30.826 | 30.826 | 0 | 0 | 0 | 0 | 0
3515 | D1 | 4 |  | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | 3 | 54.49389 | 0 | 4.8811 | 20.1808 | 19.80799 | 0 | 9.624
3515 | D1 | 5 |  | 209.9943800000002 | 2.1 | 0 | 0 | 4.692 | 0 |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 |  | 0
3515 | D1 | 6 |  | 0 | 0 | 5.63 | 0 | 0 | 1.626 |  |  |  |  | 5 | 216.7863800000002 | 209.9943800000002 | 2.1 | 0 | 0 | 4.692 | 0
4075 | A1 | 1 |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 6 | 7.256 | 0 | 0 | 5.63 | 0 | 0 | 1.626
4075 | A1 | 2 |  | 0 | 20.1 | 40.156 | 0 | 0 | 0 |  |  |  | D1 Total |  | 451.6772700000002 | 243.6803800000002 | 8.0911 | 76.05579999999999 | 107.90799 | 4.692 | 11.25
4075 | A1 | 3 |  | 0 | 0 | 0 | 8.15 | 0 | 0 |  |  | 3515 Total |  |  | 451.6772700000002 | 243.6803800000002 | 8.0911 | 76.05579999999999 | 107.90799 | 4.692 | 11.25
4075 | B1 | 1 |  | 6.23 | 0 | 0 | 0 | 9.15 | 0
4075 | B1 | 2 |  | 0 | 8.14 | 0 | 8.15 | 0 | 2.1
Spreadsheet: 705566d1606199483-generate-a-list-by-gathering-data-from-another-sheet-sample-workbook
Sheet: Production Sheet

Customer |  | Product 1 |  |  | Product 2 |  |  | Product 3 |  |  | Product 4 |  |  | Product 5 |  |  | Product 6 |  | Product 7 |  | Product 8 |  | Product 9 |  | Product 10 |  | [NAME]. Product |  |  |  | Total | Paid | Pick Up or Delivery | Sent | Packaging |  | Pickup
Name | Size | Qty | Cost | Size | Qty | Cost | Size | Qty | Cost | Size | Qty | Cost | Size | Qty | Cost | Size | Qty | Cost | Qty | Cost | Qty | Cost | Qty | Cost | Qty | Cost | Item | Qty | Cost | Total |  |  |  |  | Day | Date | Day | Date
Brent | F | 1 |  | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | D | Y | 2020-11-22 00:00:00 |  | 2020-11-23 00:00:00
Anna | F | 1 |  | F | 1 |  | H | 1 |  | H | 1 |  | H | 1 |  | F | 1 |  | 2 |  | 3 |  | 6 |  | 6 |  | Extra | 1 | 35 |  |  | a | P | Y | 2020-11-21 00:00:00 |  | 2020-11-21 00:00:00
Kelly | F | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | P | Y | 2020-11-21 00:00:00 |  | 2020-11-21 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  | a | D | Y | 2020-11-19 00:00:00 |  | 2020-11-20 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 3 |  | 2 |  | 6 |  | 6 |  |  |  |  |  |  |  |  | a | P |  | 2020-11-23 00:00:00 |  | 2020-11-24 00:00:00
[NAME] | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | P |  | 2020-11-22 00:00:00 |  | 2020-11-23 00:00:00
Carley | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | Y | 2020-11-21 00:00:00 |  | 2020-11-21 00:00:00
Haley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  | Disc | 1 | -2.5 |  |  |  | D | Y | 2020-11-22 00:00:00 |  | 2020-11-23 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | D |  | 2020-11-21 00:00:00 |  | 2020-11-22 00:00:00
[NAME] | F | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | Y | 2020-11-19 00:00:00 |  | 2020-11-20 00:00:00
Spreadsheet: 879448d1726981451-rotating-timetable-issues-musicteacher1925-rotating-timetable-problem-partial-spill-365-aligw
Sheet: Sheet1

Inst. |  |  | Tutor |  |  |  | Start | 0.375 | Groups | 10 | Lessons | 12 |  |  |  |  | please note: if the group number changes in M1 then the formulas still need to work
 |  |  |  |  |  |  | End
 |  |  |  |  |  |  |  | the above will be on visible sheet as hh:[NAME] |  | groups up to 20 |  |  |  |  | from here on will be on another sheet eventually | examples of possible formula | this is fine if all cells are in order | nested ifs = very long!!- doesn’t work if dynamic number of groups change
Dates | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | mins |  |  | 2024-09-01 00:00:00
 |  | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 20
Group 2 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 15 |  |  |  | 09:20:00 | 10:20:00 | 12:15:00 | 09:00:00 | 10:00:00 | 11:35:00 | 13:05:00 | 09:40:00 | 10:35:00 | 12:45:00 | 09:20:00 | 10:20:00
Group 3 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 20 |  |  |  | 09:35:00 | 10:35:00 | 12:30:00 | 09:15:00 | 10:15:00 | 11:50:00 | 09:00:00 | 09:55:00 | 10:50:00 | 13:00:00 | 09:35:00 | 10:35:00
Group 4 | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 30 |  |  |  | 09:55:00 | 10:55:00 | 12:50:00 | 09:35:00 | 10:35:00 | 12:10:00 | 09:20:00 | 10:15:00 | 11:10:00 | 09:00:00 | 09:55:00 | 10:55:00
Group 5 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 40 |  |  |  | 10:25:00 | 11:25:00 | 09:00:00 | 10:05:00 | 11:05:00 | 12:40:00 | 09:50:00 | 10:45:00 | 11:40:00 | 09:30:00 | 10:25:00 | 11:25:00
Group 6 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 9 | 60 |  |  |  | 11:05:00 | 12:05:00 | 09:40:00 | 10:45:00 | 11:45:00 | 09:00:00 | 10:30:00 | 11:25:00 | 12:20:00 | 10:10:00 | 11:05:00 | 12:05:00
Group 7 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 15 |  |  |  | 12:05:00 | 13:05:00 | 10:40:00 | 11:45:00 | 12:45:00 | 10:00:00 | 11:30:00 | 12:25:00 | 09:00:00 | 11:10:00 | 12:05:00 | 13:05:00
Group 8 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 20 |  |  |  | 12:20:00 | 09:00:00 | 10:55:00 | 12:00:00 | 13:00:00 | 10:15:00 | 11:45:00 | 12:40:00 | 09:15:00 | 11:25:00 | 12:20:00 | 09:00:00
Group 9 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 6 | 9 | 2 | 20 |  |  |  | 12:40:00 | 09:20:00 | 11:15:00 | 12:20:00 | 09:00:00 | 10:35:00 | 12:05:00 | 13:00:00 | 09:35:00 | 11:45:00 | 12:40:00 | 09:20:00
Group 10 | 10 | 3 | 6 | 9 | 2 | 5 | 8 | 1 | 4 | 7 | 10 | 3 | 20 |  |  |  | 13:00:00 | 09:40:00 | 11:35:00 | 12:40:00 | 09:20:00 | 10:55:00 | 12:25:00 | 09:00:00 | 09:55:00 | 12:05:00 | 13:00:00 | 09:40:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 15
Maximum limit of proposed work