tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702405d1604332480-formula-required-in-cell-h3-to-add-all-peas-from-a-spreadsheet-is-it-countifs-book1-tony
Sheet: Sheet1

 |  | [NAME] | PRODUCT | QTY AVAILABLE |  | Products
 |  | A1 | PEAS | 200 |  | PEAS |  |  | how to add all available Peas from all locations,
 |  | A2 | CARROTS | 44 |  | CARROTS |  |  | Total should be 375 when all "Peas" are added from all locations
 |  | A3 | POTATOES | 74 |  | POTATOES |  |  | the formula in H3 only displays the first found. How do I add all locations ?
 |  | A4 | ONIONS | 2 |  | ONIONS
 |  | A5 | PEAS | 50 |  | SWEDE
 |  | B1
 |  | B2 | POTATOES | 50
 |  | B3 | SWEDE | 10
 |  | B4 | SWEDE | 10
 |  | B5 | ONIONS | 5
 |  | C1 | PEAS | 45
 |  | C2 | PEAS | 80
 |  | [NAME]
 |  | C4
 |  | C5
Spreadsheet: 677438d1589360606-vlookup-to-automate-discharge-slips-vlookup-on-sheet-2
Sheet: DISCHARGE SLIPS

 |  | GOVERNMENT OF AP
 |  | OFFICE OF THE DM0
 |  | ICC |  |  |  |  |  |  |  |  |  | SEARCH BY NAME :
 | NO. DMO/ |  |  |  |  |  | Dated the
 |  |  | PROVISIONAL DISCHARGE CERTIFICATE
 |  | COVID-19 QUARANTINE FACILITY CENTRE
 | 1. | NAME
 | 2. | AGE
 | 3. | SEX
 | 4. | ADDRESS
 | 5. | FATHER/GUARDIAN NAME
 | 6. | DATE OF ADMISSION
 | 7. | DATE OF DISCHARGE
 |  | THIS IS TO CERTIFY THAT THE ABOVE MENTIONED PERSON HAS UNDERGONE  FACILITY
 |  | QUARANTINE OF ...................DAYS AT FACILITY QUARANTINE. AFTER EXAMINATION HE/SHE HAS BEEN FOUND
 |  | WITH NO SIGNIFICANT SIGNS OR SYMPTOMS OF COVID-19 AND FURTHER HE/SHE MUST
 |  | GO SELF-APPRAISAL HOME QUARANTINE FOR ANOTHER ..........                          .... DAYS. |  |  |  |  |  | DAYS
 |  | REMARKS :
Spreadsheet: 3d55ed23-77f7-4d03-b434-986e52241bbe
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
CHOU | Test | CHOU | Carbohydrate, [NAME] | Carbohydrate, U | CHOU/9255: Thin-Layer Chromatography (TLC), Qualitative GALU/8765: Spectrophotometric, Kinetic RGLUR/89847: [NAME] | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL  Collection Instructions: Collect an early-morning (preferred) random urine specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK - note to lab Lipemia	NA Icterus	NA Other	NA | Negative If positive, carbohydrate is identified. | Wednesday; 11 a.m. | 8 days (not reported on Saturday or Sunday) | 15 days | 1 | 84377 |  |  |  |  | Rochester
CHOU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 21 days
CHOU | Result | 9255 | Carbohydrate, U | Carbohydrate, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16550-6
CHOU | [NAME] | GALU | Galactose, Quantitative, [NAME] | Galactose, QN, U | Spectrophotometric, Kinetic | [NAME]: Urine |  |  | 5 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: Collect a random urine specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK - refreeze Lipemia	NA Icterus	NA Other	NA | <30 mg/dL | Wednesday; 11 a.m. | 8 days | 15 days | 1 | 82760 |  |  | No | Yes
GALU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 365 days
GALU | Result | 8765 | Galactose, QN, U | Galactose, QN, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2310-1
CHOU | [NAME] | RGLUR | Glucose, Random, [NAME] | Glucose, Random, U | [NAME] | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | < or =15 mg/dL | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 82945 |  |  | No | Yes
RGLUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RGLUR | Result | RGLUR | Glucose, Random, U | Glucose, Random, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2350-7
Spreadsheet: harry_arora__12146__Staffing Report 12-8-2000
Sheet: LWYTD

YTD Summary
# of Resumes Sent to Managers |  |  |  |  | 5124
# of Candidates Interviewed by Managers |  |  |  |  | 1942
# of Offers |  |  |  |  | 603
# of Offers Declined |  |  |  |  | 32
Acceptance Rate |  |  |  |  | 0.947
# of Starts |  |  |  |  | 842
 |  |  | fulltime | 288
 |  |  | conversions | 140
 |  | internal transfers |  | 21
 |  |  | contractors | 376
 |  |  | interns | 10
# of Positions Opened in 2000 |  |  |  |  | 706
 |  |  | new | 630
 |  |  | replacement | 76
# of Positions Cancelled in 2000 |  |  |  |  | 171
Lowest # of Openings since Jan 1, 2000 |  |  |  |  | 62
Highest # of Openings since Jan 1, 2000 |  |  |  |  | 161
Ratios: | Submittals to Interviews |  |  |  | 2.7 to 1
 | Interviews to Hires |  |  |  | 3.2 to 1
Agency Fees Paid |  |  |  |  | 1734301
Referral Fees Paid |  |  |  |  | 303000
Savings Thru Enron Recruiters |  |  |  |  | 1163640
Savings Thru Employee Referral Program |  |  |  |  | 912290
Spreadsheet: 65528d1266248789-help-with-vlookup-excel-forum
Sheet: Vlookup

Division | Org L4 | Position No | Vlookup
334  External BUSINESS | 334 DAKOO MANG | 3727108 | #N/A
335  External BUSINESS | 335 DAKOO MANG | 4089690 | #N/A
336  External BUSINESS | 336 DAKOO MANG | 3825162 | #N/A
337  External BUSINESS | 337 DAKOO MANG | 4629918 | #N/A
338  External BUSINESS TOTAL
Spreadsheet: ad6e6e08-46ce-4463-bfc8-8f756a633877
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
ACM | Test | ACM | Acetaminophen, Serum | Acetaminophen, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Therapeutic concentration: <50 mcg/mL Toxic concentration: > or =120 mcg/mL Half-life: <4 hours Toxic half-life: >4 hours The toxic level is dependent on half-life. When the half-life is 4 hours, hepatotoxicity generally is not seen until the concentration is > or =120 mcg/mL. The level at which toxicity occurs decreases with increasing half-lives until it is encountered at values as low as 50 mcg/mL when the half-life reaches 12 hours. | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 82003 |  |  |  |  | Rochester
ACM | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
ACM | Result | 8698 | Acetaminophen, S | Acetaminophen, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3298-7 | Acetaminophen:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 631839d1562857002-distance-between-coordinates-shown-in-a-sorted-list-xlf_1282014_part2
Sheet: PQ Only

[NAME] | X1 | Y1 | 1st Closest Location | 1st Closest Distance | 2nd Closest Location | 2nd Closest Distance
DE902 | 668849 | 245006 | AG082-2 | 0 | AG212-1 | 12.52996408614167
DF392 | 633251 | 239845 | ROIN | 62.81719509815764 | VORD | 3877.385846159755
DR029 | 638611 | 263271 | SUPF | 0 | AG_4616A | 2047.340225756335
ES492 | 650560 | 236088 | SCRU | 0 | AG_0034A | 7025.348674621068
GF329 | 635070 | 236500 | VORD | 99.62429422585637 | AG_0712A | 100.8811181539935
HF029 | 653510 | 246900 | SCHH | 5 | AG_0627A | 8.94427190999916
HY675 | 655820 | 257720 | BRWI | 87.32124598286491 | ZH955-1 | 1795.132307101624
[NAME] | 647150 | 249980 | AASI | 94.86832980505137 | AG_7519A | 1542.19583711019
KH387 | 648322 | 246675 | AG_0501B | 1.414213562373095 | AABF | 2159.330683336853
KL329 | 635070 | 236500 | VORD | 99.62429422585637 | AG_0712A | 100.8811181539935
KO420 | 665069 | 259111 | BABS | 91.6624241442479 | BADE | 529.3410998590606
[NAME] | 665580 | 258800 | ZH246-1 | 46.09772228646444 | BADE | 94.86832980505137
LK392 | 656622 | 232628 | AG_0034A | 73.53910524340094 | MEKE | 79.7057087039567
LN392 | 671310 | 243990 | AG_4190C | 0 | AG212-1 | 2661.156515502235
LR012 | 645850 | 249150 | AG_7519A | 50.47771785649585 | AG_7513A | 1340.932511351709
NJ111 | 656622 | 232628 | AG_0034A | 73.53910524340094 | MEKE | 79.7057087039567
OL942 | 656550 | 256150 | ZH955-1 | 70 | BRWI | 1644.118304745738
OR654 | 668855 | 245017 | AG212-1 | 0 | AG082-2 | 12.52996408614167
PG343 | 646860 | 248249 | AABF | 64.81512169239521 | AG_7513A | 65.36818798161687
PL122 | 646860 | 248249 | AABF | 64.81512169239521 | AG_7513A | 65.36818798161687
[NAME] | 656260 | 249240 | LELI | 5 | LEST | 1516.47617851386
PT940 | 643443 | 237911 | BORA | 0 | [NAME] | 3.605551275463989
PY492 | 643443 | 237911 | BORA | 0 | [NAME] | 3.605551275463989
RH392 | 653510 | 246900 | SCHH | 5 | AG_0627A | 8.94427190999916
RH992 | 665580 | 258800 | ZH246-1 | 46.09772228646444 | BADE | 94.86832980505137
SD932 | 637023 | 261981 | AG_4616A | 1.414213562373095 | HEKO | 15
UB482 | 655642 | 247923 | LEST | 94.83142938920619 | LELI | 1459.317648766025
WE942 | 637023 | 261981 | AG_4616A | 1.414213562373095 | HEKO | 15
[NAME] | 665470 | 258450 | AG959-1 | 86.6083136886985 | ZH246-1 | 412.8256290493603
Spreadsheet: 01454f89-b58c-4658-a145-ccdaf80d7b85
Sheet: Sheet1

Unnamed: 0 | City of Albuquerque | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Vendor ACH Payment Form
 | I here by authorize the CITY OF ALBUQUERQUE to initiate accounts payable payments through
 | automatic bank deposits and, if necessary, adjustments to my account for payments made in error.
 | * - Required Information
 | NEW: |  |  |  | UPDATED:
 | CHECKING ACCOUNT INFORMATION
 | ACCOUNT NUMBER: |  |  |  |  |  |  |  | *
 | COMPANY/ORGANIZATION NAME: |  |  |  |  |  |  |  | *
 | COMPANY/ORGANIZATION PHONE: |  |  |  |  |  |  |  | *
 | ACCOUNT NAME |  |  |  |  |  |  |  | *
 | ABA ROUTING NUMBER: |  |  |  |  |  |  |  | *
 | NAME OF BANK OR CREDIT UNION: |  |  |  |  |  |  |  | *
 | BANK ADDRESS LINE 1: |  |  |  |  |  |  |  | *
 | CITY AND STATE: |  |  |  |  |  |  |  | *
 | ZIP CODE: |  |  |  |  |  |  |  | *
 | COMPANY CONTACT: |  |  |  |  |  |  |  | *
 | CONTACT PHONE: |  |  |  |  |  |  |  | *
 | AUTHORIZED SIGNATURE: |  |  |  |  |  |  |  | *
 | TITLE: |  |  |  |  |  |  |  | *
 | DATE (MM/DD/YYYY): |  |  |  |  |  |  |  | *
 | SOCIAL SECURITY OR FEIN NO: |  |  |  |  |  |  |  | *
 | EMAIL:
 | PLEASE RETURN AN ORIGINAL, COMPLETED FORM, ALONG WITH **VOIDED CHECK, DIRECTLY
 | TO THE ADDRESS BELOW TO INITIATE ACH PROCESSING SETUP.  YOU WILL BE ESTABLISHED
 | AS AN ACH VENDOR AND PAYMENTS WILL BE MADE VIA ACH UPON COMPLETION OF THE BANK
 | VERIFICATION PROCESS.  (POSTING TO BANK ACCOUNT IS WITHIN 48 HOURS FROM DATE
 | OF TRANSFER)  *** VOIDED CHECK IS USED FOR VERIFICATION OF ACCT/RT NUMBERS ONLY
 | IF YOU CANNOT PROVIDE ONE THIS WILL NOT HOLD UP THE PROCESS
 | Questions regarding this form or your ACH transactions should be directed to the accounts payable
 | department at the address/number below.
 | DFAS Accounts Payable Office
 | City of Albuquerque |  |  |  |  | Phone: (505) 768-3471
 | PO Box 1985 |  |  |  |  | Fax: (505) 768-3476
 | Albuquerque, NM  87103 |  |  |  |  | E-Mail: [EMAIL]
Spreadsheet: 150655d1334652225-excel-work-coshh
Sheet: CDS453

 |  |  | Control of Substances Hazardous to Health Data
 |  | COSHH Number: |  |  | CDS 1 |  |  | Issue Number: |  | n/a |  | Issue Date: | 28.03.2012
 |  | Substance: |  |  | MOULDING COMPOUND - POLYAMIDE 66
 |  | Other Name: |  |  |  |  |  |  |  |  |  |  | Supplier: |  | Rhodia
 |  | Code Number: |  |  |  |  |  |  |  |  |  |  | Address:
 | User Department:
 |  | Application:
 |  | Big QTY:
 |  | [NAME]:
 |  | Quantity: |  |  |  |  |  |  |  |  |  | Telephone Number:
 |  | Location:
 |  | [NAME]: |  |  |  |  |  |  |  |  |  |  | Cell: |  | Two |  | Issue | 01
 |  | Engineer: |  |  |  |  |  | Type:
 |  |  | Status:
 |  | Origin Date: |  |  |  |  |  | Manufacturers
 |  | Revision Date:
 |  |  | Priority:
 |  |  | Current or Obsolete
 |  |  | Obsolete |  |  |  |  | Checked:
 |  |  |  |  |  |  |  | Checked Date:
 |  | Comments:
Spreadsheet: 274883d1383247431-conditional-formatting-based-on-an-entire-row-test2
Sheet: Sheet1

Order 1 | Date goes here | Qty on Quote |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty on Order (not arrived) |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty Received (pre-ILMS)
Order 1 | Date goes here | Qty on Quote |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty on Order (not arrived) |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty Received (pre-ILMS) |  | 500 |  |  |  |  |  | 90 |  |  |  |  |  | 150
Order 1 | Date goes here | Qty on Quote |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty on Order (not arrived) |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
 |  | Qty Received (pre-ILMS) |  | 597 |  | 60 |  |  |  | 100 |  |  | 35 | 35 |  | 400 |  |  | 60
Spreadsheet: eric_saibi__9766__012302
Sheet: Huntington Beach 03

Owner Name | AES
Station Name | Huntington Beach Power Station
Unit Name | Huntington Beach 03
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 218 MW
Start Date | 2002-01-23 00:00:00
End Date | 2002-02-06 00:00:00
Comments | Annual Tune-up
SIC | 4931
Plant ID | 1013155
Unit ID | 1010235
Outage ID | 19608
Spreadsheet: 839080d1691648304-sumif-formula-help-financial-report-2023-season-financial-report
Sheet: July

Date | Transaction | Withdrawals | Deposits | Balance | Code | Comments
Opening balance |  |  |  | 9240.6
2023-07-01 00:00:00 | INTEREST |  | 0.07 | 9240.67 | INT
2023-07-14 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 75.77 | 9316.44 | SQ
2023-07-15 00:00:00 | OSKO PAYMENT   [NAME] canteen | 75.51 |  | 9240.93 | REIMB
2023-07-15 00:00:00 | OSKO PAYMENT   WAFC Inv15690 | 660 |  | 8580.93 | WAFC
2023-07-15 00:00:00 | OSKO PAYMENT   WAFC CHI002 | 66 |  | 8514.93 | WAFC
2023-07-15 00:00:00 | OSKO PAYMENT   [NAME] receipts - auskick | 52.95 |  | 8461.98 | REIMB
2023-07-17 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 99.38 | 8561.36 | SQ
2023-07-19 00:00:00 | DIRECT CREDIT  PLAYHQCOM_PHzoBwjQ PLAYHQCOM            [PHONE] |  | 57.45 | 8618.81 | PLAYHQ
2023-07-21 00:00:00 | OSKO PAYMENT   [NAME] | 208.49 |  | 8410.32 | REIMB
2023-07-21 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 748.03 | 9158.35 | SQ
2023-07-25 00:00:00 | OSKO PAYMENT   GO Contracting inv cjfc20230701 |  | 500 | 9658.35 | SPO
2023-07-28 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 128.33 | 9786.68 | SQ
2023-07-31 00:00:00 | DIRECT CREDIT SQUARE AU PTY LT    [PHONE] |  | 118.97 | 9905.65 | SQ
Transaction totals / Closing balance |  | 1062.95 | 1728 | 9905.65
Spreadsheet: 823420d1679952104-how-to-change-a-cell-colour-depending-on-if-another-cell-has-the-word-sun-and-or-sat-book2
Sheet: Sheet1

 | Field Services
 | 2023
 | Codes |  |  |  |  |  | [NAME] | Prision
 |  |  |  |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feburary
 | Employee name | Sick | Entitled | C F/W | Used | Left | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | [NAME] |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 | Trevor Mcinnes |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME]
 |  |  |  |  |  |  |  |  |  | pris
 | [NAME] Armitage |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Justin Peat
 | [NAME]
 | Ash Mistry
 | Pyrus Durrent
Spreadsheet: 820254d1677955476-xlookup-with-multiple-rows-and-values-datasample_concatenate
Sheet: Sheet1

data source example |  |  |  |  |  | RESULT NEEDED
 |  |  |  |  |  | 2023-03-03 00:00:00 | 2023-03-04 00:00:00 | 2023-03-05 00:00:00 | 2023-03-06 00:00:00 | 2023-03-07 00:00:00 | 2023-03-08 00:00:00 | 2023-03-09 00:00:00 | 2023-03-10 00:00:00 | 2023-03-11 00:00:00 | 2023-03-12 00:00:00 | DATES FIXED IN MAIN WORKSHEET
Date | Sku | Desc | qty |  |  | 12345-XWP1-10 | 12348-XWP4-12 | 12351-XWP7-1 | 12353-XWP9-78 |  |  |  |  |  |  | PULL AND CONCATENATE DATA FROM DATA SOURCE
2023-03-03 00:00:00 | 12345 | [NAME] | 10 |  |  | 12346-XWP2-299 | 12349-XWP5-51 | 12352-XWP8-3 | 12354-XWP10-5 |  |  |  |  |  |  | XLOOKUP REPORTS ALL INSTANCES OF SAME DATE
2023-03-03 00:00:00 | 12346 | XWP2 | 299 |  |  | 12347-XWP3-35 | 12350-XWP6-923 |  |  |  |  |  |  |  |  | AND REPORTS AND CONCATENATES ORDER#, ITEM#,QTY
2023-03-03 00:00:00 | 12347 | XWP3 | 35
2023-03-04 00:00:00 | 12348 | XWP4 | 12
2023-03-04 00:00:00 | 12349 | [NAME] | 51
2023-03-04 00:00:00 | 12350 | XWP6 | 923
2023-03-05 00:00:00 | 12351 | XWP7 | 1
2023-03-05 00:00:00 | 12352 | XWP8 | 3
2023-03-06 00:00:00 | 12353 | XWP9 | 78
2023-03-06 00:00:00 | 12354 | XWP10 | 5
Spreadsheet: 839735d1692190329-skip-empty-rows-when-importing-data-from-one-sheet-to-other-sheet-through-formula-sample
Sheet: Sheet1

CUSTOMER
Coppel
Coppel
Coppel
Coppel
Coppel
Coppel
WT&T
WT&T
WT&T
NASA
NASA
NASA
NASA
NASA
NASA
NASA
ORBICO
ORBICO
ORBICO
ORBICO
ORBICO
ORBICO
ORBICO
ORBICO
ORBICO
Spreadsheet: 122734d1317119655-logical-formula-pivot
Sheet: Sheet1

Numbers | Decimals
1002 | 00
1002.1 | 10 |  | Count of Numbers
1002.1 | 10 |  | Decimals | Total
1014 | 00 |  | 10 | 9
1029 | 00 |  | 20 | 6
1029.1 | 10 |  | 30 | 4
1003 | 00 |  | 40 | 5
1014.4 | 40 |  | 50 | 5
1053.4 | 40 |  | 60 | 5
1084.6 | 60 |  | 80 | 2
1031.1 | 10 |  | 90 | 11
1041.3 | 30
1047.3 | 30
1081.5 | 50
1075.5 | 50
1023.2 | 20
1001 | 00
1022.9 | 90
1045 | 00
1058.9 | 90
1052.4 | 40
1062.5 | 50
1051.7 | 70
1012.9 | 90
1007.8 | 80
1035.3 | 30
1029.5 | 50
1019.9 | 90
1070.9 | 90
1010 | 00
1057.1 | 10
1012.4 | 40
1064.9 | 90
1002.6 | 60
1040.2 | 20
1042.5 | 50
1057.9 | 90
1082.6 | 60
1032.6 | 60
1016.2 | 20
1012.2 | 20
1082.4 | 40
1037.9 | 90
1054.9 | 90
1030.1 | 10
1042.2 | 20
1092.1 | 10
1003.6 | 60
1099.7 | 70
1073.1 | 10
1071.9 | 90
1010.9 | 90
1099.7 | 70
1075.3 | 30
1029.2 | 20
1006.1 | 10
1029.7 | 70
1039.8 | 80
1033.7 | 70
1070 | 00
Spreadsheet: 876985d1723687912-data-transformation-in-two-types-of-sheets-book1-1-7
Sheet: Wide

site | pid | age | wt0 | hr0 | hb0 | wt1 | hr1 | hb1 | wt2 | [NAME] | hb2
A | 1 | 34 | 66 | 78 | 12 | 67 | 76 | 11.2 | 65 | 77 | 12.3
A | 2 | 43 | 76 | 88 | 13.1 | 77 | 87 | 11.2 | 77 | 88 | 12.3
A | 3 | 45 | 54 | 77 | 14 | 56 | 76 | 13 | 60 | 65 | 11
B | 1 | 41 | 68 | 77 | 12.1 | 67 | 70 | 11.2 | 65 | 77 | 12.3
B | 2 | 23 | 87 | 78 | 13.3 | 82 | 76 | 10.2 | 80 | 77 | 11.4
Spreadsheet: 793037d1661270121-help-with-comparison-needed-sample-2-
Sheet: Sheet1

CONDITION | [NAME] | DATE & TIME | CONDITION | [NAME] | DATE & TIME | DIFFERENCE
Door Forced | SE Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR E Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR E Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR W Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR W Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR [NAME] | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Forced | [NAME] A | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Held Open | [NAME] IN | 2021-01-01 00:05:00
Door Alarm Reset | BR Ext Loading Store IN | 2021-01-01 00:07:00
Door Held Open | CR Office | 2021-01-01 01:21:00
Door Alarm Reset | CR  Office | 2021-01-01 01:22:00
Door Held Open | [NAME] IN | 2021-01-01 04:28:00
Door Alarm Reset | [NAME] IN | 2021-01-01 04:29:00
Door Held Open | CR Office | 2021-01-01 04:31:00
Door Alarm Reset | CR  Office | 2021-01-01 04:34:00
Door Forced | [NAME] | 2021-01-01 07:29:00
Door Alarm Reset | [NAME] | 2021-01-01 07:29:00