tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 670230d1585792845-subtotal-question-stock-spreadsheet-sample
Sheet: Sheet2

Name/Ticker | Shares Purchased | Purchase Price | Total Cost | Current Price | Shares to sell | Total Profit/Loss
#[NAME]! | 55.5 | 54.49 |  | 62.75 | 55.5
#[NAME]! | 130 | 61.76 |  | 62.75 | 130
#[NAME]! | 5 | 126.5 |  | 137 | 5
#[NAME]! | 10 | 73.5 |  | 91.37 | 10
#[NAME]! | 12 | 85 |  | 91.37 | 12
#[NAME]! | 19 | 25.86 |  | 7.45 | 19
#[NAME]! | 11 | 25.02 |  | 7.45 | 11
Spreadsheet: 675733d1588443421-use-data-in-multiple-cells-to-return-result-example
Sheet: Sheet2

Under 2
Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
2 Year Old
Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
3 Years +
Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
Spreadsheet: 838106d1690730669-excel-formula-to-analyse-production-based-on-a-days-production
Sheet: Production

PRODUCTION
Date | Output
2023-01-01 00:00:00 | 12000
2023-01-02 00:00:00 | 1300
2023-01-03 00:00:00 | 100000
2023-01-04 00:00:00 | 9000
2023-01-05 00:00:00 | 3000
2023-01-06 00:00:00 | 2000
2023-01-07 00:00:00 | 1700
2023-01-08 00:00:00 | 2890
2023-01-09 00:00:00 | 2323
2023-01-10 00:00:00 | 1000
2023-01-11 00:00:00 | 800
2023-01-12 00:00:00 | 9000
2023-01-13 00:00:00 | 4000
2023-01-14 00:00:00 | 34589
2023-01-15 00:00:00 | 6789
2023-01-16 00:00:00 | 30000
2023-01-17 00:00:00 | 96700
2023-01-18 00:00:00 | 134000
2023-01-19 00:00:00 | 678000
2023-01-20 00:00:00 | 890100
2023-01-21 00:00:00 | 5000
2023-01-22 00:00:00 | 900
2023-01-23 00:00:00 | 6000
2023-01-24 00:00:00 | 3457
2023-01-25 00:00:00 | 5678
2023-01-26 00:00:00 | 2345
2023-01-27 00:00:00 | 4000
2023-01-28 00:00:00 | 5679
2023-01-29 00:00:00 | 987612
2023-01-30 00:00:00 | 34009
2023-01-31 00:00:00 | 345
Spreadsheet: 58317d1258581925-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-commission-report-test
Sheet: Solution

 | Name |  | [NAME]
 | Number |  | 111
 | Employee #: |  | 22222
 | Incentive Payment Summary
 |  | Total Incentive Payment | Dealer Incentive | Retail Incentive | Windsor Incentive
 |  | 1137.1229 | 27.968 | 1109.1549 | 0
 | Incentive Payment Details
 | Customer # | Customer Name | Sales | Territory | Cust Type | Currency
 | S018 | AAA | 2549.22 | 1 | L | CD
 | S023 | BBB | 23547.55 | 1 | L | CD
Spreadsheet: 165415d1341225601-calculation-alters-dependant-on-no-selected-number-of-sales
Sheet: Sheet1

 | Months Older than = | 6
 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
 | Monthly Sales | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194 | 194
 | Cumulative Sales | 194 | 389 | 583 | 778 | 972 | 1167 | 1361 | 1556 | 1750 | 1944 | 2139 | 2333 | 2522 | 2711 | 2899 | 3088 | 3276 | 3465 | 3654 | 3842 | 4031 | 4219 | 4408 | 4597
 | Sales Less than "6 Months" old | 194
 | [NAME] than "6 Months" Old
 | I would llike the calculations in rows 11 and 12 to change in line with the number of months entered in CELL "C2"
Spreadsheet: 680230d1590863891-index-match-with-3-criteria-index-match_match-type
Sheet: Sheet1

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
djnc | haha | 12 | 34 | 56 | 98 | 85
djnc | hehe | 78 | 89 | 910 | 54 | 52
djnc | hoho | 1112 | 1314 | 1516 | 321 | 63
oinc | haha | 1 | 2 | 3 | 4 | 5
oinc | hehe | 6 | 7 | 8 | 9 | 10
oinc | hoho | 11 | 12 | 13 | 14 | 15
 |  | Index Match |  | [NAME]
Greather than
criteria 1 | hoho
criteria 2 | 2020-04-01 00:00:00
Exact
criteria 1 | haha
criteria 2 | 2020-03-31 00:00:00
Less than
criteria 1 | haha
criteria 2 | djnc
criteria 3 | 2020-03-30 00:00:00
djnc | 1
oinc | 2
Spreadsheet: 273456d1382717347-trying-to-combine-an-if-statement-and-a-dual-vlookup-its-doing-something-but-dummy-workbook
Sheet: Sheet1

 | B | L | D
[NAME] | 10 | 0 | 5
[NAME] | 0 | 15 | 25
[NAME] | 10 | 15 | 0
Gemma | 5 | 25 | 0
[NAME] | 30 | 100 | 0
[NAME] | 10 | 10 | 0
[NAME] | 5 | 5 | 5
[NAME] | 15 | 35 | 0
Spreadsheet: 810232d1671628901-how-to-delete-cells-with-text-and-keep-cell-that-has-numbers-s666-pq-how-to-delete-cells-with-text-and-keep-cell-that-has-numbers
Sheet: Sheet1

Main - 16
Column1 | Column2 | Column3 | Column4 | Column5
16-02 | 16-08 | 16-11 | 16-12 | 16-14
XYZ | XYZ | XYZ | XYZ | XYZ
A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx,
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297
7207263403 | 92461 64011 / 65546450 | 98490 35111 / 65580029 | 92966 51780 /  24560775 | 93470 55211 / 66611680
Column1 | Column2 | Column3 | Column4 | Column5
16-51 | 16-53 | 16-55 | 16-59 | 16-66
XYZ | XYZ | XYZ | XYZ | XYZ
A311, xxxxxx, | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297
xxxxx xxxx - 297 | 92461 80493 / 66901575 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93910 12959 / 66566542
99669 94499 / 66731204 |  | 98495 55159 / 24577243 | 99665 51066 / 65537578 / 9
Column1 | Column2 | Column3 | Column4 | Column5
16-67 | 16-68 | 16-69 | 16-71 | 16-74
XYZ | XYZ | XYZ | XYZ | XYZ
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297
93910 22163 / 66566542 | 93475 22673 / 66566542 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93903 63349 / 66144727
 |  | 9246119600 | 93911 43879 / 66365645
Column1 | Column2 | Column3 | Column4 | Column5
7207263403 | 92461 64011 / 65546450 | 98490 35111 / 65580029 | 92966 51780 /  24560775 | 93470 55211 / 66611680
99669 94499 / 66731204 | 92461 80493 / 66901575 | 98495 55159 / 24577243 | 99665 51066 / 65537578 / 9 | 93910 12959 / 66566542
93910 22163 / 66566542 | 93475 22673 / 66566542 | 9246119600 | 93911 43879 / 66365645 | 93903 63349 / 66144727
Spreadsheet: 888176d1738628899-how-to-count-rows-with-a-funciton-row-count
Sheet: Sheet1

# | Date | Invoice
 | 2025-01-25 00:00:00 | 22548
 | 2025-01-28 00:00:00 | 4455
 | 2025-01-29 00:00:00 | 54554
 | 2025-01-30 00:00:00 | 45455
 | 2025-01-31 00:00:00 | 454545
 | 2025-02-01 00:00:00 | 45455
Spreadsheet: 582976d1532128314-need-help-with-multiple-conditions-from-multiple-ranges-on-multiple-sheets-new-salary-metric-and-comparison-chart-2018-0719-forum-version
Sheet: Quartiles - Monthly

Class Code PS Job Code | Range  PS Grade | Class/Range Description PS Job Code/Grade Description | Min / Hour | Max / Hour | Monthly Minimum | Monthly Maximum | Top of 1st Quartile | Tier 1 Range | Mid-Point | [NAME] | Top of 3rd Quartile | [NAME] | Top of 4th Quartile | [NAME]
1038 | 1 | Job Title 1 | 20 | 25 |  |  | 3650 |  | 3850 |  | 4050
1038 | 2 | Job Title 2 | 21 | 30 |  |  | 4040 |  | 4440 |  | 4840
1032 | 1 | Job Title 3 | 18 | 22 |  |  | 3270 |  | 3420 |  | 3570
1032 | 2 | Job Title 4 | 19 | 28 |  |  | 3690 |  | 4090 |  | 4490
1035 | 1 | Job Title 5 | 25 | 38 |  |  | 4830 |  | 5330 |  | 5830
1035 | 2 | Job Title 6 | 28 | 50 |  |  | 5750 |  | 6650 |  | 7550
Spreadsheet: 101375d1299524950-summarizing-a-table-room-sample
Sheet: Sheet1

Cost per night | 179
tax | 0.18
 | Wednesday | Thursday | Friday |  | Name | Total Cost
rooms needed: | 1 | 2 | 2 |  | Jessica | 173.5021428571428
total room cost: | 211.22 | 422.44 | 422.44 |  | Kelly | 173.5021428571428
cost per person: | 52.805 | 60.34857142857143 | 60.34857142857143 |  | [NAME] | 173.5021428571428
 | Jessica | Jessica | Jessica |  | [NAME] | 173.5021428571428
 | Kelly | Kelly | Kelly |  | [NAME] | 120.6971428571429
 | [NAME] | [NAME] | [NAME] |  | [NAME] | 120.6971428571429
 | [NAME] | [NAME] | [NAME] |  | [NAME] | 120.6971428571429
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
Spreadsheet: 63883d1264738403-map-data-from-multiple-columns-map-data-from-multiple-columns
Sheet: Original

Column A | Column B | Column C | Column D | Column E
919810332270 | 8050713804 | New Delhi | 8022946914 | 8023648189
8025323519 | 918026687004 | 8022293746 | Wlcc | 918050713804
8025323519 | Hardeep kanwar | 8088208554 | 8088227204 | 8093361841
8099278016 | 8023648189 | 918123534516 | 918125531112 | 8012369850
B1/200 | 8055782954 | [EMAIL] | 8050703529 | 8022293746
Spreadsheet: 820797d1678290603-need-help-totalling-columns-that-have-multiple-if-commands-type7-catchpit-ring-spreadsheet-1-
Sheet: TYPE7 SPREADSHEET

Manhole Reference | Cover Level | [NAME] | AOD FOR DIG | AOD FOR TOC | Minimum sump | Course with minimum | Diameter | Rings needed (M) | 1M | 750mm | 500mm | 250mm | Chamber Depth
1 | 81.903 | 81.003
2 | 43 | 41
3 | 43 | 41 |  |  |  |  |  |  |  |  |  |  |  |  | Total 1m |  | I am looking for the total of column J
4 | 43.87 | 42.86 |  |  |  |  |  |  |  |  |  |  |  |  | total 750 | 4 | I am looking for the total of column K
5 | 44 | 42.3 |  |  |  |  |  |  |  |  |  |  |  |  | total500 | 6 | I am looking for the total of column L
6 | 44 | 42.4 |  |  |  |  |  |  |  |  |  |  |  |  | total 250 | 3 | I am looking for the total of column M
7 | 44 | 41.6
8 | 44 | 41.9
9 | 44 | 42.065
10 | 44 | 43
Spreadsheet: 136338d1326552284-autoformatting-of-cells-relating-to-weekends-and-public-holidays-sickness-calendar-draft1
Sheet: Jan 2012

JAN
1 | Month Number | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | n/a | n/a | n/a | n/a
Group 1
Smith | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Doe | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Morris | Greg | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Jones | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
[NAME] | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Group 2
[NAME] | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
[NAME] | Amanda | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Brookes | [NAME] | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E | #N/A | #N/A | #N/A | #N/A | #N/A | W/E | W/E
Group 1 Totals |  | #N/A
Group 2 Totals |  | #N/A
Spreadsheet: a501200c-d3ec-436b-966f-23afb482d5dc
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
ASU | Test | ASU | Arsenic, 24 Hour, [NAME] | Arsenic, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Patient should not eat seafood for a 48-hour period prior to start of collection. 4. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 5. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3 	No Toluene	Yes 6N HNO3	No Boric Acid	No Thymol	No | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-35 mcg/specimen Reference values apply to all ages. | Monday through Friday; 3 p.m. - 9 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 2 days | 1 | 82175 |  |  |  |  | Rochester
ASU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ASU | Order Question | TIME3 | Collection Duration |  | Plain Text
ASU | Order Question | VL14 | [NAME] |  | Plain Text
ASU | Result | 31086 | Arsenic, 24 Hr, U | Arsenic, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5587-1 | Arsenic:MRat:24H:[NAME]:Qn:
ASU | Result | TIME3 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
ASU | Result | VL14 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
ASU | Result | 859 | As Concentration | As Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21074-0 | Arsenic:MCnc:24H:[NAME]:Qn:
Spreadsheet: 154177d1336276984-excel-2007-sum-based-on-range-and-multiple-worksheet-xyz-product
Sheet: Marketing

Category | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Project | 0.075 | 0.175 | 0.18125 | 0.425 | 0.65 | 0.53125 | 0.175 | 0.28125
Research and Development | 8 | 24 | 24 | 64 | 100 | 80 | 24 | 40
Market Survey | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 2
Focus Group | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Internal Training | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 0982fecb-b693-4f06-b431-16c0f11c74c8
Sheet: Sheet1

Table 3--U.S. monthly average farm prices and marketings | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | 2013/14 |  |  |  | 2012/13 |  |  |  | 2011/12
Month |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August |  | 15.6 | 1/ |  |  | 14.6 |  | 10856 |  | 13.6 |  | 11434
September |  |  |  |  |  | 14.3 |  | 10630 |  | 14.4 |  | 12704
October |  |  |  |  |  | 14.4 |  | 14110 |  | 14.9 |  | 12070
November |  |  |  |  |  | 14.6 |  | 16343 |  | 15.3 |  | 11404
December |  |  |  |  |  | 14.8 |  | 15272 |  | 15 |  | 14624
January |  |  |  |  |  | 15 |  | 18859 |  | 15.2 |  | 15053
February |  |  |  |  |  | 14.9 |  | 15472 |  | 14.1 |  | 13555
March |  |  |  |  |  | 15 |  | 14301 |  | 14.1 |  | 14682
April |  |  |  |  |  | 15.3 |  | 12649 |  | 14.4 |  | 13311
May |  |  |  |  |  | 15.3 |  | 11250 |  | 14.1 |  | 13127
June |  |  |  |  |  | 15.4 |  | 9843 |  | 14.2 |  | 10510
July |  |  |  |  |  | 15.3 |  | 8979 |  | 14.4 |  | 11380
Average price to date |  | 15.6 | 2/
Season average farm price |  | 15.2 | 3/ |  |  | 14.9 |  |  |  | 14.5
Average Marketings |  |  |  |  |  |  |  | 13213.66666666667 |  |  |  | 12821.16666666667
Total volume marketed |  |  |  |  |  |  |  | 158564 |  |  |  | 153854
N/A = Not available.
1/ Mid-month only.  2/ Simple average.  3/ Mid-point of season-average farm price projection range.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated September 12, 2013.
Spreadsheet: 44926d1243672517-simple-ledger-examplebook1-1-
Sheet: Sheet1

 |  |  |  | choose start date | 2009-01-12 00:00:00 | total credit | total debit | difference
 |  |  |  | choose end date | 2009-02-05 00:00:00 | 1250 | 1375 | -125
Date | Description | Credit | Debit | Balance | Monthly
2009-01-05 00:00:00 |  |  | 300 | -300 | -300
2009-01-12 00:00:00 |  |  | 400 | -700
2009-01-19 00:00:00 |  |  | 250 | -950
2009-01-26 00:00:00 |  |  | 300 | -1250
2009-02-02 00:00:00 |  |  | 425 | -1675 | -1675
2009-02-05 00:00:00 |  | 1250 |  | -425
2009-03-05 00:00:00 |  |  |  | -425 | -425
Spreadsheet: 849570d1699995255-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-example-for-forum-jean_sibelius-corrected-by-jetemc-two-new-items-
Sheet: Result

How can I automate the linking between publication, DATA and labelling (type) in the most efficient and robust way?
 |  | Selection of Data | VLOOKUP
Spreadsheet: sally_beck__33957__Weekly Operating Report 2-22
Sheet: WE 2-1 EOL Data

EOL
 | Week ending 2/1 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas |  |  | MMBTU
Power |  |  | MHtz
EGM
Liquids |  |  | BBL
Coal |  |  | TONNE
Coal International |  |  | TONNE
Weather |  |  | HDD/CDD
IR/FX | 0 | 0 | USD
Emissions |  |  | CONTRACTS
EIM
Pulp & Paper | 5 | 286 | TONNE
Steel | 0 | 0 | TONNE
Number of new EOL Counterparties | 8
Non-EOL
 | Week ending 2/1 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas |  |  | MMBTU
Power |  |  | MHtz
EGM
Liquids |  |  | BBL
Coal |  |  | TONNE
Coal International |  |  | TONNE
Weather |  |  | HDD/CDD
IR/FX |  |  | USD
Emissions |  |  | CONTRACTS
EIM
Pulp & Paper |  | 24860 | TONNE
Steel | 0 | 0 | TONNE
Clickpaper
 | Week ending 2/1 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EIM
Lumber | 5 | 286000 | Board Feet
Newsprint
Pulp (recycled paper) | 2 | 440 | [NAME]
Number of new CP Counterparties | 1
Lumber Converted
EIM TOTAL
Spreadsheet: 818347d1676751316-logic-formulas-when-counting-unique-clients-sample-data
Sheet: Sheet1

Client ID | Date | Service |  |  |  |  |  |  | For INFO | Only |  | Only | Wash &
7645 | 2022-07-15 00:00:00 | Haircut |  | Unique clients = |  |  |  |  | Wash | Wash | Haircut | Haircut | Haircut
7123 | 2022-07-22 00:00:00 | Haircut |  | only [NAME]
7123 | 2022-07-22 00:00:00 | Wash |  | only Haircut |  |  |  |  | 5462 | 6603 | 7123 | 8905 | 7922
5462 | 2022-07-22 00:00:00 | Wash |  | Both |  |  |  |  | 6603 | 1042 | 8905 | 1115 | 4554
8905 | 2022-07-23 00:00:00 | Haircut |  |  |  |  |  |  | 7922 |  | 7922 |  | 9621
6603 | 2022-07-25 00:00:00 | Wash |  | only |  |  |  |  | 4554 |  | 4554
7922 | 2022-07-30 00:00:00 | Haircut |  | Wash |  |  |  |  | 9621 |  | 9621
7922 | 2022-07-30 00:00:00 | Wash |  |  |  |  |  |  | 1042 |  | 1115
4554 | 2022-08-01 00:00:00 | Wash |  | only
4554 | 2022-08-01 00:00:00 | Haircut |  | Haircut
9621 | 2022-08-04 00:00:00 | Wash
9621 | 2022-08-04 00:00:00 | Haircut |  | Wash
1115 | 2022-08-05 00:00:00 | Haircut |  | and
1042 | 2022-08-07 00:00:00 | Wash |  | Haircut
Spreadsheet: 219868d1362997947-referencing-vertical-list-horizontally-with-gap-in-cells-example
Sheet: Sheet1

1 | 675118 | 78410 | 0.0112 | 7561.3216 | 559 | 8120.3216 | 0.0091 | 6143.5738 | 398 | 6541.5738
2 | 673827 | 78410 | 0.0112 | 7546.8624 | 558 | 8104.8624 | 0.0097 | 6536.1219 | 397 | 6933.1219
3 | 621563 | 79910 | 0.0122 | 7583.068600000001 | 565 | 8148.068600000001 | 0.0094 | 5842.6922 | 403 | 6245.6922
4 | 624874 | 82060 | 0.012 | 7498.488 | 557 | 8055.488 | 0.0097 | 6061.2778 | 397 | 6458.2778
5 | 687248 | 80160 | 0.0113 | 7765.9024 | 610 | 8375.902399999999 | 0.0071 | 4879.4608 | 434 | 5313.4608
6 | 730876 | 79510 | 0.0129 | 9428.3004 | 656 | 10084.3004 | 0.0071 | 5189.2196 | 467 | 5656.2196
7 | 655959 | 84910 | 0.0129 | 8461.8711 | 555 | 9016.8711 | 0.0086 | 5641.2474 | 396 | 6037.2474
8 | 598820 | 80760 | 0.0133 | 7964.306 | 532 | 8496.306 |  |  | 379
9 | 636531 | 78910 | 0.0127 | 8083.9437 | 553 | 8636.9437 |  |  | 394
10 | 659527 | 78910 | 0.0117 | 7716.4659 | 570 | 8286.4659 |  |  | 406
11 | 647944 | 78910 | 0.0127 | 8228.888799999999 | 549 | 8777.888799999999 |  |  | 391
12 | 0 |  | 0.0122 | 0 | 564 | 564 |  |  | 402
13 | 0 |  | 0.0122 | 0 | 633 | 633 |  |  | 451
14 | 0 |  | 0.0115 | 0 | 595 | 595 |  |  | 424
15 | 0 |  | 0.0124 | 0 | 536 | 536 |  |  | 382
16 | 0 |  | 0.012 | 0 | 525 | 525 |  |  | 374
17 | 0 |  | 0.0124 | 0 | 527 | 527 |  |  | 375
18 | 0 |  | 0.0116 | 0 | 531 | 531 |  |  | 378
19 | 0 |  | 0.012 | 0 | 531 | 531 |  |  | 379
20 | 0 |  | 0.0127 | 0 | 531 | 531 |  |  | 378
21 | 0 |  | 0.0128 | 0 | 535 | 535 |  |  | 381
22 | 0 |  | 0.0121 | 0 | 583 | 583 |  |  | 415
23 | 0 |  | 0.0121 | 0 | 541 | 541 |  |  | 385
24 | 0 |  | 0.0127 | 0 | 543 | 543 |  |  | 387
25 | 0 |  | 0.013 | 0 | 525 | 525 |  |  | 374
26 | 0 |  | 0.0132 | 0 | 524 | 524 |  |  | 374
27 | 0 |  | 0.0128 | 0 | 505 | 505 |  |  | 360
28 | 0 |  | 0.013 | 0 | 513 | 513 |  |  | 365
29 | 0 |  | 0.0133 | 0 | 490 | 490 |  |  | 349
30 | 0 |  | 0.0131 | 0 | 499 | 499 |  |  | 356
31 | 0 |  | 0.0126 | 0 | 511 | 511 |  |  | 364
32 | 0 |  | 0.0127 | 0 | 496 | 496 |  |  | 354
33 | 0 |  | 0.0138 | 0 | 503 | 503 |  |  | 358
34 | 0 |  | 0.0137 | 0 | 500 | 500 |  |  | 356
35 | 0 |  | 0.0134 | 0 | 515 | 515 |  |  | 367
36 | 0 |  | 0.0134 | 0 | 559 | 559 |  |  | 398
37 | 0 |  | 0.0137 | 0 | 524 | 524 |  |  | 373
38 | 0 |  | 0.0133 | 0 | 518 | 518 |  |  | 369
39 | 0 |  | 0.0126 | 0 | 500 | 500 |  |  | 356
40 | 0 |  | 0.0121 | 0 | 493 | 493 |  |  | 351
41 | 0 |  | 0.0123 | 0 | 484 | 484 |  |  | 345
42 | 0 |  | 0.0116 | 0 | 489 | 489 |  |  | 348
43 | 0 |  | 0.0093 | 0 | 592 | 592 |  |  | 422
44 | 0 |  | 0.0227 | 0 | 426 | 426 |  |  | 304
45 | 0 |  | 0.018 | 0 | 451 | 451 |  |  | 321
46 | 0 |  | 0.0161 | 0 | 445 | 445 |  |  | 317
47 | 0 |  | 0.0145 | 0 | 447 | 447 |  |  | 319
48 | 0 |  | 0.0136 | 0 | 485 | 485 |  |  | 345
49 | 0 |  | 0.0136 | 0 | 500 | 500 |  |  | 356
50 | 0 |  | 0.0132 | 0 | 515 | 515 |  |  | 367
51 | 0 |  | 0.013 | 0 | 515 | 515 |  |  | 367
52 | 0 |  | 0.0132 | 0 | 496 | 496 |  |  | 353