tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 700284d1603114520-current-form-formula-team-charts-2020-21-sample
Sheet: Sheet1

Goals scored per game | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Current FTS | Current scored | Longest FTS | Longest scoring
Bath City | 0 | 2 | 0
Billericay Town | 0 | 0 | 1
Braintree Town | 0 | 0 | 0
Chelmsford City | 0 | 1 | 1
[NAME] | 0 | 1 | 2
Concord Rangers | 1 | 2 | 0
[NAME] | 1 | 0 | 1
Dorking Wanderers | 3 | 3 | 4
[NAME] | 1 | 0
[NAME] | 0 | 4 | 1
Ebbsfleet United | 3 | 1 | 2
Hampton & Richmond Borough | 0 | 0
Havant & Waterlooville | 2 | 2
[NAME] | 0 | 4 | 1
Hungerford Town | 3 | 2 | 1
Maidstone United | 2 | 2 | 4
Oxford City | 2 | 1 | 4
Slough Town | 1 | 1 | 4
St Albans City | 1 | 1 | 3
Tonbridge Angels | 2 | 0 | 0
Welling United | 1 | 4
Goals conceded per game | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Current CS | Current conc | Longest CS | Longest conc
Bath City | 2 | 0 | 1
Billericay Town | 2 | 2 | 2
Braintree Town | 3 | 1 | 4
Chelmsford City | 1 | 1 | 1
[NAME] | 3 | 0 | 0
Concord Rangers | 1 | 1
[NAME] | 0 | 0 | 0
Dorking Wanderers | 0 | 1 | 0
[NAME] | 1 | 2
[NAME] | 3 | 1 | 1
Ebbsfleet United | 0 | 1 | 3
Hampton & Richmond Borough | 1 | 0
Havant & Waterlooville | 2 | 1
[NAME] | 1 | 4 | 4
Hungerford Town | 0 | 0 | 0
Maidstone United | 1 | 2 | 1
Oxford City | 0 | 1 | 0
Slough Town | 0 | 3 | 4
St Albans City | 0 | 1 | 2
Tonbridge Angels | 0 | 2 | 4
Welling United | 2 | 4
Spreadsheet: 881093d1729006065-separating-fields-out-of-an-address-ex-address-suite-city-state-zip-book1
Sheet: Sheet1

Group Mailing Address | Address 1 (Main Address) | Address 2 (Suite) | City | State | ZIP
123 Lake Forest Road Suite 10 New York, NY 70258 | 123 Lake Forest Road | Suite 10 | New York | NY | 70258 | Example
PO BOX 12345 Belfast, ME 04915 | PO BOX 12345 |  | Belfast | ME | 04915 | Example
5000 KING ST STE 215 Shreveport, LA 71105 | 5000 KING ST | STE 215 | Shreveport | LA | 71105 | Example
9999 Main Avenue Suite 555 Houma, LA 70360 | 9999 Main Avenue | Suite 555 | [NAME] | LA | 70360 | Example
Spreadsheet: 54322d1254323644-search-for-text-within-a-string-lookup-and-then-return-item-701479_raoul_duke
Sheet: Sheet2

Channel | Tag | Keyword(s)
Tech | Microsoft | Windows | Vista | XP | Word | Excel
Tech | Computers | Internet | PC
Tech | MP3 Players | iPod | Zune
Wedding | ZYX | Flowers | Gowns | Rings | Vicars | Bridal
Spreadsheet: 705840d1606326767-formula-to-search-across-three-values-to-populate-a-result-test-data
Sheet: JAN-JUN

 |  | JAN-21 |  | FEB-21 |  | MAR-21 |  | APR-21 |  | MAY-21 |  | JUN-21
ACCID | AcctName | # Devices | Revenue ($) | # Devices | Revenue ($) | # Devices | Revenue ($) | # Devices | Revenue ($) | # Devices | Revenue ($) | # Devices | Revenue ($)
100000973 |  | 22676 | 52242.15
500361737
100000954
500362837
Spreadsheet: 84372d1284414628-using-multi-conditional-formats-for-a-calendar-index
Sheet: Sheet1

Date | Name | Code | Interval | Min | Comments | Column1 | Column12 | Column2 | Column3
2010-07-08 00:00:00 | [NAME] | V
2010-08-24 00:00:00 | [NAME] | V
2010-08-31 00:00:00 | [NAME] | V
2010-09-01 00:00:00 | [NAME] | V
2010-09-02 00:00:00 | [NAME] | V
2010-09-06 00:00:00 | [NAME] | V
2010-09-07 00:00:00 | [NAME] | FMLA
2010-09-07 00:00:00 | [NAME] | T | S | 1 | Late
2010-09-07 00:00:00 | [NAME] | T | B2 | 5
2010-09-08 00:00:00 | [NAME] | T | S | 3
2010-09-09 00:00:00 | [NAME] | T | B1 | 2
2010-09-09 00:00:00 | [NAME] | T | B2 | 2 | Late
2010-09-10 00:00:00 | [NAME] | T | S | 1
2010-09-13 00:00:00 | [NAME] | T | S | 1
2010-09-14 00:00:00 | [NAME] | T | S | 7 | Late
2010-09-18 00:00:00 | [NAME] | T | S | 4 | Late
2010-09-22 00:00:00 | [NAME] | T | S | 1
2010-09-22 00:00:00 | [NAME] | T | B1 | 6
2010-09-22 00:00:00 | [NAME] | T | B2 | 5 | Late
2010-09-23 00:00:00 | [NAME] | T | S | 1
2010-09-23 00:00:00 | [NAME] | T | B2 | 2
2010-09-25 00:00:00 | [NAME] | T | B2 | 3
2010-09-29 00:00:00 | [NAME] | T | B1 | 5
2012-08-08 00:00:00 | [NAME] | T | S | 5 | Late
Spreadsheet: 00c08665-1809-4df2-9706-af88e6ec61cb
Sheet: Sheet1

Article | Title | Page Number
I | [NAME] | 1
II | Recognition | 1
III | Definitions | 2
IV | Salary | 2
V | [NAME] | 3
VI | Promotion Stipend | 3
VII | Workload | 4
VIII | Merit Evaluation | 7
IX | Tenure | 11
X | Promotion | 26
XI | Reappoitnment, Merit and Promotion for Non-Tenure Track (NTT) Faculty | 39
XII | Summer Session and Virtual College | 47
XIII | Prorating of Supplemental Contracts | 51
XIV | Sabbatical Leave | 51
XV | Phased Retirement | 55
XVI | Terminal Degree Compensation | 59
XVII | Professional Travel Funds | 59
XVIII | Tuition Assistance Program | 60
XIX | Personnel Files | 66
XX | Faculty-Authored Textbooks | 68
XXI | Grievance Procedure | 69
XXII | Reduction in Force | 76
XXIII | Program Discontinuance | 77
XXIV | Chronic Low Performance | 80
XXV | [NAME] and Pay Reduction | 82
[NAME] | Non-Retaliation | 84
XXVII | Dues Deduction | 85
XXVIII | Information to be Provided | 85
[NAME] | Continuing Commitment | 86
[NAME] | FHSU-AAUP Use of Campus Facilities | 87
XXXI | Savings Clause | 87
Appendix A | Step 1 Informal Grievance Form
Appendix B | Steps 2, 3, 4 Grievance Decision Review Form
[NAME] | Academic Freedom and Responsibility
Spreadsheet: 681635d1591682517-calculate-order-values-using-records-in-multiple-tables-supplier-order-values-aligw
Sheet: ORDER SHEET

CUSTOMER | ITEM | QTY | SUPPLIER | ORDER # | COST
GEORGE | BVBB123 | 2 | COMPANY A
[NAME] | RVTR321 | 1 | COMPANY B
STEPHEN | BSBB222 | 1 | COMPANY A
[NAME] | RVTR111 | 2 | COMPANY B
Spreadsheet: 87017d1286947788-user-friendly-data-validation-from-list-in-two-steps-rjdp-query
Sheet: Data_Hidden

Company Name | Individual Name
ABC Inc | A Doe
ABC Inc | B Doe
ABC Inc | C Doe
ABC Inc | A Coe
ABC Inc | B Coe
ABC Inc | C Coe
ABC Inc | D Coe
ABC Inc | E Coe
DEF Inc | A Soe
DEF Inc | B Soe
DEF Inc | C Soe
... | ...
Note: there are about 7,500 Companies and about 30,000 Individuals (average of about 4 Individuals per Company)
Spreadsheet: 163657d1340388297-excel-2003-summing-and-then-sorting-data-by-date-then-size-excel2test
Sheet: Dan

SHEET 1
Date | Large/Small |  |  | January | February | March
2012-01-02 00:00:00 | Large
2012-01-01 00:00:00 | Large |  |  | 4
2012-01-01 00:00:00 | Large
2012-01-01 00:00:00 | Small
SHEET 2
 | Month | January | February | March
[NAME] | Large | ?
 | Small | ?
Spreadsheet: dutch_quigley__9176__Delta11-27
Sheet: Sheet2

Natural Gas
 |  | Delta
Month | Futures | Options | Combined
2001-12-01 00:00:00 | 0 | 0
2002-01-01 00:00:00 | 9703 | -890.55
2002-02-01 00:00:00 | -6281 | 522.2
2002-03-01 00:00:00 | 4884 | 159.8
2002-04-01 00:00:00 | 2783 | 103.5
2002-05-01 00:00:00 | -7607 | 9
2002-06-01 00:00:00 | -118 | 343.5
2002-07-01 00:00:00 | -829 | 0
2002-08-01 00:00:00 | -9322 | 46
2002-09-01 00:00:00 | -6613 | -818.5
2002-10-01 00:00:00 | 8962 | -38
2002-11-01 00:00:00 | -9826 | -451.75
2002-12-01 00:00:00 | 7596 | -158
2003-01-01 00:00:00 | -2273 | 0
2003-02-01 00:00:00 | 6959 | 0
2003-03-01 00:00:00 | -763 | 18
2003-04-01 00:00:00 | -1155 | 0
2003-05-01 00:00:00 | 778 | 0
2003-06-01 00:00:00 | 5115 | 22.5
2003-07-01 00:00:00 | 5115 | 0
2003-08-01 00:00:00 | 1270 | 0
2003-09-01 00:00:00 | -3 | 0
2003-10-01 00:00:00 | -212 | 0
2003-11-01 00:00:00 | -126 | 0
2003-12-01 00:00:00 | 4605 | 0
2004-01-01 00:00:00 | -3938 | 0
2004-02-01 00:00:00 | 2825 | 0
2004-03-01 00:00:00 | -295 | 0
2004-04-01 00:00:00 | 270 | 0
2004-05-01 00:00:00 | 131 | 0
2004-06-01 00:00:00 | 69 | 0
2004-07-01 00:00:00 | -50 | 0
2004-08-01 00:00:00 | 2474 | 0
2004-09-01 00:00:00 | -45 | -86
2004-10-01 00:00:00 | 805 | 0
2004-11-01 00:00:00 | 120 | 0
2006-12-01 00:00:00 | 0 | 0
2007-12-01 00:00:00 | 0 | 0
Spreadsheet: 875306d1721903273-need-sum-data-vertically-te
Sheet: Summary

Emp No | Name | V | PH | S | U | A
00001 | [NAME]
00002 | Demian
00005 | [NAME]
00015 | MOHAMMAD
00018 | MEGZARI
 |  |  |  |  |  |  |  | v | Vacation
 |  |  |  |  |  |  |  | PH | Public Holdiday
 |  |  |  |  |  |  |  | S | [NAME]
 |  |  |  |  |  |  |  | U | Unpaid
 |  |  |  |  |  |  |  | A | Absent
Spreadsheet: 122209d1316663543-a-formula-to-understand-range-and-apply-criteria-range
Sheet: Sheet1

Start | End | Result |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 321 | 1.6
348 | 355 | 14.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 322 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 323 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 324 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 325 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 326 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 327 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 328 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 329 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 330 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 331 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 332 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 333 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 334 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 335 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 336 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 337 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 338 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 339 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 340 | 1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 341 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 342 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 343 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 344 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 345 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 346 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 347 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 349 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 | 1.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 351 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 352 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 353 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 354 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 355 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 356 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 357 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 358 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 359 | 1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | 1.9
Spreadsheet: 35e8e07d-a9b6-461b-a5e6-71f1b304fd91
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Democratic | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2004-09-14 00:00:00 | Sheriff |  | Attorney |  | Treasurer |  | Reg. of Deeds
 | Collis, r | [NAME] | [NAME], r | [NAME] | Corbin, r | [NAME] | Normandin, r | [NAME]
Alton |  | 2 |  | 3 |  |  |  | 1
Barnstead |  | 5 |  | 4 |  | 2 |  | 2
Belmont | 4 |  | 1 | 3 | 1 | 2 | 1 | 2
Center Harbor | 2 | 1 |  | 1 |  | 1
Gilford | 12 | 3 | 3 | 1 |  |  | 3 | 1
Gilmanton | 3 | 8 | 3 | 5 |  | 2 | 3
[NAME] | 3 | 1 |  | 1 | 1 |  | 2
[NAME] | 4 | 2 | 3 | 2 | 2 | 1 | 5 | 1
[NAME] 3 | 3 |  | 1 | 3 | 1 |  | 1 | 1
[NAME] | 7 | 3 | 4 | 3 |  | 2 | 3 | 3
[NAME] | 7 | 1 | 3 | 1 | 1 | 1 | 4
[NAME] 6 | 6 | 1 | 3 | 3 | 1 | 1 | 5 | 1
Meredith | 8 | 3 | 1 | 4 | 1 | 2 | 2 | 3
New Hampton | 2 | 7 | 2 |  |  | 1 | 1 | 1
Sanbornton | 6 | 2 | 9 | 3 | 2 | 2 | 2 | 2
[NAME] | 4 | 2 | 6 | 1 |  | 2 | 1 | 1
TOTALS | 71 | 41 | 39 | 38 | 10 | 19 | 33 | 19
 |  |  |  | COUNTY COMMISSIONERS
 | Reg. Of Probate |  |  | Dist. 1 |  | District No. 2 |  | District No. 3
 | Brickner, r | [NAME] |  |  | [NAME], d | [NAME], r | [NAME] | Boothby, r | [NAME]
Alton |  | 2 |  | NO ELECTION |  |  |  |  | 1
Barnstead | 2 | 3 |  |  | 97
Belmont |  | 2 |  |  | 122 | 2 | 1
Center Harbor |  | 1
Gilford |  | 2 |  |  |  |  |  |  | 3
Gilmanton |  | 1 |  |  | 70 |  | 2
[NAME] |  | 1
[NAME] | 3 | 1
[NAME] 3 | 1
[NAME] | 1 | 3
[NAME] | 1 | 1
[NAME] 6 | 1 | 1
Meredith |  | 3 |  |  |  |  |  | 2 | 2
New Hampton |  |  |  |  |  |  |  | 1
Sanbornton | 1 | 2 |  |  |  |  | 1
[NAME] | 1 |  |  |  | 103
TOTALS | 11 | 23 |  |  | 392 | 2 | 4 | 3 | 6
Spreadsheet: 118465d1313702735-multiple-criteria-match-3-criteria-matching
Sheet: Sheet1

Date set |  |  |  |  |  |  | Summary:
 |  |  |  |  |  |  | choose category 1: | black
 |  |  |  |  |  |  | choose category 2: | snake
description 1 | black | yellow | black | yellow | pink |  | description 1
description 2 | frog | frog | snake | snake | snake |  | description 2
description 3 | b9 | c9 | d9 | e9 | f9 |  | description 3
description 4 | b10 | c10 | d10 | e10 | f10 |  | description 4
description 5 | b11 | c11 | d11 | e11 | f11 |  | description 5
description 6 | b12 | c12 | d12 | e12 | f12 |  | description 6 |  |  |  | result wanted
description 7 | b13 | c13 | d13 | e13 | f13 |  | description 7
description 8 | b14 | c14 | d14 | e14 | f14 |  | description 8
description 9 | b15 | c15 | d15 | e15 | f15 |  | description 9
description 10 | b16 | c16 | d16 | e16 | f16 |  | description 10
description 11 | b17 | c17 | d17 | e17 | f17 |  | description 11
Spreadsheet: 217268d1362026510-how-to-sort-based-on-mulitiple-column-reorgdata-bmiguy-ef903147-sdg15
Sheet: Instructions

Name | Skill1 | Skill2 | Skill3
[NAME] | Driving | Swimming
[NAME] | Swimming | Soccer | Driving
[NAME] | Swimming | Hiking | Cycling
Willie | Driving | Cycling | Hiking
 | ReorgData - bmiguy - EF903147 - SDG15.xls
 | Today, 09:10 PM #1
 | Join Date:02-27-2013Location:BMIMS-Off Ver:Excel 2003Posts:1
 | how to sort based on mulitiple column!!
 | http://www.excelforum.com/excel-general/903147-how-to-sort-based-on-mulitiple-column.html
 |  |  |  |  |  |  |  |  |  | Name Skill1 Skill2 Skill3 | Name | Skill1 | Skill2 | Skill3
 |  |  |  |  |  |  |  |  |  | [NAME] Swimming | [NAME] | Driving | Swimming
 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Swimming | Soccer | Driving
 |  |  |  |  |  |  |  |  |  | [NAME] Hiking Cycling | [NAME] | Swimming | Hiking | Cycling
 |  |  |  |  |  |  |  |  |  | Willie Driving Cycling Hiking | Willie | Driving | Cycling | Hiking
 |  |  |  |  |  |  |  |  | Driving Swimming Soccer Hiking Cycling |  | Driving | Swimming | Soccer | Hiking | Cycling
 |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] | [NAME] |  | Willie | Willie
 |  |  |  |  |  |  |  |  | [NAME] |  | Willie | [NAME]
Spreadsheet: 761583d1641062760-how-to-get-difference-between-two-numbers-based-on-condition-new-receipt-begin-difference
Sheet: Sheet1

SR | RECEIPT BATCH NO | RECEIPT FROM | RECEIPT TO | NEW RECEIPT BEGIN DIFFERENCE
1 | PLY 7851 | 167071 | 167119
2 | PLY 6970 | 234174 | 234275
3 | BJT 8155 | 182946 | 182999
4 | PLY 7851 | 167120 | 167155 | 1
5 | PLY 6970 | 234278 | 234361 | 3
6 | BJT 8155 | 183000 | 183062 | 1
7 | PLY 7851 | 167157 | 167193 | 2
8 | PLY 6970 | 234362 | 234456 | 1
9 | BJT 8155 | 183063 | 183144 | 1
10 | PLY 6970 | 234457 | 234504 | 1
11 | BJT 8155 | 183146 | 183244 | 2
12 | PLY 6970 | 234507 | 234603 | 3
Spreadsheet: 89237d1288981259-extracting-data-from-master-file-to-multiple-single-country-files-without-using-vba-example_master
Sheet: TabB

series_code | country | 1990 | 1991 | 1992 | 1993
512 | afghanistan | 100 | 98.7 | 102.9 | 99
631 | liberia | 100 | 107.2 | 109.1 | 101.4
679 | somalia | 100 | 97.2 | 91.1 | 90.8
Spreadsheet: 799884d1665387012-exact-match-a-specific-word-to-a-list-column-a-and-sum-consecutive-numbers-in-column-b-exact-match-a-specific-word-to-a-list-column-a-and-sum-consecutive-numbers-in-column-b-
Sheet: Sheet1

Keyword | Search Volume |  | Roots | [NAME] |  | Roots | [NAME]
gardening | 10 |  | gardening |  |  | gardening | 80
garden tools | 20 |  | garden |  |  | garden | 70
gardening tool set | 30 |  | tool |  |  | tool | 80
gardening tools | 40 |  | tools |  |  | tools | 60
garden tool | 50
 |  |  |  |  |  |  |  | What I am looking for
 |  |  |  |  |  |  |  | Exact matching each root word (D2-D5) to all in column A (A2-A6)
 |  |  |  |  |  |  |  | and adding the search volume (in column B, i.e. [NAME])
 |  |  |  |  |  |  |  | Few Notes:
 |  |  |  |  |  |  |  | I've tried to do it with =SUM(IF(ISNUMBER(SEARCH(D2,$A$2:$A$6)),$B$2:$B$6))
 |  |  |  |  |  |  |  | But it doesn't work, as it doesn't exact match word to word
 |  |  |  |  |  |  |  | I found a way around, by using spaces after every word in every cell
 |  |  |  |  |  |  |  | But that seems messing up the other stuff in my project, I am working on
 |  |  |  |  |  |  |  | Thanks for considering
 |  |  |  |  |  |  |  | Respect
Spreadsheet: 152760d1335517857-automaticaly-make-an-exact-copy-of-a-sheet-to-another-sheet-in-another-file-berekeningen
Sheet: Seizoenskorting

1 | Januari | 0.0317
2 | Februari | 0.0288
3 | Maart | 0.0278
4 | April | 0.0265
5 | [NAME] | 0.0257
6 | Juni | 0.0217
7 | [NAME] | 0.0125
8 | Augustus | 0.0088
9 | September | 0.0133
10 | Oktober | 0.0179
11 | November | 0.0243
12 | December | 0.0299
Spreadsheet: 70061d1270724409-check-2-values-in-a-row-against-2-values-on-another-worksheet-sample
Sheet: Forecast

Area | Verify | [NAME] | RPM | Ship To Name | City | State | Order # | Product | Part Number
 |  |  | PM Name |  | City |  | 5749690 | Product Name | P25NNC043
 |  |  | PM Name |  | City |  | 5754274 | Product Name | P25NNC043
 |  |  | PM Name |  | City |  | 5780437 | Product Name | P25NNC066
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 902 | 902
Index | 190989 | 100860 | 291849
Europe | 82493 | 36880 | 119373
North America/Asia | 107538 | 62841 | 170379
Other | 958 | 1139 | 2097
OTHER* | 8429 | 24240 | 32669
TOTAL | 199418 | 126002 | 325420
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 127112d1320166650-counting-unique-values-uniquecountpivot
Sheet: Sheet1

 | Table 1 |  |  | Table 2
Date | Product number |  | Date | Number of Unique Products |  | Date | Product number
2011-10-01 00:00:00 | 1 |  | 2011-10-01 00:00:00 | 4
2011-10-01 00:00:00 | 2 |  | 2011-10-02 00:00:00 | 2 |  | Date | Product number | <<Do an Advanced Filter using Unique First
2011-10-01 00:00:00 | 4 |  | 2011-10-03 00:00:00 | 3 |  | 2011-10-01 00:00:00 | 1 |  | Then make a Pivot Table with Count
2011-10-01 00:00:00 | 3 |  | 2011-10-04 00:00:00 | 1 |  | 2011-10-01 00:00:00 | 2 |  | from the Unique Advanced Filter
2011-10-01 00:00:00 | 2 |  |  |  |  | 2011-10-01 00:00:00 | 4
2011-10-01 00:00:00 | 3 |  |  |  |  | 2011-10-01 00:00:00 | 3
2011-10-02 00:00:00 | 2 |  | Row Labels | Count of Product number |  | 2011-10-02 00:00:00 | 2
2011-10-02 00:00:00 | 2 |  | 2011-10-01 00:00:00 | 4 |  | 2011-10-02 00:00:00 | 3
2011-10-02 00:00:00 | 3 |  | 2011-10-02 00:00:00 | 2 |  | 2011-10-03 00:00:00 | 2
2011-10-02 00:00:00 | 2 |  | 2011-10-03 00:00:00 | 3 |  | 2011-10-03 00:00:00 | 3
2011-10-02 00:00:00 | 3 |  | 2011-10-04 00:00:00 | 1 |  | 2011-10-03 00:00:00 | 1
2011-10-03 00:00:00 | 2 |  | Grand Total | 10 |  | 2011-10-04 00:00:00 | 2
2011-10-03 00:00:00 | 3
2011-10-03 00:00:00 | 1
2011-10-03 00:00:00 | 2
2011-10-03 00:00:00 | 3
2011-10-04 00:00:00 | 2
2011-10-04 00:00:00 | 2
2011-10-04 00:00:00 | 2
Spreadsheet: 758552d1638943770-lookup-multiple-rows-and-match-excel-forum-help-8-12-21
Sheet: Sheet4

Receipt by Items |  |  |  | Receipt Total
Receipt ID | Product | Reference |  |  | 1 only | 2 only | Mix
39091970 | [NAME] | 2 |  | 39091970 |  |  | True
39091970 | Avocado 1/4 | 1 |  | 39092481 | True
39091970 | Beetroot 35g | 2 |  | 39092506 |  | True
39092481 | [NAME] | 1 |  | 39092516 |  | True
39092481 | Chicken & Bacon | 1 |  | 39092545
39092481 | [NAME] | 1 |  | 39092550
39092506 | American Moby | 2 |  | 39092661
39092506 | Food Panda 20% (Tax: 7%) | 2 |  | 39093466
39092506 | Food Panda 20% (Tax: 0%) | 2 |  | 39093664
39092516 | Cappuccino Large | 2 |  | 39093747
39092516 | Ham & Cheese Toastie | 2 |  | 39094533
39092545 | American Breakfast Toastie | 2 |  | 39095302
39092550 | Hot Tea | 2 |  | 39095304
39092550 | REOPENING PROMO 50% (Tax: 7%) | 2 |  | 39095419
39092550 | REOPENING PROMO 50% (Tax: 0%) | 2 |  | 39095424
39092661 | Ham & Cheese Toastie | 2 |  | 39095528
39092661 | Chicken & Bacon | 2 |  | 39095555
39092661 | Falafel Salad | 2
39093466 | [NAME] | 2
39093664 | Coke Zero | 2
39093664 | [NAME] | 2
39093664 | [NAME] | 2
39093664 | [NAME] | 2
39093747 | [NAME] | 2
39094533 | [NAME] | 2
39094533 | Falafel Salad | 2
39094533 | [NAME] | 2
39094533 | [NAME] | 2
39094533 | Premium Member 13% (Tax: 7%) | 2
39094533 | Premium Member 13% (Tax: 0%) | 2
39095302 | The Black Pearl | 2
39095302 | Gloria Food 20% (Tax: 7%) | 2
39095302 | Gloria Food 20% (Tax: 0%) | 2
39095304 | Water | 2
39095304 | Water | 2
39095419 | [NAME] | 2
39095419 | Gloria Food 20% (Tax: 7%) | 2
39095419 | Gloria Food 20% (Tax: 0%) | 2
39095424 | [NAME] | 2
39095528 | Ham & Cheese Toastie | 2
39095528 | [NAME] | 2
39095528 | Passion Fruit Soda | 2
39095528 | Singha Beer | 2
39095555 | The Black Pearl | 2
39095555 | Gloria Food 20% (Tax: 7%) | 2
39095555 | Gloria Food 20% (Tax: 0%) | 2
Spreadsheet: 92311b1c-ebfe-46c4-914d-d76c652db82f
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
FCPP | Test | FCPP | Chlamydia Pneumoniae PCR | Chlamydia Pneumonia PCR | DNA amplification by polymerase chain reaction (PCR) with gel-electrophoresis of PCR products. |  |  |  | 0.5 | mL | 0.5 mL serum, plasma, blood, fluids and other sources. Tissue with no fixative is also acceptable. Ship frozen. Note: Source required. | 0.5 mL | Hemolysis:	NA Thawing:	Cold reject; Warm reject Lipemia:	NA Icterus:	NA Other:	NA | TND - Target Not Detected Positive - Virus Detected   This test employs PCR and agarose gel electrophoresis detection of a chlamydia pneumoniae-specific conserved genetic target. A positive result should be coupled with clinical indicators for diagnosis. A negative CHLPPCR result (TND) does not exclude chlamydia involvement in a disease process.   Test Performed by: University of Colorado Hospital                              Clinical Laboratory                              12401 E 17th Ave                              [NAME], CO  80045 | Tuesday, Thursday | 1 - 2 days | 3 - 5 days | 1 | 87486 |  |  |  |  | University of Colorado Hospital Clinical Laboratory
FCPP | [NAME] | VARIES | Varies |  |  |  | Frozen | 180 days
FCPP | Order Question | Z2685 | Source |  | Plain Text
FCPP | Result | Z2685 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCPP | Result | Z2686 | Chlamydia PCR | Chlamydia PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 731643d1620473844-formula-to-search-compare-data-from-multiple-sheets-mappe2_test_engl-1-ans3
Sheet: Register

All_Fem_Catalog No. | Description | Company | All_Tib_Catalog No. | Description | Company | All_Inl_Catalog No. | Description | Company
6307-00-020