tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723200d1615559043-search-or-index-formula-needed-testalles
Sheet: Blad1

project | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | km verkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
5129 | ik | nl | 4 | 256 | 4.5 | 271
5129 | ernst | nl | 4.5 | 261 | 5 | 270 |  | Inkoop NL |  |  | Inkoop D
5129 | willem | nl | 4 | 264 | 4.5 | 269 |  | [NAME] |  |  | Verkoop D
5130 | jan | ics | 3 | 290 | 3.5 | 293 |  | [NAME] |  |  | Verschil D
5130 | klaas | ics | 3.5 | 289 | 4 | 292
5131 | willem | nl | 7 | 600 | 7.5 | 620 |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  | totaal [NAME]
 |  |  |  |  |  |  |  | search code | count cell B and C | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  | 5129 | 6 | 4 | 256 | 4.5 | 271
 |  |  |  |  |  |  |  |  |  | 4.5 | 261 | 5 | 270
 |  |  |  |  |  |  |  |  |  | 4 | 264 | 4.5 | 269
 |  |  |  |  |  |  |  |  |  | The lenght of this cells will change of course if you set another searchcode
 |  |  |  |  |  |  |  | number  of  amount (fill in) that i need. In search 5129 that are 6, i can change this number to count the cells
 |  |  | If i put the search code 5129 in cel I15, i would like to show the results from D to G belongs to 5129. somewhere from k15 to m15 or so
 |  |  | the other one i am searchiing for. Is if i put a searchcode in I16 i need to show how much cells are filled in B and C belonging to the searchcode
Spreadsheet: 725813d1616883771-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-7
Sheet: Student Statement

 | ST 001
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
 | ST 002
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
 | ST 003
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
 | ST 004
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
Spreadsheet: 0064f787-13e0-41fa-bcba-96215b953a37
Sheet: Computing

COMPUTING CAR
Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
Biology | BIOL 350
Business | BUSN 336
Chemistry | CHEM 325
 | CHEM 340
Computer Science | CSCI 106
 | CSCI 107
 | CSCI 111
 | CSCI 112
 | CSCI 181
 | CSCI 481 |  | Fall 2013 Building Mobile [NAME]
Drama | DRAM 331
Economics | ECON 312
Education | EDUC 346
Honors Program | HONR 249
 | HONR 254
 | HONR 258
 | HONR 292
Mathematics | MATH 107
 | MATH 113
 | MATH 141
 | MATH 142
 | MATH 203
Music | MUSC 322
 | MUSC 371
Political Science | PSCI 301
Psychology | PSYC 201
Sociology | SOCI 300
Spreadsheet: 851774d1701906735-trying-to-create-formula-to-break-down-water-usage-into-several-tiers-txxx2-reierme-
Sheet: TXXX1

 |  |  |  |  |  |  |  |  |  | TIER 1 | TIER 2 | TIER 3 | TIER 4 | TIER 5 | TIER 6 | TIER 7 | TIER 8 | TIER 9 | TIER 10
TranDate | Acct. # | BilledUsage | Charges | MeterSizeDesc | StartReading | StartReadDate | EndReading | EndReadDate |  | 0 - 2,000 | 2,001 - 5,000 | 5,001 - 7,500 | 7,501 - 10,000 | 10,001 - 15,000 | 15,001 - 25,000 | 25,001 - 35,000 | 35,001 - 45,000 | 45,001 - 55,000 | 55,001 +
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55001
2019-12-10 00:00:00 | 25 | 19992600 | 76.31 | 5/8" METER | 5850 | 2019-12-02 00:00:00 | 5850 | 2019-12-10 00:00:00
2023-01-10 00:00:00 | 236 | 392910 | 2573.71 | 5/8" METER | 225460 | 2022-12-01 12:47:00 | 618370 | 2023-01-03 08:58:00
2019-10-10 00:00:00 | 56 | 264250 | 0 | 5/8" METER | 27310 | 2019-08-30 00:00:00 | 291560 | 2019-09-30 00:00:00
2020-07-10 00:00:00 | 1115 | 215940 | 0 | 5/8" METER | 0 | 2020-06-01 00:00:00 | 0 | 2020-07-10 00:00:00
Spreadsheet: 63349d1264261520-alternative-to-using-vlookup-with-identical-cells-values-vlookup-test-1
Sheet: Acknowledgements

Employee:
Signed Acknowledgements
Date | Type (Select from list or type in) | Recorded By
2010-01-01 00:00:00 | Test #1 |  | [NAME]
2010-01-01 00:00:00 | Test #2 |  | Audit Policy
2010-01-02 00:00:00 | Test #3 |  | [NAME] Procedure
 |  |  | Code of Conduct
 |  |  | Confidentiality Agreement
 |  |  | Dress Code Policy
 |  |  | Guest Service Policy
 |  |  | Tip Agreement
 |  |  | Title 31 Policy
 |  |  | [NAME]
Spreadsheet: 876718d1723461981-create-an-action-log-tab-automatically-from-different-tabs-and-sheets-of-info-book1-creating-auto-filled-action-log-from-multiple-entry-sheet
Sheet: person 1

Who | Who | Date | Time | Who | Medium | Comments | Questions | Actions | Status | ambitions | achievements
 | person 1 | 2024-07-30 00:00:00 | noon | Person1 | email | initial contact | no questions as yet | book initial teams meeting | complete
 |  | 2024-08-08 00:00:00 | 09:30:00 | Person 2 | Teams |  |  | find a new challenge - DLSE course in logistics post grad initially could go on to masters | ongoing | wants to run teams not processes
Spreadsheet: 734235d1622055578-match-index-over-multiple-tabs-test
Sheet: Commande

Description | Manufacturier | Fournisseur | Numéro de pièce | Estimé | Design | Demandé | Commandé | Inv. RF | Inv. [NAME] | Inv. SB | Box | Sortie | Retour | Tot. Installé | Remarques | Suivi commande | [NAME]:
Spreadsheet: 218883d1362598489-lookup-index-match-array-help-accommodation-solution
Sheet: Sheet1

 | Hotel A |  |  | Hotel B |  |  | Hotel C
 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3
2013-01-01 00:00:00
2013-01-02 00:00:00
2013-01-03 00:00:00
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
2013-01-08 00:00:00
2013-01-09 00:00:00
2013-01-10 00:00:00
2013-01-11 00:00:00
2013-01-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Date | Guest | Hotel | Room
2013-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | Grant | Hotel A | 2
2013-01-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-02 00:00:00 | [NAME] | Hotel B | 3
2013-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-03 00:00:00 | [NAME] | Hotel C | 1
2013-01-16 00:00:00
2013-01-17 00:00:00
Spreadsheet: 735956d1623277038-index-of-terms-based-on-overlapping-dates-gantt-chart-utilizing-conditional-distinct-values-lilybickel-
Sheet: Sheet2

name | variable 1 | start date 1 | end date 1 | variable 2 | start date 2 | end date 2 | variable 3 | start date 3 | end date 3 | variable 4 | start date 4 | end date 4 | variable 5 | start date 5 | end date 5 |  |  |  |  |  |  |  |  |  | Names
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00 | B | 2014-01-01 00:00:00 |  | C | 2015-01-01 00:00:00 |  | A | 2018-01-01 00:00:00 |  | E | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | name1
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00 | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | E | 2019-01-01 00:00:00 |  | A | 2019-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Name | Variable | Start Date | End Date | End Date 2 | End Date 3 |  | Name: | [NAME]
name1 | A | 2010-01-01 00:00:00 | 2015-01-01 00:00:00
name1 | B | 2014-01-01 00:00:00
name1 | C | 2015-01-01 00:00:00
name1 | A | 2018-01-01 00:00:00
name1 | E | 2020-01-01 00:00:00
[NAME] | G | 2015-01-01 00:00:00 | 2018-01-01 00:00:00
[NAME] | B | 2015-01-01 00:00:00 | 2016-01-01 00:00:00
[NAME] | E | 2019-01-01 00:00:00
[NAME] | A | 2019-01-01 00:00:00
Spreadsheet: 57208d1257348270-how-to-express-multiple-if-statement-winhalf_temp
Sheet: Sheet1

Odds | Unit (S) |  |  |  |  | Stake £ | Bookmaker | Name |  | [NAME]. | Return |  | Profit |  |  | Yield |  | Bank
1.9 | 4 |  |  |  |  | 80 | BF | [NAME] |  | win
1.9 | 9 |  |  |  |  | 80 | P | Dunc |  | win
1.9 | 9 |  |  |  |  | 80 | P | Dunc |  | win 0.5 |  |  | 36
1.9 | 9 |  |  |  |  | 80 | P | Dunc |  | lose 0.5 |  |  | -40 |  |  |  |  |  |  |  | key
1.9 | 9 |  |  |  |  | 80 | P | Dunc |  | draw |  |  | 0 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: f37b3fc9-aca3-40ed-8f63-db36764a5357
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
AGA | Test | AGA | Alpha-Galactosidase, Leukocytes | Alpha-Galactosidase, Leukocytes | Fluorometric | Yellow-Top (ACD) Tube: ACD |  |  | 7 | mL | [NAME] must arrive within 72 hours of draw to be stabilized. [NAME] received after 72 hours could have falsely normal results. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 7 mL  Collection Instructions: Do not transfer blood to other containers. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 6 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =23.1 nmol/hour/mg protein An interpretative report will be provided. Note: Results from this assay do not reflect carrier status because of individual variation of alpha-galactosidase enzyme levels. | Specimens are processed Monday through Sunday. Assay is performed on Wednesday. | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
AGA | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 72 hours
AGA | Result | 32302 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AGA | Result | 32303 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
AGA | Result | 8785 | Alpha-Galactosidase, Leukocytes | Alpha-Galactosidase, Leukocytes | Numeric |  |  |  |  | nmol/h/mg |  |  |  |  |  |  |  |  |  | 24049-9 | Alpha galactosidase A:CCnt:Pt:WBC:Qn:
Spreadsheet: 66850d1267543572-sum-values-based-on-multiple-criteria-comma-delimited-in-a-single-cell-sample
Sheet: data

code | balance
[NAME] | 110
C09 | 157
[NAME] | 268
[NAME] | 268
[NAME] | 268
C09 | 268
[NAME] | 268
[NAME] | 268
[NAME] | 268
C09 | 268
AN30 | 18
C04 | 47
AN30 | 70
AN30 | 70
C04 | 115
C04 | 47
C07 | 190
C09 | 19
C09 | 66
Spreadsheet: 167547d1342022463-trying-to-display-multiple-instances-of-same-value-maintenance-log-2012
Sheet: Maintenance sheet LST 090

PATTEMORES DAIRY INGREDIENTS |  |  |  |  |  | FORM NO: |  | LST 090
BY [NAME]________________________ |  |  |  |  |  | ISSUE:  1 |  | 05.03.03
 |  | [NAME]
ENGINEER / S
DATE WORK COMMENCED |  |  |  |  | TIME TAKEN
AREA
A PERMIT TO WORK IS NEEDED FOR ANY TANK WORK
PERMIT TO WORK REQUIRED? YES/NO IF YES NUMBER:
ITEM
ITEM NUMBER / S:
FAULT
ACTION TAKEN
CORRECTIVE ACTION AND PARTS USED:
WHEN SIGNING THIS FORM I AGREE THAT TO THE BEST OF MY KNOWLEDGE, THE AREA
AROUND THE EQUIPMENT AND THE EQUIPMENT ITSELF IS CLEAN AND FREE FROM FOREIGN
BODIES AND FIT FOR FOOD PRODUCTION.
DATE WORK COMPLETED: |  |  |  | DAIRY MANAGER
 |  |  |  | SIGNED:
ENGINEER
SIGNED: |  |  |  | PRINT:
 |  |  |  | PERMIT NO:
PRINT: |  |  |  | PERMIT [NAME] AND CANCELLED:
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Comp Info Tech Certs 2

COMPUTER INFORMATION TECHNOLOGY
Certificates
Student Name:
ID #
Information Security Specialist | Semester | Grade
___ Level I Network Course (4)
___ CIT 180 (3) Security Fundamentals
___ CIT 182 (3) Perimeter Defense
___ CIT 184 (3) Attacks and Exploits
___ Approved Security/Security Elective Courses (6)
Microsoft Network Administrator
___ Level I Network Course (4)
___ CIT 213 (3) MS Client/Serveer Configuration
___ CIT 214 (3) Server Infrastructure Administration
OR ___ CIT 262 (3) MS Network Infrastructure
___ CIT 261 (3) MS Active Directory Services
___ CIT 264 (3) MS Server Administration
___ Approved CIT Technical Course (3)
CISCO Networking Associate
___ CIT 161 (4) Network Fundamentals
OR ___ CIT 162 (4) Home and Small Office Networks
___ Network Associate Track Course Sequence (12)
Network Technologies Specialist
___ CIT 219 (3) Internet [NAME]
___ CIT 288 (3) Network Security
___ Approved Level I and Level II Network Technology Microsoft Windows Course Sequence (12)
OR ___ Approved Level I and Level II Network Technonlogy  CISCO Course Sequence (12)
OR ___ Approved Level I and Level II Network Technology UNIX/[NAME] (12)
___ Approved Level I, Level II and Level III Network Technologies Course Sequence (4-6)
CISCO Networking Enhanced
___ CIT 161 (4) Network Fundamentals
OR ___ CIT 162 (4) Home and Small Office Networks
___ Network Associate Track Course Sequence (12)
___ Approved CIT Technical Courses (8-9)
A+
___ CIT 111 (4) Computer [NAME] and Software
Net+
___ CIT 160 (3) Introduction to Networking Concepts
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: stacey_white__38953__13616_EPMI-ST-PJM-OFF_deal_sum
Sheet: _tmp_13616_EPMI-ST-PJM-OFF_deal

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       10/16 | /01
Report Da | te:  10/15/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       14:29 | :50
Post ID: | 13616
Desk: EPM | I-ST-PJM-OFF
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
789679 | NEWPOWCOM | 2001-09-25 00:00:00 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | No | FINANCIAL DEAL-R1E Western HUB | 0 | -21079 | 0 | 0 | 0 | -21200 | -115806 | 0 | -115806 | -115806 |  | -112753 | 0
794864 | NEWPOWCOM | 2001-09-28 00:00:00 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | No | FINANCIAL DEAL-R1E Western HUB | 0 | -21079 | 0 | 0 | 0 | -21200 | -137939 | 0 | -137939 | -137939 |  | -112758 | 0
795724 | NEWPOWCOM | 2001-09-28 00:00:00 | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 | No | FINANCIAL DEAL-R1E Western HUB | 0 | -19130 | 0 | 0 | 0 | -19200 | -74707 | 0 | -74707 | -74707 |  | -47823 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R1E |  |  |  |  |  | 0 | -61287 | 0 | 0 | 0 | -61600 | -328452 | 0 | -328452 | -328452 |  | -273334 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 0 | -61287 | 0 | 0 | 0 | -61600 | -328452 | 0 | -328452 | -328452 |  | -273334 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 148806d1333559641-copying-data-to-another-worksheet-sample-test-tracker
Sheet: Test Tracker

test # | TEST #1 | TEST #2 | TEST #3 | TEST #4 | TEST #5
[NAME] | 0 | 0 | 2 | 0 | 0
JONES | 1 | 0 | 0 | 0 | 1
SMITH | 0 | 3 | 0 | 0 | 0
WHITEHALL | 0 | 0 | 0 | 1 | 0
Spreadsheet: 88678d1288513590-can-unmerge-a-cell-without-merge-before-book3
Sheet: Sheet1

Product A
Customer | Grade A |  | [NAME] |  | [NAME]
customer A | 20
customer A |  |  | 10
customer A | 5
customer B |  |  | 20 |  | 15
customer C
customer C | 10 |  |  |  | 100
customer B | 120 |  | 10
Total Sales
Suppr stock 1: | ABC = | 2000 | DEF = | 2000 | HIJ = | 3000
Balance :
Suppr stock 2: | ABC = | 2000
Product B
Customer | Grade A |  | [NAME] |  | [NAME]
customer A | 20
customer A |  |  | 10
customer A | 5
customer B |  |  | 20 |  | 15
customer C
customer C | 10 |  |  |  | 100
customer B | 120 |  | 10
Total Sales
Supplier 1 : | ABC = 1000 |  | DEF = 2000 |  | HIJ = 3000
Supplier 2 : | ABC = 2000
 | 5
Spreadsheet: 848415d1699142358-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days_rev-03
Sheet: Pay Calculator

DATE | DAY | JOB [NAME] | NON-NORMAL WORK DAY DESCRIPTION |  | NORMAL HOURS PAID $ |  |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC) |  | ADO | ALLOCATED DAY OFF CANCELLED (ADOC)
 |  |  |  |  |  |  |  | WORK | +  PUBLIC HOLIDAY | NO WORK |  | 1st. 3 hrs | After 3hrs |  | ADO Default | 1st. 3 hrs | After 3hrs
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 268
 |  |  |  |  | 324 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | Week 1 Totals :
Spreadsheet: 79852d1280097669-lookup-data-and-show-charted-by-month-sample
Sheet: CORE DATA

doc name | Revision | Activation date | review date
ABC123 | 1 | 2009-09-14 00:00:00 | 2011-03-03 00:00:00
DEF456 | 3 | 2010-02-06 00:00:00 | 2011-02-05 00:00:00
GHI789 | 2 | 2008-03-27 00:00:00 | 2011-04-20 00:00:00
JKL123 | 1 | 2011-03-17 00:00:00 | 2011-03-16 00:00:00
Spreadsheet: 586635d1534490448-select-rows-between-blank-rows-using-power-query-sample
Sheet: FINAL Placement 2

Placement 2
Size | Text | Url | Site | ID | Color | BGColor | Upload | Source | Desc | StartDate | EndDate | Rot | Notes
100x50 | Text | URL | Site.com | 123 | white | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 50
100x50 | Text | URL | Site.com | 123 | white | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 50
100x50 | Text | URL | Site.com | 123 | White | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100 | Notes
Spreadsheet: 755993d1637226544-count-attandance-within-a-month-by-employee-id-attendance
Sheet: Sheet2

Yearly Report
 |  | User ID: | PB01
 |  | User Name:
 |  |  | Attandance | Weekday | Leave
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Jul
 |  | Aug
 |  | Sep
 |  | Oct
 |  | Nov
 |  | Dec
Spreadsheet: 795928d1663010283-combining-sheets-into-a-master-file-s666-pq-test
Sheet: CR

Concat | Customer Number | Account Manager | Company Chain | Mode | Product Code | Site | Incoterm
1002RailSADWYPCIP | 1002 | CR | A E | Rail | 123 | WYP | CIP
1003RailSADWYPCIP | 1003 | CR | A E | Rail | 123 | WYP | CIP
1871TruckSADTOLCIP | 1871 | CR | D C | Truck | 123 | TOL | CIP
1228TruckSAD2000TOLEXW | 1228 | CR | BR | Truck | 124 | TOL | EXW
1693TruckSAD2000TOLEXW | 1693 | CR | BR | Truck | 124 | TOL | EXW
1230TruckSAD2000TOLCIP | 1230 | CR | BR | Truck | 124 | TOL | CIP
Concat | Customer Number | Account Manager | Company Chain | Mode | Product Code | Site | Incoterm
Spreadsheet: 28409d1222687159-counting-how-often-duplicate-items-have-occured-joefredkim
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
fred
[NAME]
Spreadsheet: 679660d1590570289-tracking-time-and-ot-past-midnight-w-3-columns-date-start-and-end-date_time_hours-past-midnight
Sheet: Sheet1

 | End of period | 2017-12-15 00:00:00 |  |  | 1st half-month
 |  |  |  |  | 2nd half-month
 |  |  |  |  | Totals
 |  | Date | (text only date) | Start | End | Hours | Regular | O/T
 |  |  | 12/01/2017 | 12:00 AM | 01:00 PM
 |  |  | 12/02/2017 | 04:00 PM | 10:00 PM
 |  |  | 12/03/2017 | 12:00 PM | 06:00 PM
 |  |  | 12/04/2017 | 12:00 PM | 06:00 PM
 |  |  | 12/06/2017 | 04:00 PM | 10:00 PM
 |  |  | 12/07/2017 | 06:00 AM | 09:00 AM
 |  |  | 12/08/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/09/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/10/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/11/2017 | 12:00 AM | 09:00 AM
 |  |  | 12/13/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/14/2017 | 12:00 AM | 09:00 AM
 |  |  | 12/20/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/21/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/22/2017 | 05:00 AM | 01:00 PM
 |  |  | 12/27/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/28/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/29/2017 | 06:00 AM | 02:00 PM
Spreadsheet: 115447d1311066349-budget-calc-help-2011budget
Sheet: May

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 721108d1614498418-row-and-column-matching-column-row-matching
Sheet: Sheet1

General Ledger |  |  |  | Bank
Description | Credit | Reconciliation |  | Description | Debit | Reconcilition
Electrosales | 3384.76 |  |  | Halsted | 1415.22
Halsted | 1415.22 |  |  | Imtt
Powertel | 5438 |  |  | Powertel | 5438
Salary | 7500 |  |  | Imtt
TM | 1234 |  |  | Electrosales | 3384.76
 |  |  |  | Imtt
I am kindly asking for a formula in column C and D, If the amount and description appears in both General Ledger and Bank
the answer will be matched and if does not appear both sides it leaves it blank as the above example.
Spreadsheet: 724414d1616154705-counting-the-number-of-cell-that-fit-the-condition-e-g-odd-toto
Sheet: toto

Date | Number |  |  |  |  |  | Add | Odd | Even | 1 to 10 | 11 to 20 | 21 to 30 | 31 to 40 | 40 to 49
2021-01-28 00:00:00 | 6 | 16 | 25 | 32 | 35 | 37 | 22
2021-02-01 00:00:00 | 4 | 6 | 9 | 18 | 27 | 39 | 33
2021-02-05 00:00:00 | 8 | 9 | 11 | 24 | 26 | 47 | 34
2021-02-08 00:00:00 | 9 | 10 | 25 | 27 | 34 | 42 | 29
2021-02-11 00:00:00 | 10 | 23 | 25 | 28 | 46 | 49 | 36
2021-02-15 00:00:00 | 9 | 13 | 18 | 20 | 34 | 40 | 36
2021-02-18 00:00:00 | 1 | 4 | 6 | 15 | 40 | 44 | 37
2021-02-22 00:00:00 | 3 | 6 | 8 | 11 | 36 | 48 | 1
2021-02-26 00:00:00 | 21 | 24 | 40 | 42 | 44 | 48 | 1
2021-03-01 00:00:00 | 5 | 6 | 7 | 13 | 25 | 27 | 30
2021-03-04 00:00:00 | 11 | 12 | 20 | 28 | 30 | 38 | 27
2021-03-08 00:00:00 | 8 | 13 | 17 | 27 | 33 | 40 | 38
2021-03-11 00:00:00 | 12 | 19 | 26 | 41 | 46 | 47 | 35
2021-03-15 00:00:00 | 12 | 15 | 19 | 28 | 35 | 43 | 44
2021-03-18 00:00:00 | 2 | 5 | 12 | 24 | 25 | 29 | 3