tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2eb1e129-7b5c-494e-8e0c-52d24b03a74c
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Apr. 12 - Apr. 18, 2009
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-04-15 00:00:00 | 2009-04-17 00:00:00 | 2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 2009-04-15 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | - | - | -
 | Top (A) | 10326 | 17289 | 72821 | 10378 | 17286 | 30352 | - | - | -
 | Center (A) | 10329 | 17269 | 72830 | 10339 | 17260 | 30265 | - | - | -
 | Flat (A) | 10320 | 17286 | 72862 | 10349 | 17256 | 30256 | - | - | -
 | Left  (A) | 10352 | 17281 | 72863 | 10369 | 17264 | 30281 | - | - | -
 | Right (A) | 10346 | 17294 | 72928 | 10377 | 17277 | 30298 | - | - | -
 | Average (A) | 10335 | 17284 | 72861 | 10362 | 17269 | 30290 | - | - | -
 | [NAME]  (A) | 14 | 10 | 42 | 18 | 13 | 38 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 0.9s | 1.1s | 3.0s x2 | 1.0s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 2009-04-16 00:00:00
 | Top (H/V) (um) | 1/1 | 1.5/1.5 | 2.5/2.5 | 1/1 | 1.5/1.5 | 2/2
 | Center (H/V) (um) | 1/1 | 1.5/1.5 | 2.5/3 | 1/1.5 | 1.5/1.5 | 1.5/2
 | Flat (H/V) (um) | 1/1.5 | 1.5/2 | 2.5/2.5 | 1/1.5 | 1.5/1.5 | 2/2
 | Left (H/V) (um) | 1/1.5 | 2/2 | 2.5/3 | 1/1.5 | 1.5/1.5 | 1.5/2
 | Right (H/V) (um) | 1/1.5 | 2/2 | 3/2.5 | 1/1.5 | 1/1.5 | 1.5/2
 | Comments |  | overexposed
Spreadsheet: 852914d1702903575-bring-projects-names-based-on-month-and-agent-name-lista-bpo-2022-2023-2-aligw
Sheet: Sheet4

Luna | Marca | Nume | Regim Lucru | US | Pozitie | start date | end date | [NAME] conform raport lunar | Norma
2022-01-01 00:00:00 | 5289 | Avram [NAME] | 8 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-01 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 8
2023-01-01 00:00:00 | 6324 | [NAME] | 4 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-01-01 00:00:00 | 5289 | Avram [NAME] | 8 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-01 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 8
2023-01-01 00:00:00 | 6774 | [NAME] | 4 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-31 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-01-01 00:00:00 | 6316 | Tcaciuc Andreea Larisa | 8 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2023-11-30 00:00:00 | [NAME] | 8
2023-02-01 00:00:00 | 6324 | [NAME] | 4 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-02-01 00:00:00 | 5289 | Avram [NAME] | 8 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-01 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 8
2023-02-01 00:00:00 | 6774 | [NAME] | 4 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-31 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-02-01 00:00:00 | 6316 | Tcaciuc Andreea Larisa | 8 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2023-11-30 00:00:00 | [NAME] | 8
2023-03-01 00:00:00 | 6324 | [NAME] | 4 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-03-01 00:00:00 | 5289 | Avram [NAME] | 8 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-01 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 8
2023-03-01 00:00:00 | 6774 | [NAME] | 4 | Smartemp SA - Orange BPO Craiova | Agent servicii client(333907) | 2022-08-31 00:00:00 | 2024-02-29 00:00:00 | [NAME] | 4
2023-03-01 00:00:00 | 6316 | Tcaciuc Andreea Larisa | 8 | Smartemp SA - Orange BPO Bacau | Agent servicii client(333907) | 2022-06-17 00:00:00 | 2023-11-30 00:00:00 | [NAME] | 8
Spreadsheet: sally_beck__35041__MgmtSum-Q2-0501
Sheet: Headcount

PLAN2000 | ENRON NORTH AMERICA
TOT_COM_HC | 2ND QUARTER 2000 HEADCOUNT
TOT_NC_HC
2000-03-01 00:00:00
2000-04-01 00:00:00
M.QTD |  |  | Actuals - April Team Report |  |  |  | Plan - April |  |  |  | Variance to Plan
ENA | Business Team |  | Commercial | Other | Total |  | Commercial | Other | Total |  | Commercial | Other | Total
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
[NAME] | Financial Trading
CANADA | Canada Trading
COAL | Coal
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
DWNSTRM_IND_ORIG | Industrial Downstream - Paper
MDSTRM_IPP_ORIG | Midstream IPP
 | Canada Origination & Finance |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments
ASST_ORIG | ENA Upstream Assets
ASST_TRD | ENA Upstream Assets - Trading
 | Total Assets
EQUITY | Principal Investing
PROD_FIN | Energy Capital Services
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
GROUP
ACTUAL | Total
Spreadsheet: 861770d1709610542-how-to-compare-different-solutions-brands-and-extract-specific-ones-extraction_v-dj
Sheet: Feuil PQ

Índice | Unique solutions
1 | APEX Analytix
2 | Accrualify
3 | Allocation
4 | Analytics8 SpendView
5 | AppZen
6 | Aquiire
7 | Artificial Intelligence Meets Payables and Dynamic Discounting
8 | Basware
9 | [NAME] vs. SAP Ariba
10 | Bid Ops
11 | Billtrust solution overview
12 | BirchStreet Systems
13 | Bonfire
14 | BravoSolution
15 | BuyerQuest
16 | Candex
17 | ClientLoyalty
18 | Corridor Company
19 | Coupa vs Basware
20 | Coupa vs. SAP Ariba
21 | Currencycloud
22 | DataServ
23 | Determine
24 | Dhatim Conciliator
25 | Directworks
26 | E-Procurement Catalog Management and Search
27 | E-Procurement Head-to-Head Technology Evaluation and Comparison
28 | EC Sourcing
29 | [NAME]
30 | Eved
31 | GEP
32 | Glantus
33 | GoProcure
34 | Infor Nexus
35 | Intenda
36 | Ivalua vs. SAP Ariba
37 | [NAME] vs SAP Ariba
38 | [NAME]
39 | [NAME] (KPC)
40 | LexisNexis Entity Insight
41 | Market Dojo
42 | [NAME]
43 | Medius
44 | MineralTree
45 | NPI
46 | OpenEnvoy
47 | Oracle Procurement Cloud
48 | Oracle Procurement Cloud Update — The Sleeping Giant is Waking Up
49 | Oracle Procurement Contracts Cloud
50 | Oracle vs SAP Ariba
51 | [NAME] vs. Coupa
52 | Orpheus
53 | Oversight Systems
54 | PRGX
55 | Part Analytics
56 | Per Angusta
57 | Precoro
58 | Procurify
59 | Promena
60 | SAP Ariba
61 | Scout RFP
62 | Seal Software
63 | [NAME]
64 | SoftCo
65 | Sourceit
66 | Spend360
67 | Stampli
68 | Statess (State of Flux)
69 | Supply Dynamics
70 | Taulia
71 | Teampay
72 | Tipalti's Payment Capability
73 | Tradeshift
74 | Tradeshift Pay overview
75 | Tradeshift vs. SAP Ariba
76 | Transcepta
77 | [NAME]
78 | Uppler
79 | VNDLY
80 | WPS Management (Wescale)
81 | [NAME]
82 | WorkMarket (ADP)
83 | Workforce Logiq
84 | Xeeva
85 | Yooz
86 | Zumen
87 | riskmethods
Spreadsheet: 703095d1604751031-to-bring-row-cell-data-in-column-data-bill-2-
Sheet: Bil

 | ||भवानी
 |  |  |  |  | DR.PRAVINA INAMDAR
 |  |  |  |  | 602-B KAVERI MG ROAD
 |  |  |  |  | GOREGAON WEST
 |  |  |  |  | MUMBAI 400104
 |  |  |  |  | MOB:877586339
 | Order No |  | BH015
 | Name
 | Sr No | Product ID | Product No | Quantity | Unit Price [NAME] | Total
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 |  |  | Total
 |  |  | Special Discount 5%
 |  |  | Net Bill
 | RS. FIVE HUNDRED FORTY ONE ONLY
 | PAYMENT
 | NETBANKING: ABHYUDAYA COOP BANK SHASTRI NAGAR GOREGAON MUMBA
 | ACCOUNT NO:105011100005713
 | 8779865339
Spreadsheet: 175267d1345473909-need-consistent-formula-for-computation-for-amortization-on-tcd-tcd-1-
Sheet: Sheet1

Placement | Account | Depositor | Amount | Term | Interest | Maturity | 2012-08-31 00:00:00 |  |  | 2012-09-30 00:00:00 |  |  | 2012-10-31 00:00:00 |  |  | 2012-11-30 00:00:00
Date | Number |  |  |  | Rate | Date | Days | I.E | AIP | Days | I.E | AIP | Days | I.E | AIP | Days | I.E | AIP
2012-08-01 00:00:00 | 5268-3336-49 |  | 50000 |  | 0.015 | 2012-08-31 00:00:00
2012-08-02 00:00:00 | 5268-2436-31 |  | 10000 |  | 0.0125 | 2012-09-03 00:00:00
2012-08-02 00:00:00 | 5268-3336-35 |  | 35000 |  | 0.015 | 2012-10-01 00:00:00
2012-08-03 00:00:00 | 5268-3336-36 |  | 85000 |  | 0.0175 | 2012-10-02 00:00:00
2012-08-08 00:00:00 | 5268-3336-37 |  | 100000 |  | 0.02 | 2012-09-07 00:00:00
2012-08-08 00:00:00 | 5268-3336-38 |  | 275000 |  | 0.0225 | 2012-10-08 00:00:00
2012-08-10 00:00:00 | 5268-3336-39 |  | 34000 |  | 0.015 | 2012-10-08 00:00:00
2012-08-13 00:00:00 | 5268-3336-40 |  | 22000 |  | 0.01 | 2012-09-12 00:00:00
2012-08-15 00:00:00 | 5268-3336-41 |  | 1350000 |  | 0.02 | 2012-09-14 00:00:00
2012-08-16 00:00:00 | 5268-3336-42 |  | 890000 |  | 0.0175 | 2012-10-15 00:00:00
2012-08-22 00:00:00 | 5268-3336-43 |  | 645000 |  | 0.0165 | 2012-10-22 00:00:00
2012-08-24 00:00:00 | 5268-3336-44 |  | 325000 |  | 0.0125 | 2012-09-22 00:00:00
2012-08-27 00:00:00 | 5268-3336-45 |  | 336500 |  | 0.0125 | 2012-09-26 00:00:00
2012-08-28 00:00:00 | 5268-5336-45 |  | 185700 |  | 0.0175 | 2012-10-27 00:00:00
2012-08-31 00:00:00 | 5268-3236-49 |  | 33000 |  | 0.0125 | 2012-10-30 00:00:00
2012-09-05 00:00:00 | 5268-3358-49 |  | 15000 |  | 0.01 | 2012-10-04 00:00:00
2012-09-07 00:00:00 | 5268-3836-49 |  | 450600 |  | 0.015 | 2012-10-04 00:00:00
2012-09-12 00:00:00 | 5268-3356-49 |  | 89100 |  | 0.0125 | 2012-10-12 00:00:00
2012-09-18 00:00:00 | 5268-8636-49 |  | 1800456 |  | 0.0275 | 2012-10-18 00:00:00
2012-09-20 00:00:00 | 5268-3336-39 |  | 327000 |  | 0.0175 | 2012-11-20 00:00:00
2012-09-25 00:00:00 | 5268-3337-49 |  | 757600 |  | 0.0175 | 2012-11-24 00:00:00
2012-09-25 00:00:00 | 5268-3396-49 |  | 921256 |  | 0.02 | 2012-10-25 00:00:00
2012-09-27 00:00:00 | 5268-3336-89 |  | 764200 |  | 0.02 | 2012-10-27 00:00:00
Spreadsheet: 882898d1731365651-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r2
Sheet: Oct 23

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value
[NAME] | [NAME] | I have completed today's training | 2023-10-04 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-10-05 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 0.5 | [NAME] | 1 |  |  |  | 31.5
[NAME] | Lucan Heron | The student has completed the laptop agreement and I am attaching the agreement |  |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have completed today's training | 2023-10-16 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am notifying a non-attendance | 2023-10-19 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 30 | 1 | 30
[NAME] | [NAME] | I am submitting a student progress update | 2023-10-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | The student has completed the laptop agreement and I am attaching the agreement |  |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have completed a TNA | 2023-10-27 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50
[NAME] | Celine [NAME] | The student has completed the laptop agreement and I am attaching the agreement |  |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
Spreadsheet: 69860d1270547718-combination-generator-needed-combinations
Sheet: data

ac
[NAME]
qc
jc
tc
9c
8c
7c
6c
5c
4c
3c
2c
ad
kd
qd
jd
td
9d
8d
7d
6d
5d
4d
3d
2d
ah
kh
qh
jh
th
9h
8h
7h
6h
5h
4h
3h
2h
as
ks
qs
js
ts
9s
8s
7s
6s
5s
4s
3s
2s
Spreadsheet: scott_neal__38690__NA Master Global Contract Report
Sheet: Can Pwr Rankings

COUNTRY | Canada
COMMODITY | Power
Sum of EXTERNAL QTY |  |  | CATEGORY
COUNTERPARTY ID | GLOBAL ID | COUNTERPARTY NAME | Financial | Grand Total | Ranking
5806 | 56264 | Mirant Americas Energy Marketing, L.P. | 253236 | 253236 | 1
6082 | 65292 | Dynegy Canada Inc. | 161328 | 161328 | 2
5780 | 55898 | TransAlta Energy Marketing Corp. | 128328 | 128328 | 3
5564 | 50591 | Aquila Canada Corp. | 84486 | 84486 | 4
5699 | 53341 | Engage Energy Canada L.P. | 78930 | 78930 | 5
5529 | 48528 | TransCanada Energy Financial Products Limited | 67644 | 67644 | 6
6081 | 65291 | BP Corporation North America Inc. | 44094 | 44094 | 7
5999 | 53350 | El Paso Merchant Energy, L.P. | 21900 | 21900 | 8
9873 | 88408 | Encore Energy Solutions, L.P. | 14460 | 14460 | 9
9469 | 93623 | ENMAX Energy Corporation | 11862 | 11862 | 10
5746 | 54980 | Duke Energy Marketing Limited Partnership | 11292 | 11292 | 11
6078 | 65246 | IDACORP Energy L.P. | 8696 | 8696 | 12
5003 | 12 | BP Energy Company | 4380 | 4380 | 13
7329 | 76158 | Idaho Power Company, dba IDACORP Energy | 3642 | 3642 | 14
6625 | 11107 | Conoco Canada Limited | 888 | 888 | 15
7156 | 62413 | TransAlta Energy Marketing (US) Inc. | 750 | 750 | 16
Grand Total |  |  | 895916 | 895916
Spreadsheet: 719031d1613478513-how-to-use-vlookup-on-transposed-data-book2-2-
Sheet: Sheet2

Trans | ID | Value | VL
 | A2 | 5
A2
ID | Value | Trans | VL
A2 | 5
 |  | A2
Spreadsheet: 121192d1315915415-formula-to-sum-max-of-each-group-excel-formula-need
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Name | Part Name | Part Number | Engine Qty | Jan Y1 | Feb Y1 | [NAME] | Apr Y1 | May Y1 | [NAME] | [NAME] | Aug Y1 | Sep Y1 | [NAME] | Nov Y1 | Dec Y1
Expected | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget2 | PN3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Part Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  | G0001 | Widget2 | PN3A | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Widget1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget4 | PN5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Widget2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget1 | PN22 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Widget3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget4 | PN6A | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Widget4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget4 | PN6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Widget5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget2 | PN3 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Widget6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget2 | PN3A | 5 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget4 | PN5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget1 | PN22 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cell B6 should be 1, since we're taking the [NAME] for that group.  Cell C6 should be 3, etc….. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget2 | PN3 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget2 | PN3A | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN6A | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN6 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
Spreadsheet: 125965d1319449474-excel-2007-how-to-shuffle-words-in-a-row-udf-concatenate-range-concrange-
Sheet: Sheet1

 |  |  |  |  |  |  | No separator
Can | you | put | this | into | one | cell? | Canyouputthisintoonecell?
Can
you
put
this
into
one |  |  |  |  |  |  | " " separator (space)
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes!
Can
 | you
 |  | put
 |  |  | this
 |  |  |  | into
 |  |  |  |  | one
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes!
How to use
If you don't need separators use like this
otherwise
The separator can be any string you might need.
The range can be any size or shape, the function will concatenate by Columns left to right, then by Rows, omitting any blank cells
 |  |  |  |  |  |  | Can you put this into one cell? - Yes!  The separator can be any string you might need.  The range can be any size or shape, the function will concatenate by Columns left to right, then by Rows, omitting any blank cells | By using builtin CONCATENATE and ConcRange together Use Char(10) to start a new line. Use Char(10)&Char(10) to separate with a blank line. Then apply Wrap Text
Spreadsheet: 109566d1306396103-dynamic-charting-top-ten-example
Sheet: Sheet1

 | Aged Items Brighton
 | <1 Month | 1-2 months | 2-3 Months | 3-6 Months | Over 6-12 Months | Over 12 Months
30/8 | 146 | 118 | 64 | 53 | 45 | 0
6/9 | 240 | 99 | 86 | 72 | 47 | 0
13/9 | 183 | 92 | 107 | 48 | 45 | 0
20/9 | 228 | 114 | 85 | 64 | 51 | 0
27/9 | 199 | 137 | 77 | 54 | 51 | 2
4/10 | 223 | 85 | 79 | 73 | 59 | 2
11/10 | 116 | 103 | 67 | 101 | 57 | 1
18/10 | 126 | 137 | 75 | 91 | 66 | 2
25/10 | 127 | 145 | 99 | 92 | 68 | 4
1/11 | 147 | 165 | 71 | 120 | 68 | 4
8/11 | 118 | 131 | 61 | 129 | 63 | 5
15/11 | 157 | 95 | 110 | 135 | 63 | 6
22/11 | 113 | 108 | 84 | 145 | 62 | 6
29/11 | 77 | 93 | 84 | 135 | 58 | 7
6/12 | 58 | 105 | 84 | 141 | 59 | 7
13/12 | 17 | 128 | 65 | 162 | 75 | 7
20/12 | 112 | 111 | 56 | 177 | 73 | 7
27/12 | 70 | 91 | 54 | 183 | 71 | 8
3/1 | 69 | 71 | 67 | 163 | 89 | 8
10/1 | 128 | 55 | 68 | 149 | 112 | 10
17/1 | 53 | 72 | 93 | 152 | 115 | 8
24/1 | 185 | 63 | 81 | 170 | 111 | 11
31/1 | 209 | 56 | 64 | 160 | 135 | 11
7/2 | 161 | 90 | 49 | 163 | 145 | 5
14/2 | 221 | 61 | 34 | 179 | 119 | 8
21/2 | 171 | 122 | 52 | 167 | 126 | 8
28/2 | 193 | 153 | 41 | 175 | 114 | 8
7/3 | 225 | 149 | 39 | 155 | 128 | 8
14/3 | 200 | 142 | 61 | 116 | 133 | 6
21/3 | 168 | 117 | 46 | 93 | 113 | 6
28/3 | 142 | 154 | 96 | 109 | 122 | 8
4/4 | 135 | 144 | 100 | 94 | 116 | 5
11/4 | 118 | 125 | 67 | 97 | 118 | 2
18/4 | 94 | 142 | 92 | 88 | 122 | 7
25/4 | 108 | 129 | 73 | 133 | 127 | 8
2/5 | 106 | 109 | 95 | 136 | 140 | 8
9/5 | 94 | 131 | 112 | 132 | 144 | 8
16/5 | 91 | 134 | 110 | 126 | 156 | 9
23/5 | 63 | 121 | 106 | 153 | 157 | 8
Spreadsheet: 131279d1322842188-if-equal-to-then-insert-entire-row-ttttexfor
Sheet: Sheet2

[NAME] | Doe | abc | 100 | en-US | USA | yes
[NAME] | Doe | abc | 80.3 | en-US | USA | yes
[NAME] | Doe | abc | 87.935 | en-US | USA | yes
[NAME] | Doe | abc | 100 | en-US | USA | yes
[NAME] | Doe | abc | 80.735 | en | USA | yes
[NAME] | Doe | abc | 100 | en | USA | yes
Spreadsheet: 867107d1713991629-count-the-number-of-days-since-the-last-accident-for-departments-test-accident-counts-by-dept
Sheet: Sheet1

Date of Accident | Fault | Department | No. of Days up to today |  |  | Department | Days since Last Accident
2012-01-05 00:00:00 | yes | garage |  |  |  | Garage
2012-01-07 00:00:00 | yes | production |  |  |  | Route Ops
2012-01-16 00:00:00 | Yes | Office |  |  |  | Product Control
2019-08-06 00:00:00 | yes | product control |  |  |  | Office
2022-05-04 00:00:00 | yes | garage |  |  |  | Maintenance
2023-06-01 00:00:00 | yes | product control |  |  |  | Engineering
2023-07-02 00:00:00 | yes | production
2023-08-06 00:00:00 | yes | garage
2023-10-23 00:00:00 | no | route ops
2024-01-01 00:00:00 | no | route ops
2024-01-04 00:00:00 | yes | route ops
2024-04-01 00:00:00 | no | route ops
2024-04-07 00:00:00 | yes | product control
Spreadsheet: 878566d1725659175-need-formulas-to-get-average-of-monthly-productivity-per-person-productivity-changes_v3
Sheet: Monthly Average

Months | Person 1 | Months | Person 2 | Months | Person 3
2024-09-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 |  | 2024-12-01 00:00:00 |  | 2024-12-01 00:00:00
2025-01-01 00:00:00 |  | 2025-01-01 00:00:00 |  | 2025-01-01 00:00:00
2025-02-01 00:00:00 |  | 2025-02-01 00:00:00 |  | 2025-02-01 00:00:00
Spreadsheet: daren_farmer__6664__Force_Majeure
Sheet: Sheet1

Days Calpine is Claiming Force Majeure
 |  |  |  |  |  | Scheduled
Beginning | End | # Days | Notice Given | Letter Sent | Letter Rec'd | Maint.? | Days | Problem | Penalties | Paid?
1999-10-04 00:00:00 | 1999-10-10 00:00:00 | 7 | one day per nom sheet |  |  | no | Mon - Sun | Nom sheet said scheduled maintenance. | 11795 | no
2000-12-19 00:00:00 | 1999-12-21 00:00:00 | 3 |  | 2000-12-21 00:00:00 |  | no | Sun - Tue | Gas turbine fuel line | None - per [NAME] | n/a
1999-12-31 00:00:00 | 2000-01-01 00:00:00 | 2 |  | 2000-01-06 00:00:00 |  | no | Fri - Sat | Damaged fuel nozzle & turbine flex fuel line |  | n/a
2000-02-05 00:00:00 | 2000-02-08 00:00:00 | 4 |  | 2000-02-07 00:00:00 |  | no | Sat-Tue | Steam turbine oil pump failure | 6784 | no
2000-03-25 00:00:00 | 2000-03-30 00:00:00 | 6 | one day per nom sheet | 2000-03-27 00:00:00 | 2000-03-28 00:00:00 | no | Sat - Thur | Voltage regulator failure | none - per contract pricing penalty formulas | n/a
2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 1 | none - no mention in nom sheet | 2000-04-04 00:00:00 | 2000-04-10 00:00:00 | no | Fri | Reactor valve failure | 750 | no
To my knowledge, Calpine has not sent notice of scheduled maintenace days to anyone at Enron or HPL for 1999 or 2000 contract years
Spreadsheet: 111241d1307652810-counting-distinct-cells-uniqueno
Sheet: Sheet1

Y/N | Num | Helper1 | Helper2 | Helper3
YES | 190 | YES190 | 1 | 0
NO | 190 | NO190 | 1 | 1
NO | 170 | NO170 | 1 | 1
YES | 190 | YES190 | 2 | 0
NO | 190 | NO190 | 2 | 0
 |  |  |  | 2 | <<Here is your answer.
*My desired result is 2
*Counting the Cells with "NO" but if it has the same number, it is not included in the count anymore