tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81944d1282052952-set-up-ongoing-copying-from-one-sheet-to-another-sheet-in-same-workbook-example-1111111111-
Sheet: Sheet2

Amount | Date
USD | 2010-08-17 00:00:00
USD | 2010-08-17 00:00:00
USD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
AUD | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
GBP | 2010-08-17 00:00:00
AUD | 2010-08-18 00:00:00
AUD | 2010-08-18 00:00:00
AUD | 2010-08-18 00:00:00
AUD | 2010-08-18 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
CAD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
USD | 2010-08-19 00:00:00
GBP | 2010-08-19 00:00:00
GBP | 2010-08-19 00:00:00
GBP | 2010-08-19 00:00:00
GBP | 2010-08-19 00:00:00
GBP | 2010-08-19 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
USD | 2010-08-23 00:00:00
GBP | 2010-08-25 00:00:00
GBP | 2010-08-25 00:00:00
AUD | 2010-08-26 00:00:00
AUD | 2010-08-26 00:00:00
GBP | 2010-08-27 00:00:00
GBP | 2010-08-27 00:00:00
USD | 2010-08-27 00:00:00
GBP | 2010-08-27 00:00:00
GBP | 2010-08-27 00:00:00
AUD | 2010-08-30 00:00:00
AUD | 2010-08-31 00:00:00
AUD | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
ZAR | 2010-08-31 00:00:00
Spreadsheet: 838701d1691262996-the-return-value-past-a-specific-should-be-zero-example-55-
Sheet: Projected Depreciation

 | Description | ID | Type | Useful Life (Months) | Useful Life (Years) | Monthly Depre. | Acquisition Date | Asset Value | 2011-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014 | 2015-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2015 | 2016-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2016 | 2017-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Book Salvage Value
 | Equipment 1 | 123456789 | Bread Machine | 120 | 10 | 114.1666666666667 | 2011-07-01 00:00:00 | 13700
Spreadsheet: 54815d1254861165-using-same-range-in-a-formula-for-two-cells-rangequestion
Sheet: Sheet1

Data | Mon
1 | A
1 | A
1 | A
1 | A
1 | A
1 | A
1 | A
0 | A
0 | A
1 | A
1 | A
0 | A
0 | A
0 | A
1 | A
1 | A |  | CountA | 16
1 | B | 1 | Count | 11
1 | B | 2
1 | B | 3
1 | B | 4
1 | B | 5
1 | B | 6
0 | B | 7 | 1
0 | B | 8 | 2
0 | B | 9 | 3
0 | B | 10 | 4
0 | B | 11 | 5
0 | B | 12 | 6
Spreadsheet: 75879d1276503335-calculating-1st-position-without-additional-cumulative-calculations-maxindex
Sheet: Sheet1

 |  |  | r1 | r2 | r3 | r4 | r5 |  | [NAME] | cum r3 | cum r4 | cum r5
 | 1 |  | 8.550579502738254 | 8.87338111352513 | 1.046343244142149 | 3.033115799948183 | 4.256758182336267 |  | 17.42396061626339 | 18.47030386040554 | 21.50341966035372 | 25.76017784268999
 | 2 |  | 5.754010862354166 | 7.54758548676898 | 4.589477534992474 | 1.565700032836657 | 2.27944227432308 |  | 13.30159634912315 | 17.89107388411562 | 19.45677391695228 | 21.73621619127536
 | 3 |  | 1.865992084162582 | 3.417373036833906 | 1.505846187766855 | 4.925120623868762 | 6.789988631758328 |  | 5.283365120996488 | 6.789211308763344 | 11.71433193263211 | 18.50432056439043
 | 4 |  | 3.821921188445865 | 4.043582953890685 | 0.06872514884309844 | 8.677340545184169 | 3.669175281154979 |  | 7.86550414233655 | 7.934229291179649 | 16.61156983636382 | 20.2807451175188
 | 5 |  | 6.320034471970786 | 5.689350029426223 | 6.827299460620173 | 8.080767916198665 | 4.463698012411708 |  | 12.00938450139701 | 18.83668396201718 | 26.91745187821585 | 31.38114989062756
 | 6 |  | 9.843066699935745 | 3.961057961652463 | 5.535464401729127 | 1.604233044543455 | 0.02612452018072364 |  | 13.80412466158821 | 19.33958906331733 | 20.94382210786079 | 20.96994662804151
 | 7 |  | 1.525468730874966 | 3.227496220460486 | 7.319397515373431 | 9.797795816921626 | 0.5791550228701525 |  | 4.752964951335452 | 12.07236246670888 | 21.87015828363051 | 22.44931330650066
 | 8 |  | 8.874639133384692 | 5.34845223029309 | 3.148449788080956 | 5.337884380909221 | 5.132243539299903 |  | 14.22309136367778 | 17.37154115175874 | 22.70942553266796 | 27.84166907196786
 | 9 |  | 9.472825621630998 | 7.538231737088728 | 9.016323165937463 | 1.156781039898509 | 8.07155708382696 |  | 17.01105735871973 | 26.02738052465719 | 27.1841615645557 | 35.25571864838265
 | 10 |  | 3.976370576401518 | 6.848210111578146 | 8.734242609659033 | 7.908317690505271 | 3.1702719561041 |  | 10.82458068797966 | 19.5588232976387 | 27.46714098814397 | 30.63741294424807
 |  |  |  |  |  |  |  |  | 17.42396061626339 | 26.02738052465719
 |  |  | r1 | 6 | 6
 |  |  | r2 | 1 | 1
 |  |  | r3 | 9 | 9
 |  |  | r4 |  | 10
 |  |  | r5 |  | 9
Spreadsheet: 727554d1617959592-dynamic-array-formula-for-nearest-non-blank-nearest-non-blank
Sheet: NearestNonblank

Data source |  | Upwards | Downwards |  | Value of nearest non-blank
Non-blank |  |  |  |  |  | Non-blank
 |  |  |  |  |  | Non-blank
Non-blank again |  |  |  |  |  | Non-blank again
 |  |  |  |  |  | Non-blank again
 |  |  |  |  |  | Non-blank again
 |  |  |  |  |  | Another one
 |  |  |  |  |  | Another one
Another one |  |  |  |  |  | Another one
Yet another |  |  |  |  |  | Yet another
 |  |  |  |  |  | Yet another
 |  |  |  |  |  | Yet another
Spreadsheet: 137943d1327438647-cells-formulas-which-are-dependent-on-more-than-1-other-cell-example2
Sheet: Sheet1

eg1
Value | 1000
No of people | 0
Total charge | 50
eg2
Value | 1000
No of people | 1
Total charge | 50 | effectively B9 could be 0 or 1 and the answer should be the same at 50
eg3
Value | 0
No of people | 1
Total charge | 0 | this should be 0 as it needs a value in B13 to give answer of 50
eg4
Value | 0
No of people | 0
Total charge | 0
eg5
Value | 0
No of people | 2
Total charge | 0 | this should be 0 as it needs a value in B13 to give answer of 100
eg6
Value | 1000
No of people | 2
Total charge | 100 | Now the answer sees a value in B28 so multiplies B28 by B29
eg6
Value | 1000
No of people | 3
Total charge | 150 | as above etc etc
Spreadsheet: 864801d1711952929-separating-data-into-different-columns-book1-5-
Sheet: Sheet1

Software Name | Software Name | Version |  | Software Name | Version
[NAME] Agent [NAME] | [NAME] Agent Windows | 5.4.0.10 |  | [NAME] Agent Windows | 5.4.0.10
Microsoft Defender for Endpoint 10.8735.26020.1014 | Microsoft Defender for Endpoint | 10.8735.26020.1014 |  | Microsoft Defender for Endpoint | 10.8735.26020.1014
chrome web store payments Chrome-Plugin 1.0.0.6 | chrome web store payments Chrome-Plugin | 1.0.0.6 |  | chrome web store payments Chrome-Plugin | 1.0.0.6
Microsoft Edge Update 1.3.185.21 | Microsoft Edge Update | 1.3.185.21 |  | Microsoft Edge Update | 1.3.185.21
Microsoft Edge 122.0.2365.92 | Microsoft Edge | 122.0.2365.92 |  | Microsoft Edge | 122.0.2365.92
Microsoft Edge WebView2 Runtime 122.0.2365.92 | Microsoft Edge WebView2 Runtime | 122.0.2365.92 |  | Microsoft Edge WebView2 Runtime | 122.0.2365.92
Cisco Systems Umbrella Roaming Client 3.0.466.0 | Cisco Systems Umbrella Roaming Client | 3.0.466.0 |  | Cisco Systems Umbrella Roaming Client | 3.0.466.0
Igor Pavlov 7-Zip 23.01 64-Bit | Igor Pavlov 7-Zip | 23.01 64-Bit |  | Igor Pavlov 7-Zip 23.01 | 64-Bit
Microsoft.People 2021.2202.33.0 | Microsoft.People | 2021.2202.33.0 |  | Microsoft.People | 2021.2202.33.0
Microsoft.WindowsCamera 2022.2312.3.0 | Microsoft.WindowsCamera | 2022.2312.3.0 |  | Microsoft.WindowsCamera | 2022.2312.3.0
Microsoft.549981C3F5F10 4.2308.1005.0 | Microsoft.549981C3F5F10 | 4.2308.1005.0 |  | Microsoft.549981C3F5F10 | 4.2308.1005.0
Spreadsheet: 179912d1347412921-vlookup-of-a-filtered-list-drystorm_859657_filtered_list_lookup_subtotal_11sep12_01
Sheet: Result

Name | Account
Spreadsheet: 752832d1635000592-combing-sumif-search-and-xlookup-excel-help-10-23-21
Sheet: Sheet1

 | Desired Outcome |  |  |  | Formulated Outcome |  | Potential formulas
Line List Only Unique | "Pipe" | "90" |  | Line List Only Unique | "Pipe" | "90" | Example IF(SEARCH("Pipe",P3),Q3,0) | Example XLOOKUP(A2,O4:O24,Q4:Q24,"",0) | Example SUMIF(O3:O23,A3,Q3:[NAME]) |  | Model Dump MTO | Desciption | Value 1
00001 | 40 | 10 |  | 00001 |  |  |  |  |  |  | 00001 | wholly molly, Pipe car car | 10
00002 | 60 | 10 |  | 00002 |  |  |  |  |  |  | 00001 | wholly molly 90, car car | 10
00003 | 50 | 20 |  | 00003 |  |  |  |  |  |  | 00001 | wholly molly Pipe, car car | 10
00004 | 20 | 0 |  | 00004 |  |  |  |  |  |  | 00001 | wholly molly pipe, car car | 10
00005 |  |  |  | 00005 |  |  |  |  |  |  | 00001 | wholly molly pipe, car car | 10
00006 |  |  |  | 00006 |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
00007 |  |  |  | 00007 |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
00008 |  |  |  | 00008 |  |  |  |  |  |  | 00002 | wholly molly, Pipe car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly 90, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly Pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
IF the word "Pipe " is present, AND the XLOOKUP says that that line is in is the line list, SUM the corresponding values |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly 90, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
IF(SEARCH("Pipe",D1),E1,0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly, Pipe car car | 10
XLOOKUP(K1,A:A,E:E,"",0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly 90, car car | 10
SUMIF(A:A,K1,E:E) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly Pipe, car car | 10
IF(SEARCH("Pipe",D1),XLOOKUP(K1,A:A,E:E,"",0),0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
SUMIF(A:A,XLOOKUP(K1,A:A,E:E,"",0),E:E) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00004 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00004 | wholly molly pipe, car car | 10
Spreadsheet: 226098d1365246018-dependant-lists-20130406-three-tier-list-rjg_universal_dd_dependent
Sheet: Lists

Regions | APAC | MEA | Europe | Americas | UK | France | Wales | England | US | Washington | Canada | Ontario
APAC | Japan | Turkey | Spain | US | England | Brittany | Cardiff | London | California | Seattle | Ontario | Toronto
MEA | China | South Africa | UK | Canada | Wales | Calvados | Swansea | Birmingham | Washington | [NAME] | Quebec | [NAME]
Europe | Korea | Jordan | Italy | Mexico | Scotland | Charente | Newport | [NAME] | Florida | Tacoma | British Columbia | [NAME]
Americas | India | Egypt | France | Brazil | Ireland | Cote-D'or | Bangor | Liverpool | Texas |  | Alberta
 |  | Israel | Germany | Argentina |  | Loire | Aberystwyth | Southampton |  |  | Manitoba
 |  |  | Belgium | Chile |  | Normandy |  | Leeds
 |  |  | Holland |  |  | Pas-de-Calais |  | Newcastle
 |  |  | Portugal |  |  | Rhone
 |  |  |  |  |  | Sarthe
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Seine-Maritime
Spreadsheet: 271113d1381829005-if-statement-timing-and-span-of-variable-spanning-of-cost_pere
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Start Date | 2013-12-01 00:00:00 |  |  | 2013-12-01 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-31 00:00:00 | 2014-09-30 00:00:00 | 2014-10-31 00:00:00 | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Item |  | Timing | Span | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | END
Acquisition & DA Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Land | 960000 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Spreadsheet: 862985d1710529922-multiple-criteria-filter-function-filterfunctiononecriteria-dj
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 1 [NAME] -Easy
 |  | City |  |  | Currency |  | Category |  |  | CAD | NZD | AUD
 |  | New York |  |  | USD |  | 1
 |  | Chicago |  |  | USD |  | 1 |  | Chicago | Vancouver
 |  | Toronto |  |  | CAD |  | 1 |  | Los Angeles
 |  | Los Angeles |  |  | USD |  | 1 |  | San Francisco
 |  | San Francisco |  |  | USD |  | 1 |  | Baltimore MD
 |  | Baltimore MD |  |  | USD |  | 1 |  | Nashville TN
 |  | Vancouver |  |  | CAD |  | 1 |  | [NAME]
 |  | Nashville TN |  |  | USD |  | 2 |  | Phoenix AZ
 |  | [NAME] |  |  | USD |  | 2 |  | Las Vegas NV
 |  | Phoenix AZ |  |  | USD |  | 2 |  | Des Moines IA
 |  | Las Vegas NV |  |  | USD |  | 2
 |  | Des Moines IA |  |  | USD |  | 2
 |  | Auckland |  |  | NZD |  | 3
 |  | Melbourne |  |  | AUD |  | 3
 |  |  |  |  |  |  |  |  | Need 2 Criteria Filter - without using titles as a "helper" range
 |  |  |  |  |  |  |  |  | USD1 | USD2 | CAD1 | NZD3 | AUD3
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | True | True | True | True
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | False | False | False | False | False
 |  |  |  |  |  |  |  |  | Above Should Be ..
 |  |  |  |  |  |  |  |  | USD1 | USD2 | CAD1 | NZD3 | AUD3
 |  |  |  |  |  |  |  |  | New York | Nashville TN | Toronto | Auckland | Melbourne
 |  |  |  |  |  |  |  |  | Chicago | [NAME] | Vancouver
 |  |  |  |  |  |  |  |  | Los Angeles | Phoenix AZ
 |  |  |  |  |  |  |  |  | San Francisco | Las Vegas NV
 |  |  |  |  |  |  |  |  | Baltimore MD | Des Moines IA
 |  |  |  |  |  |  |  |  | Chicago | [NAME] | Vancouver
 |  |  |  |  |  |  |  |  | Los Angeles | Phoenix AZ
 |  |  |  |  |  |  |  |  | San Francisco | Las Vegas NV
 |  |  |  |  |  |  |  |  | Baltimore MD | Des Moines IA
Spreadsheet: 1f6f6c9a-796b-4997-8dcd-55f8742c24a2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Please enter the odds of the outcome in the doubly exposed, singly exposed to one factor,
 | singly exposed to the other factor and doubly unexposed
 | in cells D6, D7, D8 and D9 respectively
 |  | O11= | 4
 |  | O10= | 1.5
 |  | O01= | 0.6666666666666666
 |  | O00= | 0.25
 | DO NOT ALTER THE CELLS BELOW
 |  | OR11= | 16
 |  | OR10= | 6
 |  | OR01= | 2.666666666666667
 |  | ICR= | 2.775557561562891e-16
 |  | AP= | 6.938893903907228e-17
 |  | S= | 1
Spreadsheet: 870876d1717342751-trying-to-populate-a-cell-with-value-from-a-range-based-on-criteria-in-another-range-lotto-bingo2
Sheet: Input

 | DRAW DATE | NUMBERS DRAWN |  |  |  |  |  |  | WINNER
 | 2024-05-18 00:00:00 | 9 | 13 | 22 | 45 | 46 | 48
 | 2024-05-25 00:00:00 | 6 | 28 | 30 | 40 | 53 | 58
 | 2024-06-01 00:00:00 | 6 | 11 | 16 | 21 | 43 | 50 |  | I want to display winner in cell J4 from the range List!A2:A31 matching "10" in List!L2:[NAME]
 | 2024-06-08 00:00:00 | 8 | 27 | 44 | 55 |  |  |  | So in this instance Z would be displayed
 | 2024-06-15 00:00:00
Spreadsheet: kate_symes__18160__Cob
Sheet: DJ COB 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-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 526053d1499095505-vlookup-based-on-partial-match-example-file
Sheet: Sheet1

AAABBBCCC |  |  | 1
DDDEEEFFF |  |  | 2
GGGHHHIII |  |  | 3
JJJKKKLLL |  |  | 4
MMMNNNOOO |  |  | 5
PPPBBBQQQ |  |  | 1
RRRHHHSSS |  |  | 3
TTTNNNUUU |  |  | 5
 |  |  |  |  | BBB | 1
 |  |  |  |  | EEE | 2
 |  |  |  |  | HHH | 3
 |  |  |  |  | KKK | 4
 |  |  |  |  | NNN | 5
Spreadsheet: 69992d1270652732-iferror-with-zeros-2009-8teams-
Sheet: WEEK 4A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0 | 0
WEEK 4A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 72591d1273266180-excel-round-robin-league-scheduler-teamscheduler4
Sheet: MatchUps

 | 1
 |  |  |  |  | Matchups list of each Round of the Round Robin style schedule.  Each team will be matched up with each other team once.  If there is an uneven number of teams, eachteam will get a BYE once per schedule.  To have more than one face off, repeat the complete cycle. C48 holds the number of team slots.
 | Total Teams: