tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 207659d1358524464-finding-the-location-of-the-last-string-of-26-consecutive-blanks-in-a-row-example
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Answer (looking for this):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column | Address
Numbers( through column DW) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Want the last Period of Blanks
 |  |  | 4 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 2 | 3 | 4 | 2 | 3 | 4 | 5 | 4 | 5 | 6 | 7 | 8 | 7 | 6 |  | 5 | 6 | 7 | 8 | 9 | 8 | 6 | 7 | 5 | 4 | 8.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.2
Spreadsheet: 270671d1381581138-nested-if-vlookup-formula-breaks-when-lookup-value-changes-colin-12-oct-13-v2
Sheet: MM

date and IO | Date | Campaign name |  |  |  |  |  | Total cost
 | 2013-10-01 00:00:00 | UK - Chevrolet - Retail Q4 - Oct-Dec '13 |  |  |  |  |  | 265.67
 | 2013-10-01 00:00:00 | BE - Telenet - King Kong - Oct' 13 - DR |  |  |  |  |  | 266.67
 | 2013-10-02 00:00:00 | UK - Chevrolet - Retail Q4 - Oct-Dec '13 |  |  |  |  |  | 267.67
 | 2013-10-02 00:00:00 | BE - Telenet - King Kong - Oct' 13 - DR |  |  |  |  |  | 268.67
 | 2013-10-03 00:00:00 | UK - Chevrolet - Retail Q4 - Oct-Dec '13 |  |  |  |  |  | 269.67
 | 2013-10-03 00:00:00 | BE - Telenet - King Kong - Oct' 13 - DR |  |  |  |  |  | 270.67
 |  |  |  |  |  |  | M
Spreadsheet: 676328d1588762046-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: Main Sheet

[NAME] | May |  | [NAME] (Manual Payment) | Planned £ | Actual £ |  | [NAME] (DD Payment) | Planned £ | Actual £
[NAME] | 2020 |  |  | 125 |  |  | Home Insurance | 0
Yearly | 25000 |  |  |  |  |  |  | 25
Monthly |  |  | Water | 30 |  |  | TV, Talk & Broadband | 50
Tax | 100 |  |  |  |  |  | TV Licence | 12
National Insurance | 110 |  | Diesel | 50 |  |  | [NAME] | 11
Pension | 110 |  | Electric | 60 |  |  | Mobile Phone Joint Bill | 30
Rebates | 0 |  | Gas | 30 |  |  |  | 15
[NAME] |  |  | Savings | 100 |  |  | Netflix | 11.99
 |  |  | Trust Fund | 50 |  |  |  | 62
Bills Total |  |  | Loan Repay | 50 |  |  |  | 30
Leftover After Bills |  |  | Store Card | 0
 |  |  | Credit Card | 0
 |  |  | [NAME] | 20
 |  |  | Total |  |  |  | Total
 |  |  | Left To Pay |  |  |  | Left To Pay
Spreadsheet: 656508d1578267803-calculating-values-depending-on-variable-suppliers-sample-supplier-products-calcs
Sheet: Sheet1

Shift | Time of Day | Supplier | Product 1 | Product 2 | Product 3 | Cost
1 | Day | Supplier 1 | 1 | 1
2 | Night | Supplier 1 |  | 3 | 1
3 | Day | Supplier 2 | 2 | 2 | 1
4 | Weekend | Supplier 1 |  |  | 4
 |  | Product 1 | Product 2 | Product 3
Supplier 1 | Day | 1 | 2 | 3
 | Night | 2 | 3 | 4
 | Weekend | 2.5 | 3.5 | 4.5
Supplier 2 | Day | 2 | 3 | 1
 | Night | 3 | 4 | 2
 | Weekend | 3.5 | 4.5 | 2.5
Supplier 1
Supplier 2
Spreadsheet: 6e3b351f-1ee7-41b0-95d2-ba31c33bc1c4
Sheet: Sheet1

Unnamed: 0 | UMS to Raw Score Calculator | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | v0.22, by markdr and terrafire | Unnamed: 9 | Unnamed: 10
 | This is designed so you only need to edit the white cells to input data.
 | 1. Enter the raw mark boundaries for grades A and E and the maximum marks available.
 | Percent | Grade | Raw boundary | High RAW
 | 0 | U | 0 | 11
 | 0.3 | N | 11 | 14
 | 0.4 | E | 14 | 17
 | 0.5 | D | 17 | 20
 | 0.6 | C | 20 | 24
 | 0.7 | B | 24 | 28
 | 0.8 | A | 28 | 36
 | 1 | A - Cap | 36 | 40
 | Maximum mark |  | 40
 |  |  |  |  | True
 | 2. Enter your UMS score and the maximum UMS available
 |  | / |  |  |  |  |  |  | check 1 | TRUE
 | 105 |  | 120 | 88% (A) |  |  |  |  | check 2 | TRUE
 |  |  |  |  |  |  |  |  | % UMS | 0.875
 | 3. Your raw mark estimation is: |  |  |  |  |  |  |  | Low raw | 28
 |  |  |  |  |  |  |  |  | High raw | 36
 | 31 / 40 |  |  |  |  |  |  |  | Grade | A
 |  |  |  |  |  |  |  |  | Diff - raw | 8
 | (rounded to | 0 | decimal places) |  |  |  |  |  | Low UMS | 96
 |  |  |  |  |  |  |  |  | High UMS | 120
 |  |  |  |  |  |  |  |  | Diff - UMS | 24
 |  |  |  |  |  |  |  |  | Result | 31
Spreadsheet: 47391d1246428734-vlookup-help-example
Sheet: Sheet1

My list
C/I | C/O | Nts | Guest Name | Folio No. | PCR No. | staff ID | Room rate | F&B | Total
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name1 | 1234567 | 698248792 | ls | 100 |  | 100 |  | exists on sheet2
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | [NAME] | 9876543 | 698248558 | ls | 200 |  | 200 |  | exists on sheet2
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name3 | 1472583 | 698248516 | ls | 300 |  | 300 |  | exists on sheet2
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name4 | 1237894 | 698273593 | ls | 400 |  | 400 |  | exists on sheet2
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name5 | 6548196 | 698273551 | ls | 888 |  | 888 |  | does NOT exist on sheet2 - should remain empty
2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 1 | Name6 | 6841848 | 698273072 | ls | 999 |  | 999 |  | does NOT exist on sheet2 - should remain empty
The highlighted column is missing on this sheet, but is entered on sheet2. I would like, if the [NAME] is the same as in the entry at sheet 2, to have the value for F&B imported.
However, the [NAME] number is not always the same as on sheet 1, thus I only need to have the F&B imoprted from rows with the SAME Folio number.
Thanks!
A2k
Spreadsheet: 92716d1292271936-sum-if-date-ranged-report-demo
Sheet: raw data

Sate | Name | Event 1 | Event 2
2011-01-01 00:00:00 | Jessica | 1
2011-01-01 00:00:00 | [NAME] | 1
2011-01-01 00:00:00 | Jessica | 1
2011-01-01 00:00:00 | Jessica |  | 1
2011-01-02 00:00:00 | [NAME] | 1
2011-01-02 00:00:00 | Jessica | 1
2011-01-10 00:00:00 | [NAME] | 1
2011-01-10 00:00:00 | [NAME] | 1
2011-01-10 00:00:00 | Jessica | 1
2011-01-20 00:00:00 | Jessica |  | 1
2011-01-21 00:00:00 | [NAME] |  | 1
2011-01-21 00:00:00 | [NAME] | 1
2011-01-21 00:00:00 | Jessica | 1
Spreadsheet: 199340d1355182370-custom-sort-items-not-in-alpha-order-sign-sheet-oeldere-
Sheet: Memo Sign Sheet

Accepting Valid Coupons/Prize Redemptions
Due Date: |  | MUST READ MEMO BINDER
Last Name, First | Shift | Date | Signature
Employee #01 | 1 Day
Employee #02 | 1 Day
Employee #03 | 1 Day
Employee #04 | 1 Day
Employee #05 | 1 Day
Employee #06 | 1 Day
Employee #07 | 1 Day
Employee #08 | 1 Day
Employee #09 | 1 Day
Employee #10 | 1 Day
Employee #11 | 1 Day
Employee #12 | 1 Day
Employee #13 | 1 Day
Employee #14 | 1 Day
Employee #15 | 2 Swing
Employee #16 | 2 Swing
Employee #17 | 2 Swing
Employee #18 | 2 Swing
Employee #19 | 2 Swing
Employee #20 | 2 Swing
Employee #21 | 2 Swing
Employee #22 | 2 Swing
Employee #23 | 2 Swing
Employee #24 | 2 Swing
Employee #25 | 2 Swing
Employee #26 | 2 Swing
Employee #27 | 2 Swing
Employee #28 | 2 Swing
Employee #29 | 2 Swing
Employee #30 | 2 Swing
Employee #31 | 2 Swing
Employee #32 | 2 Swing
Employee #33 | 2 Swing
Employee #34 | 2 Swing
Employee #35 | 3 Grave
Employee #36 | 3 Grave
Employee #37 | 3 Grave
Employee #38 | 3 Grave
Employee #39 | 3 Grave
Employee #40 | 3 Grave
Employee #41 | 3 Grave
Employee #42 | 3 Grave
Employee #43 | 3 Grave
Employee #44 | 3 Grave
Employee #45 | 3 Grave
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: GAS

 | PRICE CALCULATOR
 | Enter Gas Price: | 3.03
 | Estimated Power Cost: | @ 10 HR | @13.5 HR
 | Sylmar
 | Mead (230 KV)
 | Palo Verde
 | Losses
 | Sylmar |  | 0.005
 | Palo Verde |  | 0.064
 | Mead |  | 0.035
Spreadsheet: 542042d1507686469-return-a-value-when-multiple-criteria-were-met-nickyme02-spreadsheet
Sheet: Sheet2

 | BATCH CLAIMS LOGSHEET
 | Client Name | Job Number | Stage | Amount Due | Claim Date | Due Date | Received Date | Notes
 | Villareal | 12345 | Base Completion | 25684 | 2017-10-03 00:00:00
 | Prado | 67894 | Frame Completion | 22589 | 2017-10-04 00:00:00
 | Suñiga | 12584 | Fix Completion | 22647 | 2017-10-04 00:00:00
Spreadsheet: 698515d1602013781-find-column-values-in-rows-and-retrieve-result-index-match-example2
Sheet: Feuil1

ID | Week | Data |  |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8
005146 | Week 1 | 2221 |  |  | 005146
005146 | Week 2 | 1704 |  |  | 005149
005146 | Week 3 | 1516 |  |  | 005151
005149 | Week 1 | 1461
005149 | Week 2 | 109
005151 | Week 1 | 776
005151 | Week 2 | 1687
005151 | Week 3 | 1320
Spreadsheet: 766600d1643960094-search-within-an-array-table-search
Sheet: Sheet1

Desired Results (Searchable databse)
Type the animal below | legs |  |  |  | animal database
dog | 4 |  |  |  | animal | legs
human | 2 |  |  |  | dog
xyz |  |  |  |  | CAT
pluto |  |  |  |  | SnaKE
 |  |  |  |  | HuMAN
snake | 0
dog | 4
cat | 4
Spreadsheet: 125468d1319047213-using-a-formula-to-copy-a-cell-if-another-cells-value-is-between-two-dates-capacity-chart-workbook
Sheet: October Capacity Chart

OPERATIONAL CAPACITY (MAN HOURS) |  | 2011-10-24 00:00:00
Saw | 5-DAY Avail Man-Hours | 80
 | 6-DAY Avail Man-Hours | 88
 | Booked Man Hours
Vert [NAME] | 5-DAY Avail Man-Hours | 240
 | 6-DAY Avail Man-Hours | 264
 | Booked Man Hours
[NAME] | 5-DAY Avail Man-Hours | 80
 | 6-DAY Avail Man-Hours | 88
 | Booked Man Hours
CNC Lathe | 5-DAY Avail Man-Hours | 200
 | 6-DAY Avail Man-Hours | 224
 | Booked Man Hours
Braze | 5-DAY Avail Man-Hours | 40
 | 6-DAY Avail Man-Hours | 48
 | Booked Man Hours
Sm Manual | 5-DAY Avail Man-Hours | 56
 | 6-DAY Avail Man-Hours | 73
 | Booked Man Hours
Lg Manual | 5-DAY Avail Man-Hours | 40
 | 6-DAY Avail Man-Hours | 48
 | Booked Man Hours
TOTAL | 5-DAY Avail Man-Hours
 | 6-DAY Avail Man-Hours
 | Booked Man Hours
Spreadsheet: 179617d1347316327-value-error-dow
Sheet: 2

Baggage
Cargo
Mail
 |  |  | 53 | 52 | 51 |  | 43 L | 42 L | 41 L |  | 34 L | 33 L | 32 L | 31 L |  |  | 26 L | 25 L | 24 L | 23 L | 22 L | 21 L |  | 13 L | 12 L | 11 L
 |  | B |  |  |  | B |  |  |  | B | 500 | 500 | 500 |  |  | B |  |  |  |  |  |  | B
 |  | C |  |  |  | C |  |  |  | C |  |  |  |  |  | C |  |  |  |  |  |  | C
 |  | M |  |  |  | M |  |  |  | M |  |  |  |  |  | M |  |  |  |  |  |  | M
 |  |  |  |  |  |  | 43 R | 42 R | 41 R |  | 32 R | 32 R | 32 R | 32 R |  |  | 26 R | 25 R | 24 R | 23 R | 22 R | 21 R |  | 13 R | 12 R | 11 R
 |  | B |  |  |  | B |  |  |  | B | 500 | 500 |  |  |  | B |  |  |  |  |  |  | B
 |  | C |  |  |  | C |  |  |  | C |  |  |  |  |  | C |  |  |  |  |  |  | C
 |  | M |  |  |  | M |  |  |  | M |  |  |  |  |  | M |  |  |  |  |  |  | M
Total | B
 | C
 | M
 | Per Compt
Balance:
Baggage
Cargo
Mail
Spreadsheet: 31156352-8982-4155-954b-9faf124797f1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MANN | Test | MANN | Alpha-Mannosidase, Leukocytes | Alpha-Mannosidase, Leukocytes | Fluorometric | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | [NAME] must arrive within 48 hours of draw to be stabilized. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | > or =16 years: 1.04-2.68 U/10(10) cells Reference values have not been established for patients that are <16 years of age. | Wednesday; 8 a.m. | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
MANN | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 48 hours
MANN | Result | 8772 | Alpha-Mannosidase, Leukocytes | Alpha-Mannosidase, Leukocytes | Numeric |  |  |  |  | U/10(10) |  |  |  |  |  |  |  |  |  | 24053-1
Spreadsheet: 144519d1331019794-sales-sheet-transfer-to-invoice-sheet-sample-monthly-sales-and-invoices-update
Sheet: Sample inv

 |  |  |  |  |  |  | Code
 |  |  |  |  |  |  | 1
 |  |  | Invoice No. | 1922/
 |  |  |  | Date:
 |  | Date | Vendor name | Cost | VAT
 | _
 |  |  |  | Total Cost of Classes
 |  |  |  | VAT | 0
 |  |  |  | Invoice Total
Spreadsheet: 819311d1677412377-calculate-credit-card-account-age-follow-up
Sheet: View 2 (Inaccurate AVERAGE)

 | Open Credit Cards
 | Creditor | [Other Columns] |  |  |  |  |  |  |  |  | Date Opened | Year(s) | Month(s)
 | Credit Card  1 |  |  |  |  |  |  |  |  |  | 2022-03-08 00:00:00
 | Credit Card  2 |  |  |  |  |  |  |  |  |  | 2015-09-21 00:00:00
 | Credit Card  3 |  |  |  |  |  |  |  |  |  | 2022-09-01 00:00:00
 | Credit Card  4 |  |  |  |  |  |  |  |  |  | 2022-04-24 00:00:00
 | Credit Card  5 |  |  |  |  |  |  |  |  |  | 2001-06-16 00:00:00
 | Credit Card  6 |  |  |  |  |  |  |  |  |  | 2017-02-17 00:00:00
 | Credit Card  7 |  |  |  |  |  |  |  |  |  | 2021-04-29 00:00:00
 | Credit Card  8 |  |  |  |  |  |  |  |  |  | 2016-06-14 00:00:00
 | Credit Card  9 |  |  |  |  |  |  |  |  |  | 2004-12-30 00:00:00
 | Credit Card  10 |  |  |  |  |  |  |  |  |  | 2004-12-30 00:00:00
 | Credit Card  11 |  |  |  |  |  |  |  |  |  | 2016-05-09 00:00:00
 | Open Auto Loans
 | Creditor | [Other Columns] |  |  |  |  |  |  |  |  | Date Opened | Year(s) | Month(s)
 | Auto Loan 1 |  |  |  |  |  |  |  |  |  | 2022-03-10 00:00:00
 | Open Personal Loans
 | Creditor | [Other Columns] |  |  |  |  |  |  |  |  | Date Opened | Year(s) | Month(s)
 | Personal Loan 1 |  |  |  |  |  |  |  |  |  | 2022-03-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year(s) | Month(s)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oldest Account:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newest Account:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Age:
Spreadsheet: 873017d1719470465-is-excel-miscalculating-this-excel-forum-qn
Sheet: Sheet1

A | B | C = A - B | D = C - A + B
Debits | Credits | Net balance | Check |  | Short question:
0 | 2588.082267759565 |  |  |  | How is cell C14 equal not equal to zero?
0 | 0
225.4635081967214 | 0 |  |  |  | Long question:
0 | 0 |  |  |  | Column A | Debits (positive numbers)
0 | 0 |  |  |  | Column B | Credits (negative numbers)
0 | 0 |  |  |  | Column C | Net balance (debits - credits)
0 | 0 |  |  |  | Column D | Check for the line items in column C, i.e. that Column C - column A + column B equals zero. All of these equal zero, exactly
0 | 0 |  |  |  |  | The sum of all column D numbers (cell D14) also is zero, exactly.
0 | 0
2362.618759562841 | 0 |  |  |  | If the above is true, it must follow that:
0 | 0 |  |  |  |  | Sum(column C) - sum (column D) = zero
2588.082267759562 | 2588.082267759565
 |  |  |  |  | Then: how can it be that the sum of column C (cell C14) is not equal to zero?
 |  |  |  |  | Column C and Column D are summing the same numbers, yet yield different results. How?
Spreadsheet: 842052d1694125837-values-based-on-different-scenarios-financial-model_example_v01
Sheet: Sheet1

 | Selected case » | Upside case |  | Cases
 |  |  |  | Base case
 | Revenue | 100 |  | Upside case
 | [NAME] |  |  | Downside case
 | R&D
 | SG&A
 | EBIT
 | Assumptions - Base case
 |  | 0.5
 |  | 0.15
 |  | 0.2
 | Assumptions - Upside & Downside cases
 | EBIT margin
 | Upside case | 0.2
 | Downside case | 0.1
 | Outputs
 | EBIT margin
Spreadsheet: 734359d1622124442-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5235 |  |  |  |  |  |  |  |  | 2 | 1 |  | nl |  |  |  |  |  | Uren inkoop |  |  | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  | =OF(EN($d2="";AANTALARG($g2:$h2)<>1);EN($d2=<>"";L2=""))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: master

1 | PLAYER | Playing Handicap | Official Handicap | Exact handicap | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | stableford points | Handicap Alteration
1 |  |  |  |  | PAR
1 |  |  |  |  | S/I
0 | Adams. [NAME]
0 | Adams. [NAME]
0 | Addison. [NAME]
0 | [NAME]. [NAME]
0 | Ankers. Neville
0 | Atkins. [NAME]
0 | [NAME]. [NAME]
0 | Bartram. [NAME]
0 | Basil. Greg
0 | Batterbee. J
0 | Baxter. [NAME]
0 | Baxter. [NAME]
0 | Beadsmore. Russ
0 | Biggins. Clive
0 | Biggins. Sue
0 | Bradley. [NAME]
0 | [NAME]. [NAME]
0 | Bromley. [NAME]
0 | [NAME]. [NAME]
0 | [NAME]. Hamon
0 | Clarke. [NAME]
0 | Curt. Sean
0 | Davey. [NAME]
0 | [NAME]. Martyn
0 | Dooley. [NAME]
0 | [NAME]. [NAME]
0 | Giboin. [NAME]
0 | Goodall. [NAME]
0 | [NAME]. [NAME]
0 | Grout. [NAME]
0 | Haines. [NAME]
0 | Hubband. [NAME]
0 | Huckstepp. [NAME]
0 | Hutchinson. [NAME]
0 | Hutton. [NAME]
0 | [NAME]. [NAME]
0 | Kelly. [NAME]
0 | [NAME]. [NAME]
0 | [NAME]. [NAME]
0 | [NAME]. [NAME]
0 | Kolek. Darren
0 | [NAME]. [NAME]
0 | Leadbetter. [NAME]
0 | Leadbetter. [NAME]
0 | Leech. [NAME]
0 | Leech. [NAME]
0 | Lewis. [NAME]
0 | Loom. [NAME]
0 | [NAME]. [NAME]
0 | Mackenzie. [NAME]
0 | [NAME]. [NAME]
0 | Marvesley. [NAME]
0 | Manktelow. Trevor
0 | McFaddon. [NAME]
0 | [NAME]. [NAME]
0 | Mitchell. [NAME]
0 | Morgan. Rhys
0 | Moriarty. [NAME]
0 | Munting. [NAME]
0 | [NAME]. [NAME]
0 | [NAME]. [NAME]
0 | Noons. Con
0 | Noons. Martin
0 | O'Grady. Eddie
0 | [NAME]. Greg
0 | Parrish. [NAME]
0 | Parsonage. Eddie
0 | Pearce. [NAME]
0 | Pearce. [NAME]
0 | Pennington. Carol
0 | Power. [NAME]
0 | Pym. [NAME]
0 | [NAME]. Ian
0 | Redondo. [NAME]
0 | Reynolds. [NAME]
0 | Rondeau. Gene
0 | [NAME]. [NAME]
0 | Scott. Bruce
0 | Scott. [NAME]
0 | Sharp. Ady
0 | Shaw. [NAME]
0 | Simmons. [NAME]
0 | Smith. [NAME]
0 | Smith. [NAME]
0 | Smith. [NAME]
0 | Sweeney. Eddie
0 | Sweeney. [NAME]
0 | Thompson. [NAME]
0 | Thorpe. [NAME]
0 | Umney. [NAME]
0 | [NAME]. [NAME]
0 | Watson. [NAME]
0 | [NAME]. [NAME]
0 | Weed. [NAME]
0 | [NAME]. [NAME]
0 | [NAME]. [NAME]
0 | Woodford. [NAME]
Spreadsheet: 866891d1713803833-match-pairs-from-columns-forum_testxlsx
Sheet: Sheet1

Team | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 |  | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9
1 | 10 | 6 | 13 | 9 | 12 | 5 | 11 | 15
2 | 15 | 4 | 7 | 5 | 10 | 16 | 19 | 13
3 | 13 | 9 | 8 | 17 | 7 | 10 | 4 | 16
4 | 16 | 2 | 15 | 12 | 11 | 18 | 3 | 7
5 | 14 | 17 | 20 | 2 | 19 | 1 | 8 | 10
6 | 19 | 1 | 9 | 16 | 20 | 11 | 7 | 14
7 | 20 | 19 | 2 | 11 | 3 | 13 | 6 | 4
8 | 12 | 16 | 3 | 14 | 13 | 15 | 5 | 18
9 | 18 | 3 | 6 | 1 | 14 | 19 | 12 | 11
10 | 1 | 11 | 18 | 20 | 2 | 3 | 14 | 5
11 | 17 | 10 | 12 | 7 | 4 | 6 | 1 | 9
12 | 8 | 13 | 11 | 4 | 1 | 14 | 9 | 20
13 | 3 | 12 | 1 | 15 | 8 | 7 | 16 | 2
14 | 5 | 18 | 17 | 8 | 9 | 12 | 10 | 6
15 | 2 | 20 | 4 | 13 | 16 | 8 | 17 | 1
16 | 4 | 8 | 19 | 6 | 15 | 2 | 13 | 3
17 | 11 | 5 | 14 | 3 | 18 | 20 | 15 | 19
18 | 9 | 14 | 10 | 19 | 17 | 4 | 20 | 8
19 | 6 | 7 | 16 | 18 | 5 | 9 | 2 | 17
20 | 7 | 15 | 5 | 10 | 6 | 17 | 18 | 12
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Jan2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-01-01 00:00:00 | 0 | 0 | 0 | 0
2021-01-02 00:00:00 | 0 | 0 | 0 | 0
2021-01-03 00:00:00 | 0 | 0 | 0 | 0
2021-01-04 00:00:00 | 2 | 23.04 | 0 | 0
2021-01-05 00:00:00 | 3 | 40.81 | 0 | 0
2021-01-06 00:00:00
2021-01-07 00:00:00
2021-01-08 00:00:00
2021-01-09 00:00:00
2021-01-10 00:00:00
2021-01-11 00:00:00
2021-01-12 00:00:00
2021-01-13 00:00:00
2021-01-14 00:00:00
2021-01-15 00:00:00
2021-01-16 00:00:00
2021-01-17 00:00:00
2021-01-18 00:00:00
2021-01-19 00:00:00
2021-01-20 00:00:00
2021-01-21 00:00:00
2021-01-22 00:00:00
2021-01-23 00:00:00
2021-01-24 00:00:00
2021-01-25 00:00:00
2021-01-26 00:00:00
2021-01-27 00:00:00
2021-01-28 00:00:00
2021-01-29 00:00:00
2021-01-30 00:00:00
2021-01-31 00:00:00
Totals:
Spreadsheet: 158263d1338124228-ref-error-in-index-and-match-formula-ref-issue-in-formula
Sheet: Working File

 | Summary
 | Group
 | X
 | Y
 | Z
Working File
Items | Group | 2012-05-21 00:00:00 | 2012-05-23 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 |  |  |  |  |  | 2012-06-11 00:00:00 | 2012-06-18 00:00:00 | 2012-06-25 00:00:00
Item 1 | X | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750
Item 2 | Y | -200 | -250 | -300 | 10 | -400 | -450 | -500 | 300 | -600 | -650 | 200 | -750 | -800 | -850
Item 3 | Z | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850
Item 4 | Z | 1 | 10 | -400 | -450 | -500 | 900 | -600 | -650 | -700 | -750 | -800 | -850 | -900 | -950
Item 5 | Z | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950
Item 6 | Z | -400 | -450 | -500 | -550 | -600 | 7 | -700 | -750 | -800 | -850 | -900 | -950 | -1000 | 100
Item 7 | Z | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050
Item 8 | Z | -500 | -550 | -600 | -650 | -700 | -750 | -800 | -850 | -900 | -950 | -1000 | -1050 | -1100 | -1150
Item 9 | Z | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150
Item 10 | Y | -600 | -650 | -700 | 700 | -800 | -850 | -900 | -950 | -1000 | -1050 | -1100 | 500 | -1200 | 1000