tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846605d1697747873-dynamic-list-based-on-multiple-criteria-sample-book
Sheet: Sheet1

CM | Name | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month
[NAME] | [NAME] |  | January
[NAME] | [NAME] |  |  |  |  |  |  |  | February |  | March
Janelle | [NAME] |  | January
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  | March
[NAME] | Elijah |  |  |  | March |  | January
Janelle | [NAME] |  | February |  |  |  |  |  |  |  | May
[NAME] | [NAME] |  |  |  |  |  | May |  | May
[NAME] | Lucas |  |  |  |  |  |  |  |  |  | March
Janelle | [NAME] |  |  |  | March
[NAME] | Theodore |  | February |  | March |  | April |  | April
[NAME] | Olivia |  |  |  |  |  |  |  |  |  | April
Janelle | Emma |  |  |  |  |  |  |  | April
[NAME] | Charlotte |  | February
[NAME] | Amelia |  |  |  |  |  | January |  |  |  | March
Janelle | Sophia |  |  |  | February
[NAME] | [NAME]
[NAME] | Ava |  |  |  |  |  |  |  | March
Janelle | [NAME] |  | May |  | May
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  | April
[NAME] | Luna
 | [NAME] | January | February | March | April | May
Spreadsheet: 548594d1511217381-approval-matrix-with-4-different-lookup-criteria-index-matches-array-not-sure-approval-matrix
Sheet: Sheet1

 |  |  | Op Income | Revenue | Capital | New Lease (Term) | BU MD | BU VP | COO | CEO | BU Finance | CFO | Ground | Corp | BOD
 |  |  | 7%-12.5% | <$2M |  |  | A |  |  |  | A
 |  |  |  | >=$2m |  |  | R | A |  |  | A
 |  |  |  | >=$5m |  |  | R | R | A |  | A
 |  |  |  | >=$10m |  |  | R | R | R | A | R | A
 |  |  | >12.5% | <$2.5m |  |  | A |  |  |  | A
 |  |  |  | >=$2.5M |  |  | R | A |  |  | A
 |  |  |  | >=$7.5m |  |  | R | R | A |  | A
 |  |  |  | >=$12.5m |  |  | R | R | R | A | R | A
 |  |  |  |  | $0-$1M | $0-$2.5m | R | A |  |  | A
 |  |  |  |  | $1m- $2.5M | $2.5M to $5m | R | R | A |  | R | A
 |  |  |  |  | $2.5M-$5m | $5m to $10m | R | R | R | A | R | A
 |  |  |  |  | $5m-$15m | $10m to $40m | R | R | R | R | R | R | A
 |  |  |  |  | $15m - $50m | $40m to $100m | R | R | R | R | R | R | R | A
 |  |  |  |  | > $50m | >$100m | R | R | R | R | R | R | R | R | A
 | Example:
 | Op Income: | 0.08
 | Revenue: | 11000000
 | Capital: | 100000
 | New Lease: | 100000
 | Reviewer (s): | BU MD | COO | BU Finance
 | Approver: | BU VP | CEO | BU Finance | CFO
Spreadsheet: 333105d1405666966-planned-vs-actual-formula-planned-vs-actual-hours-summary-
Sheet: Summary

 | Name | Project | 2014-05-05 00:00:00 | 2014-07-05 00:00:00 | 2014-08-05 00:00:00 | 2014-09-05 00:00:00
 | [NAME] | Project A
 |  | Project 1
 |  | Project AD
 |  | Project 9
 |  | Project 10
 |  | Project C4
 |  | Project 1944
 |  | [NAME]
Spreadsheet: 146252d1332008705-building-an-eve-online-spreadsheet-of-my-own-matrix-for-prob
Sheet: Sheet1

a | b | c | d | e | f | = k
3 | -10 | 0 | 0 | 0 | 0 | 0
0 | 0 | 20 | 0 | -3000 | 0 | 0
0 | 0 | 0 | 20 | 0 | -3000 | 0
0 | -5 | 40 | 40 | 0 | 0 | 0
Or
3 | -10 | 0 | 0 | 0 | 0 | 0
0 | 0 | 1 | 0 | -150 | 0 | 0
0 | 0 | 0 | 1 | 0 | -150 | 0
0 | -1 | 8 | 8 | 0 | 0 | 0
Spreadsheet: 859274d1707727030-creating-calculation-after-matchinf-data-look-up-and-add-value
Sheet: Monthly Cashflow

 |  | Month |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 |  | Year |  |  | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1
Revenue
 | Line Item 1
 | Line Item 2
 | Line Item 3
 | Line Item 4
 | Line Item 5
 | Line Item 6
 | Line Item 7
 | Line Item 8
 | Line Item 9
 | Line Item 10
 | Line Item 11
 | Total
Spreadsheet: 220684d1363230805-person-matching-between-two-data-sets-need-to-return-id-from-one-and-match-to-other-sample-workbook_1
Sheet: NFP Data

idnr | fname | mname | lname | NFP | School | DOB
 | [NAME] |  | Smith | Tutoring | MADISON | 2000-08-18 00:00:00
 | [NAME] | Alejandro | Munoz | Mentoring | WHITE | 1999-08-12 00:00:00
 | [NAME] | Celeste | [NAME] | Math Blasters | CLARKSTON | 2001-06-29 00:00:00
 | [NAME] |  | Ray | Early Childhood | [NAME] | 2006-12-01 00:00:00
 | [NAME] | [NAME] | Switzer | Math Blasters | CLARKSTON | 2001-11-23 00:00:00
Spreadsheet: kate_symes__18897__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 | 2001-03-16 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 325 | 415 | 188.89 | 405
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144 | 237.58 | 642 | 186.25 | 260
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 |  |  |  |  |  | ..
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Bob Irish

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
I'd like to explain my position
Explain your fair share position, if you choose.
I have read you questionier in depth. I am a school board member.  This whole questionier is about
protecting the teacher without requard for anything else. Not once is there one mention of the student.
When we can work colaboratively for what is best for the student, when we can put education and student
outcomes first you will have ny unconditional support. I am also a certificated teacher.
Teachers' Retirement: Support in the State Budget
I'd like to explain my position
Explain your teachers' retirement position, if you choose.
Read above
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
What entitles teachers to better treatment than the rest of employees caught in the transition
Teaching Career: Retaining New Teachers
I'd like to explain my position
Explain your teaching career position, if you choose
I need futher explination on proven ways  of helping young professionals
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 1909 Barnum Rd. [NAME] | State Rep | No |  | Franklin
Spreadsheet: 840532d1692802712-adding-cells-and-columns-with-criteria-of-other-columns-formula-question
Sheet: Sheet1

 |  |  | 5 |  | debit
 | 15 |  | 7 |  | credit
 | 30 |  | 3 |  | Credit
 | 25 |  | 6 |  | Debit
 | 96 |  | 9 |  | Debit
 | 83 |  | 1 |  | Debit
 | 12 |  | 18 |  | Credit
 |  |  | 5 |  | Credit
 |  |  | 6 |  | Debit
 |  |  | 7 |  | Credit
 |  |  | 6 |  | Credit
 |  |  | 8 |  | Debit
 |  |  |  | debit
 |  |  |  | credit
Spreadsheet: 822622d1679453448-repeat-values-x-times-down-a-column-repeat-values
Sheet: Sheet1

Input data |  | Desired results from formula
1 |  | 1
a |  | 1
test |  | 1
jkl |  | a
wjklwl |  | a
33 |  | a
502 |  | test
sdjkl |  | test
elkjl |  | test
[NAME] |  | jkl
 |  | jkl
 |  | jkl
 |  | wjklwl
 |  | wjklwl
 |  | wjklwl
 |  | 33
 |  | 33
 |  | 33
 |  | 502
 |  | 502
 |  | 502
 |  | sdjkl
 |  | sdjkl
 |  | sdjkl
 |  | elkjl
 |  | elkjl
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 881447d1729522935-index-match-formula-for-multiple-criteria-product
Sheet: Lookup

 |  | Make | Product
 |  | Aster
 | Make
 | Product
 | Application
 | Model
 | Type
 | [NAME]
 | [NAME]
 | Output
 | Installation
 | Power supply
 | Pressure rating
 | Process temperature
 | Electrode material
 | Lining material
 | Body material
 | protection
 | Price
 | Feature
Spreadsheet: 160137d1338984931-ignoring-duplicates-when-calculating-a-median-excel-example
Sheet: Sheet1

83
67
67
67 |  | Median
40
31
25
20
11
10
6
4
4
4
5
2
2
2
1
1
3
1
3
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
Spreadsheet: 473790d1470401790-getting-a-status-change-protocol
Sheet: Appendix

Lists:
"Status" |  |  | Module status:
 | To do |  | 1
 | Failed |  | 2
 | Done |  | 3
 |  |  | 4
 |  |  | 5
"Testing" |  |  | 6
 | Not yet |  | 7
 | Yes, please do |  | 8
 | Inactive |  | 9
 |  |  | 10
Spreadsheet: 688529d1595842779-extract-dates-from-vlookup-vlookup-problem-md-comments
Sheet: Sheet1

 |  | Misuse |  |  |  | Other
Id | Location Name | Events | 1st Event | 2nd Event | 3rd Event | Events | 1st Event | 2nd Event | 3rd Event
2125 | Location a |  | 28/02/2020 | 2020-05-17 00:00:00 | 2020-07-03 00:00:00 | 3
Spreadsheet: larry_campbell__21031__SeminolePTE
Sheet: enginePTE

NORTHERN NATURAL GAS COMPANY
SEMINOLE COMPRESSOR STATION
TNRCC ACCOUNT NO. GA-0174-T
 |  |  |  |  |  |  |  |  | `
NATURAL GAS FIRED PIPELINE COMPRESSOR ENGINE EMISSIONS
ANNUAL EMISSIONS
UNIT | TOTAL | HEAT | RATED |  | EMISSION FACTORS (1) (3) |  |  | (4) | ANNUAL EMISSIONS (TONS/YR)  (5)
I.D. | ANNUAL | RATE | HORSE
(EPN) | HOURS | (Btu/hp-hr) | POWER | SO2 | NOX | CO | nm-VOC | PM | SO2 | NOX | CO | nm-VOC | PM
A-1 | 8760 | 7500 | 430 | 0.00058 | 2.21 | 3.72 | 0.0296 | 0.01941
T-1 | 8760 | 10000 | 9300 | 0.0034 | 0.32 | 0.082 | 0.0021 | 0.0066
TOTAL
HAP Emissions AP-42 Factors
Pollutant | 4SRB | 4SLB | 2SLB | Turbines
Acetaldehyde | 0.00279 | 0.00836 | 0.00776 | 4e-05
[NAME] | 0.00263 | 0.00514 | 0.00778
Benzene | 0.00158 | 0.00044 | 0.00194
Formaldehyde | 0.0205 | 0.0528 | 0.0552 | 0.00071
Methanol | 0.00306 | 0.0025 | 0.00248
Ethylbenzene |  |  |  | 3.2e-05
Toluene |  |  |  | 0.00013
Xylenes |  |  |  | 6.4e-05
Total HAP | 0.0324 | 0.07203 | 0.07954 | 0.001027
POTENTIAL ANNUAL HAP EMISSIONS (tpy)
UNIT
I.D. |  | Pollutant
 | [NAME]/hr | Acetaldehyde | [NAME] | Benzene | Formaldehyde | Methanol | Ethylbenzene | Toluene | Xylene | Total HAP
A-1 |  |  |  |  |  |  | - | - | -
T-1 |  |  |  |  |  |  | - | - | -
TOTAL
NOTES:
(1) Emission factors (lb/[NAME]) for NOx, CO, and VOC from AP-42 Tables 3.1-1 and 3.1-2a dated 4/00 (turbines) and 3.2-3 dated 7/00 (4Rich), at 90-105% loads.
(2) Analysis of natural gas shows virtually no sulfur.  AP-42 factor based on 2000 grains per [NAME].
(3) 100% of Total Outlet particulate is assumed to be PM2.5.  PM2.5 factor (lb/[NAME]) was obtained from AP-42, Tables 3.1-2a (gas turbine) and 3.2-3 (4 stroke rich-burn engine).
(4) Compressor turbine is a General Electric M3912R. [NAME] is amodel F1197GRSIU.
Spreadsheet: 799125d1664945962-extract-telephone-number-and-phone-number-extract-tele-nos
Sheet: Sheet2

To Extract telephone and phone numbers
code | Address /contact details | Address /contact details | Expected Answer | Expected Answer | Expected Answer
1015 | POST BOX # 119311 -TEL: +971 04 8842242 | TEL: +971 04 8942240 ,PH: 971 11 2939763 , FAX: 971 04 2959763 | TEL: +971 04 8842242 | TEL: +971 04 8942240 | PH: 971 11 2939763
951 | POST BOX # 118887 | PH: 971 04 8329811 , FAX: 971 04 8329211 | PH: 971 04 8329811
968 | BILL TO:EMAAR BUSINESS PARK-SHK ZAYED RD | TEL: +971 04 4430035 - FAX: +971 04 4432421 | TEL: +971 04 4430035
871 | POST BOX # 45200 | PH: 971 02 6979444 , PH: 971 02 6443989,FAX: 971 02 6979085 | PH: 971 02 6979444 | PH: 971 02 6443989
703 | TEL: +971 04 8142322 | FAX: +971 04 -PH: 971 02 6979444 | TEL: +971 04 8142322 | PH: 971 02 6979444
 | 1. Check for either [NAME]: or Ph: in cell B and cell C of each row
 | 2 Need to extract [NAME]: and Ph: in separate columns in the sequence it reflects in those columns
 | 3. which means if in one column you have two Tel: , the it will appear in two separate columns , ie D and E
 | 4. Same logic for PH: as well
Spreadsheet: 41376d1239831017-array-formula-test5
Sheet: Wellness Profiles

Wellness Code | Cost PEPM | Monthly Cost | Annual Cost | Wellness Product Description
SC | 5 | 1750 | 21000 | NRT  - Product 1
EAP | 2.5 | 1250 | 15000 | EAP - Product 2
GM | 0.19 | 120 | 1440 | Globalfit - Product 3
SC | 45 | 15750 | 189000 | Test - Product 4
GM | 0 | 0 | 0 | Get up and start walking
MISC | 30 | 10500 | 10500 | First aid CPR class
Spreadsheet: 739665d1625847251-extracting-overlapping-date-ranges-sample-46-ans
Sheet: Sheet1

Pers.no. | Name Last Name | Start | End | Company
 |  |  |  |  |  |  |  | hiuh
Spreadsheet: 648151d1572898938-lookup-returning-multiple-results-lookup-multiple-occurrences
Sheet: Data

2019-10-31 00:00:00
REGION | SALESPERSON | COUNTRY
Europe | AAA | Spain
Europe | BBB | Portugal
Europe | CCC | France
Africa | DDD | Zimbabwe
Africa | EEE | Zambia
Africa | FFF | Botswana
Africa | GGG | Mozambique
Spreadsheet: 793967d1661824479-year-to-date-formula-examplea-hd
Sheet: Sheet1

 |  | FY 2023 BUDGET |  |  |  |  |  |  |  |  |  |  |  |  | Current Month |  | 2022-08-01 00:00:00
 |  | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 |  | MONTH TARGET | FY TO DATE TARGET | FY23 TARGET
 | Store 1 | 5104.93 | 14592.85 | 7754.33 | 11224.24 | 7392.92 | 11433 | 7548.83 | 14562.67 | 8114.71 | 8237.19 | 6210.87 | 6074.01
 | Store 2 | 7754.33 | 11224.24 | 7392.92 | 11433 | 7548.83 | 14562.67 | 8114.71 | 8237.19 | 6210.87 | 10695.34 | 8255.140000000001 | 15128.97
 | Store 3 | 11630 | 5104.589999999998 | 8163.130000000001 | 8455.289999999995 | 4413.610000000001 | 10695.34 | 8255.140000000001 | 15128.97 | 9000 | 9382.259999999998 | 5542.560000000001 | 8000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: 768890d1645190876-two-different-formulas-to-sort-values-and-dates-wind-example
Sheet: Blad1

1941-01-01 00:00:00 | 2.5 |  |  |  |  | 1941-01-01 00:00:00 | 2.5 |  | 1941-01-11 00:00:00 | 4.5
1941-01-01 00:00:00 | 6.5 |  |  |  |  | 1941-01-01 00:00:00 | 6.5 |  | 1941-01-11 00:00:00 | 4.5
1941-01-01 00:00:00 | 6.5 |  |  |  |  | 1941-01-01 00:00:00 | 6.5 |  | 1941-01-11 00:00:00 | 4.5
1941-01-02 00:00:00 | 9.0 |  |  |  |  | 1941-01-03 00:00:00 | 6.5 |  | 1941-01-12 00:00:00 | 1.0
1941-01-02 00:00:00 | 9.0 |  |  |  |  | 1941-01-04 00:00:00 | 6.5 |  | 1941-01-12 00:00:00 | 6.5
1941-01-02 00:00:00 | 9.0 |  |  |  |  | 1941-01-04 00:00:00 | 6.5 |  | 1941-01-12 00:00:00 | 6.5
1941-01-03 00:00:00 | 9.0 |  |  |  |  |  |  |  | 1941-01-13 00:00:00 | 2.5
1941-01-03 00:00:00 | 9.0 |  |  |  |  | 1941-01-12 00:00:00 | 1.0 |  | 1941-01-13 00:00:00 | 6.5
1941-01-03 00:00:00 | 6.5 |  |  |  |  | 1941-01-12 00:00:00 | 6.5
1941-01-04 00:00:00 | 6.5 |  |  |  |  | 1941-01-12 00:00:00 | 6.5
1941-01-04 00:00:00 | 6.5 |  |  |  |  | 1941-01-13 00:00:00 | 2.5
1941-01-04 00:00:00 | 12.0
1941-01-05 00:00:00 | 9.0
1941-01-05 00:00:00 | 9.0
1941-01-05 00:00:00 | 6.5
1941-01-06 00:00:00 | 4.5
1941-01-06 00:00:00 | 6.5
1941-01-06 00:00:00 | 9.0
1941-01-07 00:00:00 | 4.5
1941-01-07 00:00:00 | 2.5
1941-01-07 00:00:00 | 2.5
1941-01-08 00:00:00 | 9.0
1941-01-08 00:00:00 | 6.5
1941-01-08 00:00:00 | 9.0
1941-01-09 00:00:00 | 6.5
1941-01-09 00:00:00 | 4.5
1941-01-09 00:00:00 | 2.5
1941-01-10 00:00:00 | 9.0
1941-01-10 00:00:00 | 6.5
1941-01-10 00:00:00 | 9.0
1941-01-11 00:00:00 | 4.5
1941-01-11 00:00:00 | 4.5
1941-01-11 00:00:00 | 4.5
1941-01-12 00:00:00 | 1.0
1941-01-12 00:00:00 | 6.5
1941-01-12 00:00:00 | 6.5
1941-01-13 00:00:00 | 2.5
1941-01-13 00:00:00 | 6.5
1941-01-13 00:00:00 | 9.0
1941-01-14 00:00:00 | 15.0
1941-01-14 00:00:00 | 2.5
1941-01-14 00:00:00 | 4.5
1941-01-15 00:00:00 | 4.5
1941-01-15 00:00:00 | 4.5
1941-01-15 00:00:00 | 4.5
Spreadsheet: 163904d1340536576-lookup-question-tricky-sample-file
Sheet: Fast Moving Items

Item Code | Brand | Variant | Remarks
EN/ACR/M/100/EDT | ENTITY | ACROSS | Fast
EN/ACT/M/100/EDT | ENTITY | ACTION SPORTS | Fast
EN/AZN/M/100/EDT | ENTITY | AIR ZONE | Running
EN/AQU/M/100/EDT | ENTITY | AQUA ZONE
EN/BAS/M/100/EDT | ENTITY | BASE CODE
EN/BAM/M/100/EDT | ENTITY | BIG AMBITION
EN/BLB/M/100/EDT | ENTITY | BLACK BELT | Fast
EN/BON/M/100/EDT | ENTITY | BON AQUA
EN/CKM/M/100/EDT | ENTITY | CAREER MAN | Fast
EN/COL/M/100/EDT | ENTITY | COOL OFF MEN | Fast
EN/DHS/M/100/EDT | ENTITY | DAILY HOMME SPORT | Running
EN/DFN/M/100/EDT | ENTITY | [NAME]
EN/DVG/M/100/EDT | ENTITY | DIVING SUIT
EN/DLT/M/100/EDT | ENTITY | DOLCETTO | Fast
EN/DTO/M/100/EDT | ENTITY | DOLCETTO THE ONE
EN/EXL/M/100/EDT | ENTITY | EXCEL
EN/FIR/M/100/EDT | ENTITY | FIRE GATE ABSOLUTION
EN/FGT/M/100/EDT | ENTITY | FIRE GATE | Fast
EN/GBL/M/100/EDT | ENTITY | GIVEN BLUE LEVEL | Fast
EN/GDG/M/100/EDT | ENTITY | GOOD GUY | Running
EN/MOV/M/100/EDT | ENTITY | MOVE ENERGY
EN/PAL/M/100/EDT | ENTITY | PALADIUM ELITE
EN/9HD/M/100/EDT | ENTITY | 9HUNDRED
EN/AEF/M/100/EDT | ENTITY | ALTITUDE EFFECT
EN/DLB/M/100/EDT | ENTITY | DEEPLY BLACK
EN/EFC/M/100/EDT | ENTITY | E'FRANCKY
EN/GAL/M/100/EDT | ENTITY | GALLANT | Running
EN/JMP/M/100/EDT | ENTITY | JUMP
EN/JTM/M/100/EDT | ENTITY | JUST MAN | Running
EN/MID/M/100/EDT | ENTITY | MIDNIGHT
EN/OFH/M/100/EDT | ENTITY | ONLY FOR HIM | Running
EN/PRD/M/100/EDT | ENTITY | PARODY POUR HOMME
EN/TSK/M/100/EDT | ENTITY | TUSK | Fast
EN/WAY/M/100/EDT | ENTITY | WAY
EN/BRB/W/100/EDT | ENTITY | BRIGHT BLUE | Running
EN/COL/W/100/EDT | ENTITY | COOL OFF WOMEN | Fast
EN/MOR/W/100/EDT | ENTITY | MORE & MORE | Running
EN/NAV/W/100/EDT | ENTITY | NAVE
EN/RTY/W/100/EDT | ENTITY | REALITY
EN/VIC/W/100/EDT | ENTITY | VICTORIA | Fast
EN/5NM/W/100/EDT | ENTITY | 5 NUMBER | Running
EN/CMT/W/100/EDT | ENTITY | CLIMATIC
EN/FUJ/W/100/EDT | ENTITY | FUJI
EN/MGCW/W/100/EDT | ENTITY | MAGIC WOMEN
EN/ROCO/W/100/EDT | ENTITY | ROCOCO | Running
EN/WEK/W/100/EDT | ENTITY | WEEK IN | Running
EN/BGL/W/100/EDT | ENTITY | BLACK GLAMOUR
EN/CCL/W/100/EDT | ENTITY | CHERY CHERY LADY
EN/FLO/W/100/EDT | ENTITY | FLORENCE
EN/PRT/W/100/EDT | ENTITY | PRETTY PRETYY | Running
EN/SPR/W/100/Edt | ENTITY | SAPPHIRE
EN/TRS/W/100/EDT | ENTITY | THE ROSE
EN/DOR/W/100/EDT | ENTITY | DREAM ON ROCKS
EN/IDO/W/100/EDT | ENTITY | I DOLLY
EN/ORN/W/100/EDT | ENTITY | ORANGE
EN/VER/W/100/EDT | ENTITY | VERSAILLES
EN/DEW/W/100/EDT | ENTITY | DEW
EN/ABT/W/100/EDT | ENTITY | ABILITY
EN/DBR/W/100/EDT | ENTITY | [NAME]
EN/AUR/W/100/EDT | ENTITY | AURA
EN/IMP/W/100/EDT | ENTITY | IMPRESSION
EN/VNT/W/100/EDT | ENTITY | VANITY
Spreadsheet: 821611d1678815385-multiple-changing-variables-that-require-a-sum-dummy-ulcer-data
Sheet: Sheet2

Division 1 |  |  | Ward: | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Division 2 |  |  | W301 QEH | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Division 3 |  |  | W302 QEH | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4
Division 4 |  |  | W303 QEH | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 1 | 1 | 1
Division 5 |  |  | W304 QEH | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Division 6 |  |  | W305 QEH | 4
Division 7 |  |  | W306 QEH | 7
 |  |  | W407 QEH | 9
 |  |  | W408 QEH | 6
 |  |  | W409 QEH | 1
Spreadsheet: 713643d1610858908-formula-to-return-multiple-matches-from-a-reference-list-excel_help-1-ans-4
Sheet: Sheet1

groups_listed | categories_listed |  |  |  |  |  | categories_listed
Group A; Group M; Group T; Group B |  |  |  |  |  |  | Red | Blue | GREEN | TURQUOISE |  | Red | Blue | GREEN | TURQUOISE
Group J; Group S; Group C; Group T |  |  |  |  |  |  | YELLOW | Red | Red | GREEN |  | YELLOW | Red | GREEN
Group M; Group Q |  |  |  |  |  |  | Blue | Blue |  |  |  | Blue
Group C; Group J; Group Q |  |  |  |  |  |  | Red | YELLOW | Blue |  |  | Red | YELLOW | Blue
Group F; Group A |  |  |  |  |  |  | Red | Red |  |  |  | Red
Group B; Group C; Group D |  |  |  |  |  |  | TURQUOISE | Red | Red |  |  | TURQUOISE | Red
Group W; Group Z |  |  |  |  |  |  | Red | Red |  |  |  | Red
Group T |  |  |  |  |  |  | GREEN |  |  |  |  | GREEN
Group O; Group Y |  |  |  |  |  |  | Blue | Red |  |  |  | Blue | Red
Spreadsheet: 172258d1344077148-create-a-drop-down-box-in-a-worksheet-based-on-certain-values-gazps-workbook-example-edited-nick
Sheet: 123456

Source | [NAME] | CREDITED |  |  | Customer | Balance |  |  | Row Labels
123456 | 222222 | 100 |  |  | 123456 |  |  |  | 111111 |  | Customer | 222222
123456 | 333333 | 20 |  |  | 222222 |  |  |  | 222222 |  | Balance
333333 | 222222 | 75 |  |  | 333333 |  |  |  | 333333
123456 | 999999 | 50 |  |  | 999999 |  |  |  | 555555
999999 | 222222 | 10 |  |  | 777777 |  |  |  | 777777
123456 | 333333 | 25 |  |  | 888888 |  |  |  | 999999
777777 | 999999 | 10 |  |  | 555555 |  |  |  | [NAME]
999999 | 777777 | 20 |  |  | 444444
123456 | 777777 | 5 |  |  | 111111
444444 | 555555 | 20 |  |  | 232323
[NAME] | 222222 | 15 |  |  | [NAME]
444444 | [NAME] | 25
123456 | 111111 | 25
232323 | [NAME] | 5