tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 191885d1352237964-sorting-out-duplicates-and-placing-only-the-unique-numbers-workbook117b
Sheet: Sheet1

1 | -0.6
3 | 0.4
5 | 1.3
13 | 0.4
15 | 1.5
17 | 0.6
19 | 0.4
21 | 0.4
23 | -0.7
25 | -0.7999999999999999
27 | 1.3
29 | 0.4
51 | 0.4
55 | 0.4
59 | -0.7999999999999999
63 | 0.3
71 | 0.2
73 | -1.7
75 | -0.6
79 | -0.5
Spreadsheet: 567822d1522242891-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-example-workbook-2
Sheet: Match

Player 1 | def. | Player 2 | Old ELO for player 1 | Old ELO for player 2 | New ELO for player 1 | New RLO for player 2
Adam | def. | Jessica | 1000 | 1000 | 1100 | 900
Alicia | def. | Olivia | 1000 | 1000 | 1100 | 900
Grace | def. | Adam | 1000 | 1000 | 1130 | 980
Tyron | def. | [NAME] | 1000 | 1000 | 1100 | 900
Braxton | def. | Erin | 1000 | 1000 | 1100 | 900
Ellie | def. | [NAME] | 1000 | 1000 | 1100 | 900
[NAME] | def. | Grace | 1000 | 1000 | 1140 | 1010
Olivia | def. | [NAME] | 1000 | 1000 | 1010 | 820
Braxton | def. | Jessica | 1000 | 1000 | 1170 | 835
[NAME] | def. | [NAME] | 1000 | 1000 | 1070 | 800
[NAME] | def. | Tyron | 1000 | 1000 | 1100 | 1000
Adam | def. | Braxton | 1000 | 1000 | 1200 | 875
Jessica | def. | Ellie | 1000 | 1000 | 950 | 990
[NAME] | def. | [NAME] | 1000 | 1000 | 900 | 800
Erin | def. | Grace | 1000 | 1000 | 1105 | 900
Spreadsheet: 174933d1345239368-sort-while-keeping-specific-rows-at-the-bottom-sort-w-totals
Sheet: Sheet1

 | Status | Type | RREA  Contact | ShortName
 | TOTAL CLOSED AFFILIATE HOSPITALITY SALES | [NAME] | Altobello
 | TOTAL CLOSED HOSPITALITY SALES | Hospitality Sales | Altobello
 | TOTAL IN CONTRACT AFFILIATE HOSPITALITY | [NAME] | Altobello
 | TOTAL CLOSED FINANCING ASSIGNMENTS | Financing Assignments | Baum
 | Closed | [NAME] | Altobello
 | Closed | Hospitality Sales | Altobello
 | Closed | Hospitality Sales | Altobello
 | In Contract | [NAME] | Altobello
 | Closed | Financing Assignments | Baum
 | Closed | Financing Assignments | Baum/Owen
 | Closed | Financing Assignments | Baum/Owen
 | Closed | Financing Assignments | Baum/Owen
 | Closed | Financing Assignments | Baum
 | Closed | Financing Assignments | Baum/Owen
 | Closed | Financing Assignments | Baum/Seter
Spreadsheet: 862291d1710042962-data-validation-from-multiple-sheets-w-in-workbook-review_template-redesigned-1-ans
Sheet: Main

 | As of: | 2023-09-30 00:00:00 | Manpower | Auth | Req | On Hand | Vacancies | % Vacancies |  |  | Project A
 | Program/Project: |  |  | 5 | 5 | 4
 | Sponsor/Customer: | Multiple |  | 3 | 3 | 0
 | Directorate: |  |  | 0 | 0 | 0
 | Program Mgr: |  |  | 0 | 0 | 0
 | PE: |  |  | 10 | 10 | 10
 | Overall Status: | On track | Total
 | Description:
 | Milestones, Deliverables, Risks, and Accomplishments
 | Project | Objectives | MS # | Milestones | Planned Completion | Actual Completion | [NAME] | [NAME] | Due | Delivered | Risk | Type | Corrective Action Plan (CAP) | Significant Accomplishments
 | Project A | Something |  | Proj B Task 1 |  |  |  |  |  |  |  | Financial | Resolve FAR regulation issue
 | Project B | Something |  | Proj B Task 4 |  |  |  | Proj B Del 1 |  |  |  | Schedule | Fix HVAC- Bring SPARTAN up and continue certification process
 | Project B | Something |  | Proj B Task 3 |  |  |  | Proj B Del 2 |  |  |  | Performance
 | Project C | Something |  | Proj B Task 4 |  |  |  | Proj C Del 3 |  |  |  | Technical
 | Project C | Something |  | Proj C Task 3 |  |  |  | Proj C Del 5 |  |  |  | Multiple
 |  |  |  | [NAME] | =INDIRECT(SUBSTITUTE($B13," ","_")&"[Tasks]")
Spreadsheet: 865595d1712653216-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-
Sheet: WORKER 2

WORKER 2
no | location | customer | Status | worker 2
Spreadsheet: 152341d1335358211-pivot-table-grand-total-row-grand-total-column
Sheet: Sheet6

Value | [NAME]
Row Labels | A | B | C | D | E | F | G | H | I | J | K | L | M | N | Grand Total
2012-04-20 00:00:00 | 0 | 154 | 62 | 102 | 240 | 80 | 398 | 11 | 101 | 1 | 823 | 5 | 0 | 1350 | 3327 | Grand Total = value in N10
2012-04-21 00:00:00 | 137 | 317 | 10 | 1107 | 960 | 890 | 909 | 467 | 884 | 341 | 231 | 0 | 20 | 0 | 6273 | Grand Total = value in D11
2012-04-22 00:00:00 | 390 | 267 | 1100 | 1122 | 0 | 1817 | 499 | 298 | 364 | 454 | 504 | 0 | 0 | 0 | 6815 | Grand Total = value in F12
Grand Total | 527 | 738 | 1172 | 2331 | 1200 | 2787 | 1806 | 776 | 1349 | 796 | 1558 | 5 | 20 | 1350 | 16415
Spreadsheet: 83540d1283507735-vlookup-spend-figures-test
Sheet: Checklist

 | Figures Received
 | Figures | A | B | C | D | E | F | G | H | I
 | Aug | x | x | x | x | x | x | x | x | x
 | Sep
 | Oct
 | Nov
 | Dec
 | Jan | x
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Month
 | 2011-01-01 00:00:00
Spreadsheet: 160584d1339125816-finding-player-and-avg-top-3-scores-ringer-percent-experiment2
Sheet: Sheet2

 |  |  |  |  |  | bc canstat
card # | Name |  | Prov | Div | ringer avg | best 3 avg | events
614111 | Smith | [NAME] | bc |  | 43.85714285714285 | 51.66666666666666 | 7
614112 | Cole | [NAME] | bc |  | 21.2 | 15.66666666666667 | 5
614016 | Moffat | [NAME] | bc |  | 4.125 | 3.666666666666667 | 8
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: InfoTrac

InfoTRAC
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | Price for 2005-2006 | Price per unit
Literature Resource Center
Sessions | 172 | 20 | 234 | 432 | 400 | 368 | 77 | 360 | 400 | 413 | 156 | 128
Searches | 1174 | 107 | 1060 | 2542 | 2518 | 1737 | 537 | 2186 | 2154 | 2289 | 840 | 731 |  | 4678
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Successful Full-Text Article Requests | 124 | 11 | 222 | 473 | 591 | 495 | 103 | 677 | 764 | 671 | 208 | 213 |  | 4678
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: STORES

STORES
[NAME]. | SAP NO. | NAME | SECTION
 | 545 |  |  | A,
 | 466 |  |  | A,
 | 3049 |  |  | A,
 | 3050 |  |  | A,
 | 195 |  |  | A.
 | 532 |  |  | A.
 | 793 |  |  | A.
 | 384 |  |  | A.
 | 1119 |  |  | A.
 | 1723 |  |  | A.
 | 788 |  |  | A.
 | 1126 |  |  | A.
 | 1129 |  |  | A.
 | 1419 |  |  | A.
 | 2150 |  |  | A.
 | 2909 |  |  | A.
 | 189 |  |  | A.
 | 120 |  |  | B.
 | 707 |  |  | B.
 | 1125 |  |  | B.
 | 547 |  |  | B.
 | 790 |  |  | B.
 | 1124 |  |  | B.
 | 1122 |  |  | B.
 | 1116 |  |  | B.
 | 789 |  |  | B.
 | 1434 |  |  | B.
 | 600 |  |  | B.
 | 1307 |  |  | B.
 | 401 |  |  | B.
 |  | 'A' SHIFT
 |  | 'B' SHIFT
 |  | 'C' SHIFT
 |  | 'G' SHIFT
 |  | TOTAL:
Spreadsheet: 1812d6b7-74c7-4f13-b991-81249effd650
Sheet: 60aaa

ISA SENIOR WORLD
JULY 26-27-28, 2013
COLUMBUS, IN
60 AAA DIVISION
TEAMS |  |  |  |  | WON |  | LOSS
1. [NAME] 60 |  |  |  |  | I |  | I
2.  Mid State Seniors |  |  |  |  | I |  | I
3.  Brickyard Classics |  |  |  |  | II
4.  Windsor Chiefs 60 |  |  |  |  | I |  | I
5.  [NAME], AA |  |  |  |  |  |  | II
Friday, July 26, 2013 - LINCOLN PARK
TIME |  | RUNS |  | TEAM # |  | RUNS |  | DIA. #
9am |  | 12 |  | 3 v 4 |  | 11 |  | #5
9am |  | 15 |  | 1 v 5 |  | 8 |  | #6
10:30am |  | 19 |  | 1 v 4 |  | 20 |  | #5
10:30am |  | 18 |  | 2 v 5 |  | 17 |  | #6
Noon |  | 13 |  | 2 v 3 |  | 16 |  | #6
[NAME]: 60 AAA - 2 seed games for seeding into a 3 game guarantee bracket.
Home Runs - AAA = 3 per team per game, outs
Run Rules - 5 runs per ½ inning at bat (except open inning)
Time Limits - RR = 65 + open inn. • Bracket = 70 + open inn. • Championship game(s) = 7 innings full
[NAME] to head (in full RR only), least runs allowed, run differential, coin toss
Equalizer - Team #5 gets 5 runs or 11 defensive players in all games.
Rosters are subject to SSUSA approval
[NAME] to Change at Discretion of Tournament and Field Directors
Spreadsheet: 23af0635-f975-4409-8120-14c302521ce0
Sheet: Sheet1

CCR5 genotype | Donor | Day | MOI | HIV | %NHEJ
wt/wt | ND304 | 29 | 600 | mock | 36.3
 |  | 29 | 600 | [NAME] (100ng)1 | 81.9
 |  | 29 | 600 | Bk132 (10ng)1 | 82.4
 |  | 29 | 600 | Bk132 (1ng)1 | 78.7
Δ32/Δ32 | [NAME] | 5 | 600 | Mock | 34.4
 |  | 15 | 600 | Mock | 35
 |  | 18 | 600 | Mock | 30.1
 |  | 28 | 600 | Mock | 37.2
 |  | 15 | 600 | Bk132 | 55.2
 |  | 18 | 600 | Bk132 | 73
 |  | 28 | 600 | Bk132 | 77.2
 |  | 15 | 600 | HxB2 | 32.5
 |  | 18 | 600 | HxB2 | 60.7
 |  | 28 | 600 | HxB2 | 80.2
 |  | 15 | 600 | R3A | 54.8
 |  | 18 | 600 | R3A | 64.7
 |  | 28 | 600 | R3A | 81.5
1The  number refers to the amount of HIV p24 used to infect per million cells. All experiments used 100ng unless specified.
Spreadsheet: 88566923-0c85-4f0b-aa1d-dc40cf6e14e0
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (23 Entries):
 | 12 Assemblies and subsystems 12.4 Hybrid modules (including multi-chip modules)
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AB Mikroelektronik GmbH | Austria | [NAME] | 5020 | A6.321
2 | Acal BFi Germany GmbH | Germany | Gröbenzell | 82194 | A5.377
3 | Art of Technology AG | Switzerland | Zürich | 8005 | B4.157/2
4 | AUREL S.p.A. | Italy | Modigliana (FC) | 47015 | A4.373
5 | Cicor Microelectronics | Germany | [NAME] | 01454 | A2.301
6 | ELBAU Elektronik Bauelemente GmbH Berlin | Germany | Berlin | 13088 | A2.220
7 | Fraunhofer-Institut für [NAME] und Systeme IKTS | Germany | Dresden | 01277 | B2.518
8 | HEI, Inc. | USA | Victoria | MN 55386 | C1.119
9 | W.C. Heraeus GmbH | Germany | Hanau | 63450 | A2.209
10 | HE System Electronic GmbH & Co.[NAME] | Germany | Veitsbronn | 90587 | A2.300
11 | Hong Hao Communications Co., Ltd. | Taiwan | [NAME] | 241 | B3.567
12 | Lust-Hybrid-Technik GmbH | Germany | Hermsdorf | 07629 | A2.232
13 | Microdul AG | Switzerland | Zürich | 8045 | A2.434
14 | MIPOT S.p.A. | Italy | Cormons (GO) | 34071 | A4.563
15 | NEW-TEC Electronic AG | Switzerland | [NAME] | 8708 | B6.518
16 | Omega Products PVT Ltd. | India | Mumbai | 400096 | B5.530/5
17 | Origin GPS Ltd | Israel | Jerusalem | 91391 | A4.468
18 | Siegert electronic [NAME] | Germany | Cadolzburg | 90556 | A2.212
19 | Stapelfeldt electronic GmbH | Germany | Hamburg | 22559 | A2.332
20 | TELECONTROLLI SRL | Italy | Casoria (NA) | 80026 | A4.478
21 | TURCK duotec GmbH | Germany | Halver | 58553 | A2.407
22 | Vectron International Hudson | USA | Hudson | NH 03051 | B5.237
23 | Vectron International Mt. Holly Springs | USA | Mt. Holly Springs | PA 17065 | B5.237
Spreadsheet: 814686d1674553059-consolidate-data-from-two-sheets-test-weekly-sales-yoy-by-customer
Sheet: 2023

 | 2023-01-02 00:00:00 |  |  | 2023-01-09 00:00:00
Customer J | 1146.6 |  | Customer I | 1528.93
Customer I | 1344.24 |  | Customer H | 1797.84
Customer F | 1795.68 |  | Customer G | 1866
Customer E | 2788.550000000001 |  | Customer k | 2376
Customer D | 3345 |  | Customer D | 2567.04
 |  |  | Customer C | 2643.84
 |  |  | Customer A | 3301.47
Spreadsheet: 222140d1363774417-automating-and-sorting-a-stock-demand-spreadsheet-stock-total-conundrum
Sheet: Sheet1

Stock Code |  |  |  |  |  | Values
Item No | Items |  | Order | Volume |  | Need to Be:
1 | Apples |  | Apples | 4 |  | 1
2 | Bannannas |  | Oranges | 2 |  | 3
3 | Oranges |  | Oranges | 3 |  | 3
4 | Grapefruit |  | Pears | 3 |  | 6
5 | Berries |  | Pears | 2 |  | 6
6 | Pears |  | Pears | 2 |  | 6
 |  |  |  | Values
 | Totals |  |  | Should Be: | Ideally what I would like the spread sheet to do
 | Apples |  |  | 4 | is recognise that Oranges marked in orange were
 | Bannannas |  |  | 0 | to register as a 3 also and therefore be counted
 | Oranges |  |  | 5 | in the totals.  This would also be the same for the pears
 | Grapefruit |  |  | 0 | in green.
 | Berries |  |  | 0 | I have produced this in Excel 2010 and I need to
 | Pears |  |  | 7 | understand how to do it in Excel 2007.  Many thanks.
Spreadsheet: 873298d1719798575-reverse-matching-find-enterprise
Sheet: Sheet1 (3)

Ref | Obj | type
1498 | 780 | basic
1498 | 789 | basic
1507 | 786 | basic
1511 | 780 | basic
1511 | 783 | basic
1511 | 789 | basic
1511 | 790 | basic
1511 | 921 | basic
1511 | 923 | basic
1523 | 789 | basic
1537 | 923 | basic
1538 | 786 | basic
1571 | 789 | basic
1574 | 780 | basic
1950 | 780 | basic
2008 | 789 | basic
2009 | 780 | basic
2010 | 780 | basic
2012 | 780 | basic
2014 | 921 | basic
2016 | 780 | basic
2017 | 780 | basic
2017 | 790 | basic
2027 | 780 | basic
2029 | 780 | basic
2029 | 790 | basic
2038 | 780 | basic
2039 | 789 | basic
2041 | 780 | basic
2059 | 786 | basic
2060 | 923 | basic
2063 | 780 | basic
2072 | 780 | basic
2073 | 789 | basic
2076 | 780 | basic
2077 | 783 | basic
2081 | 783 | basic
2091 | 780 | basic
2091 | 789 | basic
2091 | 790 | basic
2123 | 780 | basic
2123 | 789 | basic
2124 | 780 | basic
2124 | 789 | basic
2125 | 789 | basic
2126 | 780 | basic
2126 | 783 | basic
2127 | 780 | basic
2127 | 790 | basic
2137 | 780 | basic
2137 | 789 | basic
2137 | 923 | basic
2138 | 786 | basic
2138 | 789 | basic
2139 | 780 | basic
2139 | 790 | basic
2139 | 923 | basic
2140 | 780 | basic
2140 | 923 | basic
2372 | 780 | basic
2373 | 789 | basic
2375 | 780 | basic
2376 | 780 | basic
2377 | 790 | basic
2378 | 783 | basic
2379 | 783 | basic
2381 | 786 | basic
2382 | 780 | basic
2622 | 780 | basic
2623 | 780 | basic
2629 | 786 | basic
2793 | 780 | basic
2793 | 789 | basic
2793 | 921 | basic
2794 | 790 | basic
2870 | 783 | basic
3000 | 786 | basic
3669 | 923 | basic
3760 | 780 | basic
3825 | 790 | basic
3826 | 790 | basic
3827 | 780 | basic
3828 | 790 | basic
3834 | 786 | basic
3835 | 923 | basic
3887 | 923 | basic
4042 | 786 | basic
4136 | 780 | enterprise
4136 | 790 | enterprise
4138 | 786 | enterprise
4143 | 789 | enterprise
4144 | 790 | enterprise
4147 | 783 | enterprise
Spreadsheet: 48843d1248141653-pivot-table-of-subtotal-pivot-table-of-subtotal-929a
Sheet: Dry Data

 | Need Average output Rate based on Mix
Site | [NAME] | Family recipe | comp Recipe 1 | comp Recipe 2 | comp Recipe 3 | Comp1 [NAME] | Comp2 Ratio | Comp3 Ratio | Comp1 Extruder | Comp2 Extruder | [NAME] | Demand | Family Rate
GA1 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
GA1 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 200 | 6.3
GA1 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
GA1 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 6.3
GA1 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 8.5
GA1 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 8.5
GA1 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 8.5
GA1 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 10
GA1 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 15000 | 10
CA2 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
CA2 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 200 | 6.3
CA2 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 6.3
CA2 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 6.3
CA2 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 8.5
CA2 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 8.5
CA2 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 8.5
CA2 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 10
CA2 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 2000 | 10
AL1 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
AL1 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 1500 | 6.3
AL1 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 6.3
AL1 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
AL1 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 8.5
AL1 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 8.5
AL1 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 8.5
AL1 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 10
AL1 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 2000 | 10
DL2 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 6.3
DL2 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 1500 | 6.3
DL2 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 6.3
DL2 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 6.3
DL2 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 8.5
DL2 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 8.5
DL2 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 8.5
DL2 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 10
DL2 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 10
Spreadsheet: 271915d1382108303-vlookup-to-reference-cell-not-column-number-vlookup
Sheet: SALES-GRR

BILL | ITEM# | DESC | Qty/Bill | UoM | F/G Description | 2013-10-19 00:00:00 | 2013-10-26 00:00:00 | 2013-11-02 00:00:00 | 2013-11-09 00:00:00 | 2013-11-16 00:00:00 | 2013-11-23 00:00:00 | 2013-11-30 00:00:00 | 2013-12-07 00:00:00 | 2013-12-14 00:00:00 | 2013-12-21 00:00:00 | 2013-12-28 00:00:00 | 2014-01-04 00:00:00 | 2014-01-11 00:00:00 | 2014-01-18 00:00:00 | 2014-01-25 00:00:00 | 2014-02-01 00:00:00 | 2014-02-08 00:00:00 | 2014-02-15 00:00:00 | 2014-02-22 00:00:00 | 2014-03-01 00:00:00 | 2014-03-08 00:00:00 | 2014-03-15 00:00:00 | 2014-03-22 00:00:00 | 2014-03-29 00:00:00 | 2014-04-05 00:00:00 | 2014-04-12 00:00:00 | 2014-04-19 00:00:00 | 2014-04-26 00:00:00 | 2014-05-03 00:00:00 | 2014-05-10 00:00:00 | 2014-05-17 00:00:00 | 2014-05-24 00:00:00 | 2014-05-31 00:00:00 | 2014-06-07 00:00:00 | 2014-06-14 00:00:00 | 2014-06-21 00:00:00 | 2014-06-28 00:00:00 | 2014-07-05 00:00:00 | 2014-07-12 00:00:00 | 2014-07-19 00:00:00 | 2014-07-26 00:00:00 | 2014-08-02 00:00:00 | 2014-08-09 00:00:00 | 2014-08-16 00:00:00 | 2014-08-23 00:00:00 | 2014-08-30 00:00:00 | 2014-09-06 00:00:00 | 2014-09-13 00:00:00 | 2014-09-20 00:00:00 | 2014-09-27 00:00:00 | 2014-10-04 00:00:00 | 2014-10-11 00:00:00 | 2014-10-18 00:00:00 | 2014-10-25 00:00:00 | 2014-11-01 00:00:00 | 2014-11-08 00:00:00 | 2014-11-15 00:00:00 | 2014-11-22 00:00:00 | 2014-11-29 00:00:00
^20862 | ^101413 | Paint, Shot Blocker Black | 0.85 | OZ | SB, Team Realtree 18x18x14
^20862 | ^101416 | Rope, Shot Blocker Rope | 1.5 | EACH | SB, Team Realtree 18x18x14
^20862 | ^101417 | Hot Glue, REY 54-628 PLW | 0.5 | SQFT | SB, Team Realtree 18x18x14
^20862 | ^103218 | Wrap, SB [NAME] (20862) | 1 | SQFT | SB, Team Realtree 18x18x14
Spreadsheet: 220477d1363178133-link-sales-report-example
Sheet: in

Invoice Number | Item
1 | a
1 | b
1 | c
2 | a
2 | c
2 | d
3 | b
3 | c
4 | b
4 | c
4 | d
4 | e
5 | c
5 | e
6 | a
6 | c
6 | e
7 | a
7 | c
7 | d
7 | e
Spreadsheet: 89263d1289001841-data-by-month-help
Sheet: Sheet1

Date | Start Time | End Time
2010-09-01 00:00:00 | 09:00:00 | 10:00:00
2010-09-02 00:00:00 | 09:00:00 | 10:00:00
2010-09-03 00:00:00 | 09:00:00 | 10:00:00
2010-09-04 00:00:00 | 09:00:00 | 10:00:00
2010-09-05 00:00:00 | 09:00:00 | 10:00:00
2010-10-01 00:00:00 | 10:00:00 | 11:00:00
2010-10-02 00:00:00 | 10:00:00 | 11:00:00
2010-10-03 00:00:00 | 10:00:00 | 11:00:00
2010-11-01 00:00:00 | 11:00:00 | 11:30:00
2010-11-02 00:00:00 | 11:00:00 | 11:30:00
2010-11-03 00:00:00 | 11:00:00 | 11:30:00
2010-11-04 00:00:00 | 11:00:00 | 11:30:00
Spreadsheet: 191901d1352241683-counting-unique-criteria-example-thetrirdman-oeldere-
Sheet: Pivot

Checking | y
Saving | (Alles)
Credit Card | (Alles)
Rijlabels | Count of Employee |  |  |  | Som [NAME] | Kolomlabels
Dallas | 1 |  |  |  | Rijlabels | 1 | Eindtotaal
[NAME] | 1 |  |  |  | [NAME] | 1 | 1
HK | 1 |  |  |  | [NAME] | 1 | 1
[NAME] | 1 |  |  |  | yMelita [NAME] | 1 | 1
NYC | 2 |  |  |  | yRomaine Constant | 1 | 1
[NAME] | 2 |  |  |  | Eindtotaal | 4 | 4
Philly | 2
[NAME] | 2
Eindtotaal | 6
I created a quick example similar to the format I need to use.
In the pivot table you'll notice it's counting the account numbers based on the filtering criteria (Checking). I just want the employees visible counted (Each person who opened a checking account for someone, regardless of how many times). So it should count 4 when filtered by Checking.
Thanks for any help!
Spreadsheet: 824546d1680655086-summing-selected-entries-example
Sheet: Payments

Payee | Date | A/C 1 | A/C 2 | A/C 3 | A/C 4
Alby | 2023-01-03 00:00:00 | 20
George | 2023-01-03 00:00:00 |  | 27.5
[NAME] | 2023-01-03 00:00:00 | 15
[NAME] | 2023-02-05 00:00:00 |  | 5 |  | 12.44
[NAME] | 2023-02-06 00:00:00 |  |  |  | 4.56
[NAME] | 2023-03-14 00:00:00 |  | 41.2 | 25
Alby | 2023-03-17 00:00:00 |  | 15
[NAME] | 2023-03-17 00:00:00 |  |  | 45
[NAME] | 2023-03-21 00:00:00 | 41.56
Derek | 2023-03-26 00:00:00 |  | 125.5
Spreadsheet: 835801d1688828490-compare-dynamic-arrays-return-missing-values-compare_dynamic_arrays
Sheet: Feuil1

 |  |  |  |  | COMPARE TABLE A |  |  |  |  | WITH TABLE B |  |  |  |  | EXPECTED RESULTS: VALUES FROM A, PER COLUMNS, NOT EXISTING IN B, EXCEPT FOR EMPTY COLUMNS
1 | 2 | 3 | 4 |  |  | 2 | 3 | 4 |  |  | 2 | 3 | 4 |  | 1: v,c // 2: g // 4: a,x,c
a |  |  | a |  |  |  |  | a |  |  | d |  | z
b |  |  |  |  | b |  |  |  |  | b | v |  | h
v | d |  | x |  | v | d |  | x |  |  |  |  | u
c |  |  | c |  | c |  |  | c
 |  | f |  |  |  |  | f
 | d |  |  |  |  | d
a | d |  |  |  | a | d
 | g |  | z |  |  | g |  | z
 |  |  | h |  |  |  |  | h
1 | 2 | 3 | 4
a | d |  | z
b | v |  | h
 |  |  | u
Spreadsheet: 143267d1330340059-tweak-userform-for-holiday-planner-input-form-for-holiday-planner-vba
Sheet: Employee Data

Employee Name | From | To | Reason |  | Timestamp
AAAA | 2009-05-11 00:00:00 | 2009-09-11 00:00:00 | Holiday | user | 2009-11-10 10:29:57
AAAA | 2009-02-12 00:00:00 | 2009-09-12 00:00:00 | Training | user | 2009-11-10 10:31:03
AAAA | 2009-05-11 00:00:00 | 2009-09-11 00:00:00 | Holiday | user | 2009-11-10 15:53:50
AAAA | 2009-04-11 00:00:00 | 2009-09-11 00:00:00 | Half Day Sick | user | 2009-11-10 15:54:55
AAAA | 2009-01-12 00:00:00 | 2009-05-12 00:00:00 | Leiu Day | user | 2009-11-10 15:55:30
AAAA | 2009-04-11 00:00:00 | 2009-05-11 00:00:00 | Training | user | 2009-11-10 15:56:48
AAAA | 25/11/09 | 28/11/09 | Unauthorised Absence | user | 2009-11-10 15:58:09
AAAA | 2009-09-12 00:00:00 | 2009-09-12 00:00:00 | Sick | user | 2009-11-10 16:28:08
AAAA | 2010-01-12 00:00:00 | 2010-02-12 00:00:00 | Training | user | 2009-11-10 16:30:05
AAAA | 2009-01-04 00:00:00 | 2009-07-05 00:00:00 | Holiday | user | 2009-11-10 16:37:32
AAAA | 29/4/09 | 20/5/09 | Half Leiu Day | user | 2009-11-10 16:37:52
AAAA | 22/2/12 | 21/2/12 | Half Leiu Day | Administrator | 2012-02-06 21:58:42