tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275221d1383400544-extract-unique-values-from-a-table-and-list-along-a-row-example-data
Sheet: Sheet1

Date | Advertiser | Product | Cost |  | Advertisers
2013-10-01 00:00:00 | [NAME] | cereal1 | 22.271696 |  | [NAME]
2013-10-01 00:00:00 | [NAME] | cereal2 | 261.504502 |  | Nike
2013-10-01 00:00:00 | [NAME] | cereal4 | 0.291496 |  | Ford
2013-10-01 00:00:00 | Nike | trainer1 | 3.506025
2013-10-01 00:00:00 | Nike | trainer1 | 22.820761 |  | Advertiser drop-down | [NAME]
2013-10-01 00:00:00 | Ford | car3 | 2.69254
2013-10-02 00:00:00 | [NAME] | cereal 1 | 5.966141 |  | Cost output table
2013-10-02 00:00:00 | [NAME] | cereal 5 | 104.278315 |  | Product |  |  |  |  |  | .....
2013-10-02 00:00:00 | Nike | trainer1 | 0.142326 |  | 2013-10-01 00:00:00
2013-10-02 00:00:00 | Nike | trainer2 | 26.325024 |  | 2013-10-02 00:00:00
2013-10-02 00:00:00 | Nike | trainer3 | 122.196729 |  | 2013-10-03 00:00:00
2013-10-02 00:00:00 | Ford | car3 | 3.190125
2013-10-02 00:00:00 | Ford | car7 | 0
2013-10-03 00:00:00 | [NAME] | cereal4 | 3.190125
2013-10-03 00:00:00 | Nike | trainer3 | 26.325024
Spreadsheet: 204390d1357491666-general-database-problems-to-make-it-more-user-friendly-excel-practice
Sheet: Sheet2

 | Vlook up table
 | Program | Building | Classroom
 | Business | B | 12
 | English | A | 15
 | Maths | C | 42
 | Chemistry | D | 4
 | Biology | D | 5
 | Physics | D | 23
Spreadsheet: 785807d1656695589-formula-for-gating-value-from-pivot-table-and-by-verifying-the-date-filter-2022-07-01-oeldere2-jocky6688-pivot-query
Sheet: Pivot Table

Som van Consumption | Kolomlabels
Rijlabels | 2014 | 2015 | 2016 | 2017 | Eindtotaal
1 | 2908 | 9876 | 4834.3825 |  | 17618.3825
2 | 1798 | 7958 | 2443.7409 |  | 12199.7409
3 | 4963 | 4253 | 3542.2145 |  | 12758.2145
4 |  | 7896 | 7965 | 1658 | 17519
5 |  | 3336 | 1250 |  | 4586
6 |  | 7964 | 1658 |  | 9622
7 |  | 1597 | 6761 |  | 8358
8 |  | 9876 | 1128 |  | 11004
9 |  | 7958 | 4930 |  | 12888
10 |  | 4253 | 2282 |  | 6535
11 |  | 7965 | 5450.5133 |  | 13415.5133
12 |  | 1597 | 7785.2475 |  | 9382.247500000001
Eindtotaal | 9669 | 74529 | 50030.0987 | 1658 | 135886.0987
Spreadsheet: 170412d1343258560-moving-data-with-index-and-match-for-pricing-sheet-ef136a_revised-pricing-a
Sheet: Estimate

 | CUSTOMER : |  |  | PHONE NUMBER : |  |  | ROOM
 | DOOR STYLE : |  |  | FINISH :
 | DATE QUOTED: |  |  | NOTES:
CABINET BOXES
Code | [NAME] |  | DEPTH | SQ.FT | # | COLOR | COST | Total
W2412 |  |  |  |  | 1 | STAINED VENEER
Spreadsheet: 356148d1415008546-vlookup-or-sumifs-testv2
Sheet: Home

 |  |  |  |  |  | 17*10*14 |  | 24*10*14
NAME | BBC | Factory | Floor | Park | Logistics |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | TAX | PAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
[NAME] | 500 |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 529 | 105.8 | 423.2
Carlsberg | 100 |  | 500 |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 620 | 124 | 496
[NAME] |  | 600 |  | 25 | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1425 | 285 | 1140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 600 | 600 | 500 | 54 | 820 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2574 | 514.8 | 2059.2
Spreadsheet: benjamin_rogers__1104__site_visit_schedule_100400_a
Sheet: Schedule

E2 Site Visit Schedule
 |  |  | [NAME] | Lincoln | Wheatland | [NAME] | Pastoria
Week 1 | 2000-10-11 00:00:00 | Wed
 | 2000-10-12 00:00:00 | Thur
 | 2000-10-13 00:00:00 | Fri
Week 2 | 2000-10-16 00:00:00 | Mon
 | 2000-10-17 00:00:00 | Tue
 | 2000-10-18 00:00:00 | Wed
 | 2000-10-19 00:00:00 | Thur |  |  |  |  | X1
 |  |  |  |  |  |  | X1
 | 2000-10-20 00:00:00 | Fri |  |  |  |  | X1
 |  |  |  |  |  |  | X1
Week 3 | 2000-10-23 00:00:00 | Mon |  |  |  |  | X1
 |  |  |  |  |  |  | X1
 | 2000-10-24 00:00:00 | Tue |  |  |  |  | X1
 |  |  |  |  |  |  | X1
 | 2000-10-25 00:00:00 | Wed
 | 2000-10-26 00:00:00 | Thur
 | 2000-10-27 00:00:00 | Fri
Week 4 | 2000-10-30 00:00:00 | Mon
 | 2000-10-31 00:00:00 | [NAME]
Spreadsheet: 101693d1299771085-help-with-using-a-series-of-values-to-fill-a-stocksheet-experimental-stock-movement-sheet
Sheet: Data

STOCK DESCRIPTION, SUPPLIER, ID AND LOCATION |  | STOCK STATUS |  |  |  |  | STOCK HOLDING AREAS INFORMATION | STOCK MOVEMENT DETAILS AND STOCK COST BREAKDOWN |  |  | Period 10 |  |  |  |  | Period 11
ID No. | Item Description | Running Stock | [NAME] | Min Stk | Con / Bought Stock | Price (Indv) | Location Parts Used | Opening Stock | Issued | Deliveries & Returns | Bond Store Closing Stock | Mezzanine Closing Stock | Items In | Items Out | Total Stock Holding | Bond Store Closing Stock | Mezzanine Closing Stock | Items In | Items Out | Total Stock Holding
001 | 16 watt GLS ES Energy Saver Softone | 211 | 300 | 60 | Bought | 2.83 | Lodges Normal Parts | 265 | 354 | 300 | 227 |  |  |  | 227 | 265 |  |  |  | 265
002 | 16 watt GLS BC Energy Saver Softone | 144 | 300 | 60 | Bought | 2.83 | Lodges Normal Parts | 280 | 136 | 0 | 363 |  |  |  | 363 | 280 |  |  |  | 280
003 | 7 Watt GU10 Energy Saver | 0 | 240 | 60 | Bought | 4.5 | Lodges Normal Parts | 0 | 4 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0
004 | 40 Watt SES Clear Cooker hood Lamp | 207 | 400 | 100 | Bought | 0.52 | Lodges Normal Parts | 150 | 193 | 250 | 290 |  |  |  | 290 | 150 |  |  |  | 150
005 | 25 Watt SES Clear Oven Lamp | 389 | 400 | 100 | Bought | 0.52 | Lodges Normal Parts | 201 | 12 | 200 | 1 |  |  |  | 1 | 201 |  |  |  | 201
006 | 15 Watt SES Pygmy Clear Sign Lamp | 3 | 200 | 50 | Bought | 0.17 | Lodges Normal Parts | 3 | 0 | 0 | 3 |  |  |  | 3 | 3 |  |  |  | 3
007 | 15 Watt SBC Pygmy Clear Sign Lamp | 150 | 200 | 50 | Bought | 0.17 | Central Buildings Normal Parts | 150 | 0 | 0 | 150 |  |  |  | 150 | 105 |  |  |  | 150
008 | 25 Watt BC22 Pygmy Clear Sign Lamp | 26 | 200 | 50 | Bought | 0.17 | Central Buildings Normal Parts | 26 | 0 | 0 | 26 |  |  |  | 26 | 26 |  |  |  | 26
009 | 20 Watt 12v G4 Capsule Lamp | 0 | 20 | 7 | Bought | 0.4 | Central Buildings Normal Parts | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0
010 | 50 Watt GY 6.35 12V M32 Capsule Lamp | 5 | 20 | 7 | Bought | 0.45 | Central Buildings Normal Parts | 5 | 0 | 0 | 5 |  |  |  | 5 | 5 |  |  |  | 5
 | The cells to be filled are N3 to N12 and O3 to O12 and must be dependent on the period header (L1) and the ID No. (A3)
Spreadsheet: 90587d1290359760-excel-2007-if-statements-with-3-values-test-book
Sheet: Sheet1

Product | Price Paid | Shipping | Product Cost | Supplier | MSRP | Category | Minimal Selling Price | Insertion Fees | Buy It Now | Advertised Shipping Cost | Price Sold | Total Price | Actual Shipping Cost | Date Sold | Final Value Fees | Palpal Fees | Shipping Costs & Fees | Profit | Profit Margin | Column1
FX-57 & Mobo | 19.36 | N/A |  | N/A | N/A | Electronics |  | 0.6 | YES | 0 | 75 |  | 11.13 | 2010-11-15 00:00:00 | 6.75
A-Data RAM | 8.99 | N/A |  | N/A | N/A | Electronics |  | 0.2 | YES | 0 | 45 |  | 2.57 | 2010-11-16 00:00:00 | 4.05
Product A | 3.99 | 1.99 |  | N/A | 19.99 | Books |  | 0.25 | NO | 4.99 | 18.99 |  | 4.95 | 2010-11-21 00:00:00
Product B | 14.99 | 4.95 |  | N/A | 59.99 | Other |  | 0.85 | ONLY | 0 | 55.99 |  | 3.19 | 2010-11-21 00:00:00
Spreadsheet: 56e65607-056c-4788-a425-d0aefb525c9f
Sheet: Data for graph

Top ten transboundary shipped hazardous waste types by amount, 2007
Y code | Description of Y code | Quantity (1000 tonnes)
Y18-Residues arising from industrial waste disposal | Waste stream: Residues arising from industrial waste disposal operations | 3033.335
[NAME]; lead compounds | Wastes having as constituents: Lead; lead compounds | 355.858
Y23-Zinc compounds | Wastes having as constituents: Zinc compounds | 330.01
Y8-Waste mineral oils | Waste stream: Waste mineral oils unfit for their originally intended use | 311.422
Y17-Surface treatment of metals and plastics | Waste stream: Wastes resulting from surface treatment of metals and plastics | 308.008
Y5-Manufacture, formulation and use of wood preserving chemicals | Waste stream: Wastes from the manufacture, formulation and use of wood preserving chemicals | 184.642
Y42-Organic solvents excluding halogenated solvents | Wastes having as constituents: Organic solvents excluding halogenated solvents | 166.96
Y19-Metal carbonyls | Wastes having as constituents: Metal carbonyls | 156.731
Y12-Inks, dyes,pigments, paints, lacquers, varnish | Waste stream: Wastes from production, formulation and use of inks, dyes,pigments, paints, lacquers, varnish [NAME] from production, formulation and use of resins,latex, plasticizers, glues/adhesives | 151.66
Y36-Asbestos (dust and fibres) | Wastes having as constituents: Asbestos (dust and fibres) | 151.513
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Jun

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 293354d1390956070-is-it-possible-to-inter-link-sheets-in-the-same-book-forum-example-bvj-
Sheet: Sheet2

 |  |  |  | DRILL |  |  | FIRST AID |  |  | FIRE WARDEN |  |  | CROSS BELTS |  |  | HEALTH & SAFETY
[NAME] | D | Wingate | A Line Man | 2009-02-20 00:00:00 | 12 |  | 2009-01-23 00:00:00 | 12 |  | 2011-02-02 00:00:00 | 12 |  | 2010-10-20 00:00:00 | 12 |  | 2010-04-12 00:00:00 | 12
BILY SMITH | N | Wingate | A Line Man | 2010-02-04 00:00:00 | 12 |  | 2009-01-23 00:00:00 | 12 |  | 2010-02-02 00:00:00 | 12 |  | 2010-02-01 00:00:00 | 12 |  | 2009-01-23 00:00:00 | 12
[NAME] | D | Specials | Specials Man | 2009-04-17 00:00:00 | 12 |  | 2010-06-24 00:00:00 | 12 |  |  | 12 |  | 2009-04-24 00:00:00 | 12 |  | 2009-04-24 00:00:00 | 12
[NAME] | D | Glaisdale | Glaisdale Man | 2009-04-09 00:00:00 | 12 |  | 2009-04-09 00:00:00 | 12 |  |  | 12 |  | 2013-02-06 00:00:00 | 12 |  | 2009-03-20 00:00:00 | 12
STEVE OGRADY | D | Wingate | A Line |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  | 2010-04-09 00:00:00 | 12
BARRY WALKER | D | Wingate | A Line | 2013-02-04 00:00:00 | 12 |  | 2009-04-09 00:00:00 | 12 |  |  | 12 |  |  | 12 |  |  | 12
[NAME] | D | Wingate | A Line | 2010-08-23 00:00:00 | 12 |  |  | 12 |  | 2012-05-23 00:00:00 | 12 |  |  | 12 |  |  | 12
[NAME] | D | Wingate | A Line |  | 12 |  |  | 12 |  | 2012-08-22 00:00:00 | 12 |  | 2009-03-11 00:00:00 | 12 |  | 2013-04-16 00:00:00 | 12
DAVY CRICKET | D | Wingate | A Line |  | 12 |  | 2012-11-15 00:00:00 | 12 |  | 2013-12-18 00:00:00 | 12 |  | 2013-03-14 00:00:00 | 12 |  | 2013-04-02 00:00:00 | 12
Spreadsheet: 113655d1309486705-how-to-sort-grouped-data-in-excel-multilevelsort2003sample_desired
Sheet: sample

Delivery Date | Project | Task
2011-07-02 00:00:00 | Project 9 | Task 49 |  | Hi bool,
2011-07-04 00:00:00 | Project 6 | Task 36 |  | Here is some fake data to see if it works for you.
2011-07-09 00:00:00 | Project 7 | Task 37
2011-08-13 00:00:00 | Project 6 | Task 16
2011-08-18 00:00:00 | Project 9 | Task 9
2011-08-29 00:00:00 | Project 6 | Task 6
2011-09-24 00:00:00 | Project 7 | Task 27
2011-09-24 00:00:00 | Project 9 | Task 39
2011-09-28 00:00:00 | Project 9 | Task 29
2011-10-17 00:00:00 | Project 6 | Task 46
2011-11-19 00:00:00 | Project 9 | Task 19
2011-12-12 00:00:00 | Project 6 | Task 26
2011-12-31 00:00:00 | Project 7 | Task 7
2012-01-01 00:00:00 | Project 7 | Task 17
2011-11-24 00:00:00 | Project 7 | Task 47
Spreadsheet: 865166d1712225152-indirect-function-with-multiple-criteria-indirect-formula-with-multiple-criteria
Sheet: Beam Weld

Date | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | Month
Shift | A | B | C | Total | A | B | C | Total | A | B | C | Total | A | B | C | Total
Manpower on Board | 18 | 13 | 23 |  | 18 | 13 | 23 |  | 18 | 13 | 23
Manpower Attended | 12 | 9 | 20 |  | 12 | 9 | 20 |  | 11 | 9 | 18
Absent %
Output | 20 | 20 | 20 |  | 20 | 20 | 20 |  | 20 | 20 | 20
Net Man Hrs / MT
Spreadsheet: c25a0906-47bb-4f1f-9a4b-e9b7024ce262
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 7/26/2014 10:09:07 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 218404d1362444773-base-calculations-only-on-the-latest-data-skeeball-sample
Sheet: STATS

PLAYER NAME | Current | 1 | 2 | 3 | 4 | 5/7 | 6/8 | 9 | 10 | 11 | 12 | 13/15 | 14/16 | 17 | 18 | 19 | 20 | Stats |  |  |  | Cumulative
 | Rating | Dbls | Dbls | Dbls | Dbls | [NAME] | [NAME] | Dbls | Dbls | Dbls | Dbls | [NAME] | [NAME] | Dbls | Dbls | Dbls | Dbls | Average | Rating |  | Average | Rating | Games
[NAME], [NAME] | P3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 315 | 304 | 315
[NAME], April | T3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 324 | 324 | 297
[NAME]. April | P3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 288 | 355 | 311 | 323 | 278
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 17

Product* | December 20 | December 27 | January 3 | January 10 | January 17
Total*** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Agricultural | N/A | N/A | N/A | N/A | N/A
Index | N/A | N/A | N/A | N/A | N/A
Energy | N/A | N/A | N/A | N/A | N/A
Metals | N/A | N/A | N/A | N/A | N/A
OTHER** | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, January 17 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**OTHER variable includes the following products: Multi-Commodity, Environmental, and Freight.
***These numbers are estimates.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 132670d1323880636-help-with-a-function-sum-daily-hours-depending-on-the-employee-name-example
Sheet: Projects&Operations

 | 8 hours [NAME] per day
 |  |  |  |  |  |  |  |  | Avaialble hours for January |  |  |  |  |  |  |  |  |  |  |  |  | Booked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available hours for February |  |  |  |  |  |  |  |  |  | Booked
 | Total hours:
 |  | Hours |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
Mantis ID | Function | Required | Planned | Days | Project name | Assigned to |  | Progress | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
54 |  | 20 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 5 | 8 | 7
635 |  | 45 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 5 |  |  |  |  | 8 | 6 | 2
341 |  | 20 |  |  |  | Laureen |  |  |  |  |  |  |  |  |  |  | 8 | 6 | 4 |  |  |  |  |  |  |  | 2
855 |  | 62 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 |  |  |  |  |  |  |  | 20
254135 |  | 16 |  |  |  | Violeta |  |  |  |  | 8 | 8
534154 |  | 4 |  |  |  | [NAME] |  |  |  | 4
5442 |  | 32 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 10 |  |  |  | 8 | 8 | 2
31321 |  | 10 |  |  |  | Laureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2
 | Functions
 | Content
 | Product
 | SEM
 | SEO
 | Sales
 | Hotel Relations
 | TV
 | BI
 | PR
Spreadsheet: 97269d1296499606-countif-to-find-2nd-occurence-in-range-offsetcountsaboverow
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 |  | play | play
A | A |  |  |  |  |  |  | 2 | Duplicate
B | B |  |  |  |  |  |  | 2 | Duplicate
C | C |  |  |  |  |  |  | 2 | Duplicate
D | D | A | B | C |  |  |  | 2 | Duplicate
E | D | E | F |  |  |  |  | 2 | Duplicate
F | E | F |  |  |  |  |  | 2 | Duplicate
G |  |  |  |  |  |  |  | 0
H |  |  |  |  |  |  |  | 0
I |  |  |  |  |  |  |  | 0
J |  |  |  |  |  |  |  | 0
K |  |  |  |  |  |  |  | 0
L |  |  |  |  |  |  |  | 0
 | what I want as results
A | A-1
B | B-1
C | C-1
D | D-1 | A-2 | B-2 | C-2
E | D-2 | E-1 | F-1
F | E-2 | F-2
G
H
I
J
K
L
 | using countif….
 | didn't work
A | A-1
B | B-1
C | C-1
D | D-1 | A-2 | B-2 | C-2
E | D-2 | E-1 | F-1
F | E-2 | F-2
G
H
I
J
K
L
Spreadsheet: 884659d1733904104-sum-data-with-condition-sumif
Sheet: Sheet1

Cust | Accounting Month | Net Sales (EUR) | Active L12M |  |  |  | Active L12M | -
A | 2023 - 01 | 100
B | 2023 - 02 | 0 |  |  |  |  | Sum of Net Sales (EUR) | Column Labels
B | 2023 - 03 | 0 |  |  |  |  | Row Labels | 2024 - 03 | 2024 - 04 | 2024 - 07 | 2024 - 08 | 2024 - 09 | 2024 - 10 | 2024 - 11 | Grand Total
C | 2023 - 05 | 200 |  |  |  |  | A |  |  | 0 |  |  |  |  | 0
C | 2023 - 12 | 200 |  |  |  |  | B |  |  |  | 0 | 0 |  |  | 0
C | 2023 - 12 | 300 |  |  |  |  | C |  | 0 |  |  |  | 0 | 0 | 0
A | 2024 - 01 | 20 |  |  |  |  | Grand Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 2024 - 02 | 19
B | 2024 - 03 |  |  |  |  |  | I 'd like to filter only data in 12 '23 - 11 '24 and sum this month range > 0 when filter with active L12M . My formula is correct? I found result is ok but when I use real data to test still show sum 12 m rolling = 0 but I can't use real data to post , real data some have blank as well but i tried to delete as blank in this file but it work in this file but not work in real job.Please kindly suggest.
C | 2024 - 04 | 0
C | 2024 - 05 | 11
C | 2023 - 12 | 30
A | 2024 - 07 | 0
B | 2024 - 08
B | 2024 - 09 | 0
C | 2024 - 10 | 0
C | 2024 - 11 | 0
Spreadsheet: 785475d1656433388-index-match-for-multiple-values-in-array-data
Sheet: Desired Output

EmplID | Name | Effdt | EffSeq | Status | [NAME] | Position Title | Manager [NAME] | Manager [NAME]
10293 | [NAME] | 44378 | 0 | Active | Scale Increase | Project Manager | Director | [NAME]
46385 | Holly Flax | 44743 | 0 | On Leave | [NAME] | Manager | Director | [NAME]
28331 | [NAME] | 42125 | 0 | On Leave | Academic Salary Increase | Associate Librarian | Director | [NAME]
84536 | [NAME] | 42125 | 0 | Active | Academic Salary Increase | Associate Librarian | Director | [NAME]
98765 | [NAME] | 43647 | 0 | Active | Scale Increase | Business Analyst | Project Manager | [NAME]
11111 | [NAME] | 43466 | 1 | Active | Academic Salary Increase | Lecturer | Associate Librarian | [NAME]
29673 | [NAME] | 40909 | 0 | Active | Conversion Salary | Associate Professor | Associate Librarian | [NAME]
56209 | [NAME] | 44743 | 0 | On Leave | Academic Salary Increase | Associate Professor | Associate Librarian | [NAME]
63792 | Toby Flenderson | 44682 | 0 | On Leave | Academic Salary Increase | Lecturer | Associate Librarian | [NAME]
74536 | [NAME] | 44743 | 0 | Active | Early Retirement | Associate Professor | Associate Librarian | [NAME]
94723 | [NAME] | 43647 | 1 | Active | Rehire | Assistant Professor | Associate Librarian | [NAME]
12345 | [NAME] | 41821 | 1 | Active | Rehire | Financial Assistant | Manager | Holly Flax
29781 | [NAME] | 41456 | 0 | On Leave | Job Earnings Distribution | Research Associate | Manager | Holly Flax
76933 | [NAME] | 44743 | 0 | Active | [NAME] | Office Assistant | Manager | Holly Flax
78243 | [NAME] | 41821 | 0 | Active | Scale Increase | Financial/Staffing Assistant | Manager | Holly Flax
98125 | [NAME] | 43466 | 0 | Active | Date Adjustment | Director