tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40413d1238719114-adding-rows-with-control-number-that-only-repeat-3-times-formula-scratch
Sheet: Sheet1

[NAME] | Control Number | # of 0:15 | Admin1 + Admin2
201 | 4010101 | 8 | QQJJPJJJPPJJJJJJJJJJPJJJJJJJQJQJJJ
202 | 4010101 | 6 | [NAME]
203 | 4010101 | 7 | DDQJJDDDDDDDDDDDDDJJQJJJJJJJJQQQQQ
201 | 4010102 | 4 | JJJJQJJJQJJJJJJJJJJJJJJJJQJJJJJJQJ
202 | 4010102 | 14 | JJJJJJJJJ              PPPPPPPPPPPPPPJJJJJJJ
203 | 4010102 | 12 | DDDDJJDDDDDDDDQQQJJJJJJJQQQQQQQQQD
201 | 4010103 | 16 | CQQQQJJJJQQQQQQJJQQJJJJJJJQQQQCCCCC | this control number only has one cycle, so it has to be ignored in the results
201 | 4020101 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
202 | 4020101 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
203 | 4020101 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCCC
201 | 4020103 | 0 | [NAME]
202 | 4020103 | 0 | JDDJJJJJJJJJDJJJJJJJJJJJDJJJJDJJ
203 | 4020103 | 1 | DJJDJJJJJJJJJJDJJJJJJJJJJJJQJJJJD
201 | 4020105 | 15 | CCCCCCKKKKKKKCCCCCCCCKKKKKKKKC
202 | 4020105 | 0 | JJCCCJJCCCCCCCCCCCCCCJJJJJJCCCCCJ
203 | 4020105 | 15 | KKKKKKKCCCCCCCCCCCCCCKKKKKKKCCCCCK
Results should be something like this:
[NAME] | Control Number | # of 0:15
201202203 | 4010101 | 21
201202203 | 4010102 | 30
201 | 4010103 | 0 | deleted or ignored if control number only has 1 or 2 cycles
201202203 | 4020101 | 0 | also if possible to ignore or delete control numbers that total out to zero for their three quarter cylces
201202203 | 4020103 | 1
201202203 | 4020105 | 30
Spreadsheet: 330559d1404801274-generate-combinations-of-multiple-columns-sample
Sheet: Sheet1

Manager | Action A | From Side Menu
Supervisor | Action B | From Top Menu
Employee | Action C
=INDEX(A$2:A$4;CEILING(ROWS($A$1:A1);2)/2)
 |  |  | =INDEX(C$2:C$3;MOD(ROWS(A1:$A$1)-1;2)+1)
Spreadsheet: 78515d1278925825-excel-2007-if-formula-in-chart-charting_help-1xls
Sheet: 2001

 |  |  |  |  |  |  |  |  |  | Chart
 |  | Price | Quantity |  |  |  |  |  |  |  | Grape
 | Apple | 10 | 34 |  |  |  |  |  |  |  | price | quantity
 | Grape | 10 | 43 |  |  |  |  |  |  | 2001 | 10 | 43
 | Orange | 10 | 23 |  |  |  |  |  |  | 2002 | 20 | 22
 | Pineapple | 10 | 34 |  |  |  |  |  |  | 2003 | 30 | 11
 | [NAME] | 10 | 43
Spreadsheet: 106215d1303396707-excel-2007-conditional-formatting-to-range-of-cells-sample-list
Sheet: Sheet1

First Name | Last Name | Company | Type of Business | First Contact
[NAME] | Smith | [NAME]'s Fruit Stand | Fruits | 2010-06-05 00:00:00
[NAME] | Cobb | [NAME] be Organic | Vegetables | 2008-07-01 00:00:00
[NAME] | Bubble | [NAME]'s Snack Hut | Fruits | 2007-05-06 00:00:00
[NAME] | Vanderhoeven | [NAME] | Dry Goods | 2001-04-07 00:00:00
[NAME] | Squire | Nannie's Fresh Pies | Fruits | 2005-07-07 00:00:00
Masie | McGhee | Start Fresh | Vegetables | 2006-04-05 00:00:00
[NAME] | Mitchell | [NAME]'s [NAME] | Dry Goods | 2004-05-05 00:00:00
 |  |  | Fruits
 |  |  | Vegetables
 |  |  | Dry Goods
Spreadsheet: 746966d1631141652-race-position-tracker-calc-ahead-and-behind-relative-to-own-position-race-position-tracker-calc
Sheet: Sheet1

Position | Car | Gap | Diff | AB
1 | 99
2 | 14 | 10 | 10 | 43
3 | 22 | 4 | 14 | 33
4 | 01 | 12 | 26 | 29
5 | 66 | 5 | 31 | 17
6 | 11 | 12 | 43 | 12
7 | 44 | 20 | 63
8 | 77 | 2 | 65 | 2
9 | 653 | 3 | 68 | 5
10 | 666 | 8 | 76 | 13
11 | 172 | 24 | 100 | 37
12 | 171 | 1L | 1L | 1L
13 | 12 | 2L | 3L | 3L
14 | 67 | 3L | 6L | 4L
Spreadsheet: 798477d1664495030-filter-miss-behaving-example-unique-filter-miss-behaving
Sheet: Working

Employee Name | Pay Period Start | Pay Period End | Pay Date | Hours | Gross Wages |  |  | To make it work… notice the date had to be altered… then the filter accepts this group… which is not possible as the date was correct
Employee A | 2021-01-16 00:00:00 | 2021-01-29 00:00:00 | 2021-02-02 00:00:00 | 76.88 | 1307.02 |  |  |  | 2021-01-29 00:00:00 | 2021-02-02 00:00:00
Employee B | 2021-01-16 00:00:00 | 2021-01-29 00:00:00 | 2021-02-02 00:00:00 | 64.77 | 1133.42 |  |  | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-02-17 00:00:00 | But notice how these have shared start/end dates with a miss aligned pay date and it is working….??
Employee C | 2021-01-16 00:00:00 | 2021-01-29 00:00:00 | 2021-02-02 00:00:00 | 79.05 | 1343.85 |  |  | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-03-02 00:00:00
Employee D | 2021-01-16 00:00:00 | 2021-01-29 00:00:00 | 2021-02-02 00:00:00 | 79.57 | 1352.63
Employee A | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-02-17 00:00:00 | 75.42 | 1282.08
Employee B | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-02-17 00:00:00 | 63.8 | 1116.5 |  |  |  |  |  | So why the ONE cell in the middle?
Employee C | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-02-17 00:00:00 | 79.27 | 1347.53
Employee D | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-02-17 00:00:00 | 53.87 | 915.73
Employee A | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-03-02 00:00:00 | 35.93 | 610.87
Employee B | 2021-02-01 00:00:00 | 2021-02-14 00:00:00 | 2021-03-02 00:00:00 | 32.48 | 568.46
Spreadsheet: 267022d1379914040-calculating-if-formulas-to-compute-overtime-pay-sunrise-credit-union-weekly-payroll
Sheet: Payroll Data

Sunrise Credit Union
Norfolk Branch
Name | No. of Dependents | Hourly Wage | Hours Worked | Regular Pay | Overtime Pay | Gross Pay | Taxable Pay | Federal Withholding Tax | FICA | Net Pay
Abram | 2 | 9.95 | 48
Acosta | 1 | 9.55 | 48
Bordeaux | 3 | 11.75 | 50
Higinbotham | 1 | 11.75 | 35
Ianziti | 1 | 10 | 40
[NAME] | 1 | 9.55 | 44
Ling | 3 | 15.75 | 40
Munoz | 2 | 12.25 | 20
Riley | 3 | 13.35 | 38
Sabey | 2 | 10 | 45
Trujillo | 1 | 9.95 | 15
Weston | 2 | 11.75 | 41
Totals
Assumptions |  |  | Taxable Pay | Tax Rate |  |  | Summary Statistics | # of Hours | Gross Pay | Net Pay
Base Work Hours | 40 |  | 0 | 0.15 |  |  | Average
Overtime rate | 1.5 |  | 250 | 0.22 |  |  | Highest
FICA rate | 0.0765 |  | 300 | 0.25 |  |  | Lowest
Deduct per Depend | 50 |  | 450 | 0.28
 |  |  | 525 | 0.31
Notes |  |  |  |  |  |  |  | Bin | Hours | # Employees
1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40. |  |  |  |  |  |  |  |  | 0-19
2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate. |  |  |  |  |  |  |  |  | 20-29
3. The gross pay is the total of the regular pay and overtime pay. |  |  |  |  |  |  |  |  | 30-40
4. The taxable pay is the difference between the gross pay     and the product of the number of dependents and deduction per dependent. |  |  |  |  |  |  |  |  | Over 40
5. Federal withholding tax is calculated on the taxable pay based on the tax table.
6. FICA is calculated on the employee's gross pay.
7. The net pay is based on the gross pay, federal withholding tax, and FICA.
Spreadsheet: 157363d1337708848-index-matching-with-reference-column-after-data-rolling-trends
Sheet: Oct

 |  |  | Month Ending 10/31/11 |  |  |  |  |  |  |  |  | Year To Date
 |  |  |  |  | [NAME] |  | Revenue: |  |  |  |  |  |  | [NAME]
 |  |  |  |  | From Budget |  |  |  |  |  |  |  |  | From Budget
 | Budget |  | Actual |  | Fav (Unfav) |  |  |  |  | Budget |  | Actual |  | Fav (Unfav)
 | 186472 |  |  |  |  |  | Patient Service Revenue |  |  | 745889
 |  |  |  |  |  |  | Other Income
 |  |  |  |  |  |  | Total Revenue
Spreadsheet: 262787d1378288475-lookup-multiple-rows-where-2-conditions-must-be-met-look-up-multiple-rows-ans
Sheet: Sheet2

ID |  | Grp | D
2013-09-04 00:00:00 | 2013-09-05 00:00:00
 |  |  |  |  |  |  | Array formula is used
 |  |  |  |  |  |  | [NAME] can be dragged.
Spreadsheet: 685947d1594290206-stock-allocation-example-1-optimization-model
Sheet: Sheet1

 | Stock |  |  | Stock total | Rank |  |  |  |  |  |  |  |  |  |  | Qty to Fulfill
Code | WH1 | WH2 | WH3 | available | 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 |  | 6 | 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
CODE | FROM | TO | QTY |  | Allocations |  |  |  |  |  |  |  |  |  | Stock total
K-123 | WH1 | Store 1 | 2 | Code | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10 | allocated
K-123 | WH1 | Store 2 | 2 | K-123 | 0 | 2 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0
K-123 | WH2 | Store 2 | 1 | [NAME] | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K-123 | WH2 | Store 6 | 2 | K-125 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
K-123 | WH3 | Store 6 | 1 | [NAME] | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] | WH1 | Store 1 | 5 | K-127 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
[NAME] | WH2 | Store 1 | 1
K-125 | WH1 | Store 6 | 2 |  |  |  |  |  |  |  |  |  |  |  | priority function
[NAME] | WH1 | Store 4 | 1
[NAME] | WH1 | Store 5 | 1
K-127 | WH1 | Store 6 | 1
Spreadsheet: 216551d1361806795-copying-data-between-columns-if-condition-met-upload
Sheet: Sheet1

1A0B55 | 3 |  |  |  | 1A0B30 | 2 | 1488.145
1A0B50 | 2 |  |  |  | A0B58 | 1 | 1449.26
A0B64 | 1 |  |  |  | 1A0B55 | 3 | 1316.853333333333
1A0B48 | 1 |  |  |  | 1A0B50 | 2 | 1070.93
1A0TN1216 | 1 |  |  |  | A0B64 | 1 | 1088.52
1A1AM4 | 1 |  |  |  | 1A0B48 | 1 | 1894.61
1A1AM220 | 1 |  |  |  | 1A0TN1216 | 1 | 852.4
A1B8 | 1 |  |  |  | A1A48 | 1 | 6803.16
14A1B370 | 2 |  |  |  | 1A1AM4 | 1 | 423.9
14A1B362 | 1 |  |  |  | 1A1AM220 | 1 | 280.86
1A1B543 | 2 |  |  |  | A1B8 | 1 | 1461.88
1A1B693 | 1 |  |  |  | 14A1B370 | 1 | 497.78
1A1B390 | 1 |  |  |  | 14A1B362 | 2 | 679.53
1A1B384 | 2 |  |  |  | 1A1B543 | 1 | 1704.22
14A1B427 | 1 |  |  |  | 26A1B874 | 1 | 1605.23
26A1B638 | 1 |  |  |  | 1A1B1623 | 1 | 1035
Spreadsheet: 59634d1260222630-costing-problem-with-final-sale-price-costingproblem
Sheet: Sheet1

Base Cost | Handling | Margin % | Margin £ | Paypal | Selling Price | Paypal Check
10 | 0.2 | 0.2 | 2 | 0.4757999999999999 | 12.2 | 0.4757999999999999
15 | 0.2 | 0.2 | 3 | 0.7098 | 18.2 | 0.7098
250 | 0.2 | 0.2 | 50 | 11.7078 | 300.2 | 11.7078
10 | 0.2 | 0.15 | 1.5 | 0.4563 | 11.7 | 0.4563
15 | 0.2 | 0.15 | 2.25 | 0.68055 | 17.45 | 0.68055
250 | 0.2 | 0.15 | 37.5 | 11.2203 | 287.7 | 11.2203
Spreadsheet: 860206d1708401467-time-interval-extraction-time
Sheet: Sheet1

12:08:22 |  |  | <==
12:08:50 |  | 12:09:11
12:08:51 |  | 12:10:38
12:09:11 |  | 12:11:27
12:09:13 |  | 12:11:57
12:09:35 |  | 12:12:29
12:09:37 |  | 12:14:02
12:10:38 |  | 12:17:52
12:11:06 |  | 12:18:41
12:11:27 |  | 12:19:12
12:11:30 |  | 12:20:14
12:11:51 |  | 12:20:56
12:11:57 |  | 12:21:26
12:12:19 |  | 12:22:08
12:12:29 |  | 12:23:03
12:14:02 |  | 12:38:12
12:14:06 |  | 12:38:43
12:17:52 |  | 12:39:25
12:17:56 |  | 12:40:12
12:18:41 |  | 12:40:43
12:18:45 |  | 12:41:37
12:19:12 |  | 12:42:19
12:19:14 |  | 12:42:49
12:20:14 |  | 12:43:55
12:20:17 |  | 12:45:23
12:20:36 |  | 12:45:54
12:20:38 |  | 12:46:24
12:20:56 |  | 12:47:05
12:21:02 |  | 12:47:47
12:21:03 |  | 12:48:28
12:21:26 |  | 12:49:23
12:21:28 |  | 12:50:31
12:21:46 |  | 12:54:46
12:21:48 |  | 12:55:22
12:22:08 |  | 12:56:08
12:22:10 |  | 13:06:38
12:22:26 |  | 13:09:55
12:22:28 |  | 13:10:32
12:23:03
12:23:07
12:23:23
12:23:27
12:38:12
12:38:14
12:38:43
12:38:45
12:39:05
12:39:07
12:39:25
12:39:27
12:39:50
12:39:51
12:40:12
12:40:14
12:40:43
12:40:45
12:41:37
12:41:39
12:42:00
12:42:02
12:42:19
12:42:21
12:42:32
12:42:34
12:42:49
12:42:51
12:43:05
12:43:07
12:43:55
12:43:59
12:45:23
12:45:26
12:45:48
12:45:54
12:46:24
12:46:26
12:46:41
12:46:43
12:47:05
12:47:07
12:47:47
12:47:49
12:47:56
12:48:28
12:48:36
12:48:50
12:48:54
12:49:23
12:49:25
12:49:47
12:49:49
12:50:31
12:50:38
12:54:46
12:54:48
12:55:05
12:55:07
12:55:22
12:55:24
12:55:40
12:55:43
12:56:08
12:56:12
13:06:38
13:06:44
13:09:55
13:10:03
13:10:12
13:10:17
13:10:32
13:10:35
13:10:48
13:10:51
Spreadsheet: 549648d1511859664-display-text-from-range-without-losing-value-custom-conditional-data-bars-271117-projects-dashboard
Sheet: Resumen

Resumen Proyectos
[NAME] (6 meses)
Diagnóstico General
Project |  | Programación | Presupuesto | [NAME] | Calidad | Alcance | Riesgos | Problemas | Control Cambios | [NAME] | Prioridad
Rebuild techno-pm |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Rules Engine |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
eProjectCheck |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
eProjectDashbord.com |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
ClaimsSmart |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Diagnóstico por Área |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Diagnóstico Tareas
Project |  | Tareas | Inicio | Fin | A tiempo | Contingentes | Atrasadas | [NAME] | Progreso | [NAME] | [NAME]
Rebuild techno-pm |  |  |  |  |  |  |  |  | 20
Rules Engine |  |  |  | 2017-12-04 00:00:00 |  |  |  |  | 30
eProjectCheck |  |  |  | 2018-01-06 00:00:00 |  |  |  |  | 50
eProjectDashbord.com |  |  |  | 2018-01-10 00:00:00 |  |  |  |  | 60
ClaimsSmart |  |  |  | 2018-02-22 00:00:00 |  |  |  |  | 80
Total Tareas
Spreadsheet: 21eb3877-653b-405c-99f8-0d8c4b864974
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 19. Export Price Index by Selected ANZSIC Industry of Origin Division & Subdivision, Index Numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  Agriculture, forestry and fishing (A) ; |  |  | Original | A2295732L | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME] mining (11) ; |  |  | Original | A2295735V | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Metal ore mining (13) ; |  |  | Original | A2295738A | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Mining (B) ; |  |  | Original | A2295756F | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Food, beverages and tobacco (21) ; |  |  | Original | A2295741R | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Petroleum, coal, chemical and associated products (25) ; |  |  | Original | A2295744W | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Manufacturing (C) ; |  |  | Original | A2295759L | 1974-09-01 00:00:00 | 2009-03-01 00:00:00 | 139 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 153111d1335777743-find-multiple-text-criteria-and-return-as-yes-in-matrix-passed-course-matrix1
Sheet: Tabell1

Namn | Course | Result |  |  | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Passed |  | [NAME] | Yes | #N/A | #N/A
[NAME] | Excel Medium | failed |  | Excel Medium | No | Yes | #N/A
[NAME] | Excel Advanced | Passed |  | Excel Advanced | Yes | Yes | Yes
[NAME] | Excel Medium | Passed
[NAME] | Excel Advanced | Passed
[NAME] | Excel Advanced | Passed
Requirement:
I want F4 to return text ”yes” if we can find data in column A, B and C which tells us that [NAME] has passed course ”Excel Easy”.
Appreciate all help, br Bertrand
Spreadsheet: 77660d1278081109-export-filtered-result-values-into-new-sheet-filter_extract
Sheet: Source Data

Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Column L
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.64 | 0 | 0
60 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.64 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.32 | 0 | 0
230.8 | 122.32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18.48 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11.52 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.84 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.96 | 0 | 0
0 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 4.64 | 0 | 0
131.52 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.96 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 0 | 0
230.8 | 122.32 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 34.64 | 0 | 0
0 | 122.32 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 4.64 | 0 | 0
230.8 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 30 | 0 | 0
230.8 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 48.48 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 6.96 | 0 | 0
0 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 13.84 | 0 | 0
230.8 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 34.64 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 32.32 | 0 | 0
60 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 13.84 | 0 | 0
0 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 2.32 | 0 | 0
60 | 50.8 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 16.16 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 34.64 | 0 | 0
230.8 | 50.8 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 11.52 | 0 | 0
131.52 | 50.8 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 20.8 | 0 | 0
60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 13.84 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 20.8 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 53.12 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 2.32 | 0 | 0
0 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 13.84 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 48.48 | 0 | 0
230.8 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 46.16 | 0 | 0
131.52 | 122.32 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 16.16 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 25.36 | 0 | 0
0 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 2.32 | 0 | 0
0 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 11.52 | 0 | 0
0 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 16.16 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 23.12 | 0 | 0
60 | 50.8 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 11.52 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 23.12 | 0 | 0 | 34.64 | 20.8 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 18.48 | 0 | 0
131.52 | 0 | 0 | 92.32 | 0 | 0 | 0 | 0 | 34.64 | 20.8 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 9.2 | 0 | 0
60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 13.84 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 2.32 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 11.52 | 0 | 0
230.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 2.32 | 0 | 0
60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 6.96 | 0 | 0
131.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 2.32 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.64 | 36.96 | 0 | 0
Spreadsheet: 01216421-55ad-49e6-a4a2-de78c284f97c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 49. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413727L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413728R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413729T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413730A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413731C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413732F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413733J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413734K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413735L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413736R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 93411d1292988648-counting-rows-with-variable-begin-end-begin2end-1-
Sheet: Sheet1

 | Week | Qty
 | 2010-09-24 00:00:00 | 113675
2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 111657
2010-11-19 00:00:00 | 2010-10-08 00:00:00 | 124248
 | 2010-10-15 00:00:00 | 79406
 | 2010-10-22 00:00:00 | 97150
 | 2010-10-29 00:00:00 | 93412
 | 2010-11-05 00:00:00 | 103313
 | 2010-11-12 00:00:00 | 69272
 | 2010-11-19 00:00:00 | 92925
 | 2010-11-26 00:00:00 | 56789
A5 results in number of rows in ColB between and including [NAME] and A4.
In this instance, 7 is the answer.
Spreadsheet: 759641d1639646313-gathering-data-from-scarce-cells-from-a-vertical-range-gathering-data-from-scarce-cells-from-a-vertical-range
Sheet: Sheet1

70 |  |  | 70
 |  |  | 95
 |  |  | 77
95 |  |  | 52
 |  |  | 93
77 |  |  | 16
52 |  |  | 9
 |  |  | 14
 |  |  | 90
 |  |  | 51
 |  |  | 5
 |  |  | 53
 |  |  | 42
93 |  |  | 64
16
9
14
90
51
5
53
42
64