tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 247b6072-3c7c-4f25-a12a-857ae25e30a3
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-DEC | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | DECEMBER | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 5372564 | 8058834
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 5278412 | 7917620
7 | AEA 267 | 28293632 | 2829366 | 11317464 | 16976168
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 7840272 | 11760376
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 10905344 | 16358003
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 19696428 | 29544598
12 | NORTHWEST AEA | 16359617 | 1635961 | 6543844 | 9815773
13 | LOESS HILLS AEA 13 | 16376170 | 1637617 | 6550468 | 9825702
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 6002480 | 9003682
 |  | 198768032 | 19876819 | 79507276 | 119260756
Spreadsheet: 111218d1307641892-capturing-data-and-if-formula-nested-kookai-_sample-sheet-noc-
Sheet: report 

Helper 1 | Helper 2 | Under Study
Find Match | Remove Blanks
Spreadsheet: 226211d1365305489-filter-help-vanpool
Sheet: Dashboard

 |  | Vanpool Budget |  |  |  |  |  |  |  |  |  |  |  |  | DASHBOARD
 |  |  |  |  |  | CURRENT BALANCE |  |  |  |  | # of Drivers
 |  |  |  | 4 |  |  |  |  |  |  | 12
 |  |  | 2013
 |  |  | Monthly Totals |  |  |  |  |  |  |  | Projected Funds
 |  |  | Expenditures
 |  |  | Income |  | TRANSACTION | [NAME] | Credits | BALANCE
 |  |  |  |  | [NAME]
 |  |  |  |  | Payments
Spreadsheet: 32ee70e0-a75a-46fb-8d78-0e9cb6d05c64
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
FIGBP | Test | FIGBP | IGF Binding Protein-1 (IGFBP-1) | IGFBP-1 | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s). Spin down and separate within one hour.  Ship 0.5 mL frozen in a plastic vial. | 0.1 mL | Hemolysis	NA Thawing	Warm reject, Cold reject Lipemia	NA Icterus	NA Other	NA | Units: ng/mL   Age		Range   Prepubertal  Fasting	30 - 100  Random	10 - 500   Pubertal  Fasting	20 - 200  Random	20 - 100   Adults  Fasting	10 - 150  Random	0 - 40   Test Performed By: Esoterix Endocrinology                              4301 Lost Hills Rd                              Calabasas Hills, CA 91301 | Monday, Thursday | 2-6 days | 4 - 13 days | 1 | 83519 |  |  |  |  | Esoterix Endocrinology
FIGBP | [NAME] | SRED | Serum Red |  |  |  | Frozen | 200 days
FIGBP | Result | Z2268 | IGFBP-1 | IGFBP-1 | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 12722-5
Spreadsheet: 41482d1239958722-employees-time-sheet-employee-time-sheet
Sheet: Sheet3

[NAME] – 1
Employees Time sheet
Month | Time In | Break Out | Break In | Lunch Out | Lunch In | Break Out | Break In | Time Out | Total Hours | Worked Hours
Monday | 07:10:00 | 08:30:00 | 09:00:00 | 13:00:00 | 13:35:00 | 15:45:00 | 16:05:00 | 19:00:00 | 11.83333333333333 | 10.41666666666667
Tuesday | 07:20:00 | 08:35:00 | 08:55:00 | 12:30:00 | 13:00:00 | 15:25:00 | 16:10:00 | 18:45:00 | 11.41666666666667 | 9.833333333333334
Wednesday | 07:05:00 | 08:40:00 | 09:15:00 | 12:35:00 | 13:10:00 | 15:40:00 | 16:15:00 | 18:35:00 | 11.5 | 9.750000000000004
Thursday | 08:25:00 | - | - | 12:30:00 | 13:05:00 | 15:45:00 | 16:00:00 | 17:30:00 | 9.083333333333332 | 8.25
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173349 | 404769.92
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -64826 | -174057.81
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 43.25
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: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -173349 | -465442.07 | 64826 | 174057.81
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173349 |  | 64826
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: 880279d1727897402-changing-the-range-when-dragging-a-formula-pto-tracker-example-1-
Sheet: PTO BALANCES - All Providers

PM | [NAME] | DATA | October | November | December | January | February | March | April | May | June | July | August | September | TOTAL HOURS USED | TOTAL REMAINING (FROM TRACKER)
 | Provider 1 | Hours Used Per Month
 |  | PTO Remaining Balance
 | Provider 2 | Hours Used Per Month
 |  | PTO Remaining Balance
 | Provider 3 | Hours Used Per Month
 |  | PTO Remaining Balance
 | Provider 4 | Hours Used Per Month
 |  | PTO Remaining Balance
 | Provider 5 | Hours Used Per Month
 |  | PTO Remaining Balance
 | Provider 6 | Hours Used Per Month
 |  | PTO Remaining Balance
I have a formula built in for provider 1 in cell [NAME] to pull in the monthly data from the actual tracker, I would like to be able to drag the formula across so I do not have to build the formula for every provider/every month.  I'm just not sure how to copy the range correctly
 |  |  | 2
 |  |  | 4
 |  |  | 6
Spreadsheet: 38806d1236953563-conditional-formatting-mearsy1
Sheet: Sheet1

Plant | Customer Service Measure
Barking | 0.9157734204793029
Ipswich | 0.8996061643835617
[NAME] | 0.8879028436018958
Aberdeen | 0.8856862745098039
Wolves | 0.8688521882741536
Brinsworth | 0.8544619105199516
CLS | 0.8507983193277311
Crawley | 0.781469465648855
Totton | 0.8692936802973977
Bristol | 0.7800200400801603
Plymouth | 0.8
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: ENA_Summary Output

Unhide Sub Debt, 1999 Columns
[NAME] SUMMARY OUTPUT
SOURCES & USES:
Sources of Funds | % | 000 $ |  | Uses of Funds | % | 000 $
Total Equity |  |  |  | 1999 Plants
Bond Proceeds |  |  |  | 2000 Plants
Sub Total |  |  |  | Sub Total
Power Contract Liability |  |  |  | Power Contract Liability
Total Sources |  |  |  | Total Uses
FINANCING ASSUMPTIONS:
 | Tranche 1 | Tranche 2 | Tranche 3 | Total
Debt Financing Summary:
Debt Closing Date | 2001-01-01 00:00:00
Amount ('000 $) | 50000 | 210000 | 475000
Term (yrs)
Final Maturity | 2003-12-31 00:00:00 | 2010-12-31 00:00:00 | 2020-12-31 00:00:00
Average Life (yrs)
Treasury Rate (%) | 0.068 | 0.065 | 0.062
Spread (%) | 0.0225 | 0.045 | 0.05
All-in Coupon Rate (%)
Interest Income Rate | 0.05
Equity Financing Summary:
Equity Closing Date | 2001-01-01 00:00:00
Amount ('000 $) | 577000
Required After-Tax Rate of Return (%) | 0.14
DEPRECIATION ASSUMPTIONS:
 | Initial Basis (000 $)
 | 1999 | 2000 | Year | Method | Residual (%)
Federal & State Tax Depreciation
Total Project Cost less Power Contract Liability |  |  | 15 | MACRS | 0
Book Depreciation
Total Project Cost |  |  | 30 | SL | 0.1
SUMMARY OUTPUT:
DSCR |  |  | Min | [NAME].
Fixed Price Period
Merchant Price Period
 |  |  | 1999 Projects | 2000 Projects | 1999 & 2000 Projects
Weighted Average Heat Rate (Btu/kWh)
Summer Capacity (MW)
Salvage Value (2 x EBITDA) at the end of 20 years ($/kW)
Equity's After-Tax Returns with Salvage Value (20 yrs)
 | 2001 | 2002 | 2003 | 2004 | 2005
GenCo EBITDA (000 $)
GenCo Net Income (000 $)
[NAME] (000 $)
GenCo After-Tax Cashflow (000 $)
Spreadsheet: 153615d1335974290-excel-2007-handling-duplicates-with-index-match-excel-help-needed
Sheet: Sheet1

Key Systems | # instances
system 1 | 17
system 2 | 17 |  | System
system 3 | 17 |  | Instances
system 4 | 0
system 5 | 0
system 6 | 0
system 7 | 22
system 8 | 1 |  |  |  |  |  |  | should be system 2 &3
system 9 | 0
system 10 | 16
system 11 | 0
system 12 | 20
system 13 | 0
system 14 | 0
system 15 | 0
system 16 | 0
system 17 | 5
system 18 | 0
system 19 | 0
system 20 | 0
system 21 | 7
system 22 | 0
system 23 | 0
system 24 | 0
system 25 | 8
system 26 | 0
system 27 | 0
system 28 | 0
system 29 | 0
system 30 | 0
system 31 | 0
system 32 | 0
system 33 | 0
system 34 | 0
system 35 | 0
system 36 | 0
system 37 | 0
system 38 | 0
system 39 | 0
system 40 | 0
system 41 | 0
system 42 | 0
system 43 | 19
system 44 | 1
system 45 | 4
system 46 | 0
system 47 | 0
system 48 | 0
system 49 | 0
Spreadsheet: 879540d1727112130-need-help-to-bifurcate-number-of-days-year-wise-from-date-ranges-based-on-criteria-count-number-of-days
Sheet: Sheet2

Employee ID |  |  |  |  |  |  |  | Leave Type | From Date | To Date | 2020 |  | Status
86920 |  |  |  |  |  |  |  | EL | 2023-08-07 00:00:00 | 2023-08-09 00:00:00 |  |  | APPROVED |  | In Excel Sheet1 there is Employee ID in Cell I6. From Cell E37 to Cell I37 Contains Years in YYYY manner. In Cell D39 and In Cell D40 there is Leave Type I.e. SL and EL. In Sheet2 there is Employee ID in Column A from Cell A2 onwards, In Column I There are Leave Type, In Column J and Column K Respectively contains [NAME] dates and [NAME]. And in Column N Contains Leave Status Whether It is Approved or Cancelled or Rejected etc. I Want to Count Employee ID wise Total Numbers of Approved Leaves in Sheet1 Based on Leave Type and Year wise. In Column L I have try formula but it gives only Cell Wise results. I expect the Standalone formula without helper column to achieve the desired results.
86920 |  |  |  |  |  |  |  | SL | 2023-09-04 00:00:00 | 2023-09-16 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2024-03-05 00:00:00 | 2024-03-16 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2023-12-26 00:00:00 | 2024-01-14 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | SL | 2023-09-04 00:00:00 | 2023-09-14 00:00:00 |  |  | REJECTED
86920 |  |  |  |  |  |  |  | SL | 2021-05-17 00:00:00 | 2021-05-29 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2022-05-16 00:00:00 | 2022-05-21 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2019-12-19 00:00:00 | 2020-01-12 00:00:00
Spreadsheet: 102171d1300190229-draft-day-registration-help-team-draft2
Sheet: Partners

Team | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8
Messages
1
Spreadsheet: 851167d1701380145-timesheet-complex-formuals-help-doc
Sheet: Lists

 | LISTS
 | Days of Week |  |  |  | 2023 Vic Public Holiday
 | Monday |  |  |  | 2023-01-02 00:00:00 | New Years
 | Tuesday |  |  |  | 2023-01-26 00:00:00 | Australia Day
 | Wednesday |  |  |  | 2023-03-13 00:00:00 | Labour Day
 | Thursday |  |  |  | 2023-04-07 00:00:00 | Good Friday
 | Friday |  |  |  | 2023-04-08 00:00:00 | Holy Saturday
 | Saturday |  |  |  | 2023-04-09 00:00:00 | Easter Sunday
 |  |  |  |  | 2023-04-10 00:00:00 | Easter Monday
 |  |  |  |  | 2023-04-25 00:00:00 | Anzac Day
 |  |  |  |  | 2023-06-12 00:00:00 | Kings Birthday
 |  |  |  |  | 2023-09-29 00:00:00 | AFL Grand Final
 |  |  |  |  | 2023-11-07 00:00:00 | Melbourne Cup
 |  |  |  |  | 2023-12-25 00:00:00 | Christmas Day
 |  |  |  |  | 2023-12-26 00:00:00 | Boxing Day
Spreadsheet: 75403d1275992758-sumif-or-it-might-be-something-else-sumif
Sheet: Sheet1

Cleint No. | due amount
43051 | 0.067
43051 | 20
43186 | 10
46347 | 10
48053 | 40
90002988 | 164.81
94000068 | 61.761
94000068 | 29.5
94000068 | 29.5
94000068 | 40.71
94000068 | 1
94000079 | 65.709
94000079 | 63
94000079 | 63
94000079 | 63.8
94000106 | 63.961
94000106 | 60.077
94000106 | 75
94000106 | 49.5
94000106 | 49.5
94000162 | 0.05
94000162 | 26.769
94000162 | 16.073
94000162 | 65
94000162 | 15.25
94000162 | 15.25
94000174 | 15.25
94000174 | 15.25
94000174 | 75
94000174 | 15.25
94000174 | 65
94000174 | 30.55
94000315 | 2.5
94000315 | 2.277
94000315 | 14.121
94000315 | 9.463
94000315 | 2.5
94000362 | 63.21
94000362 | 104.485
94000362 | 9
94000546 | 10.5
94000546 | 102.886
94000546 | 21.768
94000546 | 40.535
94000558 | 28.63
94000558 | 14.5
94000558 | 14.5
94000558 | 37.506
94000558 | 100
94000592 | 3
94000592 | 3
94000592 | 8.368
94000592 | 3
94000592 | 3
94000684 | 3.25
94000684 | 2.5
94000684 | 2.5
94000684 | 2.5
94000684 | 2.5
94000685 | 2.5
94000685 | 2.5
94000685 | 2.5
94000685 | 3.25
94000685 | 2.5
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 109647 | 107420
2 | 92682 | 92009
3 | 119934 | 117811
4 | 118073 | 120448
5 | 125154 | 123014
6 | 148315 | 149289
7 | 121730 | 120413
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-01-31 00:00:00 |  |  | -32211
2001-02-07 00:00:00
Spreadsheet: benjamin_rogers__1244__Simple Cycle (LM6000) Entergy model
Sheet: Revised Debt

 |  | (000's)
 | Total Project Cost
 | Total Debt
 | [NAME] (yrs)
 | Debt (%)
 | Equity (%)
 | Rate (%) | 0.07
 | Princ Amort Sched (yrs) | 30
 | Equity ($)
 | Capacity (MW)
 | Capacity Pmt ($/kw-mo)
 | Principal Balance
 | Payment
 | Interest Payment
 | Principal Payment
 | EBITDA
 | DSCR
 | Average
 | Min
Spreadsheet: 860446d1708533368-calculating-drawdowns-and-total-returns-drawdown-test
Sheet: Sheet1

 | Returns |  |  | Base 100 |  |  | [NAME]
Date | Fund 1 | Fund 2 |  | Fund 1 | Fund 2 |  | Fund 1 | Fund 2
2018-01-01 00:00:00 |  |  |  | 100 | 100
2018-02-01 00:00:00 |  | 0.078
2018-03-01 00:00:00 |  | 0.034
2018-04-01 00:00:00 |  | 0.046
2018-05-01 00:00:00 | -0.006 | -0.03
2018-06-01 00:00:00 | 0.063 | -0.007
2018-07-01 00:00:00 | -0.052 | -0.078
2018-08-01 00:00:00 | 0.087 | -0.07
2018-09-01 00:00:00 | -0.031 | 0.061
2018-10-01 00:00:00 | 0.092 | 0.064
2018-11-01 00:00:00 | -0.06 | -0.028
2018-12-01 00:00:00 | 0.005 | -0.073
2019-01-01 00:00:00 | -0.005 | 0.052
2019-02-01 00:00:00 | 0.06 | 0.082
2019-03-01 00:00:00 | 0.099 | 0.029
2019-04-01 00:00:00 | -0.06 | -0.003
2019-05-01 00:00:00 | 0.02 | -0.058
2019-06-01 00:00:00 | -0.027 | -0.022
2019-07-01 00:00:00 | 0.018 | -0.013
2019-08-01 00:00:00 | -0.087 | -0.017
2019-09-01 00:00:00 | 0.055 | 0.099
2019-10-01 00:00:00 | 0.093 | 0.051
2019-11-01 00:00:00 | 0.071 | 0.029
2019-12-01 00:00:00 | -0.054 | 0.007
2020-01-01 00:00:00 | 0.016 | -0.031
2020-02-01 00:00:00 | -0.094 | -0.053
2020-03-01 00:00:00 | 0.046 | 0.034
2020-04-01 00:00:00 | 0.033 | -0.035
2020-05-01 00:00:00 | 0.012 | -0.063
2020-06-01 00:00:00 | 0.016 | -0.057
2020-07-01 00:00:00 | -0.069 | -0.085
2020-08-01 00:00:00 | -0.098 | -0.026
2020-09-01 00:00:00 | -0.075 | -0.091
2020-10-01 00:00:00 | 0.097 | 0.016
2020-11-01 00:00:00 | -0.019 | 0.01
2020-12-01 00:00:00 | -0.098 | 0.029
2021-01-01 00:00:00 | -0.05 | -0.054
2021-02-01 00:00:00 | 0.075 | -0.093
2021-03-01 00:00:00 | 0.085 | 0.028
2021-04-01 00:00:00 | 0.026 | 0.077
2021-05-01 00:00:00 | -0.064 | -0.008
2021-06-01 00:00:00 | -0.065 | 0.043
2021-07-01 00:00:00 | -0.052 | -0.053
2021-08-01 00:00:00 | 0.071 | -0.024
2021-09-01 00:00:00 | 0.035 | 0.017
2021-10-01 00:00:00 | 0.051 | -0.063
2021-11-01 00:00:00 | 0.076 | 0.048
2021-12-01 00:00:00 | -0.005 | 0.094
2022-01-01 00:00:00 | 0.042 | -0.036
2022-02-01 00:00:00 | -0.008 | 0.045
2022-03-01 00:00:00 | 0.001 | -0.025
2022-04-01 00:00:00 | -0.008 | 0.082
2022-05-01 00:00:00 | -0.061 | -0.076
2022-06-01 00:00:00 | 0.003 | 0.005
2022-07-01 00:00:00 | -0.008 | 0.099
2022-08-01 00:00:00 | 0.02 | -0.049
2022-09-01 00:00:00 | -0.027 | -0.015
2022-10-01 00:00:00 | 0.019 | -0.01
2022-11-01 00:00:00 | 0.068 | 0.03
2022-12-01 00:00:00 | -0.041 | -0.046
2023-01-01 00:00:00 | 0.083 | 0.048
2023-02-01 00:00:00 | -0.072 | -0.079
2023-03-01 00:00:00 | -0.078 | -0.061
2023-04-01 00:00:00 | 0.046 | 0.002
2023-05-01 00:00:00 | 0.054 | -0.045
2023-06-01 00:00:00 | 0.096 | 0.023
2023-07-01 00:00:00 | 0.018 | 0.075
2023-08-01 00:00:00 | -0.044 | 0.035
2023-09-01 00:00:00 | 0.089 | -0.093
2023-10-01 00:00:00 | 0.097 | -0.013
2023-11-01 00:00:00 | -0.003 | 0.04
2023-12-01 00:00:00 | -0.078 | 0.098
Spreadsheet: 812096d1672944848-need-if-statement-to-check-text-sample-if-statement_etaf
Sheet: Sheet1

Site 1 | Site 2 | Site 3 | Site 4 | Site 5 | Site 6 | Site 7 | Site 8 | Site 9 | Site 10 | Site 11 | Site 12 | Site 13 | Site 14 | IF Function to check if column A to N does not contain any Yes or Yes.., return 1, otherwise show blank. | If column A to N contains ONLY Yes or Yes.., return 1, otherwise show blank
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Yes, sometimes | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | No | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | Yes | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Yes
Yes | 0 | #N/A | #N/A | 0 | Yes, trained | #N/A | No | No | Yes | #N/A | Yes | #N/A | Yes
No | #N/A | #N/A | Yes, train at other sites | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Unsure | #N/A | #N/A | #N/A
Spreadsheet: 137878d1327419055-two-dimentional-search-for-non-exact-results-prova
Sheet: Foglio1

2100 | 1520
 | 0 | 915 | 1120 | 1830 | 2135
 | 305 | 1 | 2 | 3 | 4
 | 610 | 2.25 | 3.25 | 4.25 | 5.25
 | 1525 | 3.5 | 4.5 | 5.5 | 6.5
 |  | 6.5
Spreadsheet: 759263d1639464421-generating-multiple-arrays-inside-array-array_issue
Sheet: Array

[NAME] |  | This Array Formula
[NAME] |  |  | → | ROW(INDIRECT("1:"&LEN(A1)))
Shank |  | Results into {1,2,3,4} |  | Ctrl + Shift + Enter
Sid
[NAME]
[NAME] |  | Now
 |  |  | → | LEN(A1:A6)
 |  | Returns {4;7;5;3;6;5} |  | Ctrl + Shift + Enter
 |  | Combining those two formula
 |  |  |  | ROW(INDIRECT("1:"&LEN(A1:A6)))
 |  |  |  | Ctrl + Shift + Enter
 |  |  |  | Doesn't return desired result
 |  |  |  | DESIRED RESULT
 |  |  |  | {1,2,3,4;1,2,3,4,5,6,7;1,2,3,4,5;1,2,3;1,2,3,4,5,6;1,2,3,4,5}
 |  |  |  |  | 2 | 3 | 4
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | 1 | 2 | 3
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 196987d1354179598-min-max-axis-options-issue-880000
Sheet: 2006

Artist | [NAME] | [NAME] | Weeks Charted
Rascal Flatts | What Hurts the Most | 03:34:00 | 46
The Fray | How to Save a Life | 04:23:00 | 36
Snow Patrol | Chasing Cars | 04:28:00 | 31
[NAME] | Sexy Back | 04:03:00 | 24
Hinder | Lips of an Angel | 04:22:00 | 23
[NAME] | Waiting on the World to Change | 03:21:00 | 23
Nickelback | Far Away | 03:58:00 | 22
Stone Sour | Through [NAME] | 04:43:00 | 20
Jibbs | Chain Hang Low | 03:28:00 | 20
[NAME] (feat. Pharrell) | Money Maker | 03:51:00 | 19
Spreadsheet: 740248d1626254847-formula-to-look-up-how-many-records-there-are-for-a-serial-number-on-a-certain-date-find-date
Sheet: Month Chart

No | S NO | Worker name | 15-Jun | 16-Jun | 17-Jun | 18-Jun | 19-Jun | 20-Jun | 21-Jun | 22-Jun | 23-Jun | 24-Jun | 25-Jun | 26-Jun | 27-Jun | 28-Jun | 29-Jun | 30-Jun | 1-Jul | 2-Jul | 3-Jul | 4-Jul | 5-Jul | 6-Jul | 7-Jul | 8-Jul | 9-Jul | 10-Jul | 11-Jul | 12-Jul | 13-Jul | 14-Jul | 15-Jul
1 | S_001754 | Yunash khan
2 | S_000898 | [NAME]
3 | S_001641 | Farook [NAME]
4 | S_001673 | [NAME]
5 | S_001702 | [NAME] Ameer
6 | S_001762 | [NAME]
7 | S_001900 | [NAME]
8 | S_001979 | [NAME]
9 | S_002013 | [NAME]
10 | S_002014 | Fateh Fateh Farook
11 | S_002039 | Naushad Alam Idu Ansari
12 | S_000716 | [NAME]
13 | S_001023 | [NAME]
14 | S_002015 | [NAME]
15 | L_052689 | [NAME]
16 | S_001905 | Shawkat
17 | S_001532 | [NAME]
18 | S_001401 | Asif
19 | S_002050 | [NAME]
20 | S_001978 | [NAME]
21 | S_002012 | [NAME]
22 | S_001483 | Mallikarjun subhash subhash.
23 | S_002011 | [NAME]
24 | S_000275 | Rajendra
Spreadsheet: 765702d1643523296-find-words-with-letter-interchange-vowel-exchange
Sheet: Sheet1

NOTAIRE |  | s | 1 | AEINORT
OTARINE |  |  | 2 | AEINORT
ETAERIO |  | s | 3 | AEEIORT
ANEROID |  | s | 4 | ADEINOR
AILERON | t | s | 5 | AEILNOR
ALERION |  | s | 6 | AEILNOR
ALIENOR |  | s | 7 | AEILNOR
ELATION | dgr | s | 8 | AEILNOT
TOENAIL |  | s | 9 | AEILNOT
ERASION |  | s | 10 | AEINORS
ATONIES |  |  | 11 | AEINOST
OARIEST | hr |  | 12 | AEIORST
OTARIES | [NAME] |  | 13 | AEIORST
ROASTIE |  | s | 14 | AEIORST | NEW IN CSW15
SKREIGH |  | s | 21463 | EGHIKRS |  | Y
SKRIEGH |  | s | 21464 | EGHIKRS |  | Y
Spreadsheet: 874684d1721225970-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Due Solution

Pay Cycle | Amount Due
1
2 |  | 88.49
3 |  | 0
4 |  | 88.49
5 |  | 117.48
6 |  | 0
7 |  | 119.44
8 |  | 0
9 |  | 132.43
10 |  | 0
11 |  | 71.3
12 |  | 0
13 |  | 71.3
14 |  | 117.48
Spreadsheet: 91007d1290691605-sumifs-hlookup-help-test
Sheet: Summary

 | Project Name | How many total hours currently assigned tothe project | how many actual hours worked on project
 | GCC 1
 | BCC 1
 | GCC 2
 | BCC 2
 | GCC 3
 | BCC 3
Spreadsheet: 163581-help-with-moving-multiple-columns-and-checking-alignment-sheet3
Sheet: Sheet3

Number | Name | Standard | List Parent | Score
22648 | student 1 | EN.9.1.1 | EN.9.1 | 1
22648 | student 1 | EN.9.1.2 | EN.9.1 | 1
22648 | student 1 | EN.9.1.3 | EN.9.1 | 1
22648 | student 1 | EN.9.1.4 | EN.9.1 | 0
22955 | student 2 | EN.9.1.1 | EN.9.1 | 3
22955 | student 2 | EN.9.1.2 | EN.9.1 | 3
22955 | student 2 | EN.9.1.3 | EN.9.1 | 2
22955 | student 2 | EN.9.1.4 | EN.9.1 | 2
22966 | student 3 | EN.9.1.1 | EN.9.1 | 1
22966 | student 3 | EN.9.1.2 | EN.9.1 | 1
22966 | student 3 | EN.9.1.3 | EN.9.1 | 1
22966 | student 3 | EN.9.1.4 | EN.9.1 | 2
22969 | student 4 | EN.9.1.1 | EN.9.1 | 1
22969 | student 4 | EN.9.1.2 | EN.9.1 | 1
22969 | student 4 | EN.9.1.3 | EN.9.1 | 1
22969 | student 4 | EN.9.1.4 | EN.9.1 | 1
23343 | student 5 | EN.9.1.1 | EN.9.1 | 1
23343 | student 5 | EN.9.1.2 | EN.9.1 | 1
23343 | student 5 | EN.9.1.3 | EN.9.1 | 1
23500 | student 6 | EN.9.1.1 | EN.9.1 | 1
23500 | student 6 | EN.9.1.2 | EN.9.1 | 2
23500 | student 6 | EN.9.1.3 | EN.9.1 | 2
23500 | student 6 | EN.9.1.4 | EN.9.1 | 3
23502 | student 7 | EN.9.1.3 | EN.9.1 | 2
23503 | student 8 | EN.9.1.2 | EN.9.1 | 2
23503 | student 8 | EN.9.1.3 | EN.9.1 | 1
25320 | student 9 | EN.9.1.1 | EN.9.1 | 2
25320 | student 9 | EN.9.1.2 | EN.9.1 | 1
25320 | student 9 | EN.9.1.3 | EN.9.1 | 1
25320 | student 9 | EN.9.1.4 | EN.9.1 | 1
Spreadsheet: 847835d1698680791-moving-cell-values-in-the-first-column-demo-problem
Sheet: Sheet1

 | Unique number | Drug A | Drug B | Drug C | Drug D
 | 123 | I
 | 456 |  | Me
 | 789 |  |  |  | Yours
 | 1011 |  |  | MY
 | 1212 | Theirs |  |  | Another