tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59703d1260284205-costing-problem-with-final-sale-price-sale-price
Sheet: Sheet1

 |  |  |  | PayPal % Charge On Sale Price | 0.039
 |  |  | Orig. Price | Sale Price | Cost | Sale Price - Cost
 |  |  | 10 | 10.60582726326743 | 0.6136272632674298 | 9.992200000000002
 |  |  | 11 | 11.64640998959417 | 0.6542099895941729 | 10.9922
 |  |  | 12 | 12.68699271592092 | 0.6947927159209157 | 11.9922
 |  |  | 13 | 13.72757544224766 | 0.7353754422476586 | 12.9922
 |  |  | 14 | 14.7681581685744 | 0.7759581685744017 | 13.9922
 |  |  | 15 | 15.80874089490115 | 0.8165408949011448 | 14.9922
 |  |  | 16 | 16.84932362122789 | 0.8571236212278877 | 15.9922
 |  |  | 17 | 17.88990634755463 | 0.8977063475546307 | 16.9922
 |  |  | 18 | 18.93048907388138 | 0.9382890738813736 | 17.9922
 |  |  | 19 | 19.97107180020812 | 0.9788718002081167 | 18.9922
 |  |  | 20 | 21.01165452653486 | 1.01945452653486 | 19.9922
Spreadsheet: 52164d1251878232-sum-formula-with-multiple-criteria-example
Sheet: Sheet1

Employee | Category ID | Category | Hours |  |  | Total Hours
SMITH JOHN | 208279 | Training | 2 |  |  | Training | [NAME] | Maintenance
SMITH JOHN | 208501 | Training | 2 |  | SMITH JOHN | ? | ? | ?
SMITH JOHN | 208579 | Training | 2 |  | JONES [NAME] | ? | ? | ?
SMITH JOHN | 891578 | [NAME] | 4 |  | [NAME] | ? | ? | ?
SMITH JOHN | 891578 | [NAME] | 4 |  | [NAME] | ? | ? | ?
SMITH JOHN | 891578 | [NAME] | 4
SMITH JOHN | 891578 | [NAME] | 4
SMITH JOHN | 904601 | Maintenance | 5 |  | If SMITH JOHN equals TRAINING then return the total number of hours for TRAINING (and so on)
SMITH JOHN | 904601 | Maintenance | 13.5
SMITH JOHN | 904601 | Maintenance | 4
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 208279 | Training | 8.5
JONES [NAME] | 208501 | Training | 8.5
JONES [NAME] | 208579 | Training | 8.5
JONES [NAME] | 209221 | Training | 8.5
[NAME] | 904601 | Maintenance | 13.5
[NAME] | 904601 | Maintenance | 4
[NAME] | 904604 | Maintenance | 3
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 904601 | Maintenance | 5
[NAME] | 904601 | Maintenance | 13.5
[NAME] | 904601 | Maintenance | 4
Spreadsheet: 67525d1268140123-formulae-across-tabs-and-knowing-which-to-use-excel-mockup-for-forum
Sheet: The Teams

Harv
No. | Code | Name | Club | Cost | Wk18-19 | Wk20 | Wk21 | Wk22 | Wk23 | Wk24 | Wk25 | Wk26 | Wk27 | Wk28 | Wk29 | Wk30 | Wk31 | Wk32 | Wk33
1 | 024 | P Cech | Chelsea | £5.5m | 87 | 107
2 | 109 | R [NAME] | Birmingham City | £1.0m | 26 | 28
3 | 170 | A Cole | Chelsea | £5.5m | 147 | 147
4 | 246 | W Brown | [NAME] | £3.5m | 73 | 76
5 | 104 | [NAME] | Arsenal | £5.0m | 148 | 148
6 | 564 | F Lampard | Chelsea | £8.5m | 189 | 189
7 | 622 | S Gerrard | Liverpool | £8.5m | 123 | 129
8 | 691 | J Milner | [NAME] | £4.5m | 29 | 35
9 | 534 | D Dunn | [NAME] | £2.0m | 41 | 46
10 | 952 | D Bent | Sunderland | £3.0m | 89 | 89
11 | 978 | [NAME] | Fulham | £2.5m | 84 | 97
 |  |  |  | Total | 1036 | 1091 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sonia
No. | Code | Name | Club | Cost | Wk18-19 | Wk20 | Wk21 | Wk22 | Wk23 | Wk24 | Wk25 | Wk26 | Wk27 | Wk28 | Wk29 | Wk30 | Wk31 | Wk32 | Wk33
1 | 065 | S Given | Manchester City | £4.5m | 85 | 91
2 | 171 | B [NAME] | Chelsea | £3.0m | 102 | 112
3 | 168 | R Carvalho | Chelsea | £4.5m | 30 | 29
4 | 104 | [NAME] | Arsenal | £5.0m | 100 | 100
5 | 247 | J Evans | [NAME] | £4.0m | 52 | 55
6 | 691 | J Milner | [NAME] | £4.5m | 185 | 191
7 | 655 | R [NAME] | [NAME] | £4.0m | 50 | 50
8 | 527 | A Young | [NAME] | £5.5m | 122 | 138
9 | 900 | C [NAME] | Manchester City | £5.0m | 76 | 76
10 | 999 | K Doyle | [NAME] | £2.0m | 65 | 65
11 | 896 | W Rooney | [NAME] | £8.0m | 291 | 309
 |  |  |  | Total | 1158 | 1216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 681369d1591533511-amend-complex-if-formula-based-on-a-specific-condtion-in-a-column-if-formla-bin-bags
Sheet: TESTBIN

header | header | Tariff No | Description | header | Pack [NAME] | Packs | Per packs | LITRAGE | Litrage Litres | Sugar Per Litre | % alcohol | Qté fact. | [NAME] | UVC | QTY2 | Unit | Qty_1 | Litres | Sugar | Description | Statist ical Unit
2633134 | data | 61046200 | LEGGINGS | data | #N/A |  |  |  |  |  |  | 3 | 15 | 45 |  |  |  |  |  | Data | U
1480593 | data | 62046200 | TROUSERS | data | #N/A |  |  |  |  |  |  | 2 | 10 | 20 |  |  |  |  |  | Data | U
3638311 | data | 21069060 | SYRUP | data | 1*6*50CL |  |  |  |  |  |  | 1 | 6 | 6 |  |  |  |  |  | Data | [NAME]
3637494 | data | 21069060 | SYRUP | data | 1*6*50CL |  |  |  |  |  |  | 1 | 6 | 6 |  |  |  |  |  | Data | [NAME]
5112700 | data | 39232920 | BINS BAGS | data | 210* 10 * 50L |  |  |  |  |  |  | 6 | 35 | 210 |  |  |  |  |  | Data | [NAME]
5112780 | data | 39232920 | BINS BAGS | data | 220* 10 * 100L |  |  |  |  |  |  | 10 | 22 | 220 |  |  |  |  |  | Data | [NAME]
5955100 | data | 39232920 | BINS BAGS | data | 144* 10 * 100L |  |  |  |  |  |  | 6 | 24 | 144 |  |  |  |  |  | Data | [NAME]
4172002 | data | 39232920 | BINS BAGS | data | 144* 20 * 30L |  |  |  |  |  |  | 6 | 24 | 144 |  |  |  |  |  | Data | [NAME]
3874620 | data | 39232920 | BINS BAGS | data | 180* 10 * 50L |  |  |  |  |  |  | 6 | 30 | 180 |  |  |  |  |  | Data | [NAME]
2142066 | data | 39232920 | BINS BAGS | data | 75* 8 * 130L |  |  |  |  |  |  | 5 | 15 | 75 |  |  |  |  |  | Data | [NAME]
5763682 | data | 39232920 | BINS BAGS | data | 120* 10 * 120L |  |  |  |  |  |  | 5 | 24 | 120 |  |  |  |  |  | Data | [NAME]
7220074 | data | 34022090 | CLEANING PREPARATIONS | data | #N/A |  |  |  |  |  |  | 3 | 9 | 27 |  |  |  |  |  | Data | [NAME]
1858042 | data | 34022090 | CLEANING PREPARATIONS | data | #N/A |  |  |  |  |  |  | 2 | 14 | 28 |  |  |  |  |  | Data | [NAME]
1142357 | data | 22021011 | TONIC WATER | data | 2*6*1,5L |  |  |  |  |  |  | 2 | 6 | 12 |  |  |  |  |  | Data | L
1262090 | data | 22030019 | BEER BT | data | 2*10*25CL |  |  |  |  |  |  | 1 | 2 | 2 |  |  |  |  |  | Data | L
1704625 | data | 22011011 | SPARKLING WATER. | data | 1*6*1L |  |  |  |  |  |  | 1 | 6 | 6 |  |  |  |  |  | Data | L
Spreadsheet: 99086d1297852059-excel-2007-average-certain-cells-of-5-worksheets-only-if-other-cells-meet-criteria-sample-averagas-by-category
Sheet: Person 1

 | Date | Date | Date | Date | Date | Date
 | 2009-01-15 00:00:00 | 2009-11-10 00:00:00 | 2010-02-27 00:00:00
Height
Age
Weight | 220 | 210 | 196
RHR
Title (L, E, or F) | E | E | F
(Of the three dates for which data was recoreded, in the most recent, D15 = "F", so D10 should (196) be included in the average formula.)
Spreadsheet: jeff_dasovich__14055__OAT Financials
Sheet: Income Statement

DOLLARS IN MILLIONS (EXCEPT PER SHARE DATA)
YEAR ENDED DECEMBER 31 |  |  |  |  |  |  |  |  |  |  | (% of total operating revenue)
 | 2000 | 1999 | 1998 | 1997 | 1996 | 1995 |  | 2000 | 1999 | 1998 | 1997 | 1996 | 1995 | Average |  | 2001
NET SALES................................................... | 5041 | 4725.2 | 4842.5 | 5015.7 | 5199 | 5954
Cost of goods sold.......................................... | 2288.3 | 2136.8 | 2374.4 | 2564.9 | 2807.5 | 3294.4
Gross profit................................................ | 2752.7 | 2588.4 | 2468.1 | 2450.8 | 2391.5 | 2659.6
Selling, general and administrative expenses................ | 1968.8 | 1904.1 | 1872.5 | 1938.9 | 1981 | 2358.8
Restructuring charges, asset impairments and (gains) losses on divestitures - Net | 182.5 | -2.3 | 128.5 | 1486.3 | -113.4 | -1053.5
Interest expense............................................ | 54 | 61.9 | 69.6 | 85.8 | 106.8 | 131.6
Interest income............................................. | -9 | -11.7 | -10.7 | -6.7 | -7.4 | -6.2
Foreign exchange loss -- net................................ | 5.3 | 18.1 | 11.6 | 10.8 | 8.9 | 8.4
INCOME BEFORE INCOME TAXES.................................. | 551.1 | 618.3 | 396.6 | -1064.3 | 415.6 | 1220.5
Provision for income taxes.................................. | 190.5 | 163.3 | 112.1 | -133.4 | 167.7 | 496.5
Net Income.................................................. | 360.6 | 455 | 284.5 | -930.9 | 247.9 | 724
Preferred dividends -- net of tax........................... | 4.2 | 4.4 | 4.5 | 3.5 | 3.7 | 4
NET INCOME AVAILABLE FOR COMMON............................. | 356.4 | 450.6 | 280 | -934.4 | 244.2 | 720
PER COMMON SHARE:
Net income................................................ | 2.71 | 3.36 | 2.04 | -6.8 | 1.8 | 5.39
Net income -- diluted..................................... | 2.61 | 3.23 | 1.97 | -6.8 | 1.78 | 5.23
Dividends declared........................................ | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14
Average Number of Common Shares Outstanding (in thousands) | 131689 | 134027 | 137185 | 137460 | 135466 | 134149
 |  |  | COMMON-SIZE INCOME STATEMENT |  |  | (% of total operating revenue)
 | 2000 | 1999 | 1998 | 1997 | 1996 | 1995 | Average
NET SALES...................................................
Cost of goods sold..........................................
Gross profit................................................
Selling, general and administrative expenses................
Restructuring charges, asset impairments and (gains) losses on divestitures - Net
Interest expense............................................
Interest income.............................................
Foreign exchange loss -- net................................
INCOME BEFORE INCOME TAXES..................................
Provision for income taxes..................................
Net Income..................................................
Preferred dividends -- net of tax...........................
NET INCOME AVAILABLE FOR COMMON.............................
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 11b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 28 | 2 | 14 | 53 | 13 | 23 | 12 | 145
Cross-Currency Fixed-Fixed | 2 | - | 4 | 5 | - | 1 | 5 | 17
Cross-Currency Fixed-Float | 1 | - | - | 16 | - | - | 44 | 61
TOTAL | 31 | 2 | 18 | 74 | 13 | 24 | 61 | 223
Spreadsheet: 240663d1370382018-duplicate-entries-in-rows-add-accompanying-data-to-new-columns-mergesample
Sheet: AFTER

DOC | USER | DEPT | CLASS | BRAND | MODEL | PRICE | COST | BEGIN | END | DOC2 | PRICE2 | BEGIN2 | END2 | DOC3 | PRICE3 | BEGIN3 | END3 | DOC4 | PRICE4 | BEGIN4 | END4
46666 | 180 | 0 | 8 | LG | 42PN4500 | 499 | 449 | 06-02-2013 | 06-08-2013 | 46712 | 489 | 06-09-2013 | 06-15-2013
46664 | 180 | 0 | 8 | SAMSUN | PN43F4500 | 399 | 349 | 06-02-2013 | 06-08-2013
46666 | 180 | 0 | 10 | LG | 50PN4500 | 599 | 519 | 06-02-2013 | 06-08-2013 | 46712 | 589 | 06-09-2013 | 06-15-2013 | 46717 | 579 | 2013-06-16 00:00:00 | 2013-06-25 00:00:00
47711 | 180 | 0 | 10 | LG | 60PN6500 | 699 | 599 | 06-09-2013 | 06-15-2013
Spreadsheet: 08c04032-0b6c-47b3-b038-6fa840d65f8a
Sheet: 3-Budget Detail

BUDGET DETAIL
District/BOCES:
School:
Facility:
1 | 2 | 3 | 4 | 5
Program | Budget Object | Funding Year | Cost | Description-Must include sufficient detail to support budget request
REQUIREMENT:  EACH OF THE FOUR YEARS MUST BE ENTERED TOGETHER.  THIS WORKSHEET IS PROTECTED AND CANNOT BE SORTED.
Instructional Program | Salaries (0100) | Year1 | 25000 | .5 Increase in salary of Behaviour Interventionist at ABC High School.
Spreadsheet: 684115d1593154387-timestamp-series-are-not-being-created-via-formula-sample-workbook
Sheet: Option1

Time | Time Reformatted | Column A | Column B
10/1/18, 12:00:00 AM PDT | 10-1-2018 12:00 | 0 | 1
10/1/18, 12:15:00 AM PDT |  | 0 | 1
10/1/18, 12:30:00 AM PDT |  | 0 | 1
10/1/18, 12:45:00 AM PDT |  | 0 | 1
10/1/18, 1:00:00 AM PDT |  | 0 | 1
10/1/18, 1:15:00 AM PDT |  | 0 | 1
10/1/18, 1:30:00 AM PDT |  | 0 | 1
10/1/18, 1:45:00 AM PDT |  | 1 | 1
10/1/18, 2:00:00 AM PDT |  | 1 | 1
10/1/18, 2:15:00 AM PDT |  | 0 | 1
10/1/18, 2:30:00 AM PDT |  | 1 | 1
10/1/18, 2:45:00 AM PDT |  | 0 | 1
10/1/18, 3:00:00 AM PDT |  | 0 | 1
10/1/18, 3:15:00 AM PDT |  | 0 | 1
10/1/18, 3:30:00 AM PDT |  | 0 | 1
10/1/18, 3:45:00 AM PDT |  | 0 | 1
10/1/18, 4:00:00 AM PDT |  | 0 | 1
10/1/18, 4:15:00 AM PDT |  | 0 | 1
Spreadsheet: 850993d1701271700-count-occurences-of-conditional-sumif-experts-only-excel-help-forum-tricky-tricky
Sheet: Sheet1

Date | Customer | Units
2019-01-01 00:00:00 | A | 10
2019-01-01 00:00:00 | B | 5 |  |  | Objective
2020-01-01 00:00:00 | C | 5 |  |  | Count the number of customers who have purchased 30 or more units in a given year
2019-01-01 00:00:00 | A | 10
2021-01-01 00:00:00 | B | 25
2022-01-01 00:00:00 | C | 5
2022-01-01 00:00:00 | A | 35 |  |  | Desired output
2021-01-01 00:00:00 | B | 5 |  |  | 2019 | 2020 | 2021 | 2022
2022-01-01 00:00:00 | C | 5 |  | # of Customers | 1 | 0 | 1 | 2
2019-01-01 00:00:00 | A | 10
2019-01-01 00:00:00 | B | 20
2020-01-01 00:00:00 | C | 10
2019-01-01 00:00:00 | C | 20
2021-01-01 00:00:00 | B | 10
2022-01-01 00:00:00 | C | 5
2022-01-01 00:00:00 | A | 5
2021-01-01 00:00:00 | B | 1
2022-01-01 00:00:00 | C | 20
Spreadsheet: sara_shackleton__36403__Schedule B
Sheet: Sheet1

Schedule B
The following Debt Service Compliance Certificate outlines the Counterparty's projected sources of cash flow, and Funded Debt Service Obligations as a means of determining whether Excess Cash Flow or Deficiency
exists.  If a Deficiency exists the Certificate displays what cash balances or reserves are available to eliminate such Deficiency and then based on such cash balances and/or reserves calculates an Adjusted Cash Flow balance.
A negative Adjusted Cash Flow balance would trigger that a MAC has occurred
 |  |  |  |  | First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Annual
 |  |  |  |  | 1/1/2000 - 3/31/2000 | 4/01/2000 - 6/30/2000 | 7/1/2000 - 9/30/2000 | 10/01/2000 - 12/31/2000 | 1/01/2000 - 12/31/2000
Operating Revenues:
Member ower Sales |  |  |  |  | 39890005
Non-Member Power Sales |  |  |  |  | 87369676
Total Operrating Revenues
Operating Income Before Interest Expense |  |  |  |  | 30291380
Add: Depreciation and Amortization |  |  |  |  | 23152311
Add: Lease Expense |  |  |  |  | 11690650
Less: Capital expenditures and other non Debt Service obligations.
Cash Flow before Debt Service
Less: Funded Debt Debt Service Obligations
(i) | CFC Notes (Principal and interest) |  |  |  | 39926484
(ii) | Bonanza Purchase Money Note ([NAME] and interest)
(iii) | GECC Secured Participation Note ([NAME] and interest)
(iv) | GECC Secured Excess Cash Flow Note ([NAME] and interest)
(vi) | RUS Replacement Note ([NAME] and interest)
(vii) | RUS Notes (Principal and interest)
(viii) | Capital Lease Obligations - Surface Mining Equipment (Lease Payment) |  |  |  | 11690650
(x) | Capital Lease Obligations - Underground Mining Equipment (Lease Payment)
(xi) | Operating Lease Obligations - Surface Mining Equipment (Lease Payment)
(xii) | Other
Total Debt Service
Excess Cash Flow/(Deficiency)
Available Cash Balances |  |  |  |  | 6937306 | 0 | 0 | 0 | 0
Available Reserves to Offset Deficiency |  |  |  |  | 18533573 | 0 | 0 | 0 | 0
Adjusted Cash Flow
Spreadsheet: 86431d1286403954-auto-data-migration-to-autofill-order-form-charlie-2010-hydronix-usa-list-price-version-6
Sheet: Purchase Order

 | [NAME]
XYZ Company |  |  |  |  | Date: | 2010-10-01 00:00:00
 |  |  |  |  | P.O. #: | 255
 |  |  |  |  | HDX OC#
Vendor |  |  | Ship to | [Name]
 | Hydronix Water Technology |  |  | [Company Name]
 | 13626 Monte Vista Ave Bldg. C |  |  | [Street Address]
 | [NAME], CA 91710 |  |  | [City, ST  ZIP Code]
 | T. [PHONE]  F. [PHONE] |  |  | [Phone]
Shipping Method |  | Shipping Terms |  |  | Delivery Date
Qty | Item # | Description |  |  | Unit Price | Line Total
 |  |  |  |  | Subtotal
 |  |  |  |  | Sales Tax
 |  |  |  |  | Total
 |  |  |  | Authorized by |  | Date
[Street Address], [City, ST  ZIP Code]  [Phone]  [Fax]  [E-mail]
Spreadsheet: 793317d1661413002-how-to-match-graded-tax-number-with-gender-contributions
Sheet: Sheet1

EMPLOYEENUMBER | FIRSTNAME | SURNAME | DOB | IDNUMBER | GRADED TAX NUMBER | CONTRIBUTION | SUPPLEMENTARY CONT | MONTHLYPENSALARY | GENDER
MGT-02 | [NAME] | Smith | 1978-10-24 00:00:00 | 7810241100200 | 3260-01-300006780 | 330 | 0 | 3300 | Female
MGT-03 | [NAME] | Reynolds | 1976-04-26 00:00:00 | 7604261100046 | 2160-01-039824455 | 330 | 0 | 3300 | Female
SH-094 | [NAME] | Blade | 1992-09-06 00:00:00 | 9209061100309 | 3260-01-406829148 | 202.7317788461538 | 0 | 2027.317788461538 | Female
SH-119 | [NAME] | [NAME] | 1994-09-18 00:00:00 | 9409186100537 | 3206-05-406824026 | 230.7766153846154 | 0 | 2307.766153846154 | Male
SH-129 | [NAME] | Gordons | 2000-04-26 00:00:00 | [PHONE] | 3209-01-406900605 | 212.6104615384615 | 0 | 2126.104615384615 | Male
SH-029 | [NAME] | Dolphy | 1984-10-03 00:00:00 | 8410036100033 | 4320-01-000533968 | 272.3799143563035 | 0 | 2723.799143563034 | Male
Spreadsheet: 133007d1324080601-excel-2007-lookup-text-and-values-lookup
Sheet: Sheet1

GEORGE | SMITH
 | ITEM |  |  |  |  |  | AA
 | ====
 | AA | APO | 0 | 0
 | BB | BAR | 8 | 1179.8
 | CC | CANS | 4 | 719.88
 | DD | DISTI | 0 | 0
 | EE | EMPTY | 0 | 0
 | FF | FRE | 0 | 0
 | GG | GOR | 0 | 50
 | HH | HYDRO | 0 | 0
 | II | ICE | 0 | 0
 | JJ | JAMN | 0 | 0
 | KK | KANT | 9 | 1264.64
 | LL | LABOR | 0 | 0
 | MM | MRCH | 0 | 0
 | OO | ORDER | 0 | 0
 | PP | PLACED | 0 | 0
 | QQ | QUIN | 0 | 0
 | RR | RAMPT | 1 | 149.99
 | SS | SALE | 0 | 0
 | TT | TEMP | 1 | 349.99
 | UU | ULTR | 42 | 405.37
 | VV | VIV | 30 | 2956.66
 | WW | WINDO | 0 | 0
 | XX | EXTEN | 0 | 0
 | YY | YEAR | 0 | 0
 | ZZ | ZANDER | 0 | 0
Spreadsheet: 116496d1311868397-duplicate-value-in-pivot-tabel-help-pivot
Sheet: Sheet1

Street | type gas | defect | length m | concat | length unique
Ceausescu Street | gas | 1 | 201 | [NAME] Streetgas10201 | 201
Ceausescu Street | gas | 1 | 201 | [NAME] Streetgas10201 | 0
Noua Street | gas | 1 | 100 | Noua Streetgas10100 | 100
Vechea Street | gas | 1 | 502 | Vechea Streetgas10502 | 502
Vechea Street | gas | 1 | 678 | Vechea Streetgas10678 | 678
Ceausescu street | gas | 1 | 400 | [NAME] | 400
Plantelor Street | gas | 1 | 90 | Plantelor Streetgas10090 | 90
Ceausescu Street | gas | 1 | 201 | [NAME] Streetgas10201 | 0
Ceausescu Street | gas | 1 | 201 | [NAME] Streetgas10201 | 0
Ceausescu Street | gas | 1 | 155 | [NAME] Streetgas10155 | 155
Sum of length unique
Street | Total
Ceausescu Street | 756
Noua Street | 100
Plantelor Street | 90
Vechea Street | 1180
Grand Total | 2126
Spreadsheet: 775509d1649158477-analysing-duplicates-in-a-column-based-on-a-value-in-another-example
Sheet: Sheet1

Module | Grade
ENG12300 | A
Ling10010 | B-
Ling10010 | Not Available
Ling10010 | WN
Ling10010 | WX
Ling10010 | WN
ENG10020 | FM
ENG10130 | C+
ENG10130 | WN
ENG10130 | WN
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: result

PLAYER | No | PAR 3 | TOTAL |  | s/index 1 | s/index 2 | s/index 3 |  |  |  | No | PLAYER | PAR 3 | TOTAL |  | s/index 1 | s/index 2 | s/index 3 | PLAYING
 | 1 |  |  |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  | 10
 | 10 |  |  |  |  |  |  |  |  |  | 11
 | 11 |  |  |  |  |  |  |  |  |  | 12
 | 12 |  |  |  |  |  |  |  |  |  | 13
 | 13 |  |  |  |  |  |  |  |  |  | 14
 | 14 |  |  |  |  |  |  |  |  |  | 15
 | 15 |  |  |  |  |  |  |  |  |  | 16
 | 16 |  |  |  |  |  |  |  |  |  | 17
 | 17 |  |  |  |  |  |  |  |  |  | 18
 | 18 |  |  |  |  |  |  |  |  |  | 19
 | 19 |  |  |  |  |  |  |  |  |  | 20
 | 20 |  |  |  |  |  |  |  |  |  | 21
 | 21 |  |  |  |  |  |  |  |  |  | 22
 | 22 |  |  |  |  |  |  |  |  |  | 23
 | 23 |  |  |  |  |  |  |  |  |  | 24
 | 24 |  |  |  |  |  |  |  |  |  | 25
 | 25 |  |  |  |  |  |  |  |  |  | 26
 | 26 |  |  |  |  |  |  |  |  |  | 27
 | 27 |  |  |  |  |  |  |  |  |  | 28
 | 28 |  |  |  |  |  |  |  |  |  | 29
 | 29 |  |  |  |  |  |  |  |  |  | 30
 | 30 |  |  |  |  |  |  |  |  |  | 32
 | 31 |  |  |  |  |  |  |  |  |  | 33
 | 32 |  |  |  |  |  |  |  |  |  | 34
 | 33 |  |  |  |  |  |  |  |  |  | 35
 | 34 |  |  |  |  |  |  |  |  |  | 36
 | 35 |  |  |  |  |  |  |  |  |  | 37
 | 36 |  |  |  |  |  |  |  |  |  | 38
 | 37 |  |  |  |  |  |  |  |  |  | 39
 | 38 |  |  |  |  |  |  |  |  |  | 40
 | 39 |  |  |  |  |  |  |  |  |  | 42
 | 40 |  |  |  |  |  |  |  |  |  | 43
 | 41 |  |  |  |  |  |  |  |  |  | 44
 | 42 |  |  |  |  |  |  |  |  |  | 45
 | 43 |  |  |  |  |  |  |  |  |  | 46
 | 44 |  |  |  |  |  |  |  |  |  | 47
 | 45 |  |  |  |  |  |  |  |  |  | 48
 | 46 |  |  |  |  |  |  |  |  |  | 49
 | 47 |  |  |  |  |  |  |  |  |  | 50
 | 48 |  |  |  |  |  |  |  |  |  | 51
 | 49 |  |  |  |  |  |  |  |  |  | 52
 | 50 |  |  |  |  |  |  |  |  |  | 53
 | 51 |  |  |  |  |  |  |  |  |  | 54
 | 52 |  |  |  |  |  |  |  |  |  | 55
 | 53 |  |  |  |  |  |  |  |  |  | 56
 | 54 |  |  |  |  |  |  |  |  |  | 57
 | 55 |  |  |  |  |  |  |  |  |  | 58
 | 56 |  |  |  |  |  |  |  |  |  | 59
 | 57 |  |  |  |  |  |  |  |  |  | 60
 | 58 |  |  |  |  |  |  |  |  |  | 61
 | 59 |  |  |  |  |  |  |  |  |  | 62
 | 60 |  |  |  |  |  |  |  |  |  | 63
 | 61 |  |  |  |  |  |  |  |  |  | 64
 | 62 |  |  |  |  |  |  |  |  |  | 65
 | 63 |  |  |  |  |  |  |  |  |  | 31
 | 64 |  |  |  |  |  |  |  |  |  | 66
 | 65 |  |  |  |  |  |  |  |  |  | 67
 | 66 |  |  |  |  |  |  |  |  |  | 68
 | 67 |  |  |  |  |  |  |  |  |  | 69
 | 68 |  |  |  |  |  |  |  |  |  | 70
 | 69 |  |  |  |  |  |  |  |  |  | 71
 | 70 |  |  |  |  |  |  |  |  |  | 72
 | 71 |  |  |  |  |  |  |  |  |  | 73
 | 72 |  |  |  |  |  |  |  |  |  | 74
 | 73 |  |  |  |  |  |  |  |  |  | 75
 | 74 |  |  |  |  |  |  |  |  |  | 76
 | 75 |  |  |  |  |  |  |  |  |  | 77
Spreadsheet: 699359d1602563082-trying-to-return-a-large-range-of-vlookup-based-on-dates-new-budget-sheet-2-
Sheet: Main Budget

PAY | Monthly BILLS | DUE DATES |  | Date | PAY | Bi-Weekly | TYPE
2600 | Mortgage (3755): | ([NAME]) Auto - 1st |  | 1 | 1300 | Mortgage (3755): | ([NAME]) Auto
90.98 | FuboTV | (6307 Discover) Auto - 3th |  | 3 | 90.98 | FuboTV | (6307 Discover) Auto
85 | FedLoan: | (Main Chase Checking) Auto - 4th |  | 4 | 85 | FedLoan: | (Main Chase Checking) Auto
13.93 | [NAME]: | (6307 Discover) Auto - 4th |  | 4 | 13.93 | [NAME]: | (6307 Discover) Auto
0 | Discover (6195): | 5th |  | 5 | 0 | Discover (6195):
0 | BlueCash CC (): | 7th |  | 7 | 0 | BlueCash CC ():
0 | SavorOne (4972): | 8th |  | 8 | 0 | SavorOne (4972):
493.18 | Ascent: | (Main Chase Checking) Auto - 9th |  | 9 | 493.18 | Ascent: | (Main Chase Checking) Auto
250 | WJ Utilities: | (9486 Chase Credit) Auto - 10th |  | 10 | 250 | WJ Utilities: | (9486 Chase Credit) Auto
76 | Dominion Gas: | (Main Chase Checking) Auto - 12th |  | 12 | 76 | Dominion Gas: | (Main Chase Checking) Auto
65.16 | Auto Ins: | (6307 Discover) Auto - 16th |  | 16 | 65.16 | Auto Ins: | (6307 Discover) Auto
0 | Citi CC (3588): | 21st |  | 21 | 0 | Citi CC (3588):
0 | Chase Freedom CC (9486): | 21st |  | 21 | 0 | Chase Freedom CC (9486):
50.5 | Xfinity Internet: | (6307 Discover) Auto - 21st |  | 21 | 50.5 | Xfinity Internet: | (6307 Discover) Auto
140 | Rocky Power: | (Main Chase Checking) Auto - 29th |  | 29 | 140 | Rocky Power: | (Main Chase Checking) Auto
5.35 | Apple Music: | (6307 Discover) Auto - 29th |  | 29 | 5.35 | Apple Music: | (6307 Discover) Auto
140 | Koda School: | ([NAME]) - 30th |  | 30 | 140 | Koda School: | [NAME]
1000 | Groceries (9786): |  |  |  | 500 | Groceries (9786):
180 | Gas (5138): |  |  |  | 90 | Gas (5138):
60 | Medical (9809): |  |  |  | 30 | Medical (9809):
300 | Shopping (9122): |  |  |  | 150 | Shopping (9122):
300 | Date Night (9528): |  |  |  | 150 | Date Night (9528):
0 | Extra (5321): |  |  |  | 0 | Extra (5321):
0 | [NAME] (6560): |  |  |  | 0 | [NAME] (6560):
0.1 | Tithing (5989): |  |  |  | 0.1 | Tithing (5989):
50 | [NAME] (0528): |  |  |  | 25 | [NAME] (0528):
50 | [NAME] (9927): |  |  |  | 25 | [NAME] (9927):
50 | Kenai Sav (0846): |  |  |  | 25 | Kenai Sav (0846):
20 | Emergency Sav (1501): |  |  |  | 10 | Emergency Sav (1501):
0 | Debts (0179): |  |  |  | 0 | Debts (0179):
 | TOTAL: |  |  |  |  | TOTAL:
Spreadsheet: 134733d1325604696-help-modifying-formula-to-remove-the-need-for-helper-columns-monthtest
Sheet: Calcs

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  | Franchise 1