tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 85937d1285933398-data-validation-hide-previously-used-dropdown-list-datavalidationtesterror
Sheet: Data

TASK CODE | Qty
HP0450 | 85 |  | Names start in column
LZ1700 |  |  | Columns to deduct A
SE0700 | 48 |  | Columns to deduct B
SP0380 | 50
SP1700 | 67
SR1700 | 50
TP1700
Spreadsheet: 749962d1633115409-how-to-return-top-values-based-on-cell-criteria-datereturn
Sheet: Sheet1

 | Beg Date |  |  |  | End Date
 | 2021-09-01 00:00:00 |  |  |  | 2021-11-30 00:00:00 |  | 13 |  | Dates to exclude
 |  |  |  |  |  |  |  |  | 2021-09-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-09-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
Spreadsheet: b6f98dc9-5f9f-4323-b5c9-c82e65ab4e1c
Sheet: Sheet1

2006 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 565/565 - Total Ballots Cast: 111325
Downloaded at 5/19/2013 4:59:24 PM
 | [NAME]
United States Senator - REP | 40647
TOTAL | 40647
 | [NAME]
United States Senator - DEM | 58231
TOTAL | 58231
 | [NAME]
Representative in Congress - REP | 40172
TOTAL | 40172
 | [NAME]
Representative in Congress - DEM | 57316
TOTAL | 57316
 | [NAME] (Al) Jaeger - REP
Secretary of State - REP | 41941
TOTAL | 41941
 | [NAME]
Secretary of State - DEM | 51023
TOTAL | 51023
 | [NAME]
Attorney General - REP | 42491
TOTAL | 42491
 | [NAME]
Attorney General - DEM | 50129
TOTAL | 50129
 | [NAME]
Agriculture Commissioner - REP | 41238
TOTAL | 41238
 | [NAME]
Agriculture Commissioner - DEM | 54302
TOTAL | 54302
 | [NAME]
Public Service Commissioner - REP | 41109
TOTAL | 41109
 | [NAME]
Public Service Commissioner - DEM | 50892
TOTAL | 50892
 | [NAME]
Tax Commissioner - REP | 40902
TOTAL | 40902
 | [NAME]
Tax Commissioner - DEM | 51457
TOTAL | 51457
 | [NAME]
Justice of the Supreme Court - NON | 89507
TOTAL | 89507
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: gerald_nemec__11405__eol screen
Sheet: Sheet1

 |  |  |  | Bid |  | Offer
Product Type | Location | Period | Unit | Volume | Price | Volume | Price
US Gas Phy Trspt | [NAME] | 2000-12-01 00:00:00 | USD/MM | 10000 | 0.1 | 10000 | 0.13
Product Description--DRAFT
A US Gas Transaction with Enron North America Corp., under which [NAME] shall sell and [NAME]
shall purchase non-recallable transportation capacity under Rate Schedule FTS-1 on
Columbia Gulf Transmission in a quantity equal to the Daily Contract Quantity at the Contract Price
on a firm basis.  The Contract Price shall be for the demand charge only and will be quoted in US dollars per MMBtu
per day.  All variable costs, including fuel, shall be borne by the [NAME] and paid directly to the pipeline, in addition
to the Contract Price herein.  The Period of Delivery shall be from the Effective Date through the Termination Date.
The term of the Transaction shall be from the Effective Date of 01 Dec 2000 to the Termination
Date of 31 Dec 2000.  The transaction is for capacity with a Primary Receipt Point of
Columbia Gulf-Rayne and a Primary Delivery Point of Columbia Gas Transmission-Leach.
All completed transactions must be posted on the appropriate pipeline bulletin board in
accordance with the pipeline tariff rules.  The transaction will be posted on the pipeline
bulletin board for competitive bids only if required by the tariff to be subject to bid.
Completed transactions must be posted in adequate time for completion of the bidding
and confirmation process to ensure timely nominations for the Effective Date.  If [NAME] fails
to post a completed Transaction on the pipeline bulletin board, [NAME] shall pay to [NAME] the
product of a) the Daily Contract Quantity and  (b) the difference between the Gas
Daily daily mid-point price for Columbia Gas Transmission-pool minus the Gas Daily daily
mid-point price for Columbia Gulf-onshore pool,  plus c) $.15 per [NAME], for each day during the term of the Transaction.
If [NAME] fails to complete a Transaction on the appropriate pipeline bulletin board, [NAME] shall pay to [NAME]
the Contract Price plus $.02 times the Daily Contract Quantity for each day during the term of the Transaction.
---------------------------------------------------------------------------------------------------------------------------------------------
Two other products shall be for Columbia Gas Transmission, FTS, from Leach to Zone 5, Market Area 2
and Columbia Gas Transmission, FTS, from Leach to Zone 10, Market Area 28.
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 6

 | November 1 | November 8 | November 15 | 2013-11-22 00:00:00 | November 29
Total Interest Rate* | 2968995 | 3638807 | 3014536 | 2933201 | 1359657
SDs and MSPs** | 1270391 | 1437794 | 1387659 | 1302927 | 528338
Other | 1698604 | 2201013 | 1626877 | 1630274 | 831319
Total Cross-Currency | 101146 | 161620 | 100879 | 168190 | 42084
SDs and MSPs | 78995 | 112608 | 71592 | 91901 | 27842
Other | 22150 | 49012 | 29287 | 76289 | 14242
Total Credit | 731447 | 764488 | 608408 | 893038 | 456078
SDs and MSPs | 452462 | 485298 | 382740 | 583786 | 304640
Other | 278985 | 279190 | 225668 | 309252 | 151439
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 3801587 | 4564915 | 3723823 | 3994429 | 1857819
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***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: 7fa7552b-057d-40c9-8ae0-b9d06e65dc37
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Digital Media Arts
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 847017d1698131920-create-dropdown-list-when-an-option-is-selected-in-b2-b44-dropdown-list_sample-3-
Sheet: Here

S/N | W4 Type | W-4 (2020 or [NAME] (before 2020)?
1 | W-4 (before 2020)
2 | W-4 (before 2020)
3 | W-4 (before 2020)
4 | W-4 (2020 or later)
5 | W-4 (2020 or later)
6 | W-4 (2020 or later)
7 | W-4 (2020 or later)
8 | W-4 (2020 or later)
9 | W-4 (2020 or later)
10 | W-4 (2020 or later)
11 | W-4 (2020 or later)
12 | W-4 (2020 or later)
13 | W-4 (2020 or later)
14 | W-4 (2020 or later)
15 | W-4 (2020 or later)
16 | W-4 (2020 or later)
17 | W-4 (2020 or later)
18 | W-4 (2020 or later)
19 | W-4 (2020 or later)
20 | W-4 (2020 or later)
21 | W-4 (2020 or later)
22 | W-4 (2020 or later)
23 | W-4 (2020 or later)
24 | W-4 (2020 or later)
25 | W-4 (2020 or later)
26 | W-4 (2020 or later)
27 | W-4 (2020 or later)
28 | W-4 (2020 or later)
29 | W-4 (2020 or later)
30 | W-4 (2020 or later)
31 | W-4 (2020 or later)
32 | W-4 (2020 or later)
33 | W-4 (2020 or later)
34 | W-4 (2020 or later)
35 | W-4 (2020 or later)
36 | W-4 (2020 or later)
37 | W-4 (2020 or later)
38 | W-4 (2020 or later)
39 | W-4 (2020 or later)
40 | W-4 (2020 or later)
41 | W-4 (2020 or later)
42 | W-4 (2020 or later)
43 | W-4 (2020 or later)
Spreadsheet: phillip_allen__28899__DRAW2
Sheet: Sheet1

Construction Draw | EAGLE SAGEWOOD PHASE I, LLC
Draw#
Job # | ESW1-ESW7
Owner | Eagle Sagewood Phase One, LLC
Addresses | 819/821 :825/827:831/833:837/839:843/845:849/851:855/857 SAGEWOOD TRAIL
Legal Descriptions | LOTS 21-27, BLOCK 0, HUGHSON HEIGHTS, SECTION 3-C
Construction Amount | Cost + 10%
 | DRAW | DRAW | DRAW | DRAW | DRAW | DRAW | DRAW
 | ONE | TWO | THREE
TOTAL LINE ITEMS | 32360.54 | 96920.02 | 18055.33
LESS: SALES TAX | 0 | -1765.5 | -614.52
LESS: SUPERVISION | 0 | -600 | -600
TOTAL FOR FEE CALC | 32360.54
ADD: 10% CC FEE | 3236.05
ADD: SALES TAX | 0 | 1765.5 | 614.52
ADD: SUPERVISION | 0 | 600 | 600
TOT AMT OF CURRENT DRAW | 35596.59
LESS: 10% RET INCOMPL. LAB. ITEMS | 0 | 0 | 0
NET AMT OF CURRENT DRAW REQUEST
LESS DRAW AT CLOSING | 17000 | 0 | 0
NET REQUEST | 18596.59
TOTAL REQUEST TO DATE | 0
TOTAL PAID TO DATE
DATE OF DRAW | 1998-06-04 00:00:00 | 1998-06-29 00:00:00 | 1998-07-02 00:00:00
The undersigned Borrower certifies that to the best of the Borrower's knowledge, information and belief the Work covered by this Application for
Payment has been completed in accordance with the Contract Documents, that aD amounts have been paid by the Contractor for Work for which the
previous Certificates of Payment were issued and payments received from the Owner, and that current payment shown herein is now due.
Eagle Sagewood Phase I, LLC
by: ____________________________________________ | date: | 6/2/98
[NAME], President
Spreadsheet: 846072d1697371222-formula-to-split-prorata-taxes-and-vat-based-on-3-criteria-columns-of-summary-sheet-dummy-tax-ca-sample-
Sheet: REPORT

TARIFF | [NAME] | origin. | AMOUNT | ITEMISED | DUTY | VAT
94054920 | SOLAR LED LAMPS. | CN |  | 1 | 50000 | 1200
56029000 | FELT ARTICLES | CN |  | 2 | 25000 | 2500
83021000 | HINGES | CN |  | 3 | 10000 | 1500
83024900 | STEEL TUBES | FR |  | 4 | 23000 | 3000
83024900 | BASED METAL MOUNTINGS | CN |  | 5 | 1200 | 1500
Spreadsheet: 116888d1312275226-selective-columns-handicapscorecards-master3
Sheet: result

Position | PLAYER | TOTAL |  | [NAME] | No | PLAYER | PAR 3 | TOTAL | S.I. > | 1 | 2 | 3
Spreadsheet: 851876d1701995377-change-the-color-of-a-cell-in-a-sheet-based-on-another-cell-that-is-in-a-different-tab-book1-etaf-1-try1
Sheet: Cabin Alocation

EDT  JANE      CABIN ALLOCATION
C | 600 |  |  | 603 |  |  | 604 |  |  | 605 |  |  | 608 |  |  | 609 |  |  | 610 |  |  | The E3 cell in the cabin allocation tab (which takes data from the cabin list tab, specifically the position on the ship, in this case the chief officer) should light up
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to a specific color depending on what shift (shift in the cabin list tab) will be assigned to it in the cabin list tab.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depending on the time (4 in total to choose from: 1200-2400, 2400-1200, 0600-1800, 1800-0600), I would like to have cells with positions on the ship in the cabin allocation tab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to be colored in a selected color after entering the shift time hour in the shift (cabin list) column.
B | 502                                             503 |  |  |  |  |  | 504 |  |  | 505 |  |  | 530 |  |  | 531 |  |  | 532
 | 533 (W) |  |  | 534  (W) |  |  | 535  (W) |  |  | 536  (W) |  |  | 537  (W) |  |  | 538  (W) |  |  | 539
A | 430 |  |  | 431 |  |  | 432 |  |  | 433  (W) |  |  | 434  (W) |  |  | 435 |  |  | 437
 | 438  (W) |  |  | 439 |  |  | 401 |  |  | 402 |  |  | 403 |  |  | 404 |  |  | 405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOAT
 |  |  | d
 | 406 |  |  | 407 |  |  | 408 |  |  | 409 |  |  | 410 |  |  |  | 12:00-24:00 |  | 00:00-12:00 | temporary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00-18:00 |  | 18:00-06:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOAT
 |  | Date: |  | 2023-11-24 00:00:00 |  |  | MARINE CREW |  |  |  |  |  | CHARTERERS |  |  |  |  | TOTAL : | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FREE BEDS:
Spreadsheet: 167891d1342139438-a-complicated-look-up-table-with-multiple-conditions-complex-look-up
Sheet: Result

 |  |  |  | Jan | Feb | Mar | April | May | June
[NAME]
TM72006 | [NAME](Z9002) | Z9002 | In Brand Text column from LookUP Data tab | 60 | 70
TM72001 | [NAME]  (ZCT) | [NAME] | In Brand Text column from LookUP Data tab
TM72004 | TMF ACRYLIC 1-P (ZMB00) | [NAME] | In Product Size column from LookUP Data tab | 53 | 56
TM72001 | TMF ACRYLIC 3-P (ZMA00) | ZMA00 | In Product Size column from LookUP Data tab | 63 | 75
TM72006 | Phaco Tips | Reusable Tips + Disposable Tips | In Brand Text column from LookUP Data tab, 2 combined look up vales | 138 | 140
TM72001 | PHACO ACC- FX [NAME] | Sovereign Accessories | In Brand Text column from LookUP Data tab
TM72001 | Phaco Equipment / Signature $ | WhiteStar Signature | In Brand Text column from LookUP Data tab
TM72001 | Fitzory | Kalmore | Not there in the Look UP Data
Look UP Values |  | Look Up Values |  | to auto populate Net Sales Values values
from Terr Surg column of LookUP [NAME] |  | some of these values are found in "Brand Text" column and Some in "Product Size Column" |  | ( if value not there, should appear as blank, no #NA vales to be there)
Spreadsheet: daren_farmer__5047__HPLN0418
Sheet: Sheet1

HPLN0418.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
 |  |  |  |  |  | Revision #1
SUBJECT:  TXU FUELS NOMINATION - April 18, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 15
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 15
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 757601d1638360035-want-to-add-additional-condition-to-if-and-countifs-function-query-if-countifs
Sheet: Matched Manually

Line | As Per | TIN | Trade Name | Remarks | GST
1483 | PORTAL | 03BCWPK5798D9X4 | January | Matched | 950 |  | Match Portal and Books
1484 | PORTAL | 03BCWPK5798D9X4 | January | Matched | 826 |  | Remarks entered with =IF(COUNTIFS(C$2:C2,C2,F$2:F2,F2)=1,"Matched","Mismatch")
2897 | Books | 03BCWPK5798D9X4 | Jan | Matched | 951 |  | If GST amounts of Portal and Books have a difference of +1/- or -1/- then also it is a match
2899 | Books | 03BCWPK5798D9X4 | Jan | Matched | 825 |  | If matched get "Matched"
561 | PORTAL | 06BBBCH0643R9XF | February | Matched | 4147.2 |  | If in Portal and not in Books "Books Not Entered"
2162 | Books | 06BBBCH0643R9XF | Feb | Matched | 4147 |  | If in Books and not in Portal "Not in Portal"
1834 | Books | 06BBBCJ9939H9XW | March | Not in Portal | 672
47 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 65.41
500 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 197
669 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 65.41
1268 | PORTAL | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Books Not Entered | 130.82
3087 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 64.45
3088 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 65.41
3089 | Books | 06BBBCJ8890B9XY | SNAPDEAL PRIVATE LIMITED | Matched | 196.23
60 | PORTAL | 06BBCCV7495P9XV | April | Matched | 5454
356 | PORTAL | 06BBCCV7495P9XV | April | Matched | 13140
1716 | Books | 06BBCCV7495P9XV | APR | Matched | 5454.05
1847 | Books | 06BBCCV7495P9XV | APR | Matched | 13140
Spreadsheet: 67816d1268329057-formula-to-return-value-based-on-category-available-hours2
Sheet: Sheet1

Output table |  |  | Gregs weekly condition |  | Category lookup | Set hours to train
[NAME] |  | Greg | Week1 | Healthy | Conditon | Training hours per week
Week 1 |  | Greg | Week2 | Healthy | Healthy | Week 1 | 30
Greg |  | Greg | Week3 | Injured | Injured | Week 2 | 28
Set training hours | 30 | Greg | Week4 | Quit | Quit | Week 3 | 25
Hours injured | 0 |  |  |  |  | Week 4 | 31
Actual training hours | 30
Week 2
Greg
Set training hours | 28
Hours injured | 0
Actual training hours | 28
Week 3
Greg
Set training hours | 25
Hours injured | 5
Actual training hours | 20
Week 4 (Quit)
Greg |  |  | (Worksheet 2) |  |  | (Worksheet 3)
Set training hours | 0
Hours injured | 0
Actual training hours | 0
(Worksheet 1)
Below is the IF/Vlookup statement I've tried without any luck. Thi formula will go in cells B5, B10, B15, [NAME].
IF(VLOOKUP(A4,C:E,3,0),=F:F,H3),=F:F,H3-B6),=F:F,0)
If [NAME] is healthy he is available to train 30 hours per week if hes injured hes available the 30 hours per week minus the 5 hours injured (25 hours) if he has Quit then his hours to train are zero
Spreadsheet: 484877d1476530693-adding-data-relating-to-both-blank-and-ful-lcells-query2
Sheet: Sheet1

Name | Time | Amount | 'D' | 'D' |  | Table 'A' works fine, but what I would like to do is not to duplicate the [NAME] 'D' time (09:00) (as in Table 'B') and still get the Amount total of 600 as in Table 'A'. In other words, in Table 'B', [NAME], to sum the amounts adjacent to the time 09:00 and the following (two) blank cells.
D | 09:00:00 | 100 | Time | Amount
 | 09:00:00 | 200
 | 09:00:00 | 300
 | 10:00:00 | 400 | Table 'A'
 |  | 500
 |  | 200
 |  | 300
Name | Time | Amount | 'D' | 'D' |  | Any 'Amounts' corresponding to a later time and subsequent blank cells are not to be included. There can be any number of blank cells between the 'D' time (09:00) and a later time entry.
D | 09:00:00 | 100 | Time | Amount
 |  | 200
 |  | 300
 | 10:00:00 | 400 | Table 'B'
 |  | 500
 |  | 200
 |  | 300 |  |  |  | The 'D' time can be any time and in any row as in Table 'C'.
Name | Time | Amount | 'D' | 'D' |  | It is possible that there may not be a later time entry and that there may be blank cells with no adjacent 'amounts' as in Table 'C'. It is assumed that if there is an additional 'amount' entry it will be part of the 'D' group, unless accompanied by a later time entry -
 | 08:30:00 | 50 | Time | Amount
D | 09:30:00 | 100
 |  | 200
 |  | 300 | Table 'C'
 |  |  |  |  |  | in which case it will not be part of the calculations.
Spreadsheet: f91144b2-15c7-4767-a5bd-2c45e7d1d87a
Sheet: Sheet1

[NAME],  by County and Public Health District, Maine 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Number |  | Rate*
Maine Total |  | 195 |  | 14.68165651248167
County
 | Androscoggin | 14 |  | 13.03562449952513
 | Aroostook | 6 |  | 8.393721496320753
 | Cumberland | 44 |  | 15.58068137152489
 | Franklin | 4 |  | 13.00982241592402
 | Hancock | 4 |  | 7.328960386969109
 | Kennebec | 23 |  | 18.86250871365892
 | Knox | 1 |  | 2.518384204694268
 | Lincoln | 4 |  | 11.68770453482936
 | Oxford | 9 |  | 15.59927203397175
 | [NAME] | 25 |  | 16.256356235288
 | Piscataquis | 2 |  | 11.48171536827602
 | Sagadahoc | 6 |  | 17.0420654983384
 | Somerset | 15 |  | 28.83062966095179
 | [NAME] | 3 |  | 7.742934572202865
 | Washington | 3 |  | 9.192021325489476
 | York | 32 |  | 16.1453892300163
Public Health District
 | Aroostook | 6 |  | 8.393721496320753
 | Central | 38 |  | 21.84372538988175
 | Cumberland | 44 |  | 15.58068137152489
 | Downeast | 7 |  | 8.02614229203692
 | [NAME] | 14 |  | 9.46687944605231
 | Penquis | 27 |  | 15.7705674483806
 | Western | 27 |  | 13.78683510434592
 | York | 32 |  | 16.1453892300163
* Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
Spreadsheet: 732173d1620813987-number-of-different-values-in-a-range-based-on-criteria-test2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Office: | HQ
JAN | 2021-01-01 00:00:00 | AAA | hq |  |  |  |  |  |  |  | Month | #cars used
 | 2021-01-12 00:00:00 | AAA | hq |  |  |  |  |  |  |  | JAN
 | 2021-01-20 00:00:00 | AAA |  | 2x AAA, so desired value is "1" |  |  |  |  |  |  | FEB
FEB | 2021-02-03 00:00:00 | BBB | hq |  |  |  |  |  |  |  | MAR
 | 2021-02-17 00:00:00 | BBB | hq |  |  |  |  |  |  |  | APR
 | 2021-02-18 00:00:00 | BBB |  |  |  |  |  |  |  |  | MAY
 | 2021-02-24 00:00:00 | AAA |  | 2x BBB, so desired value is "1" |  |  |  |  |  |  | JUN
MAR | 2021-03-03 00:00:00 | AAA | hq |  |  |  |  |  |  |  | JUL
 | 2021-03-07 00:00:00 | AAA | hq |  |  |  |  |  |  |  | AUG
 | 2021-03-08 00:00:00 | CCC |  |  |  |  |  |  |  |  | SEP
 | 2021-03-11 00:00:00 | CCC | hq |  |  |  |  |  |  |  | OCT
 | 2021-03-14 00:00:00 | CCC |  |  |  |  |  |  |  |  | NOV
 | 2021-03-21 00:00:00 | CCC |  |  |  |  |  |  |  |  | DEC
 | 2021-03-23 00:00:00 | CCC
 | 2021-03-29 00:00:00 | AAA | hq
 | 2021-03-30 00:00:00 | AAA | hq | 4x AAA & 1xCCC, so desired value is "2"
APR | 2021-04-02 00:00:00 | BBB
 | 2021-04-04 00:00:00 | BBB | hq
 | 2021-04-04 00:00:00 | AAA | hq |  |  |  |  | >> while this formula is doing what it's supposed to, it has to be applied to every cell in column, which is not practical because the main range is above 500k rows and it will put too much strain on excel
 | 2021-04-06 00:00:00 | CCC
 | 2021-04-08 00:00:00 | CCC | hq
 | 2021-04-18 00:00:00 | BBB | hq
 | 2021-04-20 00:00:00 | DDD
 | 2021-04-23 00:00:00 | DDD | hq
 | 2021-04-27 00:00:00 | DDD | hq
 | 2021-04-28 00:00:00 | AAA | hq
 | 2021-04-30 00:00:00 | DDD | hq | 2x AAA, 2xBBB, 1xCCC, 3xDDD, so desired value is "4"
MAY | 2021-05-02 00:00:00 | EEE
 | 2021-05-04 00:00:00 | AAA | hq
 | 2021-05-05 00:00:00 | CCC | hq
 | 2021-05-07 00:00:00 | CCC | hq
 | 2021-05-08 00:00:00 | BBB |  | 1xAAA, 2xCCC, so desired value is "2"