tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 203845d1357265583-specific-template-or-spreadsheet-customer-transaction-template
Sheet: Totals by Client

Sum of Amount Paid | Column Labels
Row Labels | 12/31/2012 - 1/6/2013 | 1/7/2013 - 1/13/2013 | 1/14/2013 - 1/17/2013 | Grand Total
[NAME] | 0 | 305.27 | 196.89 | 502.16
[NAME] | 177.87 | 128.84 | 0 | 306.71
Grand Total | 177.87 | 434.11 | 196.89 | 808.87
Spreadsheet: 84199d1284191287-combine-hyperlink-with-lookup-time-table-2010-2011
Sheet: Year 13 SLD HW marks

 | Name | Comments | Name | Comments | Name | Comments | Name | Comments | Name | Comments | Name | Comments
Exercise 3.1
Exercise 3.2
Exercise 3.15
Exercise 3.16
Exercise 3.17
Exercise 3.18 & 3.19
Exercise 3.20
Exercise 3.21
Exercise 3.22
Exercise 3.23
Exercise 2.1
Exercise 2.2
Exercise 3.24
Exercise 2.3
Exercise 2.4
Exercise 2.5
Exercise 2.6
Exercise 2.7
Exercise 2.8
Exercise 2.9
Exercise 2.10
Exercise 2.11
Exercise 2.16
Exercise 2.17
Exercise 2.18
Exercise 2.19
Exercise 2.19 (2)
Exercise 2.20
Exercise 2.21
Exam Questions.docx
Past Papers Java.doc
Exercise 3.3 & 3.4
Exercise 3.5
Exercise 3.6
Exercise 3.7
Topic 3.1.1 - 3.1.2 Additional HW.php.pdf
Topic 3.5 Additional HW.php.pdf
3.1 Language Translators.doc
3.5 Data Representation.doc
3.6 Errors.doc
Topic 3.6 Additional HW.php.pdf
2Arithmetic Expressions Worksheet 2.php.pdf
If statement.php.pdf
11Tracing Algorithms.php.pdf
7Methods Worksheet 2.php.pdf
Topic 3.2.1 - 3.2.5 Additional HW.php.pdf
Topic 3.2.5 - 3.2.6 Additional HW.php.pdf
3.2 Computer Architecture.doc
Spreadsheet: 866580d1713490408-match-two-criteria-in-two-columns-match-two-columns
Sheet: Sheet1

Data |  |  | Needed Result
Person1 | Job 1 |  |  | Person1 | Person2
Person1 | Job 3 |  | Job 1 | x | x
Person1 | Job 4 |  | Job 2 |  | x
Person1 | Job 5 |  | Job 3 | x | x
Person1 | Job 6 |  | Job 4 | x | x
Person1 | Job 8 |  | Job 5 | x
Person1 | Job 9 |  | Job 6 | x | x
Person2 | Job 1 |  | Job 7 |  | x
Person2 | Job 2 |  | Job 8 | x
Person2 | Job 3 |  | Job 9 | x | x
Person2 | Job 4
Person2 | Job 6
Person2 | Job 7
Person2 | Job 9
Spreadsheet: 704767d1605734386-link-error-messages-to-a-product-test-help
Sheet: Sheet1

20201112 | Sipa | 626 |  |  |  | 407757 | 700 | 832 |  |  |  | 116 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16891
20201112 | Sipa Ny | 730 |  |  |  | 407749 | 832 | 1455 |  | 24004 |  |  | 3566 |  |  |  |  |  |  |  |  |  |  |  |  | 21391
20201112 | Sipa Ny | 732 |  |  |  | 407751 | 1455 | 2107 |  |  |  |  | 5454 |  |  |  |  |  |  |  |  |  |  |  |  | 32828
20201112 | Sipa | 618 |  |  |  | 407761 | 2107 | 2249 |  |  |  | 168 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24312
20201113 | Sipa | 628 |  |  |  | 407759 | 700 | 952 |  | 40000 |  | 272 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39179
20201113 | Sipa | 626 |  |  |  | 407763 | 952 | 1232 |  | 30050 |  | 206 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29599
20201116 | Sipa | 618 |  |  |  | 407763 | 700 | 1340 |  |  |  | 174 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24923
20201116 | Sipa | 854 |  |  |  | 407771 | 1340 | 1523 |  | 20000 |  | 84 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12347
20201117 | Sipa | 146 |  |  |  | 407767 | 1523 | 1901 |  | 53352 |  | 368 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53022
20201117 | Sipa | 148 |  |  |  | 407769 | 1901 | 2055 |  | 10000 |  | 66 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9560
Spreadsheet: 218603d1362506253-flag-a-cell-for-over-year-from-date-inputted-test-conditional-format-date-out-365
Sheet: Sheet1

Position | Permanent Hire Date | Current Project | Per Diem Start Date Current Project
Construction Manager | 2011-04-25 00:00:00 | [NAME] | 2013-03-04 00:00:00
Construction Supervisor-Civil | 2011-08-08 00:00:00 | [NAME] | 2012-03-02 00:00:00
Superintendent-Electrical | 2011-08-08 00:00:00 | Alpine | 2012-01-02 00:00:00
Construction Supervisor II | 2009-10-12 00:00:00 | Amherstburg 1 | 2013-03-10 00:00:00
Construction Manager | 2008-11-17 00:00:00 | AVSR | 2012-05-02 00:00:00
Supervisor-Construction Site | 2012-08-06 00:00:00 | AVSR
Supervisor-Electrical Construction | 2011-06-27 00:00:00 | AVSR
Construction Supervisor-Electrical | 2011-11-29 00:00:00 | AVSR
Construction Supervisor-Civil | 2010-09-20 00:00:00 | AVSR
Construction Supervisor-Civil II | 2009-08-17 00:00:00 | AVSR
Supervisor-Electrical Construction | 2010-07-05 00:00:00 | Belmont
Office Manager/PMV | 2009-06-15 00:00:00 | Belmont
Construction Manager | 2010-06-21 00:00:00 | Campo Verde
Supervisor-Electrical Construction | 2010-09-20 00:00:00 | Campo Verde
Construction Supervisor-Civil | 2011-08-15 00:00:00 | Campo Verde
Supervisor-Construction Site | 2012-07-23 00:00:00 | Campo Verde
Construction Supervisor-Civil | 2009-04-13 00:00:00 | CMS2
Spreadsheet: 22098d1210615752-random-number-to-a-specific-total-random-numbers
Sheet: Sheet1

First random #s | % of total in A | Random #
0.9927170371932441 | 0.1831132048019095 | 54.93396144057284
0.09281811259369643 | 0.01712091303353718 | 5.136273910061155
0.2158185503949961 | 0.0398091550138645 | 11.94274650415935
0.8389919222355262 | 0.1547575934808457 | 46.4272780442537
0.5716394749341505 | 0.1054426712997945 | 31.63280138993834
0.146650740228953 | 0.02705069624454174 | 8.115208873362523
0.815168760839043 | 0.1503632542397695 | 45.10897627193084
0.2237906165598518 | 0.04127965519634039 | 12.38389655890212
0.9834688292401346 | 0.1814073118500202 | 54.42219355500605
0.5402655549600928 | 0.09965554483937693 | 29.89666345181308
5.421329599179688 |  | 300 | Total you want random numbers to add up to.
Spreadsheet: 803995d1667835708-formula-to-count-the-number-of-dates-entered-book1
Sheet: Sheet1

Stable Name
Address
Address 2
[NAME] Period: | October 01-31, 2022
Horse Owner Name
Address
Address 2
Horse Name:
Board |  |  |  |  | 100
NYS 7% Tax
Turnout, Lunge & Walks
Date/s | 01, 02, 03, 04, 05, 07, 08, 09,10,12,14,15,16, |  | 6 | 28
 | 17,19, 21, 23, 24, 25, 26, 27, 29, 30
Staff [NAME]
Date/s | 03, 07,13, 20, 28 |  | 20 | 5
Lessons
Date/s (Semi Private) | 22 |  | 40 | 1
Date/s (Private) | 01, 06, 08,13,15, 20, 27 |  | 45 | 7
Special Care
 |  |  | Subtotal
Previous Balance:
Payments Received:
Balance carried forward:
Please Remit
Spreadsheet: 751793d1634321430-need-to-vlookup-by-couple-criterias-1stexcel_report
Sheet: 1stExcel_Report

Invoice | Number | Contact Type
ESO/001 | 44446 | SMS
ESO/001 | 44447 | [NAME]
ESO/001 | 44448 | Letter
ESO/001 | 44449 | Call
ESO/001 | 44450 | SMS
ESO/001 | 44451 | [NAME]
ESO/001 | 44452 | Letter
ESO/001 | 44453 | Call
ESO/001 | 44454 | SMS
ESO/001 | 44455 | [NAME]
ESO/001 | 44486 | Letter
ESO/002 | 44447 | Call
ESO/002 | 44448 | SMS
ESO/002 | 44449 | [NAME]
ESO/002 | 44450 | Letter
ESO/002 | 44446 | Call
ESO/002 | 44447 | SMS
EOS/123 | 44448 | [NAME]
EOS/123 | 44449 | Letter
EOS/123 | 44450 | Call
EOS/123 | 44446 | SMS
EOS/123 | 44447 | [NAME]
EOS/123 | 44448 | Letter
EOS/123 | 44449 | Call
Spreadsheet: 143575d1330464649-index-help-skorby-comm
Sheet: Skorby comm (2)

 |  |  |  | Total commited more than Primary
 |  |  |  |  |  | additional locations |  |  |  |  |  |  | Date
Driver (please input name)
Inputted by stock control :
WHZONE | INUMBR | ILONGD | WHSLOT | WHHAND | WHCOMM | Backup 1 | Total | Backup 2 | Total | Backup3 | Total | backup4 | Total | backup 5 | Total | backup 6 | Total | AVG Pallets
Spreadsheet: 780715d1652711423-index-with-nested-year-function-not-working-sample-workbook
Sheet: Sheet1

Date | Year | Value | MatchYear | MatchDates |  | index(year(a2:a25),,) |  | sum(index(year(a2:a25),,) |  | SUMIF(E2#,C2,B2:[NAME]) |  | SUMIF(A2:A25,D2:D4,B2:B25) |  | SUMIF(INDEX(YEAR(A2:A25),,),C2:C4,B2:B25) |  |  | Sum of Value
1900-01-01 00:00:00 |  | 1 | 1990 | 1 |  |  |  |  |  |  |  |  |  |  |  | 1900
1900-01-01 00:00:00 |  | 1 | 1992 | 2 |  | 1900 |  |  |  |  |  | 0 |  | #[NAME]! |  | 1901 | 10
1900-01-03 00:00:00 |  | 1 | 1991 | 3 |  | 1900 |  |  |  |  |  | 1 |  | #[NAME]! |  | 1913 | 10
1900-01-04 00:00:00 |  | 1 |  |  |  | 1900 |  |  |  |  |  |  |  | #[NAME]!
1901-02-03 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-04 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-05 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-06 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-07 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-08 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-09 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-10 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-11 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1901-02-12 00:00:00 |  | 1 |  |  |  | 1901 |  |  |  |  |  |  |  | #[NAME]!
1913-09-08 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-09 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-10 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-11 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-12 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-13 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-14 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-15 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-16 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
1913-09-17 00:00:00 |  | 1 |  |  |  | 1913 |  |  |  |  |  |  |  | #[NAME]!
Spreadsheet: 115233d1310844103-if-function-book1_kameran
Sheet: Sheet1

100
100
101
101
102
102
103
103
104
104
105
105
106
106
107
107
108
108
109
109
110
110
111
111
112
112
113
113
114
114
115
115
116
116
117
117
118
118
119
119
120
120
121
121
122
122
123
123
124
124
125
125
126
126
127
127
128
128
129
129
130
130
131
131
132
132
133
133
134
134
135
135
136
136
137
137
138
138
139
139
140
140
141
141
142
142
143
143
144
144
145
145
146
146
147
147
148
148
149
149
150
150
151
151
152
152
153
153
154
154
155
155
156
156
157
157
158
158
159
159
160
160
161
161
162
162
163
163
164
164
165
165
166
166
167
167
168
168
169
169
170
170
171
171
172
172
173
173
174
174
175
175
176
176
177
177
178
178
179
179
180
180
181
181
182
182
183
183
184
184
185
185
186
186
187
187
188
188
189
189
190
190
191
191
192
192
193
193
194
194
195
195
196
196
197
197
198
198
199
199
200
200
201
201
202
202
203
203
204
204
205
205
206
206
207
207
208
208
209
209
210
210
211
211
212
212
213
213
214
214
215
215
216
216
217
217
218
218
219
219
220
220
221
221
222
222
223
223
224
224
225
225
226
226
227
227
228
228
229
229
230
230
231
231
232
232
233
233
234
234
235
235
236
236
237
237
238
238
239
239
240
240
241
241
242
242
243
243
244
244
245
245
246
246
247
247
248
248
249
249
250
250
251
251
252
252
253
253
254
254
255
255
256
256
257
257
258
258
259
259
260
260
261
261
262
262
263
263
264
264
265
265
266
266
267
267
268
268
269
269
270
270
271
271
272
272
273
273
274
274
275
275
276
276
277
277
278
278
279
279
280
280
281
281
282
282
283
283
284
284
285
285
286
286
287
287
288
288
289
289
290
290
291
291
292
292
293
293
294
294
295
295
296
296
297
297
298
298
299
299
300
300
301
301
302
302
303
303
304
304
305
305
306
306
307
307
308
308
309
309
310
310
311
311
312
312
313
313
314
314
315
315
316
316
317
317
318
318
319
319
320
320
321
321
322
322
323
323
324
324
325
325
326
326
327
327
328
328
329
329
330
330
331
331
332
332
333
333
334
334
335
335
336
336
337
337
338
338
339
339
340
340
341
341
342
342
343
343
344
344
345
345
346
346
347
347
348
348
349
349
Spreadsheet: 77ebe271-bb50-4e4b-9e5f-1a9b055bebf4
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
FFTAT | Test | FFTAT | Thrombin-Antithrombin Complex | Thrombin-Antithrombin Complex | Enzyme-Linked Immunosorbent Assay (ELISA) | Light blue-top 3.2% Sodium Citrate tube(s): BluNaCi |  |  | 1 | mL | Draw blood in a light-blue top (sodium citrate) tube. Spin down and send 1 mL citrated plasma frozen in plastic vial. Note: Separate specimens must be submitted when multiple tests are ordered. | 0.5 mL | Specimens other than	Plasma Anticoagulants other than	Sodium citrate Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | <4.3 ng/mL   Pre-analytical conditions such as a difficult draw may spuriously increase test results.   Test Performed by: Esoterix Coagulation                              8490 Upland Dr.                              Suite 100                              Englewood, CO 80112 | Monday, Thursday | 2 - 4 days | 4 - 8 days | 1 | 83520 |  |  |  |  | Esoterix Coagulation
FFTAT | [NAME] | NACIT | [NAME] |  |  |  | Frozen
FFTAT | Result | Z0209 | Thrombin Antithrombin Complex | Thrombin Antithrombin Complex | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 14182-0
Spreadsheet: 871111d1717549503-total-sum-from-multiple-sheets-sample-wb
Sheet: FName4

Customer Name |  | Set 1 | Set 2
Customer 1 |  | 0 | 1
HOLIDAY |  | 1 | 1
Customer 1 |  | 1 | 1
Customer 5 |  | 0 | 1
Customer 7 |  | 1 | 1
Customer 7 |  | 0 | 1
Customer 12 |  | 0 | 1
Customer 7 |  | 0 | 1
Customer 10 |  | 1 | 1
Customer 4 |  | 1 | 1
Customer 12 |  | 1 | 1
SICK LEAVE |  | 0 | 1
SICK LEAVE |  | 0 | 1
Spreadsheet: 92683d1292256371-sumproduct-using-date-range-on-time-test
Sheet: Overdue

Dept | Supervisor [NAME] | Employee # | Employee Name | Status | Review Date | Next Review Description | Month Due
100 | Supervisor 1 | 28848 | Employee 5 | FULL | 2011-01-02 00:00:00 | ANNUAL REVIEW | Jan
100 | Supervisor 1 | 27789 | Employee 1 | FULL | 2011-01-04 00:00:00 | ANNUAL REVIEW | Jan
100 | Supervisor 1 | 28387 | Employee 4 | FULL | 2011-01-05 00:00:00 | 3 MONTH REVIEW | Jan
100 | Supervisor 1 | 27908 | Employee 2 | FULL | 2011-01-12 00:00:00 | ANNUAL REVIEW | Jan
100 | Supervisor 1 | 29341 | Employee 7 | FULL | 2011-01-15 00:00:00 | ANNUAL REVIEW | Jan
100 | Supervisor 1 | 27914 | Employee 3 | FULL | 2011-01-19 00:00:00 | ANNUAL REVIEW | Jan
100 | Supervisor 1 | 28908 | Employee 6 | FULL | 2011-01-27 00:00:00 | ANNUAL REVIEW | Jan
102 | Supervisor 2 | 20032 | Employee 8 | FULL | 2011-01-31 00:00:00 | ANNUAL REVIEW | Jan
103 | Supervisor 3 | 28465 | Employee 9 | FULL | 2011-01-28 00:00:00 | 3 MONTH REVIEW | Jan
104 | [NAME] | 23093 | Employee 12 | FULL | 2011-01-26 00:00:00 | ANNUAL REVIEW | Jan
104 | [NAME] | 2015 | Employee 10 | FULL | 2011-01-27 00:00:00 | ANNUAL REVIEW | Jan
104 | [NAME] | 11134 | Employee 11 | FULL | 2011-01-30 00:00:00 | ANNUAL REVIEW | Jan
105 | Supervisor 5 | 13030 | Employee 14 | FULL | 2011-01-02 00:00:00 | ANNUAL REVIEW | Jan
105 | Supervisor 5 | 20030 | Employee 13 | FULL | 2011-01-16 00:00:00 | ANNUAL REVIEW | Jan
106 | Supervisor 6 | 19003 | Employee 15 | FULL | 2011-01-13 00:00:00 | 3 MONTH REVIEW | Jan
107 | Supervisor 7 | 29350 | Employee 16 | FULL | 2011-01-22 00:00:00 | ANNUAL REVIEW | Jan
108 | Supervisor 8 | 29451 | Employee 17 | FULL | 2011-01-12 00:00:00 | 3 MONTH REVIEW | Jan
109 | Supervisor 9 | 86011 | Employee 18 | FULL | 2011-01-19 00:00:00 | ANNUAL REVIEW | Jan
110 | Supervisor 10 | 2083 | Employee 19 | FULL | 2011-01-04 00:00:00 | 3 MONTH REVIEW | Jan
Spreadsheet: daren_farmer__5865__HPL-June
Sheet: June 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-06-01 00:00:00 | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 80000
981258 | Industrial Tier 1 & 2 | CHAMPIONS | 0
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 95000
Total  Midcon
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | existing | NGMS 308 | 10000
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 |  | CNG | 250
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7500
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 2000
016-41991-306 | VA Hospital | VA Hosp | 500
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 1000
016-41991-301 | Trans 9 -Woodlands |  | 3500
016-41991-301 | Trans 8 - Conroe |  | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 10000
012-41991-203 |  | Firm Trsp
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | TEJAS THOMPSONVILLE | 6296 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: 166398d1341578686-sumif-for-monthly-yearly-worksheet1
Sheet: Sheet1

1997-01-02 00:00:00 | 5000
1997-04-03 00:00:00 | 7892
1998-12-02 00:00:00 | 9283
1998-01-02 00:00:00 | 3875
2001-01-07 00:00:00 | 3974
2000-02-05 00:00:00 | 3985
1997-01-19 00:00:00 | 3975
1997-04-05 00:00:00 | 3095
1999-03-09 00:00:00 | 30954
1999-04-09 00:00:00 | 302
1998-05-09 00:00:00 | 30580
1997-07-09 00:00:00 | 3856
2000-08-02 00:00:00 | 2093
2000-04-02 00:00:00 | 30905
1997-03-04 00:00:00 | 3495
2000-04-03 00:00:00 | 3011
1998-05-03 00:00:00 | 2930
1999-04-02 00:00:00 | 49567
2000-06-03 00:00:00 | 20349
2000-04-22 00:00:00 | 20395
1997-04-06 00:00:00 | 20322
Spreadsheet: 274474d1383130899-need-a-formula-to-calculate-all-total-purchase-from-different-sheets-by-acct-number-sample-scenario
Sheet: AFTER

acct # | File [1] | amount purchased
1 | shane | 4000
2 | rone | 3200
3 | [NAME] | 1000
4 | bron | 1000
5 | shoon | 2400
6 | kun | 0
7 | lun | 600
8 | luna | 300
9 | aey | 1100
10 | snake | 100
 | ** total of amount purchased based on file [2]
Spreadsheet: james_steffes__12841__direct access 0807
Sheet: Sheet1

Interest rate
Amount | Rate | Interest
8500 | 0.0577
4000 | 0.0777
Payment per kwh assuming an average of 185,000,000 mwh for PG&E, [NAME] and SDG&E
Amortization | Utility Undercollection at | Bonds at | Contracts at | Total at | Total less
Years | $10.2B | $12.5 B | $7.5B | 30.2B | Contracts
5
7
10
12
15
Spreadsheet: 724894d1616433720-need-help-with-filtering-formula-data-validation-based-on-two-column-table-clifford86-
Sheet: DataFilter

Bank Register
Bank Name |  | Account Type |  | Account Number |  | Account Descrption
BearState |  | Savings
CityBank
FirstBank
Bank Name: |  | The bank name uses the formula "UNIQUE(Bank_Info[Name])" to get the Bank Name from the Bank Info sheet to populate the list of bank names on the Bank Register Sheet.
Account Type: |  | The account type is using the formula "UNIQUE(FILTER(Bank_Info[Account Type],Bank_Info[Name]=Bank_Register[@Bank],""))" The problem I am having here is that it only populates the list off of Bank Register: A4. Not a problem until I get to B5, B6, [NAME] and etc on the Bank Register Sheet. Because it still looks in A4 on the Bank Register Sheet when I need B4 to look in A4, B5 look in A5, B6 look in A6, B7 look in A7 and etc. Which brings me to thinking I am using the wrong formulas?
Account Number: |  | Here I believe I will have the same issues as Account Type at the begining. I have used the steps in the YouTube Video below to try and at lest get the correct Account Numbers to show up for A4. It seems as if something is not working their ether. Any help is much appricated. Thanks
[NAME]: |  | https://youtu.be/fDB1Ktyhp3Y
Spreadsheet: 79826d1280063343-error-in-my-formula-help-required-with-fixing-value-error
Sheet: Sheet1

FIXTURE DAY | Fixture Index |  | DATE | TIME | HOME TEAM |  |  |  | AWAY TEAM
 |  |  |  |  | WEEK |  | 1 |  | GAME | V
1 | 1 |  |  |  |  |  | V |  |  | - |  | 1 | V | 2
 | 2 |  |  |  |  |  | - |  |  |  |  | 1 |  | 1
 | 3 |  |  |  |  |  | - |  |  |  |  | 2 |  | 2
 | 4 |  |  |  |  |  | -
 | 5 |  |  |  |  |  | -
 | 6 |  |  |  |  |  | -
 | 7 |  |  |  |  |  | -
 | 8 |  |  |  |  |  | -
 | 9 |  |  |  |  |  | -
 | 10 |  |  |  |  |  | -
 | 11 |  |  |  |  |  | -
 | 12 |  |  |  |  |  | -
 | 13 |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | TOTAL POINTS
Spreadsheet: 51810d1251404971-using-name-ranges-to-group-customers-into-different-pricing-brackets-book1
Sheet: Sheet1

a1
a2 |  | a | 1
a3 |  | b | 2
a4 |  | c | 3
a5 |  | d | 1.5
a6
a7
[NAME]
a9
a10
a11
a12
a13
b1
c1
1
2 |  | Customer | a1 |  |  | 123
3
4
5
6 |  | price | 123
7
8
9
Spreadsheet: 689161d1596149802-issue-while-consolidating-multiple-excel-sheet-daily-work-control-and-time-sheet-jjacob84-
Sheet: Sheet1

 | Sl no | NAME | DESIGNATION | Working Time |  | Time allocation
 |  |  |  |  |  | JO/20/178 |  | JO/20/144 |  | [NAME] |  | JO/20/142 |  | JO/20/134 |  | JO/20/186 |  | JO/20/190 |  | JO/20/149 |  | [NAME] |  | [NAME] |  | JO/20/175 |  | Maintainance / Other works
 |  |  |  | In | Out | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT
 | 1 | MATHEW | MACHINIST
 | 2 | KESHVAN | MACHINIST
 | 3 | SIVADAS RAMANKUTTY | MACHINIST
 | 4 | SHAMIM  ANSARI | MACHINIST
 | 5 | RAGESH | WELDER
 | 6 | MUKUNDAKSHAN | WELDER
 | 7 | SATIYAR AJAM ABBASI | WELDER
 | 8 | UPENDRA KUMAR RAM | WELDER
 | 9 | MARTIN | NDT
 | 10 | SAMUEL | NDT
 | 11 | FELIX LUCAZINHO | SAND BLASTER
 | 12 | DIPAK GOVINDA SALUNKE | SAND BLASTER
 | 13 | SATHYAPALAN | SAND BLASTER
 | 14 | RAJEEV | FABRICATOR
 | 15 | [NAME] | FABRICATOR
 | 16 | FLORENCIO | FABRICATOR
 | 17 | [NAME] | FITTER
 | 18 | SAMBHU | FITTER
 | 19 | RAJASEKAR | HELPER
 | 20 | FRANCIS JOSEPH | HELPER
 | 21 | SONU  CHAUHAN  HARDEV | HELPER
 | 22 | SIMHACHALAM | HELPER
 | 23 | [NAME] MALIK | VALVE TECHNICIAN
 | 24 | SIVA | TECHNICIAN
 | 25 | SURENDRA NISHAD | PAINTER
 | 26 | RAVI | GRINDER
 | 27 | HEMRAJ | GRINDER
 | 28 | AJMER SINGH GURBAX SINGH | HEAVY [NAME]
 | 29 | ABDUR RASHID | HEAVY [NAME]
 | 30 | BALJIT SINGH | HEAVY [NAME]
 | 31
Spreadsheet: 83094d1283159941-excel-2007-lottery-numbers-lotto-1-
Sheet: WINNINGS

Main [NAME] |  |  |  |  |  |  | Bonus |  | Subscription Numbers |  |  |  |  |  |  |  | Max million Numbers
 |  |  |  |  |  |  |  |  | 1 | 3 | 7 | 8 | 9 | 12 | 18 |  | 1 | 3 | 7 | 8 | 9 | 12 | 18
 |  |  |  |  |  |  |  |  | 2 | 6 | 8 | 12 | 14 | 28 | 35 |  | 2 | 12 | 20 | 23 | 33 | 35 | 49
 |  |  |  |  |  |  |  |  | 10 | 14 | 15 | 26 | 43 | 47 | 49 |  | 2 | 6 | 8 | 12 | 14 | 28 | 35
Spreadsheet: 887537d1737758502-conditional-formatting-match-fill-font-adjacent-cell-activity-report
Sheet: QUARTILE

 |  |  |  |  |  | OPPORTUNITIES & CLOSING |  |  |  |  |  |  |  |  |  | APPOINTMENT STATS |  |  |  |  |  |  |  | ACTIVITY |  |  |  |  |  |  | DAILY AVERAGES
False | <- YESTERDAY | False | False | False |  | False | False | False | False | False | False | False | False | False |  | False | False | False | False | False | False | False |  | False | False | False | False | False | False |  | False | False | False | False | False | False
 |  | SOLD | SCORE | CSI |  | TOTAL | WALK-IN |  | PHONE |  | INTERNET |  | CAMPAIGN |  |  | SCHEDULED | CONFIRMED |  | SHOW |  | NO-SHOW |  |  | CALLS | CONNECTED |  | TEXT | [NAME] | VIDEO |  | CLIENTS | CALLS | TEXT | [NAME] | VIDEO | TOTAL
 | STORE TOTALS
 | [NAME]
 | RAJ CHANDIRAMANI
 | DUANE P CRAWFORD
 | [NAME]
 | VELMA A WILLIAMS
 | [NAME]
 | FRANTZ BELIZAIRE
 | JASON A PEMBERTON
 | [NAME]
 | [NAME]
 | ZOLTAN C TAKACS
 | [NAME]
 | FELIPE SILVA
 | ELISON JEANLOUIS
 | XAVIER GONZALES
 | LAZARO LOPEZ
 | [NAME]
 | ARMEN CHILINHARIAN
 | [NAME]
 | BLANCA FELIU
 | KENDRY CANDELARIO
 | ANTONIO LUGO
 | [NAME]
 | HOWARD PITT
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]