tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 706232d1606549443-non-negative-number-formatting-formattazione-numeri-positivi
Sheet: Foglio1

a |  |  |  |  | 1
a |  |  |  |  | 1
a |  |  |  |  | 1
b |  |  |  |  | -1 | NO |  | =VAL.NUMERO(RICERCA("1";F6))
c |  |  |  |  | 2
c |  |  |  |  | 2 |  |  | =VAL.NUMERO(RICERCA("2";F6))
c |  |  |  |  | 2
e |  |  |  |  | -2 | NO
f |  |  |  |  | 1
f |  |  |  |  | 1
f |  |  |  |  | 1
g |  |  |  |  | -1 | NO
h |  |  |  |  | -1 | NO
i |  |  |  |  | -1 | NO
j |  |  |  |  | 2
j |  |  |  |  | 2
j |  |  |  |  | 2
j |  |  |  |  | 2
k |  |  |  |  | -2 | NO
l |  |  |  |  | -2 | NO
m |  |  |  |  | -2 | NO
Spreadsheet: 153624d1335977916-index-match-help-demon8991_example-2_02may12_01
Sheet: Rail Operations

[NAME] Event Detail
 |  |  |  | 8 | RAIL OPERATIONS (1902878)
24 | 17
Reported Date | Claim ID | Division (FLEET DATA LEVEL_06_NODE_DS) | Name | Location | Event Description | Accident Date
IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN X ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN Q ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN J ON 'FLEET DATA ACC DETAIL' |  | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN AB ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN V ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'RAIL OPERATIONS (1902878)' THEN PULL INFOMRATION FROM COLUMN W ON 'FLEET DATA ACC DETAIL'
2011-06-14 00:00:00 | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN
1900-01-01 00:00:00
1900-01-01 00:00:00
2011-03-23 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
2011-09-19 00:00:00
1900-01-01 00:00:00
2011-04-18 00:00:00
1900-01-01 00:00:00
2011-11-10 00:00:00
1900-01-01 00:00:00
2011-10-25 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
2011-02-18 00:00:00
2011-02-04 00:00:00
Spreadsheet: fe7b6771-cde2-4d65-9204-a442d25be430
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Informatie / Bankgegevens: | EXTRA BESTELLING FILAFAIR… 2012
 |  | Organisatie Filafair®… / Stichting Hertogpost
 |  | [NAME] tot Voorstlaan 7
 |  | NL - 5224 CN 's-Hertogenbosch
 |  | Telefoon : +31(0)73 656 76 80
 |  | Mobile : +31(0)653769350
 |  | Mail : [EMAIL]
 |  | Website: www.filafair.nl
 |  | KvK Nr. 17238884 / BTW Nr. NL8203.41.915B01
 |  | RABO Bank Nr. 14.87.60.430 / BIC: RABONL2U
 |  | IBAN: NL91 RABO 0148 7604 30
Artikel |  |  | Verkoop | Totale | Aantal
Nummer |  | Omschrijving postzegels FILAFAIR… 2012 ( maart 23 & 24 ) | prijs | Prijs | invullen
FF.2012.001 |  | [NAME] 2012 | 1.25 | 0
FF.2012.002 |  | [NAME] 2012 velletje | 12.5 | 0
FF.2012.003 |  | [NAME] 2012 een zegel met embossing | 1.5 | 0
FF.2012.004 |  | [NAME] postzegel als serie | 10 | 0
FF.2012.005 |  | [NAME] postzegel als serie velletjes | 100 | 0
FF.2012.006 |  | [NAME] postzegel serie met FF perforatie | 12.5 | 0
FF.2012.007 |  | [NAME] postzegel serie met HP perforatie | 12.5 | 0
FF.2012.008 |  | [NAME] postzegel tarief EUROPA | 2 | 0
FF.2012.009 |  | [NAME] postzegel tarief EUROPA paartje | 4 | 0
FF.2012.010 |  | [NAME] postzegel tarief EUROPA velletje | 20 | 0
FF.2012.011 |  | [NAME] postzegel tarief WERELD | 2.2 | 0
FF.2012.012 |  | [NAME] postzegel tarief WERELD paartje | 4.4 | 0
[NAME] |  | [NAME] postzegel tarief WERELD velletje | 22 | 0
FF.2012.014 |  | [NAME] rolzegel serie | 10 | 0
FF.2012.015 |  | [NAME] rolzegels als paartje | 20 | 0
FF.2012.016 |  | Filafair POST.NL velletje Nr. 4 | 3.75 | 0
FF.2012.017 |  | Filafair POST.NL velletje Nr. 5 | 3.75 | 0
Opmerkingen | :
 |  |  | Subtotaal | 0
 |  | Uw bestelling wordt per aangetekende brief via POST.NL verstuurd.* | 8.4 | 0
 |  | Bestelling wordt per brief verstuurd op [NAME].* | 2.5 | 0
 |  | Als lid [NAME] Filatelistenvereniging op te halen.* | 0 | 0
 |  | * keuze aangeven wat gewenst is! | Factuur totaal |  | 0
Bestelling / Ontvanger :
Naam | :
Adres | :
Postcode & Plaats | :
[NAME]. Nr. | :
Mail adres | :
Graag het totale bedrag overmaken naar rekeningnummer : RABO BANK 14.87.60.430 t.n.v. Stichting Hertogpost
Onder vermelding [NAME] en woonplaats.
Na ontvangst van het bedrag sturen wij [NAME] toe, volgens de aangegeven keuze.
 |  | Ps. Uitlevering vindt plaats na 1 april 2012
Spreadsheet: 866153d1713113775-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-databse
Sheet: Sheet1

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can type in which hobby or interest you are looking for.
 | Filter (list) | Criteria (freefill) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | All_Hobbies | All_Interests
 | Hobby_List | Bowling n/a |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 |  |  |  | [NAME] | Bowling | n/a |  | Bowling |  | Bowling | Bowling
 |  |  |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Bowling | Baseball |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | In the table below the people that meet all the requirement you are filtering for will pop-up. |  |  |  |  |  |  |  |  | n/a
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Bowling | n/a | Bowling n/a | Bowling
 | ISSUE:
 | The freefill values in C7:C9 need to be an EXACT (undesired) match with [NAME]:H9 instead of a PARTIAL (desired) match to have the people show up in the above table. Typing in 'Bowling n/a' in C7 will show [NAME].
 | GOAL:
 | Desired result when typing in 'Bowling; in C6:
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 | [NAME] | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Bowling | Baseball |  | Walking
Spreadsheet: f1b517b5-b824-49c1-bc0b-c34eadba13e5
Sheet: EPR Rev Stats

SUPPLEMENTAL DATA ([NAME])
 | Quarter Ended
 | December 31,
Revenue Metrics | 2011 | 2010
In millions, unless otherwise noted
Gaming Operations
Revenues | 264.6 | 252.9
North America | 219.6 | 218
International | 45 | 34.9
Gross margin | 0.61 | 0.63
North America | 0.59 | 0.61
International | 0.67 | 0.71
Installed base ('000) | 55.6 | 52.6
North America | 42.6 | 41
International | 13 | 11.6
Average revenue per unit per day (0.00) | 53.11 | 52.68
Product Sales
Revenues | 180.9 | 198.3
North America | 103 | 133.8
International | 77.9 | 64.5
Machines | 115.7 | 118.6
North America | 59.1 | 75.5
International | 56.6 | 43.1
Non-machine | 65.2 | 79.69999999999999
North America | 43.9 | 58.3
International | 21.3 | 21.4
Gross margin | 0.51 | 0.56
North America | 0.53 | 0.57
International | 0.48 | 0.54
Units recognized ('000) | 7.3 | 8.3
North America | 3.8 | 5.1
International | 3.5 | 3.2
Units shipped ('000) [includes units where revenues deferred] | 6.5 | 7.5
North America | 3.5 | 4.5
New | 0.7 | 1.4
Replacement | 2.8 | 3.1
International | 3 | 3
New | 1.3 | 0.8
Replacement | 1.7 | 2.2
Average revenue per unit ('000) | 24.8 | 23.9
North America | 27.1 | 26.2
International | 22.3 | 20.2
Average machine sales price ('000) | 15.8 | 14.3
North America | 15.6 | 14.8
International | 16.2 | 13.5
Spreadsheet: 673193d1587239120-function-to-check-one-sheet-for-criteria-and-fill-in-another-sheet-truck-inspection-log-concretetsunami-
Sheet: 2020 Report

 |  |  |  |  | 1st Quarter |  | 2nd Quarter |  | NDE Annual (During 2nd Qtr) |  | 3rd Quarter |  | 4th Quarter
Truck # | Description of Truck | Status | On-site Date | Off-Site Date | 2020-01-01 00:00:00 | 2020-03-31 00:00:00 | 2020-04-01 00:00:00 | 2020-06-30 00:00:00 | 2020-04-01 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-09-30 00:00:00 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00
Spreadsheet: 10d17e06-a1bb-4eb0-a225-afbc2018f85e
Sheet: Sheet1

WEEKLY MENU | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Cycle # 1 | Monday | Tuesday | Wednesday | Thursday | Friday
Breakfast | Milk | Milk | Milk | Milk | Milk
 | Oranges
 | Pancakes
Lunch | Milk | Milk | Milk | Milk | Milk
 | Mac & Cheese w/ham |  |  |  | Beef & Spaghetti
 | Green Beans |  |  |  | w/ Sauce
 | Apple slices |  |  |  | Lettuce & tomato salad
 | [NAME] |  |  |  | [NAME]
Snack | Yogurt Ranch Dip
 | Carrot & Celery Sticks
Spreadsheet: 33834d1230674170-matching-pairs-of-data-combinelists1
Sheet: Sheet1

1 | 1 | A | 1 | A
2 |  |  | 3 | B
3 | 3 | B | 5 | C
4 |  |  | 7 | D
5 | 5 | C | 9 | E
6
7 | 7 | D
8
9 | 9 | E
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 772682de-82dd-4e8d-8a59-f58b928ffcdf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Ohio Department of Alcohol & Drug Addiction Services
 | SFY 2013 Budget/Expenditure Form
 | Implementing Agency:
 | Grant Program Area:
 | Budget Period:
 | State Grant #:
 | For ODADAS Internal Use Only |  | Initial Application
 |  |  | Budget Revision*
 |  |  | Expenditure Report
 | APPROVED BY | DATE
 | A. Budget Categories: | B. ODADAS Funds | C. Other Funds | D. Total Funds
 | Category I: Personnel Costs
 | A1. Personnel | 0 | 0 | 0
 | A2. Fringe Benefits | 0 | 0 | 0
 | Category II: Non-Personnel Costs
 | A3. Consultants | 0 | 0 | 0
 | A4. Subscriptions & Publications | 0 | 0 | 0
 | A5. Supplies | 0 | 0 | 0
 | A6. Printing/Copying | 0 | 0 | 0
 | A7. Rent/Lease Expenses | 0 | 0 | 0
 | A8. Phone/Utilities | 0 | 0 | 0
 | A9. Maintenance/Repair | 0 | 0 | 0
 | A10. Rentals | 0 | 0 | 0
 | A11. Insurance | 0 | 0 | 0
 | Category III: Motor Vehicle/Travel/Food/Conference
 | A12. [NAME] | 0 | 0 | 0
 | A13. Travel | 0 | 0 | 0
 | A14. Food | 0 | 0 | 0
 | A15. Conference/Training/Registration | 0 | 0 | 0
 | Category IV: Equipment/Furniture
 | A16. Equipment/Computer | 0 | 0 | 0
 | A17. Furniture | 0 | 0 | 0
 | E.  Totals | 0 | 0 | 0
 | When this form is completed as an expenditure report the person
 | submitting must print or type name and sign the document.
 | Prepared By:__________________________________________
 | Fiscal Signature:_______________________________________
 | Date:
 | *Prior written approval must be obtained from ODADAS before incurring costs that exceed a 10% change between Budget Categories or any change to Category IV.
Spreadsheet: 0d0f66dd-dd49-439d-93ee-c9d7d3824f9e
Sheet: SectorPart2

Industrial Stormwater Discharge Monitoring Report - 1200-Z Permit
Permittee Legal Name: |  |  |  |  |  | ODEQ File No./Facility ID:
Facility Common Name: |  |  |  |  |  | Reporting Period: |  | July 1, |  | to | June 30,
Facility Location: |  |  |  |  |  | Laboratory Name:
County: |  |  |  |  |  | ORELAP# |  |  |  | SIC Code(s):
Sector Specific Benchmark Sampling: 4 times per year, every year
Please refer to the permit assignment letter to determine if sector specific benchmark sampling is required.
Name or Number of Sampling Point(s) (group data per sampling point) |  | Sample Date | Antimony, Total | Beryllium, Total | Cyanide, Total | Selenium, Total | Silver, Total | Hardness Calc. | Turbidity | Magnesium, Total | Iron (Dissolved) | Radium (Dissolved) | Radium, Total | Uranium, Total
 |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | NTU | mg/L | mg/L | mg/L | mg/L | mg/L
Geometric Mean
Geometric Mean
Geometric Mean
Geometric Mean
Permit Benchmark |  |  | 0.64 | 0.13 | 0.022 | 0.005 | 0.0005 | N/A | 50 | 0.064 | 1 | unk | unk | unk
Page 4
Spreadsheet: 2be316c3-8d75-49e7-8f98-a7d52a2ddc9f
Sheet: Import Contracts Hourly

Forward Capacity Market Availability Settlement Detail Report
SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Shortage Event ID | Trading Date | Trading Interval | Resource ID | External Schedule ID | External Transaction Offered MW | External Transaction Requested MW | External Transaction Delivered MW | Calculated External Transaction Hourly Available MW | Override Description | External Transaction Hourly Available MW
Number | Date | Hour End | Number | Number | MW | MW | MW | MW | String | MW
Spreadsheet: 00670a4d-fd8a-4e77-99b3-0e89bc745cfb
Sheet: 5 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 |  |  |  |  |  | PERIOD 1 |  |  | PERIOD 2 |  |  | PERIOD 3 |  |  | PERIOD 4 |  |  | PERIOD 5 |  |  | TOTAL
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6515 | Subcontract 1 < $25K
6520 | Subcontract 1 > $25K
6515 | Subcontract 2 < $25K
6520 | Subcontract 2 > $25K
6515 | Total Sub < $25K
6520 | Total Sub > $25K
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)
 | TOTAL DIRECT COSTS: MU (Includes Subs I/C)
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
 |  |  |  |  | F&A for Subcontracts
 |  |  |  |  | #1
 |  |  |  |  | #2
Spreadsheet: 161326d1339499033-updating-a-mirror-list-with-new-rows-updatingrowsinlist
Sheet: Customer prices

 | Car |  | Show PL -> | 2
a | Estate |  |  | 110
b | Sporty |  |  | 150
 | Color
r | red |  |  | 38
w | white |  |  | 40
b | blue |  |  | 40
 | Engine
1 | 1,8l |  |  | 27
2 | 2,2l |  |  | 25
3 | 2,5l TD |  |  | 30
 | Options
s | sun roof |  |  | 10
c | cup holder |  |  | 5
Spreadsheet: 112738d1308757599-datedif-calculation-based-on-cell-contents-datedif_daddy
Sheet: Sheet1

Date Product Installed | Time in Service | Date: |  | Out of Service
2000-01-01 00:00:00 |  |  |  |  |  |  | We put widgets into service and then remove them from service.  I would like each cell in Column A to tell me for how long in Years and Months (maybe days, too) the widget has been in service or WAS in service if it's been removed.  If it's now Out of Service, it should add "(OOS)" to the Time in Service calculation as shown in B3.  All of the above is accomplished in B3.  I would like to combine that functionality with that found in B2 -- which is, if the time in service is less than a full year, "0 Years" won't show up at all.  It will ONLY display the months.  And if a full month has not been the time frame then "0 Months" won't even show up.  That is already accomplished in B2.  B3 will show 0 Years, 0 Months, x days and I don't want that long string of text for something that has only been in service 1 day.
2005-06-06 00:00:00 |  |  |  | 2006-06-08 00:00:00
2010-06-07 00:00:00
2010-12-16 00:00:00 |  |  |  | 2011-03-28 00:00:00
2009-05-04 00:00:00 |  |  |  | 2009-06-09 00:00:00
2009-07-01 00:00:00 |  |  |  | 2010-01-01 00:00:00
2010-01-23 00:00:00
2009-07-31 00:00:00
2010-10-23 00:00:00 |  |  |  | 2011-08-22 00:00:00
2009-02-19 00:00:00 |  |  |  | 2009-04-19 00:00:00
2010-02-28 00:00:00 |  |  |  | 2010-03-08 00:00:00
2010-03-07 00:00:00 |  |  |  | 2010-12-12 00:00:00
2009-11-22 00:00:00 |  |  |  | 2010-02-17 00:00:00
2008-11-06 00:00:00 |  |  |  | 2009-06-15 00:00:00
2010-05-17 00:00:00
2011-01-17 00:00:00
2010-05-17 00:00:00 |  |  |  | 2010-05-25 00:00:00
Spreadsheet: 694987d1599934263-sumproduct-formula-test-1-
Sheet: Rank & Points

Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum | Players | Game |  | Bonus Points | Sum
 | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players |  |  |  |  | Players
 | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Rank | Base Points |  |  |  | Expected Result
Spreadsheet: 880329d1727964090-trying-to-create-an-excel-doc-thatll-allow-me-to-schedule-people-on-projects-availability
Sheet: Helper

Date | Sky | Nia | [NAME]
2024-09-30
2024-10-07
2024-10-14
2024-10-21
2024-10-28
2024-11-04
2024-11-11
2024-11-18
2024-11-25
2024-12-02
2024-12-09
2024-12-16
2024-12-23
2024-12-30
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet1

Summing a range that contains error values
Total | Number | Per Unit
80 | 10
120 | 6
144 | 12
100 | 20
50 | 5
TOTAL:
 |  |  | <-- SUM, excluding errors
 |  |  | <-- Compatible with pre-Excel 2007
 |  |  | <-- Uses new AGGREGATE function
Spreadsheet: 837798d1690445131-want-to-extract-a-data-from-two-sheets-by-comparing-column-values-cars-1-
Sheet: Sheet1

License plate | Serial Number | Description | ManufSerialNo.
IN 04000 | 16976845 | TOYOTA,Hilux,DC Pickup,Diesel,LHD,4x4 | AHTFK22G303045687
IN 04503 | 16971780 | TOYOTA,Prado,GP,Diesel,LHD,4x4 | [NAME]
IN 04500 | 16971781 | TOYOTA,Prado,GP,Diesel,LHD,4x4 | JTEBD9FJ90K002282 | 69579.3
IN 04506 | 16971782 | TOYOTA,Prado,GP,Diesel,LHD,4x4 | JTEBD9FJ10K002177
IN 04035 | 16955713 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | [NAME] | 45650.8
IN 04033 | 16955715 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW285282 | 59569.5
IN 04032 | 16955716 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW285209 | 41728.4
IN 04031 | 16955717 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW285127 | 32924
IN 04029 | 16955719 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW284956 | 54534.7
IN 04027 | 16955721 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW284823 | 58261.3
IN 04022 | 16955722 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW280626 | 48352.6
IN 04025 | 16955723 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW284563 | 44924.5
IN 04023 | 16955725 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW284449 | 51989
IN 04026 | 16955726 | FORD,Ranger,DC Pickup,Diesel,LHD,4x2 | MNCLMFE00FW2804760 | 31714.3
IN 03781 | 16955768 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587387 | 40169.6
IN 03787 | 16955769 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587393 | 55291.5
IN 03780 | 16955789 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587386 | 41538.3
IN 03790 | 16955794 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587396 | 40655
IN 03797 | 16955807 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587403 | 97869.9
IN 03727 | 16955839 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587326 | 62477.1
IN 03722 | 16955864 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587320 | 43614.4
IN 03684 | 16955873 | NISSAN,Patrol,GP,Diesel,LHD,4x4 | JN1TCSY61Z0587274 | 46026.2
IN 04076 | 16955602 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324226 | 53744.5
IN 04079 | 16955605 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324281 | 31383.6
IN 04083 | 16955609 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324341 | 61423
IN 04092 | 16955618 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324754 | 50862
IN 04093 | 16955619 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324795 | 64283.1
IN 04095 | 16955621 | FORD,Ranger,DC Pickup,Diesel,LHD,4x4 | MNCLMFF00FW324890 | 43668.1
Spreadsheet: 222774d1363936938-need-help-with-formula-to-sort-data-into-multiple-columns-vba-sample
Sheet: Sort

Name | ID | Address | Barangay | Illiteracy - Disability | Birthdate | Sex
ABARIENTOS, MABEL JEAN SORRO | 1102-0001A-K1394MSA200006 | BONIFACIO STREET, A. | [NAME] (ABCR) |  | 11/13/1994 | F
ALAMON, DOLORES DIZON | 1102-0001A-C2361DDA200007 | [NAME], A. | [NAME] (ABCR) |  | 3/23/1961 | F
AMBUCAY, RITCHIE BUNIEL | 1102-0001A-K1087RBA100003 | 177 BONIFACIO ST., A. | [NAME] (ABCR) |  | 11/10/1987 | M
ANCHETA, [NAME] | 1102-0001A-B1394MAA100008 | 8D CAGUIOA ST., A. | [NAME] (ABCR) |  | 2/13/1994 | M
ANDEN, MA-ANNE RUSSEL NARTATES | 1102-0001A-I1983MNA20000 | 28 CAGUIOA ROAD ABCR BRGY. BAGUIO | [NAME] (ABCR) |  | 9/19/1983 | F
ANDEN, RUSSEL OWENS NARTATES | 1102-0001A-I1079RNA20000 | 28 CAGUIOA ROAD ABCR BRGY. BAGUIO | [NAME] (ABCR) |  | 9/10/1979 | F
ANG, ELENA LAMEN | 1102-0001A-J2457ELA200001 | 12 BONIFACIO ST., A. | [NAME] (ABCR) |  | 10/24/1957 | F
ANG, LELY GO | 1102-0001A-L0952LGA20000 | 12 BONIFACIO ST.  BAGUIO CIT, A. | [NAME] (ABCR) |  | 12/9/1952 | F
ANG, LESTER GO | 1102-0001A-H1579LGA10000 | 12 BONIFACIO ST.  BAGUIO CIT, A. | [NAME] (ABCR) |  | 8/15/1979 | M
ANYAYAHAN, [NAME] | 1102-0001A-F2594ETA200002 | 199 UPPER BONIFACIO ST., A. | [NAME] (ABCR) |  | 6/25/1994 | F
ANYAYAHAN, [NAME] | 1102-0001A-F2693ETA200005 | 199 UPPER BONIFACIO STREET, A. | [NAME] (ABCR) |  | 6/26/1993 | F
ANYAYAHAN, EUSEBIO ESCABILLAS | 1102-0001A-L1668EEA10000 | 73-A BONIFACIO ST.  BAGUIO CITY, | [NAME] (ABCR) |  | 12/16/1968 | M
ANYAYAHAN, WILMA TALAVERA | 1102-0001A-F0860WTA20000 | 73-A BONIFACIO ST.  BAGUIO CIT, A. | [NAME] (ABCR) |  | 6/8/1960 | F
AQUINO, [NAME] | 1102-0001A-G2888MOA200002 | # 12 ABCR CORNER, A. | [NAME] (ABCR) |  | 7/28/1988 | F
ASTUDILLO, LEOPOLDO FENULLAR | 1102-0001A-I0257LFA10000 | 30 CAGUIOA ST.  BAGUIO CITY, A. | [NAME] (ABCR) |  | 9/2/1957 | M
ASTUDILLO, MA. THERESA BURBANO | 1102-0001A-K2176MBA20000 | 30 CAGUIOA ST. ABCR BRGY. BAGUIO | [NAME] (ABCR) |  | 11/21/1976 | F
AZURA, PRINCESS WAILEY ECHAVEZ | 1102-0001A-L0194PEA200005 | ASSUMPTION ROAD, A. | [NAME] (ABCR) |  | 12/1/1994 | F
BACALI, CYNTHIA DIMALNAT | 1102-0001A-L2984CDB200001 | 149 A. BONIFACIO ST, A. | [NAME] (ABCR) |  | 12/29/1984 | F
BALORO, MAFF ABOGADO | 1102-0001A-L0990MAB200002 | 65 BONIFACIO ST., A. | [NAME] (ABCR) |  | 12/9/1990 | F
BAN-EG, JANICE MASLIYAN | 1102-0001A-H0480JMB20000 | 32 CAGUIOA ST  ABCR BRGY. BAGUIO | [NAME] (ABCR) |  | 8/4/1980 | F
BAN-EG, JOSEPHINE MASLIAN | 1102-0001A-B2155JMB20000 | 32 CAGUIOA ST.  BAGUIO CIT, A. | [NAME] (ABCR) |  | 2/21/1955 | F
BAN-EG, NORBERTO DAGIW-A | 1102-0001A-F2849NDB100002 | #32 INTERIOR CAGUIO ROAD, A. | [NAME] (ABCR) |  | 6/28/1949 | M