tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169084d1342698537-2-sources-2-vlookup-in-1-sheet-book1
Sheet: Top Sheet

Private Sub WorkSheet_SelectionChange(ByVal Target As Range)
Agent No | Agent Name | Material Code | Material Description
1 | Answer=vlookup the Data1 Sheets (Macro code) | A | Answer=vlookup the Data2 Sheets (Macro code)
2 | Answer=vlookup the Data1 Sheets (Macro code) | B | Answer=vlookup the Data2 Sheets (Macro code)
3 | Answer=vlookup the Data1 Sheets (Macro code) | C | Answer=vlookup the Data2 Sheets (Macro code)
4 | Answer=vlookup the Data1 Sheets (Macro code) | D | Answer=vlookup the Data2 Sheets (Macro code)
5 | Answer=vlookup the Data1 Sheets (Macro code)
End Sub
Spreadsheet: 804748d1668267411-stock-allocation-value-book1-isskint-
Sheet: Backorder

Order Date | SKU | Quantity | Stock Value | Reasoning
2022-08-12 00:00:00 | PROD1234 | 17 |  | 13@1.79 + 4 @ 3.33
2022-08-18 00:00:00 | PROD1234 | 12 |  | 9 @ 3.33 = 3 @ 8.58
2022-09-01 00:00:00 | PROD1234 | 9
2022-09-17 00:00:00 | PROD1234 | 13
2022-10-01 00:00:00 | PROD1234 | 5
2022-10-21 00:00:00 | PROD1234 | 15
Spreadsheet: 85271d1285303816-how-to-show-data-based-on-search-criteria-search
Sheet: Sheet1

ID Number | Name | Address | Phone Number | Parent Name
111 | Edrick [NAME] | Jl. [NAME] 38, Sukajadi | 421991 | Edy Pratama (pdmk)
121 | [NAME] | Villa Marina Blok B /3A | [PHONE]/431868/7077668 | [NAME]
136 | [NAME] * | [NAME] | 423071 | [NAME]
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME]
106 | [NAME] (pdmk) | Blok III Urashima | [PHONE]/457260 | Sherine (pdmk)
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
15616 | [NAME] | Komp.[NAME] 30 | 452785 / 455829/[PHONE] | Agnes Ashianti *
321 | Derrick * | [NAME] Indah Blok A / 3 | 433119 | Sherwin *
1658 | [NAME] | Blok III Nagasaki | 7041389/[PHONE] | [NAME]
 |  |  |  |  |  |  | I want to type a Name, then all the table below (in Yellow) will show those matched, or show those match part of the name (Edrick for example)
Search by Name : |  | Edrick
ID Number | Name | Address | Phone Number | Parent Name
111 | Edrick [NAME] | Jl. [NAME] 38, Sukajadi | 421991 | Edy Pratama (pdmk)
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME]
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
 |  |  |  |  |  |  | I want to type an address, then all the table below (in Yellow) will show those matched, or show those match part of it (Blok III for example)
Search by Address : |  | [NAME]
ID Number | Name | Address | Phone Number | Parent Name
106 | [NAME] (pdmk) | Blok III Urashima | [PHONE]/457260 | Sherine (pdmk)
1658 | [NAME] | Blok III Nagasaki | 7041389/[PHONE] | [NAME]
136 | [NAME] * | [NAME] | 423071 | [NAME]
 |  |  |  |  |  |  | I want to type a phone number, then all the table below (in Yellow) will show those matched, or show those match part of it (7027298 for example)
Search by Phone Number : |  | 7027298
ID Number | Name | Address | Phone Number | Parent Name
16156 | Edrick | Nagoya Paradise Center Q / 25 | 425405 / 7027298/[PHONE] | Shelton *
 |  |  |  |  |  |  | I want to type a Parent Name, then all the table below (in Yellow) will show those matched, or show those match part of the parent name ([NAME] for example)
Search by Parent Name : |  | [NAME]
ID Number | Name | Address | Phone Number | Parent Name
6514 | Edrick Purba | Komp. TOP 100 Blok B No. 8 | 450530 | [NAME]
121 | [NAME] | Villa Marina Blok B /3A | [PHONE]/431868/7077668 | [NAME]
Spreadsheet: 771078d1646405655-expected-output-based-on-2-criteria-and-header-sample-workbook-with-expected-outcome
Sheet: Data

Category | Activity | Performer Name | Dec.21 Status (Yes/No) | [NAME] (Yes/No) | Feb.22 Status (Yes/No)
GL | 123 | A | Yes | Yes | Yes
GL | 456 | A | Yes | Yes | Yes
Recon | 789 | B | No | Yes | Yes
Recon | 101 | C | Yes | Not Due | Not Due
Recon | 112 | B | Not Due | Yes | Yes
Reporting | 132 | D | No | Yes | No
Reporting | 659 | E | Yes | Yes | No
Recon | 489 | C | No | No | Yes
GL | 542 | F | No | No | Yes
Spreadsheet: 138489d1327681030-excel-2007-referencing-a-hyperlink-tlc-client-progress
Sheet: Martin Oppenlander

Client
Student
 | Date Completed | Comments
Initial Contact
Details put on database | 2012-12-12 00:00:00
Evaluation
Evaluation Report Received
Follow Up with Parent
Course Overview Made
Confirmed Teacher
Teacher Availability Updated
Sent out T&Cs/Welcome Pack
Added Lessons to Database
Send info to JF
Follow Up 1st class
How often do they want follow up?
20 classes
40 classes
Band Scores
Initial
20 classes
40 classes
Spreadsheet: 694521d1599660992-conditional-formatting-conditional-formatting-question
Sheet: Tax 2020-21

Name |  |  |  | Taxable Amount |  |  | Monthly Tax |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  | Sr.No. | Amount |  | [NAME]. Tax Within Slab | Rate (%) | Tax Amount
 |  |  |  |  | From | To
 |  |  |  | 1 | 0 | 600000 | 0 | 0 | 0 | Annual Tax
 |  |  |  | 2 |  | 1200000 |  | 5
 |  |  |  | 3 |  | 1800000 |  | 10
 |  |  |  | 4 |  | 2500000 |  | 15
 |  |  |  | 5 |  | 3500000 |  | 17.5
 |  |  |  | 6 |  | 5000000 |  | 20
 |  |  |  | 7 |  | 8000000 |  | 22.5
 |  |  |  | 8 |  | 12000000 |  | 25
 |  |  |  | 9 |  | 30000000 |  | 27.5
 |  |  |  | 10 |  | 50000000 |  | 30
 |  |  |  | 11 |  | 750000000 |  | 32.5
 |  |  |  | Taxable Amount: |  | 2463620 |  | Total Tax:
 |  |  |  | Sr.No. | Amount |  | [NAME]. Tax Within Slab | Rate (%) | Tax Amount
 |  |  |  |  | From | To
 |  |  |  | 1 | 0 | 400000 | 0 | 0
 |  |  |  | 2 | 400000 | 750000 |  | 10
 |  |  |  | 3 | 750000 | 1500000 |  | 15
 |  |  |  | 4 | 1500000 | 2500000 |  | 20
 |  |  |  | 5 | 2500000 | 4000000 |  | 25
 |  |  |  | 6 | 4000000 | 6000000 |  | 30
 |  |  |  | 7 | 6000000 | 999999999999999 |  | 35
Spreadsheet: 809776d1671303765-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst-hendrikbez-
Sheet: Summary by Month

Calendar Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total YTD
Cash Beginning of Period
Revenue
 | Total Revenue:
Expenses:
 | Total Expenses:
Net Balance: Gain / (Loss)
Cash End of Period - PER BOOKS
 | BANK 1 - Enter Number from Bank Statement
 | Bank 2 - Checking Acct
 | Bank 2 - Savings Acct
TOTAL CASH BALANCE - PER STMTS
 | zero balance - unless checks outstanding
Spreadsheet: 828406d1683473140-how-to-get-the-text-between-two-symbols-string
Sheet: Sheet1

 |  |  | Expected Result
 |  | String | Company | Category | Role | Levels | Skill
 |  | Company - Data - Consultant - Level 3 - Niche tech | Company | Data | Consultant | Level 3 | Niche Tech
 |  | Company - ADM - Developer - Level 2 - Advanced tech | Company | ADM | Developer | Level 2 | [NAME]
 |  | Company - Infra - Project Manager - Level 2 - Common tech | Company | Infra | Project Manager | Level 2 | [NAME]
 |  | Company - Data - Analyst - Level 1 - Common tech | Company | Data | Analyst | Level 1 | [NAME]
Spreadsheet: jeff_dasovich__14201__E204_MAKEaDEAL_sim
Sheet: Sheet1

DOOR # = | 2 |  | Door | Probability
 |  |  | 1 | 0.333333
 |  |  | 2 | 0.333333
 |  |  | 3 | 0.333333
No Switch
Pick Door | 2 |  |  |  | Door | Probability
Switch
Pick Door |  |  | 3 |  | 1 | 0.5
 |  |  |  |  | 3 | 0.5
No Switch | Win=1
 | Lose=0
Switch | Win = 1
 | Lose = 0
Spreadsheet: 0d1a0d6e-9d7f-452d-9e9b-9f4e20145760
Sheet: Page 3

 | Permit No.: | WQ0034380 |  | Facility Name: |  | Sanderson Farms WWTF |  |  |  |  |  | County: |  | Lenoir |  | Month: |  |  |  | Year:
 |  | Field Name: |  | 6 |  | Field Name: |  | 7 |  | Field Name: |  | 8A |  | Field Name: |  | 8B |  | Field Name:
 |  | Area (acres): |  | 30 |  | Area (acres): |  | 29.6 |  | Area (acres): |  | 22.8 |  | Area (acres): |  | 1.84 |  | Area (acres):
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
Spreadsheet: 46656d1245554720-help-with-employee-database-employees
Sheet: Sheet3

Race | # of Employees | Average Salary
African American | 5 | 54120
Asian American | 4 | 55700
Hispanic | 5 | 39360
Non-Hispanic | 7 | 53642.85714285714
Income Group
$50,000 to $60,000 | 5
Hired
Females before 1/1/85 | 4
Spreadsheet: 598577d1542613914-creating-a-list-from-cross-referenced-data-sample
Sheet: Sheet1

Person | A | B | C | D | E | F | G |  | RESULTS
#1 | 2 |  |  |  |  | 5 |  |  | Person | Type
#2 |  |  |  | 1
#3
#4
#5 |  |  |  |  |  |  | 2
Spreadsheet: 837100d1689850671-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-132-aligw
Sheet: Sheet3

ANSW3 | 1 | 2 | 3 | 4 | 5 |  | 1 - This is Pricing 3
10
20 |  |  |  |  |  |  | 2 - This pricing is pasted from an erp to here in this format.
30
40 |  |  |  |  |  |  | 3 - Each year we paste a pricesheet to the excel file.
50
Spreadsheet: 773071d1647605155-vlookup-based-on-cell-b-string-vlookup-condition-string
Sheet: Sheet1

AEGINNO | 363 STEM |  |  | AEGINNO | GANOINE
CANOEING | C |  |  | ADELNOS | LOADENS
NONIMAGE | M
ANGINOSE | S
GANOINES | S
ADELNOS | 365 STEM
CELADONS | C
DONEGALS | G
SLOGANED | G
NODALISE | I
LODESMAN | M
LADRONES | R
SOLANDER | R
Spreadsheet: diana_scholtes__8591__DJ_Prices_December
Sheet: Sheet1

Date | Price | Price | Price | Price
 | DJ-COB | DJ-COB-OFF | DJ-MC | DJ-MC-OFF
2001-12-01 00:00:00 | 29.03 | 23.31 | 28.43 | 22.48
2001-12-02 00:00:00 | 25.56 | 25.56 | 24.75 | 21
2001-12-03 00:00:00 | 29.34 | 25.56 | 27.73 | 23.81
2001-12-04 00:00:00 | 28.33 | 20.29 | 26.2 | 19.64
2001-12-05 00:00:00 | 29.56 | 20.64 | 27.34 | 20.3
2001-12-06 00:00:00 | 28.87 | 20.38 | 27.53 | 20.38
2001-12-07 00:00:00 | 27.92 | 20.66 | 26.43 | 20.18
2001-12-08 00:00:00 | 27.73 | 20.63 | 26.43 | 20.18
2001-12-09 00:00:00 | 22.63 | 22.63 | 25 | 20.5
2001-12-10 00:00:00 | 28.77 | 22.63 | 27.23 | 22.41
2001-12-11 00:00:00 | 29.06 | 21.2 | 27.17 | 21.08
2001-12-12 00:00:00 | 37.73 | 28.69 | 35.52 | 27.51
2001-12-13 00:00:00 | 36.53 | 28.89 | 34.37 | 26.6
2001-12-14 00:00:00 | 33.17 | 27.13 | 31.58 | 26.29
2001-12-15 00:00:00 | 33.09 | 27.13 | 31.57 | 26.29
2001-12-16 00:00:00 | 28.3 | 26.3 | 25 | 23
2001-12-17 00:00:00 | 30.92 | 26.3 | 28.03 | 24.95
2001-12-18 00:00:00 | 30.98 | 24.08 | 28.46 | 22.46
2001-12-19 00:00:00 | 30.98 | 24.08 | 27.71 | 22.7
2001-12-20 00:00:00 | 25.22 | 19.81 | 23.41 | 19.29
2001-12-21 00:00:00 | 25.22 | 19.81 | 23.41 | 19.29
2001-12-22 00:00:00 | 25.22 | 19.81 | 23.34 | 19.29
2001-12-23 00:00:00 | 17.19 | 17.19 | 17.75 | 16
2001-12-24 00:00:00 | 20.58 | 17.08 | 19.75 | 17.45
2001-12-25 00:00:00 | 16.15 | 16.15 | 19 | 17
2001-12-26 00:00:00 | 21.96 | 16.15 | 20.18 | 17.23
2001-12-27 00:00:00 | 25.35 | 18.75 | 23.61 | 19.78
2001-12-28 00:00:00 | 25.35 | 18.75 | 23.61 | 19.78
2001-12-29 00:00:00 | 25.35 | 18.75 | 23.61 | 19.78
2001-12-30 00:00:00 | 19.43 | 19.43 | 21.5 | 20
2001-12-31 00:00:00 | 24.48 | 19.43 | 22.99 | 21.45
Spreadsheet: 865469d1712556969-calculate-max-borrowing-based-on-funds-available-cell-and-lvr-of-88-investment-property-spreadsheet-example
Sheet: Income Input

INCOME INPUT SCREEN
 | Enter Name for Applicant One |  |  |  |  |  |  | Enter Name for Applicant Two
 |  | Annual Income: |  | 80000 |  |  |  |  |  | Annual Income: |  | 150000
 |  | Income Tax: |  |  |  |  |  |  |  | Income Tax:
 |  | [NAME]: |  |  |  |  |  |  |  | [NAME]:
 |  | Medicare Levy %: |  | 0.02 |  |  |  |  |  | Medicare Levy %: |  | 0.02
 |  | Tax Payable: |  |  |  |  |  |  |  | Tax Payable:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  | [NAME] box if 2 Appplicants
2025 |  |  | The tax year from 1 July 2024 to 30 June 2025 |  |  |  |  |  |  |  |  |  |  |  | stage 3 tax cuts updated
2024-25 Tax Year |  |  |  | This is the latest 2024-25 tax schedule
 |  |  | Taxable income |  |  |  | Tax on this income
 |  |  | From | To |  |  |  |  |  |  |  |  | LITO | LMITO |  |  | Scratch Pad |  | Annual | Month | Week
 |  |  | 0 | 18200 |  |  | Nil |  |  | 0 | 0 |  |  |  |  |  | Income
 |  |  | 18201 | 45000 |  |  | 16c for each $1 over $18,200 |  |  | 0 | 0.16
 |  |  | 45001 | 135000 |  |  | $4,288 plus 30c for each $1 over $45,000 |  |  | 4288 | 0.3 |  |  |  |  |  | Tax + medicare
 |  |  | 135001 | 190000 |  |  | $31,288 plus 37c for each $1 over $135,000 |  |  | 31288 | 0.37 |  |  |  |  |  | Offsets & credits
 |  |  | 190001 | above ** |  |  | $51,638 plus 45c for each $1 over $190,000 |  |  | 51638 | 0.45 |  |  |  |  |  | TIDs/WH | 0
 |  |  |  |  |  |  |  | True |  | <<medicare tick condition |  |  |  |  |  |  | Franking | 0
 |  |  |  |  |  |  |  |  |  |  | Rounded A1>> |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | 0
2025 |  |  | The tax year from 1 July 2024 to 30 June 2025 |  |  |  |  |  |  |  |  |  |  |  | stage 3 tax cuts updated |  | Subtotal
2024-25 Tax Year |  |  |  | This is the latest 2024-25 tax schedule
 |  |  | Taxable income |  |  |  | Tax on this income
 |  |  | From | To |  |  |  |  |  |  |  |  | LITO | LMITO |  |  | Income after tax
 |  |  | 0 | 18200 |  |  | Nil |  |  | 0 | 0
 |  |  | 18201 | 45000 |  |  | 16c for each $1 over $18,200 |  |  | 0 | 0.16
 |  |  | 45001 | 135000 |  |  | $4,288 plus 30c for each $1 over $45,000 |  |  | 4288 | 0.3
 |  |  | 135001 | 190000 |  |  | $31,288 plus 37c for each $1 over $135,000 |  |  | 31288 | 0.37
 |  |  | 190001 | above ** |  |  | $51,638 plus 45c for each $1 over $190,000 |  |  | 51638 | 0.45
 |  |  |  |  |  |  |  | True |  | <<medicare tick condition
 |  |  |  |  |  |  |  |  |  |  | Rounded A1>>
INCOME BREAK DOWN INCLUDING TAX OFFSETS
 |  |  |  | Annual |  | Monthly |  | F/Nightly |  | Weekly
 |  |  |  | Tax + Medicare |  |  |  | New Taxable Income:
 |  |  |  | Deductions From INVs |  |  |  | Adjusted Tax Payable
 |  |  |  | Annual |  | Monthly |  | F/Nightly |  | Weekly
 |  |  |  | Tax + Medicare |  |  |  | Adjusted Tax Payable
 |  |  |  | Deductions From INVs
Spreadsheet: 766931d1644172522-finding-multiple-criteria-in-nth-rows-draft-rota-example
Sheet: Lookups

Times | Reasons | Agency | Agency staff and casuals |  |  |  | Staff
06:00:00 | Amendments | Nurse 1 | Agency 1 |  |  |  | Staff 1
06:15:00 | EMERGENCY LEAVE | Nurse 2 | Agency 2 |  |  |  | Staff 2
06:30:00 | LEAVE | Nurse 3 | Agency 3 |  |  |  | Staff 3
06:45:00 | UNPAID LEAVE | Nurse 4 | Agency 4 |  |  |  | Staff 4
07:00:00 | MATERNITY | Nurse 5 | Agency 5 |  |  |  | Staff 5
07:15:00 | OVERTIME | Nurse 6 | Agency 6 |  |  |  | Staff 6
07:30:00 | PATERNITY | Nurse 7 | Agency 7 |  |  |  | Staff 7
07:45:00 | SICK | Nurse 8 | Agency 8 |  |  |  | Staff 8
08:00:00 | STEP UP | Nurse 9 | Agency 9 |  |  |  | Staff 9
08:15:00 | TOIL | Nurse 10 | Agency 10 |  |  |  | Staff 10
08:30:00 | TRAINING | Nurse 11 | Agency 11 |  |  |  | Staff 11
08:45:00 | VACANT POST | Nurse 12 | Agency 12 |  |  |  | Staff 12
09:00:00 | AGENCY | Nurse 13 | Agency 13 |  |  |  | Staff 13
09:15:00 | [NAME] |  | Agency 14 |  |  |  | Staff 14
09:30:00 | 1-1 Care Covid |  | Agency 15 |  |  |  | Staff 15
09:45:00 | 1-1 Care Non-Covid |  | Agency 16 |  |  |  | Staff 16
10:00:00 | [NAME] extra cleaning |  | Agency 17 |  |  |  | Staff 17
10:15:00 | COVID positive |  | Agency 18 |  |  |  | Staff 18
10:30:00 | [NAME] quarantine 14 days |  | Agency 19 |  |  |  | Staff 19
10:45:00 | [NAME] shielding |  | Agency 20 |  |  |  | Staff 20
11:00:00 | COVID sickness |  | Agency 21 |  |  |  | Staff 21
11:15:00 | COVID social distancing
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
00:00:00
Spreadsheet: 140813d1328897423-formula-for-quarterly-charges-rent-sample
Sheet: Sheet2

Amount (£M) | Effective Date | Rent (£)
4691300 | 2011-04-20 00:00:00
12000000 | 2011-04-10 00:00:00
6568768 | 2011-10-05 00:00:00
250000000 | 2011-07-15 00:00:00
3036577 | 2011-01-08 00:00:00
3287204 | 2011-05-20 00:00:00
5684407 | 2011-05-29 00:00:00
9716415 | 2011-12-14 00:00:00
5000000 | 2011-04-30 00:00:00
5554028 | 2011-06-20 00:00:00
1459606 | 2011-08-12 00:00:00
9846540 | 2011-08-30 00:00:00
2442737 | 2011-08-03 00:00:00
8597695 | 2011-02-19 00:00:00
1329929 | 2011-07-21 00:00:00
9046236 | 2011-08-11 00:00:00
Spreadsheet: 115555d1311116502-counting-with-conditions-recontest
Sheet: Sheet2

400831669 | CAR | CAR-PROCESSED |  |  | REJECTED | PROCESSED
400831670 | CAR | CAR-PROCESSED |  | CAR | 2 | 11
400831671 | CAR | CAR-PROCESSED |  | TRUCK | 3 | 9
400831672 | CAR | CAR-PROCESSED
400831673 | CAR | CAR-REJECTED |  |  | *I need a formula that would display these results
400831674 | CAR | CAR-PROCESSED |  |  | *Their status is on another worksheet so I'm having a hard time working on a formula
400831675 | CAR | CAR-PROCESSED
400831676 | CAR | CAR-PROCESSED
400831677 | CAR | CAR-PROCESSED
400831678 | CAR | CAR-PROCESSED
400831679 | CAR | CAR-REJECTED
400831680 | CAR | CAR-PROCESSED
400831681 | CAR | CAR-PROCESSED
400831682 | TRUCK | TRUCK-PROCESSED
400831683 | TRUCK | TRUCK-PROCESSED
400831684 | TRUCK | TRUCK-REJECTED
400831685 | TRUCK | TRUCK-PROCESSED
400831686 | TRUCK | TRUCK-PROCESSED
400831687 | TRUCK | TRUCK-PROCESSED
400831688 | TRUCK | TRUCK-PROCESSED
400831689 | TRUCK | TRUCK-REJECTED
400831690 | TRUCK | TRUCK-PROCESSED
400831691 | TRUCK | TRUCK-PROCESSED
400831692 | TRUCK | TRUCK-PROCESSED
400831693 | TRUCK | TRUCK-REJECTED
Spreadsheet: 138637d1327774884-account-matching-any-good-ideas-check-total
Sheet: Sheet1

Example
My file |  |  | Their file
Name | Counts
[NAME] | 100 |  | [NAME] | 333
[NAME] | 133 |  | [NAME] | 233
[NAME] | 100 |  | [NAME] | 103 |  | So how do i check that these are the same
[NAME] | 200 |  | bob | 10 |  | Usualy i have about 500 posts with nots so round numbers
[NAME] | 50 |  | bill | 25
[NAME] | 33 |  | [NAME] | 26
[NAME] | 53 |  |  |  |  | Any help much appreciated
bob | 10
bill | 25
[NAME] | 26
 |  |  | Sum of Counts
 |  |  | Name | Total
 |  |  | bill | 25
 |  |  | bob | 10
 |  |  | [NAME] | 26
 |  |  | [NAME] | 333
 |  |  | [NAME] | 103
 |  |  | [NAME] | 233
 |  |  | Grand Total | 730
Spreadsheet: 765369d1643294762-sum-in-diferent-sheets-with-condition-conditional-summation-of-data-from-separate-sheets-vinhas-
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  | sheet 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2020-01-01 00:00:00 | a | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2020-02-05 00:00:00 | s | 125
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021-02-03 00:00:00 | d | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021-03-05 00:00:00 | r | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2021-07-08 00:00:00 | f | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2022-02-10 00:00:00 | t | 400
Spreadsheet: 138202d1327564777-filling-in-hlookup-formula-hlookup
Sheet: Sheet1

Name | Position | Answer
Player 2 | C | 12
Player 3 | SG | 20
Player 4 | SF | 18
Player 5 | PG | 36
Player 6 | C | 12
Player 7 | PF | 19
Player 8 | C | 14
Player 9 | SG | 50
Player 10 | SF | 22
Player 11 | PG | 75
Player 12 | PF | 16
Player 13 | PF | 19
Player 14 | SG | 31
Player 15 | C | 13
Player 16 | PG | 79
Player 17 | SF | 23
Spreadsheet: 676929d1589077407-lookup-to-return-most-recently-dated-note-based-on-multiple-criteria-notes
Sheet: Rollup

Status | ID | Last Note Manager Note
Active | 1234
Active | 2345
Inactive | 3456
Active | 5678
Active | 8910
Active | 9876
Active | 8765
Active | 7654
Active | 6543
Inactive | 5432
Active | 4321
Active | 2109
Spreadsheet: darrell_schoolcraft__7698__June 2002 Maint
Sheet: Sheet1

JUNE 2002
2002-03-06 00:00:00
SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  |  | 1
 |  |  |  |  |  | White Rock 1 Liners
 |  |  |  |  |  | 75 MMcf/d
2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | Plains ESD
Leupp A PLC
150 MMcf/d
White Rock 1 Liners
75 MMcf/d
 |  |  | Bluewater ESD
9 | 10 | 11 | 12 | 13 | 14 | 15
Leupp A PLC
150 MMcf/d
 |  |  |  | L 1204 [NAME] |  | L 1204 L/R Wind.R-Navajo
 |  |  |  |  |  | 200 MMcf/d
16 | 17 | 18 | 19 | 20 | 21 | 22
Leupp A PLC
L 1204 L/R Wind.R-Navajo |  | L 1204 Smart LPC-FLG |  |  | L 1208 Caoip V 31- FLG | L 1204 L/R Vcity-WRA
200 MMcf/d |  | 150 MMcf/d |  |  | 100 MMcf/d | 200 MMcf/d
23/30 | 24 | 25 | 26 | 27 | 28 | 29
Leupp A PLC
Spreadsheet: michelle_lokay__26786__MojaveReconciliation
Sheet: Sheet1

Mojave Reconciliation
 |  | [NAME] |  | Cumm Vol |  | GDA |  |  | Bloomberg |  |  | Difference
2001-11-01 00:00:00 |  | 176934 |  |  |  | 2.04 |  |  | 2.92
2001-12-01 00:00:00 |  | 9889 |  |  |  | 2.25 |  |  | 2.56
2002-01-01 00:00:00 |  | -8864 |  |  |  | 2.08 |  |  | 2.67
2002-02-01 00:00:00
2002-03-01 00:00:00
Spreadsheet: benjamin_rogers__906__BR New York Ticker 10_01
Sheet: ZONE G DAY AHEAD

 |  |  |  | Zone A DAY- AHEAD SPREAD SHEET
Day Ahead Prices
HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
26.46 | 25.24 | 24.84 | 24.44 | 24.59 | 25.42 | 29.67 | 37.95 | 41.78 | 43.9 | 46.53 | 48.01 | 49.63 | 50.84 | 50.69 | 50.87 | 49.72 | 49.77 | 46.56 | 48.03 | 45.94 | 41.64 | 35.8 | 32.57
Real Time Prices
HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
ON PEAK |  |  |  | HOUR | BUY(MW) | SELL(MW) | PRICE | FILLED |  | AVERAGES
OFF PEAK |  |  |  | 1
RTC |  |  |  | 2 |  |  |  |  |  | ON PEAK
 |  |  |  | 3
 |  |  |  | 4 |  |  |  |  |  | OFF PEAK
 |  |  |  | 5
 |  |  |  | 6 |  |  |  |  |  | RTC
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9 |  |  |  |  |  | PRICE TO BEAT
 |  |  |  | 10
 |  |  |  | 11 |  |  |  |  |  | ON PK | 45.2
 |  |  |  | 12 |  |  |  |  |  | OFF PK | 26
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
Spreadsheet: 292235d1390527035-clear-cell-if-selection-no-longer-exist-in-drop-down-menu-forum3
Sheet: Dropdowns

Grupo A
[NAME] |  |  |  |  |  |  | Alemania
[NAME] |  |  |  | #49 |  |  | Argelia
México |  |  |  | #49 |  |  | Argentina
Camerún |  |  |  |  |  |  | Australia
 |  |  |  | #50 |  |  | Bélgica
Grupo B |  |  |  | #50 |  |  | Bosnia
España |  |  |  |  |  |  | [NAME]
Holanda |  |  |  | #51 |  |  | Camerún
Chile |  |  |  | #51 |  |  | Chile
Australia |  |  |  |  |  |  | Colombia
 |  |  |  | #52 |  |  | Corea Sur
Grupo C |  |  |  | #52 |  |  | Costa Marfil
Colombia |  |  |  |  |  |  | Costa Rica
[NAME] |  |  |  | #53 |  |  | [NAME]
Costa Marfil |  |  |  | #53 |  |  | Ecuador
Japón |  |  |  |  |  |  | España
 |  |  |  | #54 |  |  | Francia
Grupo D |  |  |  | #54 |  |  | Ghana
Uruguay |  |  |  |  |  |  | [NAME]
Italia |  |  |  | #55 |  |  | Holanda
Inglaterra |  |  |  | #55 |  |  | Honduras
Costa Rica |  |  |  |  |  |  | Inglaterra
 |  |  |  | #56 |  |  | Irán
Grupo E |  |  |  | #56 |  |  | Italia
Suiza |  |  |  |  |  |  | Japón
Francia |  |  |  | #57 |  |  | México
Ecuador |  |  |  | #57 |  |  | Nigeria
Honduras |  |  |  |  |  |  | Portugal
 |  |  |  | #58 |  |  | [NAME]
Grupo F |  |  |  | #58 |  |  | Suiza
Argentina |  |  |  |  |  |  | Uruguay
Bosnia |  |  |  | #59 |  |  | USA
Nigeria |  |  |  | #59
Irán
 |  |  |  | #60
Grupo G |  |  |  | #60
Alemania
Portugal |  |  |  | #61
USA |  |  |  | #61
Ghana
 |  |  |  | #62
Grupo H |  |  |  | #62
Bélgica
[NAME] |  |  |  | Pdor 61
Argelia |  |  |  | Pdor 61
Corea Sur
 |  |  |  | pdor 62
 |  |  |  | pdor 62
 |  |  |  | final
 |  |  |  | final
 |  |  |  | 3rd/4th
 |  |  |  | 3rd/4th