tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270722d1381608824-index-match-with-duplicates-index-match-issue
Sheet: Sheet1

Company name | Year end | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |  |  | 2013 | 2014 | 2015 | 2016 | 2017 | 2018
Black | 2017 | 1650 | 850 | 2290 | 3730 | 5170
Bongo | 2013 | 50
Book | 2018 | 1150 | 600 | 1590 | 2580 | 3570 | 4560
Cat | 2017 | 1050 | 550 | 1450 | 2350 | 3250
Computer | 2016 | 350 | 200 | 470 | 740
[NAME] | 2016 | 1550 | 800 | 2150 | 3500
Data | 2014 | 150 | 100
Dog | 2013 | 1250 | 650 | 1730 | 2810 | 3890 | 4970
Door | 2016 | 950 | 500 | 1310 | 2120
Fan | 2018 | 1750 | 900 | 2430 | 3960 | 5490 | 7020
Lamp | 2018 | 550 | 300 | 750 | 1200 | 1650 | 2100
Life | 2014 | 1350 | 700
[NAME] | 2015 | 1450 | 750 | 2010
Monitor | 2017 | 450 | 250 | 610 | 970 | 1330
[NAME] | 2015 | 250 | 150 | 330
Sofa | 2013 | 650 | 350 | 890 | 1430 | 1970 | 2510
Table | 2014 | 750 | 400
Window | 2015 | 850 | 450 | 1170
Spreadsheet: 841304d1693493579-match-date-on-two-different-pages-and-paste-data-in-columns-ef-file
Sheet: Today

 | 2023-08-30 00:00:00
 | Day | Headcount | Night | Headcount
1 |  | 0.25 | [NAME] | 0.25
2 | [NAME] | 0.25 | [NAME] | 0.25
3 | [NAME] | 0.25 | [NAME] | 0.25
4 | [NAME] | 0.25 | [NAME] | 0.25
5 | [NAME] | 0.25 | [NAME] | 0.25
6 | [NAME] | 0.25 | [NAME] | 0.25
7 | Abbott Sample Cup | 0.25 | Abbott Sample Cup | 0.25
8 | [NAME] | 0.25 | [NAME] | 0.25
9 | [NAME] | 0.25 | [NAME] | 0.25
10 | [NAME] | 0.25 | [NAME] | 0.25
11 | Abbott Sample Cup | 0.25 | Abbott Sample Cup | 0.25
12 | Baxter SIV Core |  | Baxter SIV Core
13 | [NAME] |  | [NAME]
15 | Lid Tray | 0.5 | Lid Tray | 0.5
16 | [NAME] | 0.25 | [NAME] | 0.25
17 | [NAME] | 0.25 | [NAME] | 0.25
18 | [NAME] | 0.25 | [NAME] | 0.25
19 | [NAME] | 0.25 | [NAME] | 0.25
20 | Base Sleeve |  | Base Sleeve
21 | [NAME] | 0.25 | [NAME] | 0.25
22 | [NAME] | 0.25 | [NAME] | 0.25
30
31 | [NAME] | 0.25 | [NAME] | 0.25
50 | [NAME] | 0.25 | [NAME] | 0.25
Total | Baxter SIV Assy | 2 | Baxter SIV Assy | 2
 |  | 1900-01-08 00:00:00 |  | 1900-01-08 00:00:00
52
53 | [NAME] | 0.25 | [NAME] | 0.25
54 | [NAME] | 0.25 | [NAME] | 0.25
57 | [NAME] | 0.25 | [NAME] | 0.25
58 | [NAME] Key3 White | 0.25 | [NAME] Key3 White | 0.25
59 | [NAME] | 0.25 | [NAME] | 0.25
61 | [NAME] | 0.25 | [NAME] | 0.25
62 | Lid Tray | 0.5 | Lid Tray | 0.5
63 | NP 235 | 0.1 | NP 235 | 0.1
64
66 | [NAME] |  | NP 228 IQ
67 | Base Tray | 0.5 | Base Tray | 0.5
68 | NP 236 | 0.1 | NP 236 | 0.1
69 | BD | 0.5 | BD | 0.5
71 | OverCap Black ES |  | OverCap Black ES
72 | K109 | 0.1 | K109 | 0.1
73 | Capillary Tube Holder |  | Capillary Tube Holder
74
76
77
78
79
86
87
88
89
91
95 | [NAME] | 0.25 | [NAME] | 0.25
96
99 | K107 | 0.1 | K107 | 0.1
104 | [NAME] Key2 Aqua |  | [NAME] Key2 Aqua
106 | Lid Sleeve | 2 | Lid Sleeve | 2
107 | [NAME] Key8 Violet ES |  | [NAME] [NAME]
108 | Alinity Snap Ring |  | Alinity Snap Ring
109 | [NAME] Key4 Blue | 0.25 | [NAME] Key4 Blue | 0.25
Total | White Over-cap | 0.25 | White Over-cap | 0.25
 |  | 7 |  | 7
 | [NAME] | 7 | [NAME] | 7
 |  | -10 |  | -13
Spreadsheet: 218728d1362562195-use-of-data-in-cell-as-a-name-of-file-or-sheet-in-the-formula-use-cell-reference-as-a-file-name-in-formula
Sheet: 34633

 | PO Form: |  | Polygon
 | PO#: |  | 34633
 | Submission Date: |  | 2013-03-01 00:00:00
 | Signature: |  | kk
 | DG / Non DG: |  | Non DG
 | Shipment mode: |  | SEA
 | Expected ETD: |  | ASAP
 | S/N | SAP Code | Description | Qty | Remarks
 | 1 | 12345 | fere | 24 | 457
 | 2 | 25233 | eey4 | 6 | 586
 | 3 | 2352 | svbs | 25 | 5445
 | 4 | 523435 | wt3w4t | 28 | 4575
 | 5 | 23423 | stwe | 53 | 36
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
Spreadsheet: 33268d1229560643-adding-column-values-sumif-example
Sheet: Sheet1

Item Number | Product | Price | Price 2
1000000 | Item 1 | 10.56 | 10.87
1000001 | Item 2 | 9.97 | 11.44
1000002 | Item 3 |  | 9.75
1000003 | Item 4 | 5.49
1000004 | Item 5 | 4.36 | 4.79
1000005 | Item 6 | 3.47 | 3.57
1000006 | Item 7 | 8.94 | 7.21
1000007 | Item 8 | 11.29
1000008 | Item 9 | 0.34
1000009 | Item 10 | 0.56 | 0.67
1000010 | Item 11 | 0.89 | 0.93
1000011 | Item 12 |  | 1.54
1000012 | Item 13 | 1.89 | 1.97
Spreadsheet: 687979d1595513998-fill-range-of-cell-rows-based-on-search-criteria-job-search-and-return
Sheet: Tracking

 | Project ID | TUFF
Time In Date and Time | Time Out Date and Time | Job ID | Group | Processed By | Created By | Tool | Working By | Department | Created | Priority
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: Summary YTD-Qtr

PRETAX_INCOME |  |  |  | ACTUAL | PLAN2000 | 2000-03-01 00:00:00 |  | ACTUAL | PLAN2000 | 2000-06-01 00:00:00 |  | ACTUAL | PLAN2000 | 2000-09-01 00:00:00 |  | ACTUAL | PLAN2000 | 2000-12-01 00:00:00
Q.QTD
ECT |  | ENRON NORTH AMERICA
 |  | 2000 EARNINGS ESTIMATE
 |  |  |  | 1Q |  |  |  | 2Q |  |  |  | 3Q |  |  |  | 4Q |  |  |  | Total
 |  | Business Team |  | Actual | Plan | [NAME] |  | Actual | Plan | [NAME] |  | Actual | Plan | [NAME] |  | Estimate | Plan | [NAME] |  | Estimate | Plan | [NAME]
[NAME] |  | Gas Trading
PWR_TRd |  | Power Trading
IR_FX |  | Interest Rate & Currency Trading
TRD_MKT |  | Canada - Trading & Marketing
COAL |  | Coal
[NAME] |  | Equity Trading
WEATHER |  | Weather
SO2 |  | Emissions
INSURANCE |  | Insurance Group
EXEC_TRD |  | Executive Trading
 |  | Total Trading & Risk Management
E_ORG |  | East Midstream
W_ORIG |  | West Midstream
PAPER |  | Industrial Downstream - Paper
DWNSTRM_IND_ORIG |  | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG |  | Midstream IPP |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
PROD_FIN |  | Upstream E&P
ENVR_ENGY |  | Environmental Energy
MEXICO |  | Mexico
EXEC_ORIG |  | Executive Origination |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  | Total Origination
GENCOS |  | Genco
N_BS_DEV |  | Generation Investments
ASST_ORIG |  | Gas Assets
ASST_TRD |  | Gas Assets - Trading
 |  | Total Assets
EQUITY |  | Principal Investing
RESTRUCTURING |  | Restructuring
FIN |  | Canada - Investing
 |  | Total Investing
CTG |  | Commercial Transactions Group
OF_CHAIR |  | Office of the Chairman
INT_SERV |  | Total Commercial
GROUP |  | Group
TREASURY_INT |  | Other Interest Related Charges
TREASURY_INT |  | Capital Charge Offset
OF_CHAIR |  | Overview
 |  | ENA EBIT
 |  | Interest Income/(Expense) |  | 0 | -12000 |  |  | 0 | -8600 |  |  | 0 | -18900 |  |  | 0 | -17500
 |  | [NAME]
Spreadsheet: 844519d1696301825-need-a-simplified-formula-to-compute-amount-formula-question
Sheet: Sheet1

Qty | Comm Amt |  | Qty | 1 to 30 | 31-50 | 51-80 | Above 80 | Total
1 to 30 | 23 |  | 20
31-50 | 25 |  | 33
51-80 | 30 |  | 75
Above 80 | 44 |  | 88
Spreadsheet: 04da9706-f116-4859-ad04-b7a858981e52
Sheet: State FT+PT

Public Report Summary
State Level
School Year: 2011 - 2012
Snapshot Date: Oct 24, 2011
Totals are provided for each category. The first column contains the category total, the second is the [NAME] (F) subtotal; the third is the Male (M) subtotal. | All Professional  Personnel |  |  | Administrators |  |  | Classroom  Teachers |  |  | Coordinators |  |  | Other
 | PP | PP-F | PP-M | Ad | Ad-F | Ad-M | CT | CT-F | CT-M | Co | Co-F | Co-M | Ot | Ot-F | Ot-M
 | 150981 | 109477 | 41510 | 7437 | 3572 | 3865 | 123668 | 90126 | 33547 | 16064 | 13457 | 2607 | 8495 | 5556 | 2939
Jul 17, 20121:27:32 PM |  |  |  |  |  |  | - 3 - |  |  |  |  | www.pimsreports.state.pa.us
Spreadsheet: robin_rodrigue__33258__HS_STORAGE
Sheet: Financial Book Position

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  | 2000-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  |  |  | Index
STORAGE
Gas Daily | 1 |  | NGPRICE | P
Exotic Options
Basis - Notional | 3 |  | NGLTX | P
Basis - Equivalent | 4 |  | NGFPL | P
Price | 5 |  | NGFPL | D
TOTAL:
Basis Roll-off
Gas Daily | 1 |  | NGPRICE | M
Exotic Options | 1 |  | NGPRICE
Basis - Notional | 3 |  | NGLTX | D
Basis - Equivalent | 4 |  | NGFPL | D
Price | 5 |  | NGFPL | P
TOTAL:
Basis Roll-off
Spreadsheet: 748575d1632222484-check-if-teams-pick-a-name-as-representative-and-agree-on-a-name-pick-teams-reps-art-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | Choose name
 |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  | Groupe 1 | Groupe 2 | Groupe 3 | Groupe 4 |  | [NAME]
 |  |  |  | Names choices | A | A | A | A |  |  |  | A
 |  |  |  |  | A | A | A | C |  |  |  | B
 |  |  |  |  | A | A | D | B |  |  |  | C
 |  |  |  |  | A | D | B | C |  |  |  | D
 |  |  |  |  | OR
 |  |  |  |  | Groupe 1 | Groupe 2 | Groupe 3 | Groupe 4 |  | A | B | C | D
 |  |  |  | Names choices | A | A | A | A
 |  |  |  |  | A | A | A | C
 |  |  |  |  | A | A | D | B
 |  |  |  |  | A | D | B | C
Spreadsheet: 156520d1337332439-excel-2007-removing-duplications-and-listing-cells-excel-example-for-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  | For example, want it to be: |  |  |  | Yes
 | 1 | WC |  |  |  |  |  | Urinals |  |  |  | No
 | 2 | Urinals |  | Yes |  |  |  | Basin Taps
 | 3 | Basin Taps |  | Yes |  |  |  | Shower
 | 4 | Kitchen / Utility Taps |  |  |  |  |  | Bath
 | 5 | Shower |  | Yes |  |  |  | External Water
 | 6 | Bath |  | Yes
 | 7 | Washing Machine
 | 8 | Dishwasher
 | 9 | [NAME]
 | 10 | External Water |  | Yes
 | 11 | Landscaping
Spreadsheet: 1509cef3-e287-4456-8321-bec315129e67
Sheet: Graduate Data

[NAME]
 |  | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
bac+2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6205 | 8449 | 8645 | 8094 | 7595 |  |  |  | 7047 | 2446 | 134
bac+3 | (Licence) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5701 | 5607 | 5281 | 5489 | 4968 |  |  |  | 5921 | 6262 | 7142 | 6418
bac+4 | (Master 1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2783 | 2948 | 3172 | 3309 | 3522 |  |  |  | 2798 | 877 | 319 | 182
bac+5 | (Master 2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1142 | 1188 | 1232 | 1278 | 1454 |  |  |  | 1844 | 1854 | 2163 | 2174
bac+8 | (PhD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 327 | 392 | 339 | 246 | 258 |  |  |  | 308 | 334 | 341 | 360
HDR | Professor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 74 | 56 | 44 |  |  |  | 106 | 130 | 149 | 108
Spreadsheet: 117467d1312817288-sumproduct-with-multiple-criteria-test-goods-out-sheet
Sheet: Data & Stock Check

Date |  | 2011-08-08 00:00:00 | Period / Week |  | #N/A
STOCK DESCRIPTION, SUPPLIER, ID AND LOCATION |  |  |  |  |  | STOCK LEVELS FOR ALL SECTIONS |  |  |  | PERIOD 1 STOCK STATUS |  |  |  |  |  | PERIOD 1 CAPEX STOCK STATUS |  |  |  |  |  | Max / Min STOCK LEVELS |  |  |  | STOCK TO ORDER |  |  | Stock Des. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stock order Sheet Indicators and [NAME]
ID No. | Supplier | Item Description | UOM | Price (Indv) | Date of Price Update | Complete Running Stock (Including Capex and Con Stock) | Bought Running Stock | Consignment Running Stock | Capex Running Stock | Bought / Con Opening Stock Check | Opex Stock In | Opex Stock Out | Opex Closing Stock Check | Bought / Con Disc. | [NAME]. | Opening Capex Stock | Incoming Capex Stock | Issued Capex Stock | Closing Capex Stock Check | [NAME]. | Opex / Capex Categ. | Max Stock Level | Re-Order Stock level | Qty To Reach Max Stock | Qty To Reach Par Level | Bought Stock to Order | Con Stock to Order | Total Stock To Order | Con / Bought Stock |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indicator 1 - Stock Order Sheet - Supplier | Key 1 - Stock Order Sheet - Supplier | Indicator 2 - Stock Order Sheet - Area | Key 2 - Stock Order Sheet -Area | Indicator 3 - Stock Order Sheet - Purchase Type | Key 3 - Stock Order Sheet - Purchase Type | Indicator 2 - Stock Order Sheet - Area | Key 2 - Stock Order Sheet -Area | Indicator 3 - Stock Order Sheet - Purchase Type | Key 3 - Stock Order Sheet - Purchase Type
001 | [NAME] | 16 watt GLS ES Energy Saver Softone | 1 | 2.83 | No Date Specified | 0 | 0 | 0 | -50 | 10 | 0 | 55 |  | 0 | Opex |  | 5 | 55 |  | 0 | Opex | 2 | 1 | 2 | 1 | 2 | 0 | 2 | Bought |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
002 | Parts Center - HRPC | PRV (35,37,40,42 CDI) | 1 | 11.73 | No Date Specified | 5 | 0 | 0 | 5 |  | 0 | 0 |  | 0 | Opex |  | 5 | 0 |  | 0 | Capex | 2 | 1 | 0 | 0 | 0 | 0 | 0 | Consignment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
003 | Parts Center - HRPC | Ducting | 1 | 12.5 | No Date Specified | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | Opex |  | 0 | 0 |  | 0 | Capex | 2 | 1 | 2 | 1 | 2 | 0 | 2 | Bought |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 228814d1366218312-which-group-of-students-performed-better-sample
Sheet: Group3

students | scores |  | Column1
1 | 15
2 | 15 |  | Mean | 9.65
3 | 15 |  | Standard Error | 1.159117177674003
4 | 10 |  | Median | 10.5
5 | 6 |  | Mode | 15
6 | 12 |  | Standard Deviation | 5.183729606333547
7 | -4 |  | Sample Variance | 26.87105263157894
8 | 8 |  | Kurtosis | 1.525348716974714
9 | 9 |  | Skewness | -1.349371476873724
10 | 11 |  | Range | 19
11 | 10 |  | Minimum | -4
12 | 12 |  | Maximum | 15
13 | 13 |  | Sum | 193
14 | 15 |  | Count | 20
15 | 0
16 | 9
17 | 10
18 | 13
19 | 2
20 | 12
Spreadsheet: jim_schwieger__14493__EnronFinalWorkingCapitalStmt
Sheet: Sched I Lyondell

SCHEDULE I
Lyondell / Citgo
As of 9/27/01
 |  | Volume | Fixed Price | Index | NYMEX | HSC Basis | Value
 | 2001-06-01 00:00:00 |  | 4.72 |  | 3.738 | 0.042
 | 2001-07-01 00:00:00 |  | 4.72 |  | 3.182 | 0.078
 | 2001-08-01 00:00:00 |  | 4.72 |  | 3.167 | 0.073
 | 2001-09-01 00:00:00 |  | 4.72 |  | 2.295 | 0.095
 | 2001-10-01 00:00:00 |  | 4.72 |  | 1.83 | 0.03
 | 2001-11-01 00:00:00 |  | 4.72 |  | 2.253 | -0.0225
 | Total Lyondell / Citgo due [NAME]
Spreadsheet: 206901d1358305500-help-with-retrieving-data-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | RESULTS
2012-07-31 00:00:00 |  |  | 2012-08-31 00:00:00 |  |  | 2012-09-30 00:00:00 |  |  |  |  | Type | Bought
Z0010752 | Bought |  | T0187593 |  |  | W7852755 |  |  |  |  | Z0010752 | 2012-07-31 00:00:00
Z0010753 |  |  | T0187594 | Bought |  | W7852756 |  |  |  |  | T0187597 | 2012-08-31 00:00:00
Z0010754 | Bought |  | T0187595 |  |  | W7852757
[NAME] |  |  | T0187596 |  |  | W7852758 | Bought
Z0010756 |  |  | T0187597 | Bought |  | W7852759
Z0010757 |  |  | T0187598 |  |  | W7852760 | Bought
Z0010758 | Bought |  | T0187599 |  |  | W7852761
Z0010759 |  |  | T0187600 | Bought |  | W7852762
Spreadsheet: 723035d1615484988-how-to-indicate-a-40-success-rate-in-a-row-of-events-book1
Sheet: Sheet1

 |  | Yes
 |  | No
Spreadsheet: 763536d1642229443-true-false-if-duplicate-texts-are-present-in-a-string-shiva_duplicate-text
Sheet: Sheet1

Name1 | value1 | [NAME] | value2 | Name3 | value3
A | 2 | A | 5 | Z | 57 |  | =A2:F3, TRUE/FALSE for duplicate texts, ignoring the numbers
B | 1 | S | 42 | B | 1
C | 4 | F | 2 | C | 2 |  | =A4:F5, TRUE/FALSE for duplicate texts, ignoring the numbers
D | 3 | R | 5 | D | 5
Spreadsheet: 845158d1696679798-tracking-between-multiple-dates-sample-schedule
Sheet: Sheet1

Date Requested | Date | Qty | Date | Qty | Date | Qty | Date | Qty | Tracking days
2023-06-15 00:00:00 | 2023-12-13 00:00:00 | 1 | 2023-12-10 00:00:00 | 2 | 2023-12-14 00:00:00 | 1 | NA | 0
2023-06-16 00:00:00 | 2023-10-04 00:00:00 | 1 | 2023-10-20 00:00:00 | 1 | NA | 0 | NA | 0
2023-06-17 00:00:00
2023-06-18 00:00:00 |  |  | NA | 0
2023-06-19 00:00:00 |  |  |  |  |  |  |  | 1234567890
2023-06-20 00:00:00
2023-06-21 00:00:00 |  |  |  |  |  |  |  | 2
2023-06-22 00:00:00
2023-06-23 00:00:00 |  |  |  |  | NA |  | 2023-10-09 00:00:00
2023-06-24 00:00:00
Spreadsheet: 869056d1715718947-i-need-index-match-or-another-formula-to-return-all-instanses-of-matches-index-match-with-multiple-criteria-in-column
Sheet: Sheet1

THIS IS WHAT I NEED THE TABLE TO LOOK LIKE WHEN IT IS COMPLETED.  THIS TABLE CONTAINS NO FORMULAS AND IS JUST AN EXAMPLE OF WHAT I NEED.
PART | QTY | [NAME] | WAREHOUSE
abc | 21, 22, 32 | IBP0M0, IBP0MA, I0159MA | SO1C-1, SO1C-2
def
ghi
jkl | 54 | IBP0M0 | [NAME]
mno | 34 | IBP0M0 | SOIC-6
pqr | 76, 11 | I01S9MA, IBP0M0 | SOIC-9
[NAME]
vwx | 98 | I0159MA | SOIC-23
yz | 67 | IBP0M0 | SOIC-14
If I use an INDEX / MATCH formula I will only get the first instance.
So for example, below is what I get now from the data in H19:K27.  [NAME] in B19, C19, [NAME] |  |  |  |  |  |  | TABLE BELOW IS RETURNED AFTER A SEARCH FOR THE AVAIL MATERIALS AND WHERE I RETRIEVE DATA FROM
PART | QTY | [NAME] | WAREHOUSE |  |  |  | PART | QTY | [NAME] | WAREHOUSE
abc |  |  |  |  |  |  | abc | 21 | IBP0M0 | SO1C-1
def |  |  |  |  |  |  | abc | 22 | IBP0MA | SO1C-1
ghi |  |  |  |  |  |  | abc | 32 | I0159MA | SO1C-2
jkl |  |  |  |  |  |  | jkl | 54 | IBP0M0 | [NAME]
mno |  |  |  |  |  |  | mno | 34 | IBP0M0 | SO1C-6
pqr |  |  |  |  |  |  | pqr | 76 | I0159MA | SO1C-9
[NAME] |  |  |  |  |  |  | pqr | 11 | IBP0M0 | SO1C-9
vwx |  |  |  |  |  |  | vwx | 98 | I0159MA | SO1C-23
yz |  |  |  |  |  |  | yz | 67 | IBP0MA | SO1C-14
Spreadsheet: 166229d1341503669-excel-counting-with-multiple-criteria-counting
Sheet: Sheet1

Item Number | Column A | Column B |  |  |  |  | Both columns have 0
1 | 0 | 0
1 | 0 |  |  |  |  | Iteam | 2 | has 0 | in column A
1
2 |  |  |  |  |  | Iteam | 2 | has 0 | in column B
2 | 0 | 0
2
Spreadsheet: 171981d1343936311-mark-date-with-x-when-name-entered-workroster
Sheet: worker

list of all the names e.g
 |  | and the dates
 | 2012-08-02 00:00:00 | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 2012-08-07 00:00:00 | 2012-08-08 00:00:00 | 2012-08-09 00:00:00 | 2012-08-10 00:00:00 | 2012-08-13 00:00:00
piet | x | x
koos | x
jan |  | x
[NAME] | x
george |  | x
Spreadsheet: larry_campbell__21093__Bob Kraft
Sheet: B. Kraft

# | Category | Finding | Action Item | Responsible Person | Target Date | [NAME] | Completion Date | Comments
 | PSM
135 | ESMS | #341 Is every floor hole into which a person can accidently walk guarded by a standard toe board and railing or floor hole cover that is held securely in place? | Ensure all floor openings and pits are covered to prevent anyone from accidently stepping into them as required per ETS Safety Procedure guidelines. | [NAME] | 2001-08-30 00:00:00 | [NAME]
147 | ESMS | #320 Do all electrical outlets, switch and junction boxes have cover plates? | Ensure all electrical conduits are sealed and no wiring is exposed. | [NAME] | 2001-08-30 00:00:00 | [NAME]
148 | ESMS | #384 Are all outside electrical outlets for hand tools and outlets in wet areas equipped with ground fault protection or is personal GFI available? | Ensure all electrical outlets in wet areas and within 6 feet of a water source are equipped with ground fault protection or a personal GFCI is used as required per ETS Safety Procedure guidelines. | [NAME] | 2001-08-30 00:00:00 | [NAME]
94 | Operating Procedures | Security fence missing at some locations. | Develop a plan for providing a security fence between owners at this location. | [NAME] | 2001-09-30 00:00:00 | [NAME]
98 | GMP | 2"-fire water riser valve leaking water on the ground. | Assure that leaking valve on the fire water system south of the maintenance shop is corrected from discharging to the ground. | [NAME] | 2001-12-31 00:00:00 | [NAME]
Spreadsheet: 36644d1234518733-list-matching-with-dates-using-dates-as-filters-list-matching-with-dates-modified-question-in-additional-post
Sheet: Sheet1

RED ROSE RESTAURANT LIST 1
Last Name | First Name | Job | Birth Month | Start Employment Contract | End Employment Contract |  |  | 3/5/1996
Smith | [NAME] | Waiter | March | 1995-01-31 00:00:00 | 1998-06-15 00:00:00 | 1
Smith | [NAME] | [NAME] | February | 1996-03-05 00:00:00 | 1999-08-16 00:00:00 | 1 |  |  | 1996-03-05 00:00:00
Smith | [NAME] | Janitor | January | 1996-06-05 00:00:00 | 1999-03-04 00:00:00 | 0
Smith | [NAME] | Waiter | March | 1998-09-19 00:00:00 | 2001-02-01 00:00:00 | 0
Smith | [NAME] | [NAME] | February | 2000-12-01 00:00:00 | 2003-04-03 00:00:00 | 0
Smith | [NAME] | Janitor | January | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
Smith | [NAME] | Waitress | September | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
Smith | [NAME] | [NAME] | October | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
[NAME] | [NAME] | [NAME] | November | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
Phillips | Todd | Janitor | April | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
[NAME] | [NAME] | Waiter | May | 1999-03-05 00:00:00 | 2002-07-08 00:00:00 | 0
RED ROSE RESTAURANT LIST 2
Last Name | First Name | Job | Birth Month | Start Employment Contract | End Employment Contract
Smith | [NAME] | Waiter | March | 1995-01-31 00:00:00 | 1998-06-15 00:00:00
Smith | [NAME] | [NAME] | February | 1996-03-05 00:00:00 | 1999-08-16 00:00:00
Smith | [NAME] | Janitor | January | 1996-06-05 00:00:00 | 1999-03-04 00:00:00
Smith | [NAME] | Waiter | March | 1998-09-19 00:00:00 | 2001-02-01 00:00:00
Smith | [NAME] | [NAME] | February | 2000-12-01 00:00:00 | 2003-04-03 00:00:00
Black | [NAME] | Janitor | January | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
White | [NAME] | Waitress | September | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Smith | [NAME] | [NAME] | October | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | [NAME] | November | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Phillips | Todd | Janitor | April | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | Waiter | May | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Spreadsheet: 468669d1467442146-extract-unique-list-then-list-the-sequential-numbers-as-ranges-book1
Sheet: Sheet1

 |  |  | Output:
Main | Subs |  | Unique list | Subs
99006571 | 99221240 |  | 99006571 | 99221240 | 99221243-99221246 | 99221250
99006571 | 99221243 |  | 99007404 | 99007411-99007415 | 99007499
99006571 | 99221244
99006571 | 99221245
99006571 | 99221246
99006571 | 99221250
99007404 | 99007411
99007404 | 99007412
99007404 | 99007413
99007404 | 99007414
99007404 | 99007415
99007404 | 99007499