tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738311d1624964168-extracting-position-change-dates-in-employee-data-sample
Sheet: EXAMPLE

Pers.no. | Name Last Name | Beginning Date | End Date | Position
310 | [NAME] | 2015-07-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
313 | [NAME] | 2015-07-01 00:00:00 | 2016-03-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-04-01 00:00:00 | 9999-12-31 00:00:00 | SUPERVISOR
318 | PETE PACKETT | 2015-07-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2016-02-01 00:00:00 | 2017-01-31 00:00:00 | SUPERVISOR
318 | PETE PACKETT | 2017-02-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2015-07-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2015-07-01 00:00:00 | 2016-05-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2016-06-01 00:00:00 | 9999-12-31 00:00:00 | SUPERVISOR
Spreadsheet: 729994d1619469773-array-error-checking-formula-excelhelp-formula
Sheet: Sheet5

Was SME Used? | SME Involvement | First Opinion | Second Opinion | Third Opinion | Outcome | SampleSize | Date/Time
NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL
Yes | NULL | NULL | NULL | NULL | NULL | NULL | NULL
NULL | Priority | NULL | NULL | NULL | NULL | NULL | NULL
NULL | NULL | NULL | NULL | NULL | Failure | NULL | NULL
Yes | Priority | 11 | 2200 | 14 | Success | 19000 | 2020-01-01
Spreadsheet: daren_farmer__6652__Gas Assets Ops 03-00 Prelim O&M
Sheet: Engergy Ops

ENGY_OPS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-01-01 00:00:00 |  | 1999-02-01 00:00:00 |  | 1999-03-01 00:00:00 |  | 1999-04-01 00:00:00 |  | 1999-05-01 00:00:00 |  | 1999-06-01 00:00:00 |  | 1999-07-01 00:00:00 |  | 1999-08-01 00:00:00 |  | 1999-09-01 00:00:00 |  | 1999-10-01 00:00:00 |  | 1999-11-01 00:00:00 |  | 1999-12-01 00:00:00
 |  | ACTUAL |  | PLAN99 |  |  |  | ACTUAL |  | PLAN99
ECT |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense: |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_EMP_EXP | Employee Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Technology
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 884560d1733796769-if-and-between-two-times-example
Sheet: Sheet1

Date | Start | Finish | Item | Qty of TCs | Qty of Vehicles | TGS | Notes / Location | Total Hours Worked | - 30min Meal Break
2024-10-07 00:00:00 | 18:00:00 | 05:30:00 |  | 2
2024-10-20 00:00:00 | 18:00:00 | 05:30:00 |  | 2
2024-10-20 00:00:00 | 18:00:00 | 05:00:00 |  | 6 | 6
2024-10-20 00:00:00 | 18:00:00 | 05:00:00 |  | 1 | 1
2024-10-21 00:00:00 | 06:00:00 | 17:30:00 |  | 1 | 4
2024-10-21 00:00:00 | 16:30:00 | 05:30:00 |  | 2
Spreadsheet: 160341d1339060008-comparing-a-certain-number-of-text-in-a-different-worksheet-sample-1-1-
Sheet: Sheet1

72ND SCIENTIFIC SESSIONS AMERICAN D
79 SOUTH CHINA IMPORT INC.
834TH US ARMY TRANS BATALLION
A   B WIPER SUPPLY INC.
A.G. [NAME] BRASIL
A.HARTRODT CANADA LTD.2355
A.J. HENDRIKS & SONS GREENHOUSES IN
A.PACIFIC EXPRESS ENTERPRISES
A.S. MILL PRODUCTS INC.
A.W. Faber-Castell USA, Inc.
A.W.R INC
A1 GRANITE LTD.
AAVANTI INDUSTRIES PTE., LTD
AB MAURI FOOD INC
ABA PACKAGING CORPORATION
ABASTOS TELENO S.A. DE C.V.
ABBOTS JEWELLERY   PERFUMERY
ABBOTT NUTRITION
ABC NEW YORK CORP.
[NAME] AND MOPS
ABE JANITORIAL SUPPLY INC
asap-n
Spreadsheet: 128457d1320966935-display-time-across-a-time-range-sample-timetale_daddy
Sheet: Sheet3 (2)

 |  |  |  | Aim/Target |  | 7--8 | 8--9 | 9--10 | 10--11 | 11--12 | 12--13 | 13--14 | 14--15 | 15--16 | 16--17 | 17--18 |  |  |  | 21--22 | 22--23 | 23--00 | 00--01 | 01--02 | 02--03
 |  |  |  |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00
 |  |  |  |  | ICR | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 2 | 2 | 1 | 1 | 0
 |  |  |  |  | DM | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 3 | 2 | 2 | 1 | 1 | 0
 |  |  |  |  | JPP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 3 | 3 | 2 | 2 | 1
 |  |  |  |  | RVR | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 3 | 2 | 2 | 1 | 1 | 0
Type | Start | End
ICR | 17:00:00 | 01:00:00
DM | 20:00:00 | 04:00:00
JPP | 23:00:00 | 07:00:00
RVR | 22:00:00 | 06:00:00
ICR | 18:00:00 | 02:00:00
DM | 17:00:00 | 01:00:00
JPP | 20:00:00 | 04:00:00
RVR | 10:00:00 | 18:00:00
ICR | 22:00:00 | 06:00:00
DM | 18:00:00 | 02:00:00
ICR | 10:00:00 | 20:00:00
RVR | 20:00:00 | 04:00:00
ICR | 07:00:00 | 15:00:00
DM | 22:00:00 | 06:00:00
JPP | 18:00:00 | 02:00:00
RVR | 17:00:00 | 01:00:00
ICR | 20:00:00 | 04:00:00
DM | 07:00:00 | 13:00:00
JPP | 22:00:00 | 06:00:00
RVR | 18:00:00 | 02:00:00
ICR | 07:00:00 | 15:00:00
Spreadsheet: 862872d1710442537-formula-to-calculate-progress-progress-example
Sheet: Sheet1

07:00:00 | 10:00:00 | 14:00:00 | 16:00:00 | Progress
100
07:00:00 | 10:00:00 | 14:00:00 | 16:00:00 | Progress
100 | 75
07:00:00 | 10:00:00 | 14:00:00 | 16:00:00 | Progress
100 | 75 | 45
07:00:00 | 10:00:00 | 14:00:00 | 16:00:00 | Progress
100 | 75 | 45 | 2
 |  |  | All of these in one formula
Spreadsheet: 065a5765-091d-4133-a943-361fd2de82d0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FIBUP | Test | FIBUP | Ibuprofen (Motrin, Advil, Nuprin), serum | Ibuprofen (Motrin, Advil, Nuprin) | High Performance Liquid Chromatography with Ultraviolet Detection; (HPLC-UV) |  |  |  | 1 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 1 mL sodium heparin plasma refrigerated in plastic vial.  Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 1 mL of serum refrigerated in plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Anticoagulants other than Sodium heparin, EDTA, plain red-top | Reference Range:  10.0-50.0 ug/mL   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Tuesday, Thursday, Saturday | 3 days | 5 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FIBUP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FIBUP | Result | Z3317 | Ibuprofen | Ibuprofen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 61682d1262623284-find-average-formula-average
Sheet: Sheet1

Daily Batches and Defective Log Week Of 1/4/2010
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
3rd Shift   L-1 | 80
3rd Shift   L-2 | 80
3rd Shift   [NAME] | 80
2nd Shift   L-1 | 80
2nd Shift   L-2 | 80
2nd Shift   [NAME] | 80
1st Shift    L-1 | 80
1st Shift    L-2 | 80
1st Shift    L-3 | 80
Total Batches mixed
Average per 8 hr. shift
[NAME].
Internal Defective Batches | 6
External [NAME] x 2 = | 4
Daily Average after [NAME]
Total Weekly average Before Defective |  |  | Total Weekly Average After [NAME] |  |  | Payout week of 1/5/2010
Spreadsheet: 98955d1297767592-filter-data-from-table-book1
Sheet: Enquiry

Item Code | Last Selling Price1 | L.S.Date1 | L.S.P.2 | L.S.D.2 | L.S.P.3 | L.S.D.3
a001 | 3.7 | 2012-03-01 00:00:00 | 3.5 | 2012-01-01 00:00:00 | 3.2 | 2011-10-01 00:00:00
b002 | 3.6 | 2012-02-01 00:00:00 | 3.4 | 2011-12-01 00:00:00 | 3.3 | 2011-11-01 00:00:00
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: TEDA (A33D) (Cat - 2)

Raw Material |  | TEDA (A33D) (Cat - 2)
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 90
2023-12-03 00:00:00 |  | 8 | 25
Total
Spreadsheet: 586738d1534545001-how-to-get-specific-rows-in-a-worksheet-copied-from-another-coloured-backgrounds
Sheet: Income

Date | Title | Money
2018-02-11 00:00:00 | Sale A | 21.5
2018-02-12 00:00:00 | Sale B | 32
2018-02-14 00:00:00 | Sale A | 22
2018-02-15 00:00:00 | Sale A | 22
2018-02-16 00:00:00 | Sale Z | 23
2018-02-21 00:00:00 | [NAME] | 200
Spreadsheet: 197314d1354291829-find-occurrences-of-customer-numbers-in-a-column-and-number-them-1-2-3-etc-wace_example
Sheet: Sheet1

CustomerCode | InvoiceDate | OrderNumber | Currency | CustomerName | InvoiceComment | GLAccount | LineNumber
90679 | 11/30/2012 |  | CAD |  |  | 4107 | 1
45332 | 11/30/2012 |  | CAD |  |  |  | 1
90679 | 11/30/2012 |  | CAD |  |  |  | 2
32199 | 11/30/2012 |  | CAD |  |  |  | 1
45332 | 11/30/2012 |  | CAD |  |  |  | 2
45332 | 11/30/2012 |  | CAD |  |  |  | 3
Spreadsheet: 49691d1249024460-help-using-randbetween-randomnumgenerator
Sheet: Hoja1

 |  |  |  |  |  |  |  |  | Hide these two columns if you wish
 |  |  | A
 |  |  | 11 | These formulas find the "smallest" value in column K |  |  |  |  | 1 | 0.6728893801979945
 |  |  | 6 | and then return the matching value from column J. |  |  |  |  | 2 | 0.967778143660162
 |  |  | 13 | Since column K is randomizing extremely small numbers, |  |  |  |  | 3 | 0.9177339500059205
 |  |  | 7 | the chances at duplicates are almost zero. |  |  |  |  | 4 | 0.3487643599424013
 |  |  | 5 |  |  |  |  |  | 5 | 0.2953483942540418
 |  |  | 4 |  |  |  |  |  | 6 | 0.02639982377813688
 |  |  | 12 |  |  |  |  |  | 7 | 0.1311077260441467
 |  |  | 8 |  |  |  |  |  | 8 | 0.4514260703001183
 |  |  | 15 |  |  |  |  |  | 9 | 0.859473608473019
 |  |  |  |  |  |  |  |  | 10 | 0.8739884198106769
 |  |  |  |  |  |  |  |  | 11 | 0.02084005348492779
 |  |  |  |  |  |  |  |  | 12 | 0.4076378570969537
 |  |  |  |  |  |  |  |  | 13 | 0.08714168897038266
 |  |  |  |  |  |  |  |  | 14 | 0.9467307538032861
 |  |  |  |  |  |  |  |  | 15 | 0.5471405392560182
Spreadsheet: 271876d1382094051-check-if-all-items-in-a-range-based-on-a-particular-filter-are-in-a-report-example
Sheet: Sheet1

Customer | Active |  |  |  |  | Report
A | Yes |  |  |  |  | A
B | No |  |  |  |  | C
C | Yes |  |  |  |  | D
D | Yes |  |  |  |  | F
E | No
F | Yes
 |  |  |  |  | I would like that the formula would return TRUE if all the Active customers ("Yes") are included in the report ("G") column and FALSE if, for example B Customer would be Active ("Yes").
Spreadsheet: 819776d1677686285-adding-a-select-drop-down-filter-calendar-doc
Sheet: Help

HELP
 | https://www.vertex42.com/calendars/content-calendar.html
 |  | © 2020-2022 Vertex42 LLC
About This Template
 | This content calendar was designed to help plan and schedule content development for bloggers and other internet publishers. It can modified and used for other types of content development as well.
Instructions and Notes
Use the Settings Worksheet
 | You can change some of the labels and options in the Settings worksheet. You can also customize the list of holidays in the Settings worksheet.
Moving Rows
 | After you select an entire row (SHIFT+SPACE), if you hold the SHIFT key as you click and drag the edge of the selection with your mouse, you can use the mouse to drag the row to move it. This is a very convenient way to move rows.
Adding More Rows
 | When you insert new rows, you should insert a blank row between rows that have the formatting you want. If you do that, the formatting will be copied automatically.
 | IMPORTANT: After inserting a new row, copy a previous row and paste over the new row so that all of the formula are copied into the new row!
Changing the Colors
 | Changing the colors in the legends won't change anything. The best way to change the colors used for the 6 status options is to customize the Theme Colors (Accent colors 1-6). Go to Page Layout > Themes.
Conditional Formatting
 | This spreadsheet uses conditional formatting quite heavily. To edit conditional formatting rules, go to Conditional Formatting > Manage Rules and select "This Worksheet" to see and edit all the rules.
Content Worksheet, Column B
 | Column B serves no functional purpose other than making the list look a bit more interesting, color-coded based on the Status.
[NAME]
 | The [NAME] worksheet provides a way to list your commonly used hashtags, using the Sort and Filter features in Excel to pick which of the hashtags you want to use in your post.
Use the End Date column to show Duration in the Content Worksheet
 | Use the End Date column to highlight dates between the Publish Date and the End Date within the Content worksheet. This feature is useful for displaying the duration of an ad or sale. NOTE: Using the End Date column will not show publish durations in the [NAME] worksheet.
Additional Help and Resources
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: Assets

Assets
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Assets
Grass |  | Gas |  | Assets
Meyer |  | Gas |  | Assets
Mrha |  | Gas |  | Assets
Bieniawski |  | Gas |  | Assets |  | 425000
Total
Spreadsheet: 109642d1306437219-is-there-a-way-to-hide-a-cell-without-changing-the-font-color-conditional-format-example
Sheet: Sheet1

Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10
0.01
0.02
0.03
0.08
0.05
0.06
0.07
1
0.09 | 0.18
0.1
Spreadsheet: 849817d1700203770-help-needed-plz-with-if-or-sumif-help-please-aligw
Sheet: Sheet4

Individual |  |  |  |  |  |  | -
Aiden |  |  |  |  |  |  | Aiden
 |  |  |  |  |  |  | [NAME]
 | Q1-2024 | Q2-2024 | Q3-2024 |  |  |  |  | E | A | B & C | D | CALC
Value
 |  |  |  |  |  |  |  | True | 1 | 1 | 130196.7964511124
 |  |  |  |  |  |  |  | False | 1 | 1 | 6299.502276325147
 |  |  |  |  |  |  |  | False | 1 | 1 | 19528.45705660796
 |  |  |  |  |  |  |  | False | 1 | 0 | 5000
 |  |  |  |  |  |  |  | False | 1 | 1 | 2200
 |  |  |  |  |  |  |  | False | 1 | 0 | 84467.72040541077
 |  |  |  |  |  |  |  | False | 1 | 0 | 152727.0356369143
Liklihood | Owner | Support | $$$$ | Period |  |  |  | False | 1 | 1 | 133322.6661761454
Won | Aiden |  | 10000 | Q1-2024 |  |  |  | False | 1 | 0 | 317587.8827813814
Won | Aiden |  | 130196.7964511124 | Q1-2024 |  |  |  | False | 1 | 0 | 102274.7817694924
Won | Aiden |  | 6299.502276325147 | Q2-2024 |  |  |  | False | 1 | 0 | 224077.7560164972
Maybe | Aiden |  | 19528.45705660796 | Q2-2024 |  |  |  | False | 0 | 1 | 500
Maybe | [NAME] |  | 5000 | Q2-2024 |  |  |  | False | 0 | 1 | 27087.85978819813
Maybe | Aiden |  | 2200 | Q2-2024 |  |  |  | False | 0 | 0 | 1000
Maybe | [NAME] |  | 84467.72040541077 | Q2-2024 |  |  |  | False | 0 | 1 | 25198.00910530059
Maybe | [NAME] |  | 152727.0356369143 | Q2-2024 |  |  |  | False | 0 | 1 | 73215.58093695017
Maybe | Aiden |  | 133322.6661761454 | Q2-2024 |  |  |  | False | 1 | 1 | 22102.15650861425
[NAME] | [NAME] |  | 317587.8827813814 | Q3-2024 |  |  |  | False | 1 | 0 | 25000
[NAME] | [NAME] |  | 102274.7817694924 | Q3-2024 |  |  |  | True | 1 | 0 | 6855.716829813276
[NAME] | [NAME] |  | 224077.7560164972 | Q3-2024 |  |  |  | True | 1 | 0 | 11592.93624210751
Will Not Win | Aiden |  | 500 | Q2-2024 |  |  |  | True | 1 | 1 | 7396.71808530408
Will Not Win | Aiden |  | 27087.85978819813 | Q2-2024 |  |  |  | False | 1 | 1 | 5000
Will Not Win | [NAME] |  | 1000 | Q2-2024 |  |  |  | False | 1 | 0 | 5855.03459371675
Will Not Win | Aiden |  | 25198.00910530059 | Q2-2024 |  |  |  |  |  |  |  |  | SUM
Will Not Win | Aiden |  | 73215.58093695017 | Q2-2024
Maybe | Aiden |  | 22102.15650861425 | Q2-2024
Maybe | [NAME] |  | 25000 | Q2-2024
Won | [NAME] | [NAME] | 6855.716829813276 | Q1-2024
Won | [NAME] | [NAME] | 11592.93624210751 | Q1-2024
Won | [NAME] | Aiden | 7396.71808530408 | Q1-2024
Maybe | [NAME] | Aiden | 5000 | Q2-2024
Maybe | [NAME] | [NAME] | 5855.03459371675 | Q2-2024
 | If either B14 to B37 or C14 to C37 is equal to the indiviual in A2 then
 | I want to sum all the value against them in cell D14 to D37
 | but only if
 | E14 to E37 is the same as B4
 | A14 to A37 is the same says Won
 | A14 to A37 is the same says Maybe
 | A14 to A37 is the same says [NAME]
the formula I am trying
IF(or($B$14:$B$37=A2,$c$14:$c$37=A2,SUMIFS($D$14:$D$37,$E$14:$E$37,"Q1-2024",$A$14:$A$37,"Won",$A$14:$A$37,"Will Win",$A$14:$A$37,"Maybe"),0)))
Spreadsheet: 143385d1330396557-copy-cell-format-and-formula-to-new-worksheet-ins_raw
Sheet: InsureShip_BleuDame_120227

ORDER_NUMBER | SHIP_DATE | CARRIER | SERVICE | TRACKING | VALUE | FIRSTNAME | LASTNAME | COMPANY | LINE1 | LINE2 | [NAME] | CITY | STATECODE | STATENAME | POSTALCODE | COUNTRYCODE | COUNTRYNAME | PHONE | [NAME]
90187 | 2012-02-27 00:00:00 | USPS | USPS International First | LN248648815US | 86.55 | Tass | last name | Fit Bioceuticals Ltd | 16 / 37 - 42 O'Riordan Street |  |  | [NAME] | NSW | NSW | 2015 | AU | Australia
89838 | 2012-02-23 00:00:00 | USPS | USPS International First | LN247487895US | 161.1 | Bruna | last name |  | Duarte Coelho 582 | Morada Do Vale |  | Governador Valadares | [NAME] | [NAME] | 35057-150 | BR | Brazil | 33- 8428 1996 | [EMAIL]
90108 | 2012-02-23 00:00:00 | USPS | USPS International First | LN247485069US | 27.45 | Luciana | last name |  | [NAME] 62 Apt 1402 Boa Viagem |  |  | Recife | [NAME] | [NAME] | 51020-310 | BR | Brazil |  | [EMAIL]
90109 | 2012-02-23 00:00:00 | USPS | USPS International First | LN247486625US | 20.75 | Thaisi | last name |  | Sqs 109 Bloco N Apartamento 201 |  |  | Brasilia | Distrito Federal | Distrito Federal | 70752140 | BR | Brazil | 556181486448 | [EMAIL]
90111 | 2012-02-24 00:00:00 | USPS | USPS International First | LN248036353US | 20.75 | Tais | last name |  | SHIS QI 23 chacara 9C |  |  | Brasilia | Distrito Federal | Distrito Federal | 775479489 | BR | Brazil
Spreadsheet: 31079709-3cdb-470a-87e6-46843dd4a7e9
Sheet: Form

 | Division of Scool Finance |  |  |  |  |  | T A C O N I T E   C R E D I T   R E P O R T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ED-02331-10
 | 1500 Highway 26 West |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Due:  04/01/2013
 | Roseville, MN  55113-4266
GENERAL INFORMATION AND INSTRUCTIONS: Please read the INSTRUCTIONS FOR COMPLETION on the Instructions tab before completing this report.
I D E N T I F I C A T I O N   I N F O R M A T I O N
County Name |  |  | Prepared By |  |  |  |  |  |  |  |  |  |  |  | Email address |  |  |  |  |  |  | Telephone Number |  |  |  |  | Date
T A C O N I T E   H O M E S T E A D   C R E D I T   ( [NAME] . Stat .   2 7 3 . 1 3 5)
B Y   S C H O O L   D I S T R I C T   A N D   F U N D
School District | Actual for Payable 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimate for Payable 2013
 | General Fund 1 |  |  | Comm Serv Fund 4 |  |  | Debt Fund 7 |  |  | OPEB/Pension Fund 47 |  |  | Total |  |  | General Fund 1 |  |  | Comm Serv Fund 4 |  |  | Debt Fund 7 |  |  | OPEB/Pension Fund 47 |  |  | Total
Total for all school districts in county
S U P P L E M E N T A R Y   T A C O N I T E   C R E D I T   ( [NAME] . S tat.   2 7 3 . 1 3 9 1 )
B Y   S C H O O L   D I S T R I C T   A N D   F U N D
School District | Actual for Payable 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimate for Payable 2013
 | General Fund 1 |  |  | Comm Serv Fund 4 |  |  | Debt Fund 7 |  |  | OPEB/Pension Fund 47 |  |  | Total |  |  | General Fund 1 |  |  | Comm Serv Fund 4 |  |  | Debt Fund 7 |  |  | OPEB/Pension Fund 47 |  |  | Total
Total for all school districts in county
T A C O N I T E   C R E D I T   R E P O R T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 2
County Name |  |  | Prepared By |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telephone Number |  |  |  |  |  |  | Date
T A C O N I T E   C R E D I T   B Y   T Y P E   O F   G O V E R N M E N T   U N I T
Please indicate total taconite credit for your county, by type of governmental unit.
Type of Governmental Unit | Actual for Payable 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimate for Payable 2013
 | Taconite Homestead Credit (M.S. 273.135) |  |  |  |  | Supplementary Taconite Credit (M.S. 273.1391) |  |  |  |  | Total |  |  |  |  | Taconite Homestead Credit (M.S. 273.135) |  |  |  |  | Supplementary Taconite Credit (M.S. 273.1391) |  |  |  |  | Total
County
Cities
Townships
School Districts *
Special Districts
TIF
COUNTY TOTAL
Notes or Comments by Preparer:
* Amounts shown on this line should agree with "total for all school districts in county" shown in tables above.
Spreadsheet: 775645d1649242411-i-need-a-countifs-formula-to-count-based-on-multiple-values-daf-not-countifs-aligw
Sheet: Countifs Example

[NAME] | Name |  | Name | Email address appears 3+ times |  | AliGW
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | Tia Davies |  | Tia Davies | 3
[EMAIL] | Tia Davies |  | [NAME] | 2
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME] |  | I would like to count how many times a name has an email address that appears 3 or more times in the 1st 2 columns. The result would look like the column above.
[EMAIL] | Tia Davies
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | Tia Davies
[EMAIL] | [NAME]
[EMAIL] | [NAME] |  | Again thank you for your time, hopefully I can explain this better. For each name in column D, I want column E to return how many times the corresponding names have an email address that appears 3 or more time in column A. Example: Tia Davies appears in Column B 4 times, but in Column A there are only 3 email address that 3 or more times for Tia Davies as the [EMAIL] address only appears once. Many thanks [NAME]
[EMAIL] | [NAME]