tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863936d1711326785-data-relocation-from-worksheet-to-worksheet-excel-sample-question
Sheet: Vince Cats

 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
 |  |  | Total
 | Type | Date | Payee | Description | Amount
Spreadsheet: 799120d1664939758-linking-sheets-with-indirect-not-working-audit-schedule-iatf-2022
Sheet: QUARTER1  (2)

 | IATF 16949 Internal Audit Schedule
 | Month: Jan ,Feb,March 2022 |  | Doc No.APO4:440:04
Sl | Process | Auditor | Date of Audit | Shift
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Prepared by |  | Approved by | Date of Issue
 | Rev:01 July 2017     *Scope of Audit as per deptt. wise  applicable  clauses list
Spreadsheet: 294fdb44-b293-4ef0-9086-b1f12bc19504
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | 6" Dormant & RTF Azalea Trees 2009/2010 | Unnamed: 5 | Unnamed: 6 | SIZE | Unnamed: 8 | Unnamed: 9 | PACK | MIN.
 |  |  |  |  |  |  | Circle Product Form
 |  |  |  |  |  |  | 6" Tree Dormant |  |  | 8 | 8
 |  |  |  |  |  |  | 6" Tree RTF |  |  | 8 | 8
 |  |  |  |  |  |  | Check for Holiday Crop
2009-06-22 00:00:00 |  |  |  |  |  |  | Mother's Day |  | Valentines Day |  | Easter
ORDER TYPE |  | REASON CODE |  |  | REFERENCE          ORDER # |  | SALES ORG. | ORDER # |  |  | ONE DATE PER ORDER
DISTRIB.# & NAME |  |  |  |  |  | SHIP TO #
SOLD TO # & NAME |  |  |  |  |  | SHIP TO NAME
STREET, CITY STATE & ZIP |  |  |  |  |  | STREET, CITY                  STATE & ZIP
PHONE # |  |  |  |  |  | PHONE #
SALES REP # & NAME |  |  | P.O. # |  |  | VISA / MC / DISC |  | CARDHOLDER NAME
ARE SUBS OK? | IF NO, PHONE |  | WEEK  WANTED |  |  | CREDIT CARD NUMBER / CCV# |  |  |  | EXP DATE
 | CUST
YES / NO | DIST |  | ORDER INFO |  |  | SHIP VIA:
 | SLSM
16 Month Lead Time - Otherwise Subject to Availability
VARIETY NAME |  |  |  |  |  | QUANTITY | COLOR
HONESTY (USPP #12054) |  |  |  |  |  |  | PURE WHITE
PROMISE (USPP #11920) -- will be discarded 2/1/2010 |  |  |  |  |  |  | PURPLE
REMEMBRANCE (USPP #9123) |  |  |  |  |  |  | DK PINK
ROZALEA® CORAL (USPPAF) |  |  |  |  |  |  | CORAL
ROZALEA® CORAL PINK (USPP #16499) |  |  |  |  |  |  | CORAL PINK
SCARLET (USPP #13073) |  |  |  |  |  |  | RED
TOTAL ORDER QUANTITY |  |  |  |  |  | 0
PLACED VIA:                    PHONE / FAX / EMAIL |  | CUSTOMER: |  | SALES REP: |  | DISTRIBUTOR: |  | TAKEN BY / DATE:
Spreadsheet: 462589d1464107897-sumproduct-to-rank-values-but-ignore-blanks-sumproduct-to-ignore-blanks
Sheet: top line oview working

Categories | Australia | Canada | China | India | Italy | Korea | Mexico | Netherlands | Nigeria | South Africa | Spain | Grand Total
Economic | 3 |  |  | 2 | 2 | 3 | 1 | 6 | 1 |  | 14 | 32
[NAME] |  |  |  | 1 |  | 15 |  | 4 | 1 |  | 1 | 22
Demographics | 2 | 2 |  | 2 |  |  | 1 | 3 | 1 | 1 | 7 | 19
Census | 1 |  | 1 |  | 1 |  |  | 8 | 1 | 1 | 4 | 17
Geo Spatial location | 2 |  |  | 1 | 1 | 6 | 1 | 3 | 1 |  | 1 | 16
Financial |  | 2 |  | 3 | 1 | 3 |  | 4 | 1 |  |  | 14
Macroeconomic |  |  |  |  |  | 2 |  | 6 | 1 |  |  | 9
Expenditure |  |  |  | 2 | 1 |  | 1 |  | 1 | 1 | 3 | 9
Weather | 1 |  |  | 1 | 1 | 1 |  | 1 | 1 |  | 1 | 7
Inventory |  |  |  |  |  | 6 |  |  | 1 |  |  | 7
Socioeconomic |  |  |  | 4 |  |  |  |  |  |  |  | 4
Behavioral |  |  |  |  | 1 | 1 |  |  | 1 |  | 1 | 4
Transactions |  |  |  |  |  | 2 |  |  | 1 |  |  | 3
Psychographic |  |  |  | 1 |  |  |  | 1 | 1 |  |  | 3
Lifestyle and media |  | 1 |  |  |  |  |  |  |  |  |  | 1
Business |  |  |  |  | 1 |  |  |  |  |  |  | 1
Real Estate |  |  |  |  | 1 |  |  |  |  |  |  | 1
Business locations |  | 1 |  |  |  |  |  |  |  |  |  | 1
Consumer Medical & Health |  |  |  | 1 |  |  |  |  |  |  |  | 1
Grand Total | 9 | 6 | 1 | 18 | 10 | 39 | 4 | 36 | 13 | 3 | 32 | 171
categories | Australia | Canada | China | India | Italy | Korea | Mexico | Netherlands | Nigeria | South Africa | Spain
Economic
[NAME]
Demographics
Census
Geo Spatial location
Financial
Macroeconomic
Expenditure
Weather
Inventory
Socioeconomic
Behavioral
Transactions
Psychographic
Lifestyle and media
Business
Real Estate
Business locations
Consumer Medical & Health
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: SETTINGS

N° Client | Location | Name | Path | Sheet Name
1 | Paris |  |  | PMarcP
2 | Paris | ALFRED | PriceALPa | PAlfredP
3 | Paris | PIERRE | PricePIPa | PPierreP
1 | London | MARC | PriceMALo | PMarcL
2 | London | ALFRED | PriceALLo | PAlfredL
3 | London | PIERRE | PricePILo | PPierreL
Spreadsheet: 584449d1533197486-matching-3-data-and-getting-result-in-f-column-which-is-a-running-balance-test-match
Sheet: Sheet1

 |  | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
 |  | XL0123 | ABC | 35000 |  | 4500
 |  | AB1261 | DWKING | 45600 |  | 25000
 |  | XL0123 | ABC | 35000 |  | 15800 |  | Matching should be done for Data 1,Data2 & Data 3
 |  | AB1261 | DWKING | 45600 |  | 20600
 |  | XL0123 | ABC | 35000 |  | 14700
Spreadsheet: 221793d1363671321-count-unique-value-unique-count-query
Sheet: Summary

 |  | CODE | TYPE | Unique ID Count
 |  | 1 | CLG-ST |  | ?
 |  | 1 | NON-CLG |  | ?
 |  | 2 | CLG-ST |  | ?
 |  | 2 | NON-CLG |  | ?
 |  | 3 | CLG-ST |  | ?
 |  | 3 | NON-CLG |  | ?
 |  | 4 | CLG-ST | 80 | <--Sample Answer, mannual calculation) - When CODE is 4 and Type CLG-ST, the unique ID count is 80 (which is removed duplicate IDs)
 |  | 4 | NON-CLG | 16 | <--Sample Answer, mannual calculation) - When CODE is 4 and Type NON-CLG, the unique ID count is 16 (which is removed duplicate IDs)
 |  | 5 | CLG-ST |  | ?
 |  | 5 | NON-CLG |  | ?
 |  | 6 | CLG-ST |  | ? |  |  |  | CLG-ST
 |  | 6 | NON-CLG |  | ? |  |  |  | NON-CLG
 |  | 7 | CLG-ST |  | ?
 |  | 7 | NON-CLG |  | ?
 |  | 8 | CLG-ST |  | ?
 |  | 8 | NON-CLG |  | ?
 |  | 9 | CLG-ST |  | ?
 |  | 9 | NON-CLG |  | ?
 |  | 11 | CLG-ST |  | ?
 |  | 11 | NON-CLG |  | ?
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  | February |  | March |  | April
 |  |  | 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 |  | Cost of Inventory |  |  |  |  |  | 14142946 |  | -8292154
4 |  | Inventory Profit
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: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | 3rd Party Revenues |  |  |  |  |  |  |  | 150679 |  | -53846
 | 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 |  | Net MTM Income |  |  |  |  |  | -14142946 |  | 14833216 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Fuel |  |  |  |  |  |  |  | -3
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  | -376583
37 |  | Tx. Desk Peaking Charge
38 |  | Ad Valorem Taxes |  |  |  |  |  |  |  | -89995
39 |  | Royalty |  |  |  |  |  |  |  | -89144
40 |  | Miscellaneous |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
Spreadsheet: joe_parks__14886__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-14 00:00:00
From the Waha Area | 300000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 791078d1660144162-add-all-choice-to-dropdown-list-sample
Sheet: Income

Income Name | Income Alias | Date | From | Deposit To | Amount
Income1 | Jan1 | 2022-01-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | Jan1 | 2022-01-03 00:00:00 | Payor2 | Bank2 | 1916
Income2 | Jan2 | 2022-01-13 00:00:00 | Payor3 | Bank2 | 938.97
Income2 | Jan2 | 2022-01-27 00:00:00 | Payor3 | Bank2 | 1103.39
Income3 | Jan3 | 2022-01-04 00:00:00 | Payor4 | Bank3 | 69.5
Income3 | Jan3 | 2022-01-19 00:00:00 | Payor5 | Bank2 | 38.48
Income1 | [NAME] | 2022-02-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | [NAME] | 2022-02-03 00:00:00 | Payor2 | Bank2 | 1916
Income2 | Feb2 | 2022-02-09 00:00:00 | Payor3 | Bank2 | 1277.95
Income2 | Feb2 | 2022-02-24 00:00:00 | Payor3 | Bank2 | 1178.21
Income3 | Feb3 | 2022-02-07 00:00:00 | Payor4 | Bank3 | 69.5
Income1 | Mar1 | 2022-03-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | Mar1 | 2022-03-03 00:00:00 | Payor2 | Bank2 | 1916
Income2 | Mar2 | 2022-03-10 00:00:00 | Payor3 | Bank2 | 1570.96
Income2 | Mar2 | 2022-03-24 00:00:00 | Payor3 | Bank2 | 1043.23
Income3 | Mar3 | 2022-03-08 00:00:00 | Payor4 | Bank3 | 69.5
Income3 | Mar3 | 2022-03-17 00:00:00 | Payor5 | Bank2 | 38.48
Income1 | Apr1 | 2022-04-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | Apr1 | 2022-04-01 00:00:00 | Payor2 | Bank2 | 1916
Income2 | Apr2 | 2022-04-07 00:00:00 | Payor3 | Bank2 | 1159.13
Income2 | Apr2 | 2022-04-21 00:00:00 | Payor3 | Bank2 | 1204.61
Income3 | Apr3 | 2022-04-01 00:00:00 | Payor6 | Bank2 | 126.07
Income3 | Apr3 | 2022-04-04 00:00:00 | Payor4 | Bank3 | 69.5
Income1 | May1 | 2022-05-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | May1 | 2022-05-01 00:00:00 | Payor2 | Bank2 | 1916
Income2 | May2 | 2022-05-05 00:00:00 | Payor3 | Bank2 | 1364.57
Income2 | May2 | 2022-05-19 00:00:00 | Payor3 | Bank2 | 890.63
Income3 | May3 | 2022-05-12 00:00:00 | Payor7 | Bank2 | 250
Income3 | May3 | 2022-05-09 00:00:00 | Payor4 | Bank3 | 73.1
Income3 | May3 | 2022-05-18 00:00:00 | Payor5 | Bank2 | 38.48
Income1 | Jun1 | 2022-06-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | Jun1 | 2022-06-03 00:00:00 | Payor2 | Bank2 | 1916
Income2 | Jun2 | 2022-06-02 00:00:00 | Payor3 | Bank2 | 1056.67
Income2 | Jun2 | 2022-06-15 00:00:00 | Payor3 | Bank2 | 1495.5
Income2 | Jun2 | 2022-06-30 00:00:00 | Payor3 | Bank2 | 1278.24
Income3 | Jun3 | 2022-06-06 00:00:00 | Payor4 | Bank3 | 73.1
Income3 | Jun3 | 2022-06-10 00:00:00 | Payor7 | Bank2 | 50
Income3 | Jun3 | 2022-06-25 00:00:00 | Payor7 | Bank2 | 108
Income1 | Jul1 | 2022-07-01 00:00:00 | Payor1 | Bank1 | 2165.52
Income1 | Jul1 | 2022-07-01 00:00:00 | Payor2 | Bank2 | 1916
Income3 | Jul3 | 2022-07-07 00:00:00 | Payor4 | Bank3 | 73.1
Spreadsheet: 834532d1687883507-need-formula-size-reduction-need-formula-size-reduction
Sheet: josephteh

 |  | Need formula size reduction
 |  | https://www.excelforum.com/excel-formulas-and-functions/1407898-need-formula-size-reduction.html
 |  | Date In | Date Out | Days | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Check
 |  | 2023-01-02 00:00:00 | 2023-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 if it's a weekday
 |  | 2023-01-29 00:00:00 | 2023-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-03 00:00:00 | 1
 |  | 2023-02-26 00:00:00 | 2023-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-04 00:00:00 | 1
 |  | 2023-04-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-05 00:00:00 | 1
 |  | 2023-11-01 00:00:00 | 2024-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-06 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-07 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-08 00:00:00 | 0
 |  | Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-09 00:00:00 | 1
 |  | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-10 00:00:00 | 1
 |  | End Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-11 00:00:00 | 1
 |  | Overlap Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-12 00:00:00 | 1
 |  | Adj Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-13 00:00:00 | 1
 |  | Adj End Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-14 00:00:00 | 0
 |  |  |  |  |  | [NAME]() |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-15 00:00:00 | 0
 |  | Original Incorrect Formula |  |  | IFERROR(@IF(ISBLANK([@[Date In]]),"",IFS(AND(MONTH([@[Date In]])=1,ISBLANK([@[Date Out]]),MONTH(TODAY())>1),NETWORKDAYS([@[Date In]],DATE(YEAR([@[Date In]]),1,31)),AND(MONTH([@[Date In]])=1,MONTH([@[Date Out]])>1),NETWORKDAYS([@[Date In]],DATE(YEAR([@[Date In]]),1,31)),AND(MONTH([@[Date In]])=1,MONTH([@[Date Out]])=1),NETWORKDAYS([@[Date [NAME] Out]]),AND(YEAR([@[Date Out]])>YEAR([@[Date In]]),MONTH([@[Date Out]])>1),NETWORKDAYS(DATE(YEAR([@[Date Out]]),1,1),DATE(YEAR([@[Date Out]]),1,31)),AND(YEAR([@[Date Out]])>YEAR([@[Date In]]),MONTH([@[Date Out]])=1),NETWORKDAYS(DATE(YEAR([@[Date Out]]),1,1),[@[Date Out]]),AND(YEAR([@[Date In]])=YEAR([@[Date Out]]),MONTH([@[Date In]])>1),"",AND(MONTH([@[Date In]])>1,ISBLANK([@[Date Out]])),"",AND(MONTH([@[Date In]])=1,ISBLANK([@[Date Out]]),MONTH(TODAY())=1),NETWORKDAYS([@[Date In]],TODAY())))-1,"")
 |  | Desired Formula
 |  | - Using LET
 |  | Month |  |  | m,COLUMNS($F$4:F$4)
 |  | Adj Start Date |  |  | s,DATE(YEAR($C5)+IF(AND(MONTH($C5)>=MONTH($D5),MONTH($C5)>m),1,0),m,1)
 |  | Adj End Date |  |  | e,DATE(YEAR($C5)+IF(AND(MONTH($C5)>=MONTH($D5),MONTH($C5)>m),1,0),m+1,0)
 |  | 1) Use regular cell references instead of table structured cell references
 |  | 2) Assuming "Date In" not included if it is a weekday
 |  | 3) Assuming duration < 1 year
Spreadsheet: 157363d1337708848-index-matching-with-reference-column-after-data-rolling-trends
Sheet: Aug

 |  |  | Month Ending 08/31/11 |  |  |  |  |  |  |  |  | Year To Date
 |  |  |  |  | [NAME] |  | Revenue: |  |  |  |  |  |  | [NAME]
 |  |  |  |  | From Budget |  |  |  |  |  |  |  |  | From Budget
 | Budget |  | Actual |  | Fav (Unfav) |  |  |  |  | Budget |  | Actual |  | Fav (Unfav)
 | 186472 |  |  |  |  |  | Patient Service Revenue |  |  | 372944
 |  |  |  |  |  |  | Other Income
 |  |  |  |  |  |  | Total Revenue
Spreadsheet: 593403d1539123804-find-and-mark-cells-with-words-2-characters-or-less-in-length-jtakwformula-example3
Sheet: Sheet1

Data | Does it have words 2 characters in length or less?
!! | Yes
!!! | No
Good boy was | No
He was a good boy | Yes
a dog | Yes
** | Yes
a, | Yes
about a boy | Yes
.. | Yes
… | No
2
33
999
Spreadsheet: 840864d1693074350-calculate-of-months-each-year-in-a-date-range-forum
Sheet: Sheet1

Start | End | # of Months | # of Months Each Year
Date | Date | to Forecast | 2023
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2023-07-31 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
Spreadsheet: 202605d1356642989-how-can-i-create-a-point-system-for-attendance-tardies-absents-etc-absent
Sheet: Sheet1

Employees | october |  |  | november |  |  |  | Total
 | Tardies | Excused Call-ins | Unexcused call-ins | Tardies | Excused call-ins | Unexcused call-ins
[NAME] | 0 | 1 | 2 | 3 | 2 | 6
[NAME] | 1 | 1 | 0 | 0 | 0 | 2
[NAME] | 4 | 2 | 1 | 1 | 1 | 1
Sue | 0 | 1 | 2 | 3 | 7 | 1
Spreadsheet: 56489d1256665219-conditional-formatting-working-improperly-conditional-formatting
Sheet: Sheet1

fedEx | FXNL | Old D | R+L | Conway |  | FXF | FXNL | Old D | R+L | Conway |  | fedEx | FXNL | Old D | R+L | Conway |  | FXF | FXNL | Old D | R+L | Conway
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
125.09 | 70 | 70 | 80 | 75.25 |  | 137.25 | 73.21600000000001 | 71.81599999999997 | 80 | 75.25 |  | 139.66 | 77.79199999999997 | 76.31200000000001 | 80 | 75.25 |  | 139.66 | 77.79 | 76.31 | 80 | 75.25
As seen here above,, I have done the conditional formatting function for A2:E2 and G2:K2 and it works the way I want it but I have a problem
I have over 43 thousand rows of data I need to do this to and the conditional formatting only works 1 section at a time for example G2:K2
each section has to be separate as some have different values for example G2:K2 verses M2:Q2 …..
My question is there a tool or formula that will make this process go faster in anyway??????Please help
Spreadsheet: 756602d1637665627-sum-of-time-based-on-multiple-criteria-sample-5-
Sheet: Sheet1

Month | Year | Live Presenter | Project Manager | Back up Project Manager | Minutes Project Manager | Prep & Wrap Minutes Project Manager | Minutes Backup Project Manager | Minutes Live Presenter
January | 2021 |  | [NAME] |  | 60 | 30
January | 2021 |  | [NAME] | [NAME] |  | 30 | 80
January | 2021 |  | [NAME] |  | 60 | 30
February | 2021 |  | [NAME] | [NAME] |  | 30 | 80
March | 2021 | [NAME] | [NAME] |  |  | 30 |  | 100
June | 2021 | [NAME] | [NAME] |  |  | 30 |  | 100
Spreadsheet: 809253d1670992074-attendance-tracker-pto-tracker-ex
Sheet: Jan list

Year
Month code: |  | 1
 |  |  | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5
 |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
line 1
line 2
line 3
line 4
line 5
line 6
line 1
line 2
line 3
line 4
line 5
line 6
line 1
line 2
line 3
line 4
line 5
line 6
line 1
line 2
line 3
line 4
line 5
line 6
line 1
line 2
line 3
line 4
line 5
line 6
line 1
line 2
line 3
line 4
line 5
line 6