tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153198d1335801212-auto-populate-comment-based-on-cell-values-big-project-need-a-guru-comments
Sheet: 1

1 | [NAME] |  | Supplier ID | Phone Number |  | Quote # |  | Order # |  | Date
 | RDC Warehouse |  | 36474 | [PHONE] |  |  |  | 12 |  | 2012-04-30 10:36:04
 | Supplier Representatives |  | Account Number |  |  | Customer PO# |  | Purchase Order#
 |  |  |  |  |  |  |  | 345
 | Part Number | Description | Quantity | Price | Ext. Price | Pre-Margin | Post-Margin | Unit Price | Ext. Price | Lead
 | PN 123 | Tool
 | PN 456 | Tool 2
 | Notes
 | FIPO
2 | [NAME] |  | Supplier ID | Phone Number |  | DXP Quote # |  | DXP Order # |  | Date
 | [NAME] |  | 10002 | [PHONE] |  |  |  | 12 |  | 2012-04-30 10:46:04
 | Supplier Representatives |  | Account Number |  |  | Customer PO# |  | DXP Purchase Order #
 |  |  |  |  |  |  |  | 346
 | Part Number | Description | Quantity | DXP Price | Ext. Price | Pre-Margin | Post-Margin | Unit Price | Ext. Price | Lead
 | PN 987 | Wrench
 | PN 654 | Pipe
 | Notes
 | EDI
3 | [NAME] |  | Supplier ID | Phone Number |  | DXP Quote # |  | DXP Order # |  | Date
 |  |  |  |  |  |  |  | 12
 | Supplier Representatives |  | Account Number |  |  | Customer PO# |  | DXP Purchase Order #
 |  |  |  |  |  |  |  | 347
 | Part Number | Description | Quantity | DXP Price | Ext. Price | Pre-Margin | Post-Margin | Unit Price | Ext. Price | Lead
 | Notes
4 | [NAME] |  | Supplier ID | Phone Number |  | DXP Quote # |  | DXP Order # |  | Date
 |  |  |  |  |  |  |  | 12
 | Supplier Representatives |  | Account Number |  |  | Customer PO# |  | DXP Purchase Order #
 |  |  |  |  |  |  |  | 348
 | Part Number | Description | Quantity | DXP Price | Ext. Price | Pre-Margin | Post-Margin | Unit Price | Ext. Price | Lead
 | Notes
Spreadsheet: 006ce19e-2151-4391-865a-ac295ddb0589
Sheet: Introduction

This  spreadsheet accompanies the U.S. GAAP Financial Reporting Taxonomy v2011 Final Release Notes (January 31, 2011).
Below are the links to the worksheets which lists the elements by changes made. This file corresponds to "Appendix 4 - Label Changes" in the Final Release Notes.
 | Appendix 4 |  |  |  |  | No. of Elements
 | A. | Change to Standard label |  |  | [NAME] Lab'!A1 | 1002
 | B. | Change to Total Label (Total Label added) |  |  | TotalLab added'!A1 | 52
 | C. | Change to Total Label (Total Label removed) |  |  | Total Lab removed'!A1 | 1
 | D. | Change to Total Label (Total Label modified) |  |  | Total Lab modified'!A1 | 71
 | E. | Change to Period Start or Period End Label |  |  | Period Start lab added'!A1 | 4
 |  |  |  |  | Period Start Lab changed'!A1 | 3
 |  |  |  |  | Period End Label added'!A1 | 4
 |  |  |  |  | Period End Label changed'!A1 | 3
 |  |  |  |  | Period End Label removed '!A1 | 1
Spreadsheet: 0446ec12-f310-401b-9d83-7c082649a166
Sheet: Sheet1

Virginia Highlands Community College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Travel Estimate Worksheet
Traveler's Name |  |  |  |  | Acct #(s) |  | 0
Date of Travel |  |  |  |  |  |  | 0
Destination |  |  |  |  |  |  | 0
Purpose of Travel
List Other Employees Traveling
Travel must be made by the most economical means including carpooling where possible. Justification for separate travel must be
submitted in writing for approval prior to departure. Separate travel without prior approval will not be reimbursed.
Estimated Expenses
Mileage Expense: |  | Round Trip Mileage |  | (Use whole miles only)
 | State Vehicle
State [NAME]? |  |  | Yes |  | No
 |  | Verified By/Date
 | Personal Vehicle: | (Cost Beneficial to College - Select One) | $.56/mile |  |  |  | 0
 | Occasional travel having an average daily mileage of 100 miles or less
 | Routine daily travel within our service area of 100 miles or less per day
 | Travel to/from airport providing commercial air service requiring overnight parking
 | Use of personal vehicle is cost beneficial (complete "Trip Calculator"  to determine) Ent. Car Rental or Reimbursement at $.565/mile
x | Personal Vehicle: | (Personal Convenience) | $.246/mile |  |  |  | 0
Meals and Incidentals Expenses:
(Includes bellhop/taxi tips, personal telephone calls, laundry, travel between lodging and places where meals are taken)
M & IE Rate |  |  | # Days 100% |  | # Days 75%
41 | In-state standard |  |  |  |  |  | 0
46 | Out-of-state standard |  |  |  |  |  | 0
51 |  |  |  |  |  |  | 0
56 |  |  |  |  |  |  | 0
61 |  |  |  |  |  |  | 0
66 |  |  |  |  |  |  | 0
Lodging: (Economy or Government Rate Requested) |  |  | Yes |  | No
** | Request exception to claim 150% lodging rate (must be approved by the President or VP - Financial Services) |  | Yes |  | No
Lodging Rate |  |  | # Days
 | In-state standard |  |  |  |  |  | 0
 | In-state other (specify) |  |  |  |  |  | 0
 | Out-of-state standard |  |  |  |  |  | 0
 | Out-of-state other (specify) |  |  |  |  |  | 0
Air, Rail, Taxi or Bus Fares:
Parking and Tolls:
Car Rental: (Fuel Service Options and Insurance Options are Non-Reimbursable)
Business Telephone Expenses:
Registration Fees:
Miscellaneous:  (Itemize)
Justification:(Required):  This travel is essential toVHCC operations because:
 |  |  |  |  |  | Total | 0
 |  | [NAME]'s Signature                                   Date
Approvals
 |  | Supervisor                                                       Date
 |  | Apropriate Department VP                             Date
 |  | President                                                         Date
 | (President/president's designee approval only needed if amount exceeds $500)
Spreadsheet: 56363d1256560821-lookup-several-values-based-on-same-text-book2
Sheet: Sheet5

Sum of Price | Column Labels
Row Labels | Expense 1 | Expense 2 | Expense 3 | (blank) | Grand Total
Company A | 300 | 100 | 100 |  | 500
Company B | 600 | 200 | 200 |  | 1000
Company C | 900 | 300 | 300 |  | 1500
Company D | 1200 | 400 | 400 |  | 2000
(blank)
Grand Total | 3000 | 1000 | 1000 |  | 5000
Spreadsheet: 771349d1646641947-truncating-text-in-a-cell-but-only-whole-words-copy-of-revised-truncating-names-within-excel-example-workbook
Sheet: Test

Number of Characters
Number of Characters
 |  | FULL NAME | NAME - Part 1 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation)
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 682478d1592132244-help-with-drivers-hours-calculations-weekly-running-copy-copy
Sheet: Sheet1

Date | Day | [NAME] | Start Location | End Millage | End Location | Total Miles | Start Time | Finish Time | Total Hrs Worked | [NAME] to next day |  | Daily Rest | Driving hours
2020-06-07 00:00:00 | Sun |  |  |  |  |  |  |  |  |  |  | MANUAL
2020-06-08 00:00:00 | Mon | 421537 | Halfway | 421969 | Oakham |  | 00:45:00 | 15:45:00 |  |  |  | 09:30:00
2020-06-09 00:00:00 | [NAME] | 421969 | Oakham | 422376 | Ashford |  | 01:14:00 | 16:13:00 |  |  |  | 11:02:00
2020-06-10 00:00:00 | Weds | 422376 | Ashford | 422777 | Basildon |  | 03:45:00 | 18:42:00 |  |  |  | 10:53:00
2020-06-11 00:00:00 | Thurs | 422777 | Basildon | 423008 | [NAME] |  | 04:15:00 | 18:56:00 |  |  |  | 11:27:00
2020-06-12 00:00:00 | Fri | 423008 | [NAME] | 423348 | [NAME] |  | 05:23:00 | 18:03:00 |  |  |  | 11:12:00
2020-06-13 00:00:00 | Sat | 423348 | [NAME] | 423538 | Halfway |  | 05:15:00 | 11:00:00
 |  |  |  |  | Total
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: TEAM1

 | TEAM1
 | SALESMEN: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 | DUKE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BACK
 | RON |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 | CLEMONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PENETRATION
 | CHRIS |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross |  | new gross breakdown |  |  |  |  | used gross breakdown
## | SALESMAN | TEAM # | DATE | CUSTOMER | STOCK# | FRONT $$ | RESERVE | WARR | GAP | A/M | TOTAL $ | [N/U] | NEW UNITS | USED UNITS | NEW GROSS | USED GROSS | fe | reserve | WARR | gap | a/m | front | reserve | warr | gap | a/m
1 | DUKE
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
Spreadsheet: 759608d1639614334-get-numbers-based-on-a-cell-and-between-2-numbers-horizontaly-sample
Sheet: Sheet12

 | Branch- | Date | Branch | Payment | Column1 | Column5 | Numbers | Dicrepancy | Column2
 |  | 2021-12-09 00:00:00 | Branch 1 | PDC |  | 2021-12-09 00:00:00 | 1002
 |  | 2021-12-08 00:00:00 | Branch 1 | PDC |  | 2021-12-08 00:00:00 | 1003
 |  | 2021-12-06 00:00:00 | Branch 1 | PDC |  | 2021-12-06 00:00:00 | 100
 |  | 2021-12-06 00:00:00 | Branch 1 | PDC |  | 2021-12-06 00:00:00 | 1010
 |  | 2021-12-07 00:00:00 | Branch 2 | TDC |  | 2021-12-07 00:00:00 | 2500
 |  | 2021-12-07 00:00:00 | Branch 2 | TDC |  | 2021-12-07 00:00:00 | 2508
 |  | 2021-12-01 00:00:00 | Branch 2 |  |  |  | 900
 |  | 2021-12-01 00:00:00 | Branch 2 |  |  |  | 901
 |  | 2021-12-03 00:00:00 | Branch 1 |  |  |  | 101
 |  | 2021-12-10 00:00:00
 |  | 2021-12-07 00:00:00
 |  | 2021-12-10 00:00:00
 |  | 2021-12-10 00:00:00
Spreadsheet: a43a046a-0e23-4788-b5dc-133e430f4b64
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
VISCS | Test | VISCS | Viscosity, Serum | Viscosity, S | Sonoclot Coagulation Analyzer | Plain, Red-Top Tube: Red |  |  | 1.5 | mL | Container/Tube: Red top [NAME]: 1.5 mL Collection Instructions: Keep specimen at 37 degrees C (eg, 37 degrees C Thermopak, heat block) until after centrifugation and separation of cells. | 0.65 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Serum gel tube | > or =16 years: < or =1.5 centipoises Reference values have not been established for patients that are <16 years of age. | Monday through Friday; Continuously until 2 p.m. | Same day/1 day | 3 days | 1 | 85810 |  |  |  |  | Rochester
VISCS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
VISCS | Result | 8168 | Viscosity, S | Viscosity, S | Numeric |  |  |  |  | cpoise |  |  |  |  |  |  |  |  |  | 3128-6 | Viscosity:[NAME]:Pt:Ser:Qn:
Spreadsheet: 70e74419-c2a4-404f-85c7-e5c19c5b4282
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
HEPN | Test | HEPN | [NAME], Plasma | [NAME] Assay, P | Chromogenic Method on STA-R Evolution | Light blue-top 3.2% Sodium Citrate tube(s): BluNaCi |  |  | 1 | mL | [NAME]-poor plasma Collection Container/Tube:  Preferred: Light-blue top (3.2% sodium citrate at 9:1 ratio) Acceptable: Light-blue top (3.8% sodium citrate at 9:1 ratio) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down, remove plasma, and spin plasma again. Additional Information: Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | > or =18 years UFH therapeutic range: 0.30-0.70 IU/mL  LMWH therapeutic range: 0.50-1.00 IU/mL for twice daily dosing 1.00-2.00 IU/mL for once daily dosing (sample obtained 4-6 hours following subcutaneous injection)   > or =8 weeks-17 years UFH therapeutic range: 0.30-0.70 IU/mL LMWH therapeutic range: 0.50-1.00 IU/mL (sample obtained 4-6 hours following subcutaneous injection) LMWH prophylactic range: 0.10-0.30 IU/mL   <8 weeks Reference values have not been established for patients who are less than 8 weeks of age. | Monday through Sunday; Continuously | 1 day | 2 days | 1 | 85520 |  |  |  |  | Rochester
HEPN | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 30 days
HEPN | Result | HEPN | [NAME] Assay, P | [NAME] Assay, P | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 673541d1587430056-need-to-calculate-inventory-holding-days-between-to-first-of-month-end-of-month-old-feedlot-head-day-tracking
Sheet: Monthly Data

Month Beginning | 2020-04-01 00:00:00
Total Head Days
Total Head Days / HQ
 | Harris1 | WMQTR117L7 | Finished Lot | Harris2 | Finished Lot | Check
Head Days
Spreadsheet: 0570ef4b-f899-4e67-83c5-412fb866cbd3
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 50. PERSONAL FINANCE COMMITMENTS, Summary: Australia ($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
Fixed loans ; |  |  | Original | A2414192W | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414193X | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414194A | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414189J | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414190T | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414191V | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414186A | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414187C | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414188F | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: mary_fischer__25627__1292
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 3 MONTHS ENDED 3-31-2001
EXTENSION: |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Loss on contracts associated w/purchase
acct trx.  Offset is on Co. 77L.
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 863074d1710624076-dax-test-if-a-consecutive-series-of-cells-fulfill-a-certain-condition-week-violation-logic-3
Sheet: Manual Excel Logic

Objective is to test two conditions:
1- Test if each single week violates a certain threshold.
2- Test if this violation occurrs in X consecutive weeks or more, and highlight those weeks in conditional formatting.
 |  |  |  |  |  |  |  |  |  |  | Single violation
 |  |  |  |  |  |  |  |  |  |  | Series violation
 |  | Highlight weeks if [NAME] boundary is violated by more than | 0.1 | for more than | 4 | Weeks
 | Line or SKU | Key Figure | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | …
 | XXX1 | Stock Days | 36 | 12 | 39 | 46 | 41 | 11 | 57 | 60 | 45 | 54 | 56 | 40 | 18 | 46 | 30 | 45 | 54 | 57 | 39 | 40 | …
 | XXX1 | [NAME] |  |  |  |  |  |  |  | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 |  |  | …
Condition 1 Indicator | XXX1 | 1 for every single week violation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Is there a way to avoid looping here? | XXX1 | Cummulative Violation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
 | XXX1 | Intermediary 1 for every series violation above threshold |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
 | XXX1 | Cummulative Series Violation - Static for 4 Weeks Range (Will not work correctly if cell F6 is changed to anything other than 4 weeks). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
 | XXX1 | Cummulative Series Violation (Dynamic) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Condition 2 Indicator | XXX1 | 1 for every series of weeks violation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
 | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | … | …
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Spreadsheet: 267978d1380323719-having-trouble-with-vlookup-hlookup-francisco
Sheet: Customers-April 7-11

[NAME]'s Lawn Care
Customer List April 7-11
Last Name | First Name | Start Date | Service  Day | [NAME] | Standard Fee | Additional Charges | Subtotal | Total with Discount | Comments
Allbaugh | [NAME] | 2008-04-07 00:00:00 | Monday | Small |  | 10
Arterburn | [NAME] | 2008-04-08 00:00:00 | Tuesday | Large |  | 15
Bibb | [NAME] | 2008-04-09 00:00:00 | Wednesday | Small
[NAME] | [NAME] | 2008-04-10 00:00:00 | Thursday | Commercial |  | 30
Bourque | [NAME] | 2008-04-11 00:00:00 | Friday | Commercial |  | 25
[NAME] | [NAME] | 2008-04-12 00:00:00 | Saturday | Medium |  | 64
[NAME] | [NAME] | 2008-04-12 00:00:00 | Saturday | Small
[NAME] | [NAME] | 2008-04-07 00:00:00 | Monday | Medium
Friesen | [NAME] | 2008-04-08 00:00:00 | Tuesday | Large
Grogan | Marvel | 2008-04-09 00:00:00 | Wednesday | Small
[NAME] | Woody | 2008-04-10 00:00:00 | Thursday | Large
[NAME] | Buyung | 2008-04-11 00:00:00 | Friday | Medium |  | 5
Klisares | Joy | 2008-04-12 00:00:00 | Saturday | Large
Lessert | [NAME] | 2008-04-12 00:00:00 | Saturday | Large
[NAME] | Eddie | 2008-04-07 00:00:00 | Monday | Small
Mazza | [NAME] | 2008-04-08 00:00:00 | Tuesday | Small
[NAME] | Velma | 2008-04-09 00:00:00 | Wednesday | Small
Nazar | Robna | 2008-04-10 00:00:00 | Thursday | Medium
Reyes | [NAME] | 2008-04-11 00:00:00 | Friday | Medium
Rodman | [NAME] | 2008-04-12 00:00:00 | Saturday | Medium
Roselius | Reginald | 2008-04-12 00:00:00 | Saturday | Medium
Stanton | Catrina | 2008-04-07 00:00:00 | Monday | Medium
Walker | [NAME] | 2008-04-08 00:00:00 | Tuesday | Large
Watchel | Faye | 2008-04-09 00:00:00 | Wednesday | Medium
Watts | Kelly | 2008-04-11 00:00:00 | Friday | Commercial
 |  |  |  |  | Total Revenue:
Spreadsheet: 838190d1690811004-need-advanced-indexmatch-formula-with-specific-criteria-for-obtaining-exact-desired-result-excel-forum-help-formula
Sheet: Result

Month | Count | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | Nov'19 | Dec'19 | Jan'20 | Feb'20 | Mar'20
2019-04-30 00:00:00 |  |  | 1.5 | 0 | 1.2 | 1.1 | 7.1 | 1
 |  |  | 2.3 | 2.5 | 5.4 | 3.4 | 1.1
 |  |  | 1.2 | 1.1 | 5.4 | 5.4
 |  |  | 1.1 | 5.1 | 1.1
 |  |  | 5.4 | 1.7
 |  |  | 7.1
Nov'19
Dec'19
Jan'20
Feb'20
Mar'20
Required Result
Month | Count | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | Nov'19 | Dec'19 | Jan'20 | Feb'20 | Mar'20
2019-04-30 00:00:00 | 44 | 0 | 1.5 | 0 | 1.2 | 1.1 | 7.1 | 1
 | 14 | 0 | 2.3 | 2.5 | 5.4 | 3.4 | 1.1 | - | - | - | - | - | -
 | 44 | 0 | 1.2 | 1.1 | 5.4 | 5.4 | - | - | - | - | - | - | -
 | 87 | 0 | 1.1 | 5.1 | 1.1 | - | - | - | - | - | - | - | -
 | 42 | 0 | 5.4 | 1.7 | - | - | - | - | - | - | - | - | -
 | 87 | 0 | 7.1 | - | - | - | - | - | - | - | - | - | -
 | 47 | 0 | - | - | - | - | - | - | - | - | - | - | -
Nov'19 | 50 | 0 | - | - | - | - | - | - | - | - | - | - | -
Dec'19 | 60 | 0 | - | - | - | - | - | - | - | - | - | - | -
Jan'20 | 70 | 0 | - | - | - | - | - | - | - | - | - | - | -
Feb'20 | 80 | 0 | - | - | - | - | - | - | - | - | - | - | -
Mar'20 | 90 | 0 | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 376234d1423525768-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-ndm
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | DW4 |  |  |  |  |  |  |  | Shaded area checks Year 1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | AQ1
1005 | 23 | 22 | C1 | SS2
 |  | Excel Question:
 |  | For each row in year 2, How do I find the value that doesn’t match year 1 values and bring back the column heading?
 |  | Here the values that are different to year 1 are highlighted in red
Spreadsheet: a0968141-fb44-4b1b-a2dd-46e5555a9ff9
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 852349100121 | Jarian | He Changed Me | 2005-07-12 | Compact Disc | Black Gospel | 16.99 | N | To Be Retired
Spreadsheet: 673196d1587242095-possibly-a-complicated-index-match-offset-match-row-match-col
Sheet: Sheet1

 | Alibaba Group Holding
Code | Name | Risk & Obj | Tgt %
ABCD123 | Account 1 | MH G
ABCD124 | Account 2 | MH B
ABCD125 | Account 3 | M B
ABCD126 | Account 4 | M B
ABCD127 | Account 5 | MH G
ABCD128 | Account 6 | M G
ABCD129 | Account 7 | MH B
ABCD130 | Account 8 | H G
ABCD131 | Account 9 | MH G
[NAME] | Account 10 | M G
ABCD133 | Account 11 | M G
ABCD134 | Account 12 | M B
ABCD135 | Account 13 | M B
ABCD136 | Account 14 | M B
ABCD137 | Account 15 | MH G
ABCD138 | Account 16 | MH B
ABCD139 | Account 17 | MH B
ABCD140 | Account 18 | M G
ABCD141 | Account 19 | M B
ABCD142 | Account 20 | M B
ABCD143 | Account 21 | M B
ABCD144 | Account 22 | M B
ABCD145 | Account 23 | M B
ABCD146 | Account 24 | M B
[NAME] | Account 25 | MH G
ABCD148 | Account 26 | M B
ABCD149 | Account 27 | M B
ABCD150 | Account 28 | M B
ABCD151 | Account 29 | M B
ABCD152 | Account 30 | M B
ABCD153 | Account 31 | M G