tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98256d1297247819-pivot-table-count-data-from-multiple-columns-change-table-draft-2
Sheet:  01 March

 |  |  |  |  |  |  |  |  |  |  |  |  | CLOCK
CHANGE 1 |  |  |  |  |  |  |  |  | CHANGE 2 |  |  |  |  |  |  |  | CHANGE 3
Mach No | Time In | Batt Out | Batt In | Time Out | TIME ELAPSED SINCE LAST CHANGE | Charger No | Attendant | Comment | Time In | Batt Out | Batt In | Time Out | TIME ELAPSED SINCE LAST CHANGE | Charger No | Attendant | Comment | Time In | Batt Out | Batt In | Time Out | TIME ELAPSED SINCE LAST CHANGE | Charger No | Attendant | Comment
L45 | 17:05:00 | 10 | 12 | 12:00:00 |  | 22 | 5 |  | 15:30:00 | 12 | 7 | 15:40:00 |  | 22 | 3 |  | 23:00:00 | 7 | 15 | 23:15:00 |  | 24 | 5
L67 | 15:00:00 | 250 | 212 | 14:00:00 |  |  | 6 |  | 18:30:00 | 212 | 104
L24 | 11:00:00 | 45 | 50 | 13:05:00 |  | 25 | 5 |  | 22:10:00 | 50 | 96 |  |  | 26 | 7
Spreadsheet: chris_stokley__3979__Enron True-Upcorrect
Sheet: Sheet1

Harbor True-Up Action Itens
 |  |  |  |  |  | Day Ahead less Gas | ISO | Services Desk Profit | Total | Payments | Net
July '00
 |  |  |  |  |  |  | 1683012.18 |  |  | 3179331.16
 |  |  |  | Gas Annuity = |  | 1336995.67
 |  |  |  | Services Desk Annuity = |  | 12843.83
Aug
1.  Enter annuity deal for Services Desk Profit |  |  |  |  |  |  | 2033138.06 | 218934.91 |  | 3412253.44
 |  |  |  | Gas Annuity = |  | 2211292.1
 |  |  |  | Services Desk Annuity = |  | 218934.91
Sep
1  Wait on ISO completion later this week and enter in |  |  |  |  |  |  | 760530.99 | 73284.24 |  | 1032095.36
ISO deal |  |  |  | Gas Annuity = |  | 1696221.18
2.  Recalc Services Profit |  |  |  | Services Desk Annuity =
2.  Reverse annuity in system (#442268)
3.  Enter annuity deal for Services Desk Profit
Oct |  |  |  |  |  |  | 163320.38 | 4554.8 |  | 371091.21
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Nov |  |  |  |  |  |  | -364123 | 14135.28 |  | 410000
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
5.  Reverse Annuity Deals(# 460487, 460482, 482864, 461206, 462174)
Dec
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  |  | 0 |  | 0
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Jan
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 16401.56 | 20495.69 |  | 669376.7
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Feb
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 11787 | 0 |  | 27298.16
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Spreadsheet: 762119d1641401301-uniquely-ranking-column-based-on-another-column-ranking-category
Sheet: Sheet1

Database |  | 6
Doc Review |  | 13
Graphic |  | 48
Meeting |  | 7.5
Messages |  | 4.5
Program |  | 37.5
Overhead |  | 0
Training |  | 0
 |  |  |  |  | 48
 |  |  |  | Program | 37.5
 |  |  |  | Doc Review | 13
 |  |  |  | Meeting | 7.5
 |  |  |  | Database | 6
 |  |  |  | Messages | 4.5
 |  |  |  | Overhead | 0
 |  |  |  | Training | 0
Spreadsheet: 129225d1321503279-excel-2007-date-as-a-condition-example
Sheet: Sheet1

Apple | 2011-11-17 00:00:00 | 3
Mango | 2011-11-19 00:00:00 | 4
Apple | 2011-11-21 00:00:00 | 5
Mango | 2011-11-23 00:00:00 | 6
Apple | 2011-11-25 00:00:00 | 7
Mango | 2011-11-17 00:00:00 | 2
Apple | 2011-11-17 00:00:00 | 4
Mango | 2011-11-21 00:00:00 | 5
Apple | 2011-11-23 00:00:00 | 6 |  | Count | Sum
Apple | 2011-11-25 00:00:00 | 7 |  | 2011-11-17 00:00:00 | 2011-11-17 00:00:00
 |  |  | Apple | 2 | 7
 |  |  | Mango | 1 | 2
 |  |  | Apple | 2 | 7
 |  |  | Mango | 1 | 2
Spreadsheet: d84a613c-9a0c-45da-8868-0e64a6e0f3af
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
FFRBC | Test | FFRBC | Folate, RBC | Folate, RBC | Quantitative Chemiluminescent Immunoassay | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Draw 5 mL lavender-top (EDTA) or pink-top ([NAME]) tube(s), mix well and transfer 1 mL EDTA blood to an amber vial (Supply T192) to protect from light.  Ship frozen.   Note:  1. [NAME] (HCT) report value drawn within 24 hours of               Folate, RBC is required.           2. Protect from light during collection, storage and shipment.           3. Separate samples must be submitted when multiple tests               are ordered. | 1 mL | Hemolysis	NA Thawing	Warm reject: Cold reject Lipemia	NA Icterus	NA Other	NA | Hematocrit        % Folate, RBC     280-903 ng/mL   Test Performed By:  ARUP Laboratories                               500 [NAME]                               Salt Lake City, UT  84108 | Sunday through Saturday | 1 day | 3-5 days | 1 | 82747 |  |  |  |  | ARUP Laboratories
FFRBC | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Frozen | 60 days
FFRBC | Order Question | Z2669 | Hematocrit |  | Plain Text
FFRBC | Result | Z2669 | Hematocrit | Hematocrit | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFRBC | Result | Z2670 | Folate, RBC | Folate, RBC | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: IN State Taxes

Indiana Deduction Constant Tables
Exemptions | Bi-Weekly Amount
1 | 38.46
2 | 76.92
3 | 115.38
4 | 153.85
5 | 192.31
6 | 230.77
Taxable Amount    - | Exemption Amount = | Taxable Income | State Tax | Addn'l Amount withheld | Total State Tax Withheld
2152.7625 | 115.38 | 2037.3825 | 69.27100500000002 | 25 | 94.27100500000002
The Indiana Withholding Amount can be found at |  | http://www.in.gov/dor/reference/files/dn01.pdf
Spreadsheet: 790051d1659523563-extract-verified-cost-from-string-previous-to-simbol-example-text
Sheet: Hoja1

Text | Cost | Need
Cargo por chatarreo 105.93€ |  |  |  | Extract a number previous to first "€" simbol
Cargo pendiente de valorar
Cargo por chatarreo 500€
Chatarreo pzs NOK en DNN (680.22€)
[NAME] piezas en 8 Horas (8x22=176€) |  | 176
39,54€ - Cargo por pieza NOK
177,08€ (88,54€/unid)
Importe chatarra 4 piezas a 36.12€ |  | 36.12
Coste retrabajo en DNN (retrabajo) 286.2€
1193,07€ (retrabajo en cliente)
Cargo no aceptado
Spreadsheet: 0d78d623-b4a8-4e51-a6c9-1a6df8aaf04a
Sheet: Open

Open School Numbers for 2012-2013
Changes from prior report
AEA | District | District Name | School | Name | Comment
11 | 0261 | Ankeny | 0412 | Prairie Trails Elementary | Fall 2012
15 | 0657 | Eddyville-Blakesburg-Fremont | 0427 | Fremont Elementary | Fall 2012 | Eddyville-Blakesburg already had a building number 0409 (Reorganized).
13 | 0914 | CAM | 0136 | Iowa Connections Academy High School | Fall 2012 | Virtual High School
13 | 0914 | CAM | 0236 | Iowa Connections Academy Middle School | Fall 2012 | Virtual Middle School
13 | 0914 | CAM | 0436 | Iowa Connections Academy Elementary | Fall 2012 | Virtual Elementary school
10 | 1053 | Cedar Rapids | 0127 | Metro High School | Fall 2012 | Reopened
11 | 1576 | Dallas Center Grimes | 0218 | DC-G Meadows | Fall 2012
07 | 1719 | Denver | 0418 | Denver Early Elementary School | Fall 2012 | Changed grades from PK-2 to PK.
05 | 1967 | East Greene | 0218 | Greene County Intermediate | Fall 2012 | WGS with Jefferson-Scranton
05 | 2313 | Fort Dodge | 0509 | Riverside ELC | Fall 2012 | Changed grades from PK-4 to PK-K.
01 | 2763 | [NAME] | 0418 | Iowa Virtual Academy | Fall 2012 | Virtual School
10 | 3141 | Iowa City | 0432 | [NAME] | Fall 2012
15 | 3312 | Keokuk | 0427 | Torrence Elementary | Fall 2012
12 | 4033 | Maple Valley-Anthon Oto | 0409 | Anthon Elementary | Fall 2012 | Reorganized with Anthon-Oto. Old number was 0270 0418.
12 | 4033 | Maple Valley-Anthon Oto | 0218 | MVAO Middle School | Fall 2012 | Reorganized with Anthon-Oto.  Old number was 0270 0172.
05 | 4778 | North Kossuth | 0209 | North Union Middle School | Fall 2012 | WGS out 9-12 to Armstrong-Ringstead will use the old HS building for MS grades 6-8.
05 | 5283 | Pocahontas Area | 0436 | Pocahontas Area Pomeroy Elementary | Fall 2012 | Reorganized with Pomeroy-Palmer.
12 | 6039 | Sioux City | 0601 | Spalding Park Elementary | Fall 2012
05 | 6102 | [NAME] | 0407 | Fairview Park Elementary | Fall 2012 | Changed grades from PK-06 to 02-03
05 | 6102 | [NAME] | 0421 | [NAME] | Fall 2012 | Changed grades from PK-06 to PK-01
05 | 6102 | [NAME] | 0435 | Lincoln Elementary | Fall 2012 | Changed grades from PK-06 to 04-05
13 | 6453 | Treynor | 0209 | Treynor Middle School | Fall 2012
07 | 6633 | Ventura | 0218 | Ventura Middle School | Fall 2012
Non-Public Buildings
267 | 6795 | [NAME] | 8112 | Blessed [NAME] Palotta Middle School | Fall 2012 | grades 6-8 | Part of Cedar Valley Catholic School System
Off-Site PK Buildings
10 | 1053 | Cedar Rapids | 0824 | Lovely Lane Preschool | Fall 2012
07 | 4131 | Mason City | 0802 | Sugar Plum Tree Preschool | Fall 2012 | Reopened
11 | 3231 | Johnston | 0807 | Westside Early Education | Fall 2012
10 | 4271 | Mid-Prairie | 0807 | Mid-Prairie School on B Ave. | Fall 2012
Spreadsheet: 739268d1625597152-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample-1-1-
Sheet: (A) OCC-GEO

Employee Number | Xref | First Name | Last Name | Position | OCC | GEO | Employee Group Name
500079 | 500079 | ABEL | HERNANDEZ | 11002 - AK C/P Production - MP1770 - FACTORY MANAGER - CASE | 11-1021 | 73 | [NAME] Enterprise
501287 | 501287 | CONNIE | CORPUS | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 73 | [NAME] Enterprise
500000 | 500000 | Sample | Sample | Sample | Sample | Sample | Sample
503418 | 503418 | MARTIN | ESPINOZA | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 20 | Island Enterprise
503771 | 503771 | NELSON | DAPAR | 20072 - AK C/P Galley - HS0510 - GALLEY ASST - CASE | 35-2021 | 73 | [NAME] Enterprise
504001 | 504001 | OLVIN | HERNANDEZ | 11002 - AK C/P Production - MP1720 - FACTORY FOREMAN - CASE | 51-1011 | 73 | [NAME] Enterprise
504734 | 504734 | [NAME] | LEBEL | 20010 - Day Rate Labor - MA3330 - FILLET TECH - DAILY | 51-3092 | 73 | [NAME] Enterprise
501461 | 501461 | WAYNE | JONES | 30112 - AK C/P Annuals - MA3001 - MASTER LICENSED - ANNUAL | 53-5021 | 73 | [NAME] Enterprise
501532 | 501532 | TAI Y | CHO | 30000 - AK Shore Salaries - Plant - OL2810 - PLANT MANAGER - CANNERY | 11-1021 | 95 | Ketchikan Plant
501531 | 501531 | [NAME] | CHO | 30000 - AK Shore Salaries - Plant - OL2810 - PLANT MANAGER - CANNERY | 14-1021 | 82 | Ketchikan Plant
Spreadsheet: 863090d1710657343-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-extracting-unique-data-ans-1-
Sheet: Sheet1

a1 | b1 | c1
a1 | b1 | c2
a1 | b2 | c3 |  |  | b1 | c1 | c2
a2 | b1 | c4 |  | a1 | b2 | c3
a2 | b1 | c5 |  | a2 | b1 | c4 | c5 | c6
a2 | b1 | c6 |  | a2 | b2 | c7 | c8
a2 | b2 | c7 |  | a2 | b3 | c9 | c10 | c11
a2 | b2 | c8
a2 | b3 | c9
a2 | b3 | c10
a2 | b3 | c11
Spreadsheet: 77366d1277846944-populate-cells-sign-off-test
Sheet: EmployeeList

Last Name | First Name | Department | First Name Last Name
Belm | Aafke | Administration | [NAME]
Goldfiss | Aley | Administration | [NAME]
Hover | Stephen | Administration | [NAME]
[NAME] | [NAME] | Administration | [NAME]
Law | [NAME] | Administration | [NAME]
Lind | [NAME] | Administration | [NAME]
Rainey | Angie | Administration | [NAME]
Reil | [NAME] | Administration | [NAME]
Blaik | [NAME] | Admitting | [NAME]
Brownerd | Loretta | Admitting | [NAME]
Cart | Brittany | Admitting | Brittany Cart
Gall | Emma | Admitting | [NAME]
Haran | [NAME] | Admitting | [NAME]
Hog | [NAME] | Admitting | [NAME]
[NAME] | [NAME] | Admitting | [NAME]
Kirbie | Cat | Admitting | Cat Kirbie
McCullo | Kelly | Admitting | [NAME]
[NAME] | [NAME] | Admitting | [NAME]
Rust | Carol | Admitting | [NAME]
Scal | [NAME] | Admitting | [NAME]
Tambu | [NAME] | Admitting | [NAME]
VanDunck | Deidre | Admitting | Deidre VanDunck
VanDykert | [NAME] | Admitting | [NAME]
[NAME] | Michelle | Cardiac Rehab | [NAME]
Freising | [NAME] | Cardiac Rehab | [NAME]
Hersh | Brigida | Cardiac Rehab | [NAME]
Maglia | [NAME] | Cardiac Rehab | [NAME]
[NAME] | [NAME] | Dietary SACH | [NAME]
Dail | [NAME] | Dietary SACH | [NAME]
[NAME] | [NAME] | Dietary SACH | [NAME]
Ern | [NAME] | Dietary SACH | [NAME]
[NAME] | [NAME] | Dietary SACH | [NAME]
[NAME] | Charlene | Dietary SACH | [NAME]
Kile | [NAME] | Dietary SACH | [NAME]
Mathu | [NAME] | Dietary SACH | [NAME]
Mills | [NAME] | Dietary SACH | [NAME]
O'Raom | Doreen | Dietary SACH | Doreen O'Raom
Pizzim | [NAME] | Dietary SACH | [NAME]
Salvatore | Kathy | Dietary SACH | [NAME]
Ogrodniue | Joie | Emergency Department | [NAME]
[NAME] | [NAME] | Emergency Department | [NAME]
Bulf | [NAME] | Emergency Department | [NAME]
[NAME] | C | Emergency Department | C [NAME]
Dinoster | Micheal | Emergency Department | Micheal Dinoster
Dowler | Claudia | Emergency Department | [NAME]
Duat | [NAME] | Emergency Department | [NAME]
Ewalor | Holly | Emergency Department | [NAME]
Free | [NAME] | Emergency Department | [NAME]
Hays | [NAME] | Emergency Department | [NAME]
Hugens | Roberta | Emergency Department | [NAME]
Keerns | Kathy | Emergency Department | [NAME]
King | [NAME] | Emergency Department | [NAME]
Carry | [NAME] | Emergency Department | [NAME]
Brader | Millie | Emergency Department | [NAME]
Marow | Cathy | Emergency Department | [NAME]
McDonnell | [NAME] | Emergency Department | [NAME]
McSuide | Debora | Emergency Department | [NAME]
McQume | [NAME] | Emergency Department | [NAME]
Milstein | [NAME] | Emergency Department | [NAME]
Schrog | Heike | Emergency Department | [NAME]
Shiller | Sybil | Emergency Department | [NAME]
Trento | Tiberius | Emergency Department | Tiberius Trento
Geiden | [NAME] | Nursing-Supervisors | [NAME]
Adamos | [NAME] | Speech | [NAME]
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-10-P-0018

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-10-P-0018 |  |  | 1P
W912LP-10-P-0018 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 157652d1337817839-pulling-statistics-based-on-name-role-store
Sheet: Data By Store

Store Name | Sales Team Breakdown |  | Open Opportunities | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate
Store 1
 | [NAME] | Role 5
 | LESLEY BUCKLAND | Role 3
 | LESLIE TEO | Role 3
 | [NAME] | Role 4
 | MIRANDA KWAN | Role 3
 | [NAME] | Role 1
 | EVEY PARK | Role 1
 | JUSTIN BARNES | Role 1
 | ARUNA RATNAYAKE | Role 1
 | IRIS GUO | Role 1
 | ASHA CHERIAN | Role 1
 | [NAME] | Role 1
Spreadsheet: 60249d1260823411-how-to-combine-multiple-pivot-tables-into-one-table-vlookups-pivot-help
Sheet: Step 2 Pivot

Count of Step 2 status | Column Labels
Row Labels | Approved | Cancelled | Not Approved | Not Submitted | Pending Approval | Grand Total
2009-09-18 00:00:00 | 2 | 3 |  | 3 | 1 | 9
Classification A | 1 |  |  | 1 | 1 | 3
Classification B | 1 | 1 |  |  |  | 2
Classification C |  | 1 |  | 1 |  | 2
Classification D |  | 1 |  | 1 |  | 2
2009-09-22 00:00:00 |  |  |  |  | 1 | 1
Classification D |  |  |  |  | 1 | 1
2009-09-28 00:00:00 | 21 | 8 | 6 | 16 | 27 | 78
Classification A | 5 |  | 2 | 3 | 8 | 18
Classification B | 6 |  |  | 4 | 7 | 17
Classification C | 6 | 6 | 2 | 4 | 7 | 25
Classification D | 4 | 2 | 2 | 5 | 5 | 18
2009-10-02 00:00:00 | 1 |  |  | 2 |  | 3
Classification C | 1 |  |  | 2 |  | 3
2009-10-12 00:00:00 |  |  | 1 |  |  | 1
Classification D |  |  | 1 |  |  | 1
2009-10-24 00:00:00 |  |  |  |  | 1 | 1
Classification A |  |  |  |  | 1 | 1
2009-10-30 00:00:00 |  | 1 |  |  |  | 1
Classification B |  | 1 |  |  |  | 1
2010-02-15 00:00:00 | 1 |  |  | 1 | 1 | 3
Classification A |  |  |  | 1 |  | 1
Classification C | 1 |  |  |  |  | 1
Classification D |  |  |  |  | 1 | 1
2010-12-12 00:00:00 |  |  | 1 | 1 | 1 | 3
Classification B |  |  | 1 | 1 |  | 2
Classification C |  |  |  |  | 1 | 1
Grand Total | 25 | 12 | 8 | 23 | 32 | 100
Spreadsheet: 112760d1308768793-pulling-value-from-table-based-on-two-variables-table-on-two-variables
Sheet: Sheet1

 |  |  |  |  | [NAME] |  | Subject Cell Ref
 |  |  |  |  | 1 | Pupil | 2 | Subject |  | Scores | Maths | English | Science | History
 |  |  |  |  |  | A_Smith |  | Maths |  | A_Smith | 0.66 | 0.89 | 0.56 | 0.12
 |  |  |  |  |  | B_Smith |  | English |  | B_Smith | 0.07 | 0.87 | 0.89 | 0.03
 |  |  |  |  |  | C_Smith |  | Science |  | C_Smith | 0.85 | 0.23 | 0.04 | 0.14
Score |  |  |  |  |  | D_Smith |  | History |  | D_Smith | 0.07 | 0.21 | 0 | 0
 |  |  |  |  |  | E_Smith |  |  |  | E_Smith | 0.78 | 0.47 | 0.01 | 0.31
 |  |  |  |  |  | [NAME] |  |  |  | [NAME] | 0.23 | 0.56 | 0.47 | 0.84
Spreadsheet: 85841d1285867428-just-two-places-like-an-adding-machine-point-added
Sheet: Sheet1

1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
Spreadsheet: 153792d1336056736-change-information-in-one-sheet-and-automtically-also-in-other-sheets-example-excelforum
Sheet: Sheet1

a | b | c | d | e | f | g | h
4 | 5 | 2 | 23 | 2 | 3 | 2
5 | 4 | 2 | 4 | 9 | 2 | 3
2 | 2 | 2 | 2 | 1 | 32 | 2
6 | 2 | 2 | 2 | 8 | 7 | 2
7 | 4 | 222 | 1 | 7 | 8 | 1
2 | 4 | 5 | 5 | 3 | 5 | 1
6 | 2 | 4 | 1 | 3 | 1 | 2
8 | 2 | 2 | 2 | 2 | 6 | 7
2 | 78 | 3 | 4 | 5 | 3 | 3
68 | 5 | 3 | 1 | 4 | 4 | 0
13 | 13 | 3 | 4 | 9 | 8 | 9
Spreadsheet: 271657d1382018023-help-me-please-index-search-problem-help
Sheet: MAIN

PART NUMBER | [NAME] | COST | SELL | SUPPLIER PART NUMBER | SUPPLIER
00001 | APPLE TEST 1 | 1.5 |  | APPLE TEST 1000000 | APPLE
00002 | APPLE TEST 2 | 9.5 |  | APPLE TEST 2000000 | APPLE
00003 | APPLE TEST 3 | 6.4 |  | APPLE TEST 3000000 | APPLE
00004 | GOOGLE 4 | 100 |  | GOOGLE 4000000 | GOOGLE
00005 | GOOGLE 5 | 2.7 |  | GOOGLE 5000000 | GOOGLE
00006 | GOOGLE 6 | 1 |  | GOOGLE 6000000 | GOOGLE
00007 | YAHOO 2 | 0.5 |  | YAHOO 2000000 | YAHOO
00008 | YAHOO 3 | 9.98 |  | YAHOO 3000000 | YAHOO
00009 | YAHOO 4 | 5.7 |  | YAHOO 4000000 | YAHOO
Spreadsheet: 858831d1707358638-return-value-based-on-condition-kl-book
Sheet: Sheet 1

 | 2027-12-15 00:00:00
 |  |  |  |  |  |  |  | Start | End
 |  |  | Yes |  |  |  |  | 2020-12-16 00:00:00 | 2024-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  |  |  |  |  |  | 2020-12-15 00:00:00 | 2024-12-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  |  |  |  |  |  | 2020-12-14 00:00:00 | 2024-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  |  |  |  | Period range |  | 2020-12-01 00:00:00 | 2025-02-01 00:00:00
Spreadsheet: 205686d1357863964-rota-amalgamation-rota-test
Sheet: Combined

 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
[NAME] | 200 | 300 | 100 | 100 | 100 | 100 | 100
[NAME] | 201 | 301 | 101 | 101 | 101 | 101 | 101
[NAME] | 202 | 302 | 102 | 102 | 102 | 102 | 102
[NAME] | 210 | 310 | 110 | 110 | 110 | 110 | 110
[NAME] | 211 | 311 | 111 | 111 | 111 | 111 | 111
[NAME] | 212 | 312 | 112 | 112 | 112 | 112 | 112
[NAME] | 250 | 350 | 150 | 150 | 150 | 150 | 150
George | 251 | 351 | 151 | 151 | 151 | 151 | 151
[NAME] | 252 | 352 | 152 | 152 | 152 | 152 | 152
Fred | 253 | 353 | 153 | 153 | 153 | 153 | 153
Clare | 254 | 354 | 154 | 154 | 154 | 154 | 154
[NAME] | 255 | 355 | 155 | 155 | 155 | 155 | 155
[NAME] | 256 | 356 | 156 | 156 | 156 | 156 | 156
Guy | 257 | 357 | 157 | 157 | 157 | 157 | 157
[NAME] | 280 | 380 | 180 | 180 | 180 | 180 | 180
[NAME] | 281 | 381 | 181 | 181 | 181 | 181 | 181
[NAME] | 282 | 382 | 182 | 182 | 182 | 182 | 182
[NAME] | 283 | 383 | 183 | 183 | 183 | 183 | 183
[NAME] | 284 | 384 | 184 | 184 | 184 | 184 | 184
Carol | 285 | 385 | 185 | 185 | 185 | 185 | 185
Les | 286 | 386 | 186 | 186 | 186 | 186 | 186
Adam | 287 | 387 | 187 | 187 | 187 | 187 | 187
Spreadsheet: 862104d1709872604-help-excel-formula-ideas-needed-formula-help-excel
Sheet: Sheet2

Store ID No. | Store ID Name | Other Store ID No. within 1 min. proximity of Store in Column B | Other Store ID No. within 10 min. proximity of Store in Column B | Other Store ID No. within 15 min. proximity of Store in Column B
1 | Houston | 3|6|7 | 3|6|7|10|12 | 3|6|7|10|12|15|17
2 | Los Angeles | 1|5|6 | 1|5|6|7|8 | 1|5|6|7|8|15
3 | Tampa Bay | 1|2|8 | 1|2|8|12 | 1|2|8|12|15|17
Spreadsheet: 193800d1352953859-how-can-i-copy-hyperlink-sample
Sheet: Sheet1

ABC63493
ABC63946
ABC50806
ABC68777
ABC68985
ABC65055
ABC57903
ABC72124
[NAME]
ABC57398
ABC52531
ABC57798
ABC57277
ABC69161
ABC68805
ABC60978
ABC63952
Spreadsheet: 86481d1286451119-excel-formula-for-match-2-columns-data-same_new
Sheet: Sheet1

List A | List B
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | Same
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | Same
[PHONE] | [PHONE] | Same
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | Same
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | Same
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | New
[PHONE] | [PHONE] | Same
Spreadsheet: 82705d1282737843-find-last-value-in-column-without-using-an-array-formulaeforlastrow
Sheet: Sheet2

Data | [NAME] | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  | b |  |  | 7
 |  |  |  | a | b |  |  | b
 |  |  |  |  | b | a |  | c
11 | 20 | $[NAME] |  |  | 7 | b
Last Row --> | 20 |  | a |  | b | b |  | 123
Last Value --> | 246 |  |  |  | c | b |  | aq
 |  |  |  |  |  | 7 |  | b
[NAME] is the basic formula |  |  |  |  | 123 | b |  | b
C5 is the column address as a string |  |  |  |  | aq | c |  | b
 |  |  |  |  | b |  |  | b
 |  |  | 4 |  | b | 123 | a | b
 |  |  |  |  | b | aq | b | b
 |  |  |  |  | b | b | b | b
 |  |  |  |  | b | b | b | b
 |  |  |  |  | b | b | 7 | 123
 |  |  |  |  | b | b | b
 |  |  |  |  | b | b | c |  |  | l
 |  |  |  |  | 123 | b
 |  |  |  |  | 2010-08-12 00:00:00 | b | 123 |  |  | 246
 |  |  |  |  |  | b | aq | 7
 |  |  |  |  |  | 123 | b | b
 |  |  |  |  |  |  | b | c |  | #N/A
 |  |  |  |  |  |  | b
 |  |  |  |  |  |  | b | 123
 |  |  |  |  |  |  | b | aq | 7
 |  |  |  |  |  |  | b | b | b
 |  |  |  |  |  |  | b | b | c
 |  |  |  |  |  |  | b | b
 |  |  |  |  |  |  | 123 | b | 123
 |  |  |  |  |  |  |  | b | aq
 |  |  |  |  |  |  |  | b | b
 |  |  |  |  |  |  |  | b | b
 |  |  |  |  |  |  |  | b | b
 |  |  |  |  |  |  |  | 123 | b
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  | 123
Spreadsheet: 862960d1710515246-how-to-subtotal-with-text-criteria-book3
Sheet: Sheet1

 |  |  | Rent
 |  |  | Travel
 |  |  | Entertainment
 |  |  | Total
Year | Expense | Cost
2023 | Rent | 60000
2023 | Travel | 12000
2023 | Entertainment | 20000
2024 | Rent | 72000
2024 | Travel | 15000
2024 | Entertainment | 18000