tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266511d1379636494-question-about-counting-cell-thats-have-two-different-text-in-two-different-columns-sample-data-3
Sheet: Sample Data

Responsible Transmission Engineer | Responsible Transmission Engineering Supervisor | Subsystem Boundary Status | Subsystem Name Status
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME]/[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Out for Review | Approved
[NAME] | [NAME] | Out for Review | Approved
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Approved | Approved
[NAME] | [NAME] | Unchecked | Out for Review
[NAME] | [NAME] | Unchecked | Out for Review
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Out for Review | Unchecked
[NAME] | [NAME] | Out for Review | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Unchecked | Unchecked
[NAME] | [NAME] | Making Revisions | Unchecked
[NAME] | [NAME] | Making Revisions | Unchecked
Moriah McCarvel/Thad Quaas | Darin Jones/Anthony Thompson | Making Revisions | Unchecked
Moriah McCarvel/Thad Quaas/Bob Pace | Darin Jones/Anthony Thompson/Bob Pace | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Out for Review | Out for Review
Moriah McCarvel/Bob Pace | Darin Jones/Bob Pace | Out for Review | Out for Review
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel/Bob Pace | Darin Jones/Bob Pace | Making Revisions | Unchecked
Moriah McCarvel | Darin Jones | Making Revisions | Unchecked
Moriah McCarvel | Darin Jones | Making Revisions | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Moriah McCarvel | Darin Jones | Unchecked | Unchecked
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPL |  | Texas-EGM |  | Storage |  | Ontario |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | -1455110 |  |  |  | 1455110
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1455110
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 0 |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 19344 |  | -19344
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  | 642852 |  |  |  |  |  | 780610
 | 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 |  |  |  |  |  | 7880663 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -7880663
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | -3000 |  | 89700 |  |  |  |  |  | 238076
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  | 24750
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 689784d1596651918-indirect-syntax-within-index-match-excel_help
Sheet: SERIES

 |  |  |  | 2015-06-30 00:00:00 | 2015-07-31 00:00:00 | 2015-08-31 00:00:00 | 2015-09-30 00:00:00 | 2015-10-31 00:00:00 | 2015-11-30 00:00:00 | 2015-12-31 00:00:00 | 2016-01-31 00:00:00 | 2016-02-29 00:00:00 | 2016-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-05-31 00:00:00 | 2016-06-30 00:00:00 | 2016-07-31 00:00:00 | 2016-08-31 00:00:00 | 2016-09-30 00:00:00 | 2016-10-31 00:00:00 | 2016-11-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00 | 2018-08-31 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 6.30.20 | 7.31.20
 | Fund 1-A | Rating 3 Yr | 3-Year
 | Fund 1-A | Rating 5 Yr | 5-Year
 | Fund 1-A | Rating 10 Yr | 10-Year
 | Fund 1-A | Rating Overall | Overall
 | Fund 1-C | Rating 3 Yr | 3-Year
 | Fund 1-C | Rating 5 Yr | 5-Year
 | Fund 1-C | Rating 10 Yr | 10-Year
 | Fund 1-C | Rating Overall | Overall
 | Fund 1-I | Rating 3 Yr | 3-Year
 | Fund 1-I | Rating 5 Yr | 5-Year
 | Fund 1-I | Rating 10 Yr | 10-Year
 | Fund 1-I | Rating Overall | Overall
Spreadsheet: 123423d1317656409-drop-down-coding-help-like-this-1
Sheet: Sheet2

Last | First | MI | Grade
Adams | [NAME] | V | [NAME]
[NAME] | Kayla | P | Grade 5 | 3
Dominguez | [NAME] | W | Pre K
Griffin | [NAME] | C | Grade 11
Henri | [NAME] | M | [NAME]
Hilton | [NAME] | C | Grade 6
Jacobs | Kylie | E | Grade 11
[NAME] | Stacy | A | Grade 12
Phillips | [NAME] | S | Grade 11
Simpleton | [NAME] | J | [NAME]
[NAME] | [NAME] | B | Grade 7
[NAME] | Stanley | L | Grade 11
White | [NAME] | N | Grade 10
Wilshere | [NAME] | P | Grade 11
Last | First | MI | PK | K | Grade 1 | [NAME] | [NAME] | [NAME] | Grade 5 | Grade 6 | Grade 7 | [NAME] | Grade 9 | Grade 10 | Grade 11 | Grade 12
Adams | [NAME] | V | y |  |  |  |  | y |  |  |  | y | y |  | y
[NAME] | Kayla | P |  | y | y |  | y |  |  | y
Dominguez | [NAME] | W |  | y | y |  |  | y |  |  | y |  |  |  | y | y
Griffin | [NAME] | C |  |  |  |  | y |  | y |  |  |  | y
Henri | [NAME] | M |  |  |  | y |  |  |  | y |  | y |  |  |  | y
Hilton | [NAME] | C |  |  | y | y | y |  |  |  |  |  |  | y
Jacobs | Kylie | E | y |  |  |  |  |  |  | y |  |  | y |  |  | y
[NAME] | Stacy | A |  | y |  |  | y | y |  |  | y |  | y |  | y
Phillips | [NAME] | S | y |  |  |  | y |  |  |  |  | y
Simpleton | [NAME] | J |  |  |  | y |  | y |  | y |  |  |  |  | y
[NAME] | [NAME] | B |  | y | y | y |  |  |  |  |  | y
[NAME] | Stanley | L |  | y |  |  |  |  | y |  | y |  |  | y |  | y
White | [NAME] | N |  | y |  | y |  |  |  |  |  |  |  | y
Wilshere | [NAME] | P |  |  |  |  |  | y |  |  | y |  | y | y
Spreadsheet: 96987d1296210695-excel-2007-conditional-formatting-after-vlookup-value-conditionalvlookup
Sheet: Sheet1

CC_Sched_Arrival | Responsible MA | Loadlist |  |  | Count if
2011-01-10 00:00:00 | [NAME]
2011-01-13 00:00:00 | Daan
2011-01-14 00:00:00 | Emerson | 347929
2011-01-14 00:00:00 | Nicoleta
2011-01-17 00:00:00 | Daan
2011-01-18 00:00:00 | Emerson
2011-01-19 00:00:00 | Emerson | 347929
2011-01-24 00:00:00 | Emerson | 347622
2011-01-24 00:00:00 | Daan
2011-01-24 00:00:00 | Daan | 347929
2011-01-24 00:00:00 | Daan | 347929
2011-01-24 00:00:00 | Daan | 347929
2011-01-25 00:00:00 | Emerson | 347929
2011-01-25 00:00:00 | Daan
2011-01-25 00:00:00 | Emerson | 347622
2011-01-26 00:00:00 | Emerson | 347929
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Emerson | 347929
2011-01-26 00:00:00
2011-01-26 00:00:00 | Nicoleta
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Daan
2011-01-26 00:00:00 | Daan | 347913
2011-01-26 00:00:00 | Daan | 347913
2011-01-26 00:00:00 | Daan
2011-01-27 00:00:00
2011-01-27 00:00:00 | Emerson | 347929
2011-01-27 00:00:00 | Daan | 347913
2011-01-27 00:00:00 | [NAME]
Spreadsheet: c3b607e0-1a72-45b4-9e83-c24bfb21036e
Sheet: 16.04.2011.

Valmieras pilsētas 17.  atklātais čempionāts ar H-600 klases lidmodeļiem
 |  |  | 1.etaps
 |  |  |  |  |  |  |  |  |  |  |  |  | 22.10.2011. | Valmiera
Nr.p.k. | Vārds Uzvārds | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Punkti | Vieta
 |  |  |  |  | Jaunākā grupa
1. | [NAME] | Mazsalacas vsk. | 15 | 27 | 21 | 16 | 19 | 18 | 26 | 28 | 18 | 29 |  | 1.
2. | [NAME] | VJC "Vinda" | 16 | 9 | 18 | 11 | 17 | 16 | 33 | 18 | 16 | 45 |  | 2.
3. | Igors Jaščenkovs | RJTC | 5 | 9 | 30 | 25 | 29 | 7 | 22 | 33 | 8 | 14 |  | 3.
4. | [NAME] | RJTC | 30 | 27 | 15 | 13 | 11 | 11 | 11 | 13 | 6 | 36 |  | 4.
5. | [NAME] | VJC "Vinda" | 14 | 8 | 11 | 15 | 14 | 24 | 11 | 15 | 34 | 23 |  | 5.
6. | Emīls Bīviņš | Mazsalacas vsk. | 16 | 13 | 17 | 7 | 20 | 21 | 2 | 26 | 22 | 22 |  | 6.
7. | [NAME] | Mazsalacas vsk. | 9 | 15 | 14 | 20 | 21 | 14 | 11 | 20 | 15 | 12 |  | 7.
8. | [NAME] | VJC "Vinda" | 8 | 15 | 15 | 9 | 19 | 15 | 10 | 16 | 20 | 12 |  | 8.
9. | Deivids Obeleinis | Mazsalacas vsk. | 11 | 7 | 8 | 12 | 16 | 12 | 15 | 9 | 21 | 11 |  | 9.
10. | Francs Stabrovskis | RJTC | 23 | 9 | 16 | 20 | 15 | 4 | 10 | 10 | 2 | 7 |  | 10.
11. | Aleksis Grantiņš | Mazsalacas vsk. | 5 | 7 | 20 | 23 | 10 | 17 | 4 | 13 | 3 | 7 |  | 11.
12. | [NAME] | VJC "Vinda" | 8 | 17 | 31 | 16 | 4 | 14 | 4 | 3 | 0 | 0 |  | 12.
13. | [NAME] | Mazsalacas vsk. | 3 | 7 | 7 | 8 | 6 | 11 | 9 | 8 | 9 | 8 |  | 13.
 |  |  |  |  | Vidējā grupa
1. | [NAME] | Mazsalacas vsk. | 31 | 32 | 20 | 30 | 23 | 44 | 25 | 36 | 24 | 17 |  | 1.
2. | Kristaps Skrastiņš | VJC "Vinda" | 10 | 45 | 22 | 49 | 27 | 26 | 21 | 12 | 57 | 10 |  | 2.
3. | Vladislavs Saiko | RJTC | 15 | 22 | 20 | 22 | 15 | 15 | 32 | 5 | 7 | 40 |  | 3.
4. | [NAME] | Mazsalacas vsk. | 13 | 21 | 21 | 16 | 17 | 27 | 8 | 12 | 20 | 31 |  | 4.
 |  |  |  |  | [NAME] grupa
1. | [NAME] | RJTC | 36 | 21 | 41 | 38 | 56 | 29 | 14 | 49 | 36 | 60 |  | 1.
2. | [NAME] | Mazsalacas vsk. | 12 | 39 | 60 | 40 | 28 | 18 | 24 | 32 | 36 | 28 |  | 2.
3. | [NAME] | VJC "Vinda" | 35 | 48 | 28 | 28 | 22 | 26 | 29 | 41 | 26 | 27 |  | 3.
4. | [NAME] | VJC "Vinda" | 18 | 33 | 12 | 34 | 24 | 19 | 42 | 45 | 29 | 29 |  | 4.
5. | [NAME] | VJC "Vinda" | 10 | 17 | 14 | 22 | 31 | 23 | 19 | 17 | 8 | 11 |  | 5.
Spreadsheet: 845472d1696969492-problem-with-league-table-golfscoresmultiplayerlive
Sheet: LgeTbl

Points for 1st | 3
Points for 2nd | 2
Points for 3rd | 1
Position | Team | Count1st | [NAME] | Count2nd | Points2nd | Count3rd | Points3rd | TtlPoints | Seperate | Rank Value | Rank
1 | Team1 |  |  |  |  |  |  |  | 0.001
7 | Team7 |  |  |  |  |  |  |  | 0.007
2 | Team2 |  |  |  |  |  |  |  | 0.002
5 | Team6 |  |  |  |  |  |  |  | 0.005
6 | Team3 |  |  |  |  |  |  |  | 0.003
3 | Team5 |  |  |  |  |  |  |  | 0.006
4 | Team4 |  |  |  |  |  |  |  | 0.004
Spreadsheet: 227788d1365809717-need-help-formatting-a-workbook-with-a-search-function-example
Sheet: Dave

Stats
Name: | [NAME]
Ears
 | Pencil | Pen
First | 0 | 1000
Last | 300 | 2100
Scope
First | 1500 | 5000
Last | 3000 | 6000
Scope
First | 10000 | 15000
Last | 11000 | 17000
Scope
First | 25000 | 95000
Last | 28000 | 100000
Scope
First | 100000 | 250000
Last | 150000 | 280000
Scope
MORE INPUTED DAILY
Eyes
 | Pencil | Pen
First | 0 | 300
Last | 300 | 750
Scope
First | 700 | 9780
Last | 1200 | 10547
Scope
First | 5300 | 27050
Last | 6700 | 30715
Scope
First | 14500 | 75987
Last | 16899 | 84000
Scope
First | 74000 | 340158
Last | 79054 | 390000
Scope
MORE INPUTED DAILY
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: TAXES

INCOME TAXES
EBTDA
Tax Depreciation
Earnings Before Taxes
VA State Income Taxes
Earnings After State Taxes
NOL Carryforward
Beginning Balance of NOL |  | 0
Additions
NOL Carryforwards Used
Ending Bal of NOL Carryforwards
Taxable Income
Tax Rate Determination:
Net Tax Rate
Adjusted Taxable Income
Tax Liability Before Credits
Income Taxes Paid (Not including Property Tax)
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug11

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-11 00:00:00 |  | Y | 1 | 1 |  | SP15 | CORAL | 2 |  |  | 37 | STCALI | 37 |  |  |  |  |  |  | 727451,727453 | 1
2001-08-11 00:00:00 |  | Y | 2 | 6 |  | SP15 | EES | 2 |  |  | 25 | STCALI | 25 |  |  |  |  |  |  | 727452,727453 | 1
2001-08-11 00:00:00 |  | Y | 7 | 10 |  | SP15 | STCALI | 9 |  |  | 25 | PWRX | 25 |  |  |  |  |  |  | 727461,727462 | 1
2001-08-11 00:00:00 |  | Y | 11 | 14 |  | SP15 | STCALI | 9 |  |  | 29 | WESCO | 29 |  |  |  |  |  |  | 727461,727513 | 1
2001-08-11 00:00:00 |  | Y | 15 | 16 |  | SP15 | STCALI | 9 |  |  | 32 | DYNEGY | 32 |  |  |  |  |  |  | 727461,727531 | 1
2001-08-11 00:00:00 |  | Y | 17 | 17 |  | SP15 | STCALI | 9 |  |  | 32 | DUKE | 37 |  |  |  |  |  |  | 727461,727529 | 1
2001-08-11 00:00:00 |  | Y | 18 | 22 |  | SP15 | STCALI | 9 |  |  | 29 | NEW ENERGY | 34 |  |  |  |  |  |  | 727530,727530 | 1
2001-08-11 00:00:00 |  | Y | 23 | 24 |  | SP15 | SEMPRA | 15 |  |  | 30 | STCALI | 35 |  |  |  |  |  |  | 727522,727453 | 1
Spreadsheet: 782866d1654355914-formula-with-data-segmentation-help-a-brazilian-2022-06-03-oeldere2-pjuliocesar-seller-with-date-base
Sheet: SUMARY

 |  | Sumif => | MURILO
 |  | Subtotal and filter =>
 | n° | CITY | SELLER | TOTAL
 | 3965 | Curitiba | MURILO
 | 3975 | Forteleza | MURILO
 | 3976 | Grandes Lagos | JULIO
 | 3976 | Matinho | JULIO
added | 3975 | Forteleza | MURILO
 |  | TOTAL SALES OF THE SELLER | 44 | ??
 |  |  | VALUE MUST BE | 44 IF IT'S Julio
 |  |  |  | 52 IF IT'S Murilo
Spreadsheet: 843028d1695002274-modify-formula-to-retrieve-value-from-sheet-1-to-sheet-2-sample-book_finish_placement-copy
Sheet: Sheet2

 |  |  |  |  | Desired Result on yellow
 |  |  |  | Name | Place | What I'm trying to achieve;
 |  |  |  | [NAME] |  | [NAME] on F5 to be modify to look on SHEET 1 for values 3 and 4 on columns [NAME]:K25, S12:S25, AA12:AA25, AI12:AI25, if value is 3, to retrieve value from SHEET1 Q10 to column F, if value is 4, to retrieve value from  Y10
 |  |  |  | [NAME] |  |  |  |  |  | Place |  |  |  |  |  | Place
 |  |  |  | [NAME] |  |  |  |  | 3rd= | 17 |  |  |  |  | 4th= | 25
 |  |  |  | [NAME] |  |  |  | H1 |  |  | H2 |  |  | H3 |  |  | H4
 |  |  |  | [NAME] | 25 |  |  | [NAME] | 4 |  | [NAME] | 1 |  | [NAME] | 1 |  | Pablo Díaz | 1
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 2 |  | [NAME] | 4 |  | Hector Santamaría | 3 |  | [NAME] | 2
 |  |  |  | Esteban Chaves Morua |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 2 |  | [NAME] | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 1 |  | [NAME] | 3 |  | Moises Montalvo | 4 |  | [NAME] | 4
 |  |  |  | [NAME] | 25 |  |  | H5 | Plc. |  | H6 | [NAME] |  | H7 | [NAME] |  | H8 | [NAME]
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 3 |  | Ricardo Delgado | 2 |  | Esteban Chaves Morua | 2 |  | [NAME] | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 2 |  | [NAME] | 3 |  | Micha Cantor | 3 |  | Shane Kertesz | 1
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 1 |  | [NAME] | 1 |  | [NAME] Orias | 1 |  | Lucas Madrid | 2
 |  |  |  | Giovanni Marín | 17 |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 4 |  | Mikel Kauffmann | 4
 |  |  |  | [NAME] |  |  |  | H9 | [NAME] |  | H10 | [NAME] |  | H11 | [NAME] |  | H12 | [NAME]
 |  |  |  | Hector Santamaría | 17 |  |  | Israel Barona | 1 |  | [NAME] | 3 |  | [NAME] | 1 |  | [NAME] | 1
 |  |  |  | Israel Barona |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 3 |  | [NAME] | 2
 |  |  |  | [NAME] Orias |  |  |  | Ricardo Lucke | 2 |  | [NAME] | 1 |  | [NAME] | 4 |  | Giovanni Marín | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 2 |  | [NAME] | 4
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME]
 |  |  |  | Lucas Madrid
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | Micha Cantor | 17
 |  |  |  | [NAME]
 |  |  |  | Mikel Kauffmann | 25
 |  |  |  | Moises Montalvo | 25
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 17
 |  |  |  | Pablo Díaz
 |  |  |  | [NAME] | 17
 |  |  |  | Ricardo Delgado
 |  |  |  | Ricardo Lucke
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 17
 |  |  |  | Shane Kertesz
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 25
Spreadsheet: 690638d1597217261-formula-for-producing-customers-statement-customers-statement-2
Sheet: Receipts

Date | [NAME] | Customer  Name | VAT Number | Reference | Invoice Number | Amount Received
2020-08-01 00:00:00 | 100 | Ok Mart | 1000200 | AA | 200 | 2000
2020-08-10 00:00:00 | 100 | Ok Mart | 1000200 | AA1 | 1 | 10000
2020-08-11 00:00:00 | 101 | [NAME] | 1000201 | AA2 | 2 | 27324
2020-08-12 00:00:00 | 100 | Ok Mart | 1000200 | AA3 | 3 | 7500
2020-08-12 00:00:00 | 103 | ZIMNAT | 1000203 | AA4 | 4 | 1000
2020-08-13 00:00:00 | 100 | Ok Mart | 1000200 | AA5 | 1 | 1385
2020-09-14 00:00:00 | 100 | Ok Mart | 1000200 | AA6 | 3 | 1608
Spreadsheet: 829866d1684504937-sort-based-on-criteria-entered-book3
Sheet: Sheet1

AF | AL | AB | AE | AG | AFL | AFB | AFE | AFG | ALB |  |  |  |  |  |  | AL | AE | AFB
444 |  |  | 99 |  |  |  | 67 |  | 22
 |  | 35
33 |  |  |  | 453 |  |  |  | 34
21 | 4 |  |  |  | 34
 |  | 55 |  | 45
6 |  |  | 1 |  |  |  | 65
 | 92 | 76 |  |  | 76 | 57 |  |  | 66
 |  |  | 23
 |  |  |  | 65
7 |  | 11 |  | 23 |  |  | 11 |  | 11
 |  |  | 22
 |  | 56 | 84 |  |  |  |  |  | 14
55
 |  |  | 87 |  |  |  |  |  | 232
44
Spreadsheet: 801884d1666453703-how-to-extend-sumproduct-formula-beyond-the-current-range-sumproduct-formula-issue
Sheet: Sheet1

Account | Amount |  |  | Sum of "start with 1 or 2"
1220130 | -35000
1413160 | -55000
2413430 | -25000
3413430 | -22000 |  |  | Sum of "start with 1 or 2" |  | *trying to extend the rage
1417011 | -14000
1417011 | -15000
1419011 | 600
Spreadsheet: 92170d1291824993-lookup-for-specific-values-in-multiple-cells-ops-cards
Sheet: Coremaking Equipment

 |  |  |  |  | Master Information Record |  |  |  |  |  |  |  | Count
 | Part No. | AM054f |  |  |  | Tooling Ref. |  |  | Casting Weight |  | Kgs
 | Customer |  |  |  |  | Drg/lss.No. |  |  | Gross Wt./Mld |  | Kgs
 | Material |  |  |  |  | PATT SHOP |  |  | Yield |  | %
q | Cust. Spec |  |  |  |  | Core Weight |  |  | Castings/Mould
COREMAKING EQUIPMENT
Plant |  | Tooling Ref. |  |  |  | AM Number |  | Description
TOOLING NOTES
COREMAKING DIRECTIVES |  |  |  |  |  | NOTES
 | Core Centre
p | Cores Dipped
p | Calibration of Hansberg Mixing Plant |  |  |  | WI 9.2
p | Hansberg line sand mixer:- Cleaning |  |  |  | WI 9.49
 | Machine Settings |  |  |  | TD 14
p | "First Off" Inspection - Core Shop |  |  |  | WI 10.10
p | "In Process" Inspection - Core Shop |  |  |  | WI 10.11
p | Core Dipping:- Material Control |  |  |  | WI 9.29
p | Core Trolley Identification |  |  |  | WI 12.3
p | Corebox vent & blow tube cleaning |  |  |  | WI 9.35
p | Hansberg Production Equipment Check List |  |  |  | WI 9.15
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 165721d1341325909-can-a-repeated-date-trigger-a-formula-to-run-sample-airframe-doc
Sheet: Tech Log

G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
2016-07-02 00:00:00 | SMITHY |  |  | 10:10:00 | 10:15:00 | 11:15:00 | 11:20:00
2012-07-02 00:00:00 | JONESY |  |  | 11:00:00 | 11:05:00 | 11:55:00 | 12:00:00
2016-07-04 00:00:00 | BLAKEY |  |  | 13:00:00 | 13:05:00 | 13:55:00 | 14:00:00
2012-07-04 00:00:00 | DOPEY |  |  | 12:07:00 | 12:09:00 | 14:34:00 | 14:45:00
2012-07-04 00:00:00 | JONESY |  |  | 12:23:00 | 12:29:00 | 12:35:00 | 12:50:00
2016-08-03 00:00:00 | JONESY |  |  | 01:00:00 | 02:00:00 | 02:35:00 | 03:00:00
2016-08-04 00:00:00 | BLAKEY |  |  | 09:00:00 | 09:05:00 | 10:05:00 | 10:25:00
2012-08-04 00:00:00 | SMITHY |  |  | 11:02:00 | 11:05:00 | 11:20:00 | 11:30:00
2016-09-10 00:00:00 | SMITHY |  |  | 12:00:00 | 12:05:00 | 12:34:00 | 12:45:00
2016-08-03 00:00:00 | DOPEY |  |  | 08:08:00 | 08:20:00 | 08:50:00 | 09:00:00
2016-08-04 00:00:00 | BLAKEY |  |  | 03:45:00 | 03:45:00 | 04:50:00 | 05:00:00
2016-09-02 00:00:00 | DOPEY |  |  | 14:20:00 | 14:50:00 | 14:55:00 | 16:00:00
2016-09-10 00:00:00 | SMITHY |  |  | 11:00:00 | 11:05:00 | 12:28:00 | 12:45:00
Spreadsheet: 836537d1689455185-how-easely-prevent-problems-with-match-on-a-array-with-one-value-test-match
Sheet: Sheet2

 |  |  |  |  |  |  |  | I am trying to figure out a way to combine both formulas (column B and C) so that I can avoid dragging the formula in column C down and having a bunch of references
 | ZONE | TOTALS |  | Solution? |  |  |  | my first attempt at this was with the formula in column E (I replaced B5 with the formula in column B) but I am having no luck.
 |  | 1000
 | Alpha-02 | 2000 |  |  |  |  |  |  | INDIRECT("'"&B5&"'!"&TEXT(SUBSTITUTE(ADDRESS(1,COLUMN('ALPHA-01'!$H$222),4),"1","")&ROW('ALPHA-01'!$H$222),0))
 | Alpha-03 | 3000 |  |  |  |  |  |  |  | ^
 | Alpha-04 | 4000 |  |  |  |  |  |  |  | IF(SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found")))="","",SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found"))))
 |  |  |  |  |  |  |  |  |  | some test formulas below
 |  |  |  |  |  |  |  |  | Formula 1
 |  |  |  |  |  |  |  |  | Formula 2
 |  |  |  |  |  |  |  |  | Formula 1+2