tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__31208__sitara&tds
Sheet: Phillip Love

 | What [NAME] is approving: | Primary Approver | Alternate Approver
20668 | Sitara|Houston|Production|Central|Edit|Deal Compliance
20669 | Sitara|Houston|Production|Central|Edit|Logistics
20670 | Sitara|Houston|Production|Central|Edit|Risk Analytics
20671 | Sitara|Houston|Production|Central|Edit|Trader
20678 | Sitara|Houston|Production|Central|View Only|Settlements
22714 | TDS|Production|Central|Launchpad
22715 | TDS|Production|Central|Position Load
26381 | \\enehou\houston\common\Corporate\TRV - [Read]
26382 | \\enehou\houston\common\Corporate\TRV - [Read/Write]
28760 | \\enehou\houston\common\ERMS\1intra - [Read]
28761 | \\enehou\houston\common\ERMS\1intra - [Read/Write]
28762 | \\enehou\houston\common\ERMS\erms_adm\FIRMTRAD - [Read]
28763 | \\enehou\houston\common\ERMS\erms_adm\FIRMTRAD - [Read/Write]
Spreadsheet: 119251d1314285062-combination-of-offset-and-vlookup-formula-sample-xls
Sheet: Sheet1

Group. No | NAME | VISTOR | Position | From | To | Port
6 | CGY | KRK | TS | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | NAGOYA
6 | CGY | DRK | MS | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | NAGOYA
1 | REN | [NAME] | TS | 2011-01-02 00:00:00 | 2011-01-05 00:00:00 | TOROS
1 | REN | SPY | MS | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | TOROS
5 | IBL | PAP | TS | 2011-01-20 00:00:00 | 2011-01-26 00:00:00 | NANTONG
4 | BRB | BAL | TS | 2011-02-07 00:00:00 | 2011-02-12 00:00:00 | PORT OF CORPUS CRISTI
6 | SANTA | KRK | TS | 2011-02-22 00:00:00 | 2011-03-12 00:00:00 | LIANYUNGANG
6 | SANTA | DRK | MS | 2011-02-26 00:00:00 | 2011-03-10 00:00:00 | LIANYUNGANG
6 | SANTA | AND | TS | 2011-02-26 00:00:00 | 2011-03-02 00:00:00 | LIANYUNGANG
2 | IBR | PER | TS | 2011-02-27 00:00:00 | 2011-03-05 00:00:00 | WENZHOU
6 | SANTA | STR | TS | 2011-03-02 00:00:00 | 2011-03-10 00:00:00 | LIANYUNGANG
6 | SANTA | AND | TS | 2011-03-05 00:00:00 | 2011-03-10 00:00:00 | LIANYUNGANG
4 | BRB | BAL | TS | 2011-03-28 00:00:00 | 2011-04-03 00:00:00 | RIZHAO
2 | AS | TTT | MS | 2011-04-07 00:00:00 | 2011-04-15 00:00:00 | PARANAGUA
5 | IBL | ARG | TS | 2011-04-25 00:00:00 | 2011-05-13 00:00:00 | DALIAN
5 | IBL | VYK | TS | 2011-04-25 00:00:00 | 2011-05-13 00:00:00 | DALIAN
5 | IBL | STR | TS | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | DALIAN
5 | IBL | STR | TS | 2011-05-02 00:00:00 | 2011-05-10 00:00:00 | DALIAN
6 | CGY | AND | TS | 2011-05-27 00:00:00 | 2011-05-30 00:00:00 | AMSTERDAM
2 | IBR | KAL | TS | 2011-05-20 00:00:00 | 2011-05-24 00:00:00 | CARTAGENA
1 | REN | SPY | MS | 2011-05-20 00:00:00 | 2011-05-25 00:00:00 | GUANGZHOU
2 | IBR | TOL | MS | 2011-05-20 00:00:00 | 2011-05-24 00:00:00 | CARTAGENA
4 | BRB | BAL | TS | 2011-05-25 00:00:00 | 2011-06-02 00:00:00 | CIVITAVECCHIA
4 | BRB | VLS | MS | 2011-05-25 00:00:00 | 2011-06-08 00:00:00 | PORT SAID
6 | CGY | AND | TS | 2011-05-29 00:00:00 | 2011-06-05 00:00:00 | AMSTERDAM
6 | CGY | DRK | MS | 2011-05-29 00:00:00 | 2011-06-03 00:00:00 | AMSTERDAM
2 | AS | KKK | TS | 2011-06-02 00:00:00 | 2011-06-16 00:00:00 | KUNSAN
6 | SANTA | KRK | TS | 2011-06-06 00:00:00 | 2011-06-13 00:00:00 | DAMIETTA
Spreadsheet: 74853d1275404899-how-to-do-sumif-over-multiple-sheets-blank-sheet-for-june
Sheet: CE Rates

2010-06-01 00:00:00 | Days
2010-06-01 00:00:00 | 2010-06-01 00:00:00
2010-06-02 00:00:00 | 2010-06-02 00:00:00
2010-06-03 00:00:00 | 2010-06-03 00:00:00
2010-06-04 00:00:00 | 2010-06-04 00:00:00
2010-06-05 00:00:00 | 2010-06-05 00:00:00
2010-06-06 00:00:00 | 2010-06-06 00:00:00
2010-06-07 00:00:00 | 2010-06-07 00:00:00
2010-06-08 00:00:00 | 2010-06-08 00:00:00
2010-06-09 00:00:00 | 2010-06-09 00:00:00
2010-06-10 00:00:00 | 2010-06-10 00:00:00
2010-06-11 00:00:00 | 2010-06-11 00:00:00
2010-06-12 00:00:00 | 2010-06-12 00:00:00
2010-06-13 00:00:00 | 2010-06-13 00:00:00
2010-06-14 00:00:00 | 2010-06-14 00:00:00
2010-06-15 00:00:00 | 2010-06-15 00:00:00
2010-06-16 00:00:00 | 2010-06-16 00:00:00
2010-06-17 00:00:00 | 2010-06-17 00:00:00
2010-06-18 00:00:00 | 2010-06-18 00:00:00
2010-06-19 00:00:00 | 2010-06-19 00:00:00
2010-06-20 00:00:00 | 2010-06-20 00:00:00
2010-06-21 00:00:00 | 2010-06-21 00:00:00
2010-06-22 00:00:00 | 2010-06-22 00:00:00
2010-06-23 00:00:00 | 2010-06-23 00:00:00
2010-06-24 00:00:00 | 2010-06-24 00:00:00
2010-06-25 00:00:00 | 2010-06-25 00:00:00
2010-06-26 00:00:00 | 2010-06-26 00:00:00
2010-06-27 00:00:00 | 2010-06-27 00:00:00
2010-06-28 00:00:00 | 2010-06-28 00:00:00
2010-06-29 00:00:00 | 2010-06-29 00:00:00
2010-06-30 00:00:00 | 2010-06-30 00:00:00
2010-07-01 00:00:00 | 2010-07-01 00:00:00
 | Total Exposure |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B/rupts/Fraud/Deceased
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Current B/rupts/Deceased Total
Target | 1943000
0.05 | 1845850
0.1 | 1748700
 |  |  | Total $
 | Arrangement
 | Saved
 | Charged Off
 | Skip Accounts | 22 | 77234.66
Spreadsheet: 1d6e8457-f979-4fe9-b5b9-34e5e3a54c9a
Sheet: Alpha

COURSE | COURSE # | SEC | CR | PROFESSOR | EXAM DATE | EXAM TIME | EXAM ROOM
ADVANCED CRIMINAL PROCEDURE | 784 | 1 | 3 | CHARDO | 2014-05-12 00:00:00 | 9:00AM - 12:00PM | L202
BANKRUPTCY | 738 | 1 | 3 | MORINGIELLO | 2014-05-13 00:00:00 | 9:00 AM - 12:00PM | L204
BUSINESS ORGANIZATIONS | 631 | 1 | 3 | BARROS | 2014-05-03 00:00:00 | 12:00 -2:00 PM | A180
CIVIL PROCEDURE II | 504 | N | 3 | FAMILY | 2014-05-05 00:00:00 | 9:00AM - 12:00PM | L202
CIVIL PROCEDURE II | 504 | R | 3 | RAEKER-JORDAN, S. | 2014-05-05 00:00:00 | 6:00 - 9:00PM | L203
CONFLICTS | 700 | 1 | 3 | SEALING | 2014-05-09 00:00:00 | 1:00 - 4:00PM | L202
CONTRACTS II | 508 | N | 2 | ROBINETTE | 2014-05-01 00:00:00 | 9:00 - 11:00AM | A180
CONTRACTS II | 508 | R | 2 | KEARNEY | 2014-05-01 00:00:00 | 6:00 - 8:30PM | L204
CRIMINAL LAW | 505 | 1 | 3 | POWER | 2014-05-07 00:00:00 | 9:00AM - 12:00PM | L202
ENVIRONMENTAL LAW | 831 | 1 | 3 | DERNBACH | 2014-05-10 00:00:00 | 1:00 - 3:30PM | L204
FEDERAL INCOME TAX | 610 | 1 | 3 | HUSSEY | 2014-05-06 00:00:00 | 6:00 - 9:00PM | L204
LAND USE PLANNING | 761 | 1 | 2 | WARSHAWSKY | 2014-05-13 00:00:00 | 6:00 - 8:00PM | L203
LAW AND POLICY OF SENCTENCING AND CORRECTIONS | 6015X | 1 | 2 | TURGEON | 2014-05-01 00:00:00 | 6:00 - 8:00PM | L203
PENNSYLVANIA CIVIL PRACTICE# | 741 | 1 | 2 | DURKIN | 2014-05-13 00:00:00 | 6:00 - 8:00PM | L205
PROFESSIONAL RESPONSIBILITY | 702 | 1 | 3 | [NAME] | 2014-05-06 00:00:00 | 6:00 - 9:00PM | L202
PROPERTY II | 516 | R | 2 | EVANS | 2014-05-03 00:00:00 | 12:00 - 2:00PM | L205
PROPERTY II | 516 | N | 2 | DERNBACH | 2014-05-03 00:00:00 | 9:00 - 11:00AM | L202
REMEDIES | 655 | 1 | 3 | LOCKARD | 2014-05-10 00:00:00 | 1:00 - 4:00PM | L202
SALES AND LEASES | 646 | 1 | 3 | MEADOWS | 2014-05-05 00:00:00 | 9:00AM - 12:00PM | A180
SECURED TRANSACTIONS | 600 | 1 | 3 | MORINGIELLO | 2014-05-01 00:00:00 | 6:00 - 9:00PM | L202
STATE CONSTITUTIONAL LAW | 773 | 1 | 3 | GEDID | 2014-05-05 00:00:00 | 1:00 - 4:00PM | L204
TAXATION OF BUSINESS ENTITIES | 972 | 1 | 3 | HUSSEY | 2014-05-06 00:00:00 | 1:00 - 4:00PM | L203
TORTS II | 520 | N | 3 | RAEKER-JORDAN, S. | 2014-05-09 00:00:00 | 9:00AM - 12:00PM | A180
TORTS II | 520 | R | 3 | [NAME] | 2014-05-07 00:00:00 | 6:00 - 9:00PM | L202
WILLS AND TRUSTS | 834 | 1 | 4 | EVANS | 2014-05-08 00:00:00 | 1:00 - 5:00PM | L202
WORKER'S COMPENSATION | 745 | 1 | 2 | SCHUCKERS | 2014-05-09 00:00:00 | 1:00 - 3:15PM | L203
Spreadsheet: 466801d1466448770-report-formula-query-profitability-may-2016
Sheet: Sheet4

 |  |  | Data
Years | Date | Project | Count of Quantity | Sum of Cost Amount | Sum of Charge Amount | Sum of Invoiced
2014 | Feb | Thirty | 1 | 10 | 500 | 17613
 |  | Twenty |  |  |  | 85250
 | Feb Total |  | 1 | 10 | 500 | 102863
2014 Total |  |  | 1 | 10 | 500 | 102863
2015 | Feb | Twenty | 1 | 20 | 120 | 1655
 | Feb Total |  | 1 | 20 | 120 | 1655
2015 Total |  |  | 1 | 20 | 120 | 1655
2016 | Jan | Thirty | 1 | 13 | 150 | 10000
 |  | Twenty | 1 | 13 | 150 | 100
 | Jan Total |  | 2 | 26 | 300 | 10100
 | Feb | Thirty | 1 | 32 | 100 | 1950
 |  | Twenty | 1 | 32 | 100 | 13823
 | Feb Total |  | 2 | 64 | 200 | 15773
 | Mar | Thirty | 1 | 52 | 160 | 12433
 |  | Twenty | 1 | 52 | 160 | 12001
 | [NAME] |  | 2 | 104 | 320 | 24434
2016 Total |  |  | 6 | 194 | 820 | 50307
Grand Total |  |  | 8 | 224 | 1440 | 154825
Spreadsheet: john_griffith__16180__1_29_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 175 | 182 | 53.8 | 56 | 0.67 | 2002-01-29 12:00:00
 | CL J2 | 20 | 278 | 285 | 49.9 | 51.1 | 0.63 | 2002-01-29 12:00:00
 | CL K2 | 20 | 350 | 365 | 47.9 | 50 | 0.62 | 2002-01-29 12:00:00
 | CL M2 | 20.5 | 400 | 410 | 45.8 | 47 | 0.6 | 2002-01-29 12:00:00
 | CL N2 | 20.5 | 435 | 450 | 43.9 | 45.4 | 0.58 | 2002-01-29 12:00:00
 | CL Q2 | 20.5 | 460 | 475 | 42.2 | 43.6 | 0.55 | 2002-01-29 12:00:00
 | CL U2 | 20.5 | 480 | 490 | 40.9 | 41.8 | 0.53 | 2002-01-29 12:00:00
 | [NAME] | 20.5 | 485 | 505 | 38.4 | 40 | 0.51 | 2002-01-29 12:00:00
 | CL X2 | 20.5 | 490 | 510 | 36.6 | 38.1 | 0.48 | 2002-01-29 12:00:00
 | [NAME] | 20.5 | 495 | 510 | 35.3 | 36.4 | 0.46 | 2002-01-29 12:00:00
 | CL F3 | 20.5 | 500 | 515 | 34 | 35 | 0.44 | 2002-01-29 12:00:00
 | CL G3 | 20.5 | 510 | 525 | 33.3 | 34.3 | 0.44 | 2002-01-29 12:00:00
 | CL M3 | 20.5 | 540 | 560 | 31 | 32.2 | 0.41 | 2002-01-29 12:00:00
 | CL Z3 | 21 | 545 | 565 | 26.6 | 27.6 | 0.36 | 2002-01-29 12:00:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 160680d1339165721-aggregating-data-by-unique-value-and-sub-values-book1
Sheet: Sheet1

[NAME] | Ferrari | 1 |  |  |  | [NAME] | Ferrari
[NAME] | Honda | 1 |  |  |  | [NAME] | Honda
[NAME] | Cadillac | 1 |  |  |  | [NAME] | Cadillac
[NAME] | Ferrari | 1 |  |  |  | [NAME] | Ferrari
[NAME] | Honda | 1 |  |  |  | [NAME] | Honda
[NAME] | Honda | 1 |  |  |  | [NAME] | Cadillac
Spreadsheet: 702169d1604134407-need-formula-to-merge-data-table-data-table-merge
Sheet: Sheet5

SIZE |  | AA | BB | CC | DD | EE
COLOUR | QUALITY
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
1 | B
2 | A
3 | D
Spreadsheet: 766978d1644220646-values-to-be-written-for-no-times-according-to-cell-values-sample-3-
Sheet: Sheet1

 | Helper | Repeat for No. of Times | Values to be Written |  | Expected Result
 | 0 | 5 | 10 |  | 10
 |  | 2 | 15 |  | 10
 |  | 6 | 8 |  | 10
 |  | 3 | 40 |  | 10
 |  | 7 | 60 |  | 10
 |  |  |  |  | 15
 |  |  |  |  | 15
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 8
 |  |  |  |  | 40
 |  |  |  |  | 40
 |  |  |  |  | 40
 |  |  |  |  | 60
 |  |  |  |  | 60
 |  |  |  |  | 60
 |  |  |  |  | 60
 |  |  |  |  | 60
 |  |  |  |  | 60
 |  |  |  |  | 60
Spreadsheet: 50336d1249699729-excel-2007-solved-custom-sort-data-show-conditional-data-aug-7-after
Sheet: data

 | Sun | Sun | Mercury | Mercury | Venus | Venus | [NAME] | [NAME] | Mars | Mars | Jupiter | Jupiter | Saturn | Saturn | Uranus | Uranus | Neptune | Neptune | Pluto | Pluto
UT-6h | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude | azimuth | altitude
2009-08-07  09:30 |  |  |  |  |  |  | 290° 50' 24'' |  |  |  |  |  |  |  |  |  |  | -40° 44' 53''
2009-08-07  09:32 |  |  |  | 30° 00' 49''
2009-08-07  09:33 |  | 50° 02' 03''
2009-08-07  09:34 |  |  |  |  | 190° 37' 16''
2009-08-07  09:37 | 120° 05' 17'' |  |  |  |  |  |  |  |  |  |  |  | 100° 09' 06''
2009-08-07  09:40 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20° 08' 45''
2009-08-07  09:42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280° 07' 15''
2009-08-07  09:44 |  |  |  |  |  |  |  |  |  | 60° 08' 37''
2009-08-07  09:45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30° 26' 07''
2009-08-07  09:49 |  |  |  |  | 200° 17' 09'' |  |  |  | 240° 19' 02''
2009-08-07  09:54 |  |  | 110° 03' 44''
2009-08-07  09:56
2009-08-07  10:04 |  |  |  |  |  |  |  |  |  |  | 300° 12' 30''
2009-08-07  10:06 |  |  |  |  | 210° 19' 55''
2009-08-07  10:07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300° 09' 44'' |  | 40° 24' 28''
2009-08-07  10:09 | 130° 00' 13'' |  |  |  |  |  |  | -39° 26' 23'' |  |  |  |  |  |  |  |  |  |  |  | -60° 31' 44''
Spreadsheet: 687826d1595427956-managing-worksheets-in-excel-managing-worksheets-in-excel
Sheet: ASSETS

Asset Category | Date for B/D Assets on 1 January | Acquisition Date | Year Put in Use | Cost | Salvage Value | Useful Life - Years
Office Appliances | 2020-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013 | 100000 |  | 10
Office Appliances | 2020-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015 | 50000 |  | 5
Office Appliances | 2020-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016 | 80000 |  | 5
Office Appliances | 2020-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017 | 20000 |  | 5
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: TX-CON-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM) / HPL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: d8639111-5a31-44b5-b691-1067c2bdfefe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Instructions For Monthly Report of Operation — Package Type Wastewater
 | Treatment Plants (less than 0.05 mgd)
 | State Form 53344 (R / 3-14)
 | The standard "Activated Sludge Monthly Report of Operation" in Excel is a more fully functional program. It will calculate weekly averages for you and is generally recommended in place of this form.
 | Note "MRO" tab at bottom of page.
 | After entering the general information (name, permit #, etc.), save a copy (blank).
 | Note that your phone number and e-mail address (if available) for questions regarding the data are to be entered at the bottom of page 2.
 | Once you've begun entering data for a month, save that file version under a new name (for example Dec-05) so that you still have the blank version for future months.
 | Entering the year and the number of the month allows the program to insert the names of the month and the days.
 | "Freeze Panes" has been used to keep row and column labels visible as you scroll.
 | This feature can be turned off by selecting "Unfreeze Panes" under the Window menu selection.
 | Do not use the space bar to remove data.  This inserts a space character which may cause problems.
 | Instead, use the delete key.
 | Simply type in a column heading to use the blank column.
 | If you are testing for TBOD rather than CBOD, please make that correction to the column headings.
 | [NAME] formula in the "average" box actually calculates the geometric mean. The program converts "TNTC" to 63,200 and converts "0" to "1" when calculating the monthly geometric mean.
 | Round off the calculated numbers as appropriate when transferring the information to your DMR.
 | As with any important computer file, you should save a backup copy to a floppy disk or other location on a regular basis.
 | Cells containing formulas are "locked" to prevent accidental modification.
 | Should you find it necessary to remove the cell protection, the password is:  mro
Spreadsheet: 105891d1303159296-unable-to-countif-values-with-conditions-from-second-column-book2
Sheet: Sheet1

Type | Days
Dog | 0
Cat | 0 |  |  | 3
Dog | 0
Cat | 2
Dog | 1
[NAME] | 1
Cat | 2
Dog | 3
Cat | 1
 |  |  |  |  | Examples of what the final data should be
 |  |  |  |  | Days | 0 | 1 | 2 | 3
 |  |  |  |  | Final value | 1 | 2 | 2 | 0
Spreadsheet: 94143d1294021416-an-array-to-show-only-the-last-10-entries-forum-sample-7
Sheet: SUMMARY

O | or | 06 |  | =OFFSET('MASTER'!A1,MAX((NOT(ISBLANK(('MASTER'!A1:A3000)))*ROW(('MASTER'!A1:A3000))-10,10,1)
E |  | 08
E |  | 19 |  | This only a sample and to mark the area I "highlighted" the area - I wanting to have this update itself as I enter new data.  I just to pickup the last 10 entries from "MASTER" sheet.  If I want to "pickup" the last 10 numbers column C (text) would there be any change in the formula to pickup in column A the "O" or "E"?
E |  | 20
O |  | 30
E |  | 45
O |  | 60
E |  | 07
O |  | 88
E |  | 95
Spreadsheet: 675039d1588112709-extract-data-from-column-seprate
Sheet: Sheet1

aaaaa
[NAME] | HorneDRE |  | [PHONE] | [EMAIL]
[NAME] | YangDRE |  | [PHONE] | [EMAIL]
[NAME] | PerkinsDRE |  | [PHONE] | [EMAIL]
Rachel | [NAME] |  | [PHONE] | [EMAIL]
[NAME] | DaffaraDRE |  | [PHONE] | [EMAIL]
[NAME] | TomasiDRE |  | [PHONE] | [EMAIL]
[NAME] | MetcalfDRE |  | [PHONE] | [EMAIL]
[NAME] | DischerDRE |  | [PHONE] | [EMAIL]
[NAME] | ZeusDRE |  | [PHONE] | [EMAIL]
Kristen | ParksNegusDRE |  | [PHONE] | [EMAIL]
Gershom | HyldrethDRE |  | [PHONE] | [EMAIL]
Oren | ZroyaDRE |  | [PHONE] | [EMAIL]
Troy | GregoryDRE |  | [PHONE] | [EMAIL]
[NAME] | McKenzieDRE |  | [PHONE] | [EMAIL]
[NAME] | Villalobos-ParkerDRE |  | [PHONE] | [EMAIL]
Valeria | MartinezDRE |  | [PHONE] | [EMAIL]
Christian | StillmarkDRE |  | [PHONE] | [EMAIL]
[NAME] | ZarosimDRE |  | [PHONE] | [EMAIL]
[NAME] | BarhoumDRE |  | [PHONE] | [EMAIL]
Kimberly | KovacDRE |  | [PHONE] | [EMAIL]
[NAME] | [NAME] |  | [PHONE] | [EMAIL]
Suzi | FarajianiDRE |  | [PHONE] | [EMAIL]
Ramiah | ThomasDRE |  | [PHONE] | [EMAIL]
Scott | [NAME] |  | [PHONE] | [EMAIL]
Doug | [NAME] |  | [PHONE] | [EMAIL]
Spreadsheet: 122654d1317048227-multiple-transpose-function-from-rows-into-columns-sample
Sheet: Sheet1

101160621 | LK10001B0
101160621 | LK2001300
101160621 | LK30017B0
101160621 | LK4001700
101160621 | LK5187200
101160691 | [NAME]
101160691 | LK2000900
101160691 | LK30021A0
101160691 | LK4002100
101160691 | LK5187400
101160692 | [NAME]
101160692 | LK2000900
101160692 | LK30021A0
101160692 | LK4002100
101160692 | LK5187400
101160696 | LK10001B0
101160696 | LK2001300
101160696 | LK30017B0
101160696 | LK4001700
101160696 | LK5187300
101163278 | LK1031500
101163278 | LK2019600
101163278 | LK3040400
101163278 | LK4045600
101163278 | LK4056000
101163278 | LK5189900
101163278 | LK5189900
101163278 | LK5189900
101166240 | LK1040500
101166240 | LK2026600
101166240 | LK3050900
101166240 | LK4069600
101166240 | LK5188300
101166241 | LK1040500
101166241 | LK2026600
101166241 | LK3050900
101166241 | LK4069600
101166241 | LK5188300
101166243 | 5K2062600
101166243 | 5K30706B0
101166243 | LK1031900
101166243 | LK4042000
101166243 | LK5137200
101176043 | [NAME]
101176043 | LK2000900
101176043 | LK30021A0
101176043 | LK4002100
101176043 | LK5189800
Spreadsheet: darrell_schoolcraft__7353__imball0201
Sheet: MiVida_Rich

 | Mi Vida/Richardson Gas Treating
 | POI 500607 - Delhi/No Pyote
Day | Measured | Scheduled
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
2001-12-31 00:00:00 |  |  | -203736.06
2001-12-31 00:00:00
CBS Volume
 |  |  | -51454
Spreadsheet: 213582d1360585052-return-a-1st-2nd-or-3rd-from-row-of-numbers-society-scoring-system-template
Sheet: newburycrookham

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name        H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name        H/caps |  | Front 9 | Back 9 | Total | Points
 |  |  |  |  |  | 80
Leaders in red
 | Team Ball   K goss C Veil P Brown C Allpress   94 points
 | Handicap change C Veil to 19 L Moran to 14 P brown to 9
Spreadsheet: 769716d1645649108-help-with-formula-to-pull-description-and-add-quantities-from-lookup-list-bom-template
Sheet: Intrusion

ROOM | Quantity | Part No. | Brief Description | Purchase From | (NU) Labor Cost | (U) Labor Cost | ( C ) Labor Cost | Device Cost | Cable | (NU) Labor Total | (U) Labor Total | ( C ) Labor Total | Hardware Total | Labor Sell | Hardware Sell |  | Totals Sell |  |  | Totals Cost
INTRUSION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Sell |  |  | Labor Cost
Sallyport |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardware Sell |  |  | Hardware Cost
Intrusion keypad | 0
Spreadsheet: 136197d1326468033-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration
Sheet: Hours

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 806432d1669296201-searching-for-an-exact-numeric-match-with-a-formula-filter-example-forum-1-ans
Sheet: Sheet1

 | ID | Result |  |  |  | ID | Value
 | 5.1 |  |  |  |  | 5.1 | banana |  | First Format cells for Wrap text. After that you apply formula. Reverse way it will not work. After Formatting only formula should be executed.
 | 5.2 |  |  |  |  | 5.11 | apple
 | 5.3 |  |  |  |  | 15.1 | [NAME]
 | 5.4 |  |  |  |  | 10.6 5.1 | avocado
 |  |  |  |  |  | 4.9 5.2 13.3 | orange
 | [NAME] used: | =TEXTJOIN(CHAR(10),TRUE,FILTER(H4:H8,ISNUMBER(SEARCH(B4,G4:G8)),""))
 |  | The result above (C4) should only return (banana, avocado), ideally in a new line
Spreadsheet: 599994d1543410546-need-a-formula-to-filter-data-need-a-formula-to-filter-data
Sheet: Sheet1

Winner | [NAME] | Winner Score | [NAME] |  | Emma | Winner | [NAME] | Winner Score | [NAME] |  | Original → | Winner | [NAME] | Winner Score | [NAME] |  | Emma
Emma | Jake | 3 | 2 |  |  |  |  |  |  |  |  | Emma | Jake | 3 | 2 |  | Hamish
Jake | Sandra | 4 | 0 |  |  |  |  |  |  |  |  | [NAME] | Emma | 1 | 0 |  | Jake
[NAME] | [NAME] | 2 | 1 |  |  |  |  |  |  |  |  | Emma | Kait | 5 | 2 |  | [NAME]
Millie | Kait | 10 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kait
[NAME] | Emma | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Hamish | [NAME] | 9 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | Millie
Millie | [NAME] | 6 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Emma | Kait | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sandra