tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 114493d1310204947-count-value-with-multiple-condition-copy-of-copy-of-count-value-dumy
Sheet: Sheet1

 | Working Perfectly
 |  | Type | Value |  |  |  |  |  | Name | Order no. | Value
 |  | A | 45 |  |  |  |  |  | [NAME] | 000-G-000 | 20
 |  | A | 18 |  |  |  |  |  | George | 111-A-111 | 25
 |  | A | 15 |  |  |  |  |  | [NAME] | 000-G-020 | 15
 |  | B | 50 |  |  |  |  |  | George | 111-A-112 | 18
 |  | B | 25 |  |  |  |  |  | [NAME] | 102-F-101 | 25
 |  | B | 30 |  |  |  |  |  | George | 111-A-113 | 30
 |  | C | 35 |  |  |  |  |  | [NAME] | 000-G-020 | 30
 |  | C | 55 |  |  |  |  |  | George | 111-A-112 | 35
 |  | C | 20 |  |  |  |  |  | [NAME] | 000-G-020 | 20
 | I would like to count the value if Type is "A" & Value is >=20 and in another column  count value if Type is "A" and value is greater than 30 but less than 40. |  |  |  |  |  |  |  | I would like to count no. of unique order no. for [NAME], [NAME] and Anthony
 |  | Type | Value >20 | Value >30 & < 40 |  |  |  |  |  | Type | No. of order
 |  | A | 1 | 0 |  |  |  |  |  | [NAME] | 4 | count K column if matched with column J
 |  | B | 3 | 0 |  |  |  |  |  | George | 4 | I need to count unique value.
 |  | C | 2 | 1 |  |  |  |  |  | [NAME] | 1 | Ex: [NAME] has total 2 unique order thou
 |  |  |  |  |  |  |  |  |  |  |  | 000-G-020 is repeated 3 times
Spreadsheet: 814458d1674408998-help-to-formula-seperate-full-name-kampseddel_2023_5-ny-aktiv-form-formula-help
Sheet: Kampseddel

 | KAMPSEDDEL - DANSK DART UNION
 |  |  |  |  | Kamp nr. |  |  |  |  |  |  |  |  | Hj.hold |  |  |  |  |  |  |  | Resultat
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Ude hold
 |  |  |  |  | Kamp dato |  |  |  |  |  |  |  |  | Start |  |  |  | Slut
 |  | Spillenavn |  |  |  |  |  |  | [NAME] |  | [NAME] |  |  | [NAME] |  |  | Tabte Sæt |  |  | Antal 180 |  |  | [NAME] |  |  | [NAME]
 | Hjemmehold | 1 | [NAME] |  |  |  |  |  | 32221
 |  | 2 | [NAME]
 |  | 3 | [NAME]
 |  | 4 | [NAME]
 | Udehold | A | jesper Petersen
 |  | B | [NAME]
 |  | C | [NAME]
 |  | D | [NAME]
 | Navn |  |  | a | Rest | Antal dart | Lukket fra | Lukket fra | Antal dart | Rest | a | Navn |  |  | Navn |  |  | a | Rest | Antal dart | Lukket fra | Lukket fra | Antal dart | Rest | a | Navn
Kamp 1 | 1 |  |  |  |  |  |  |  |  |  |  | B |  |  | 4 |  |  |  |  |  |  |  |  |  |  | D |  |  | Kamp 9
Kamp 2 | 2 |  |  |  |  |  |  |  |  |  |  | A |  |  | 1 |  |  |  |  |  |  |  |  |  |  | A |  |  | Kamp 10
Kamp 3 | 3 |  |  |  |  |  |  |  |  |  |  | D |  |  | 2 |  |  |  |  |  |  |  |  |  |  | C |  |  | Kamp 11
Kamp 4 | 4 |  |  |  |  |  |  |  |  |  |  | C |  |  | 3 |  |  |  |  |  |  |  |  |  |  | B |  |  | Kamp 12
Kamp 5 | 2 |  |  |  |  |  |  |  |  |  |  | B |  |  | 1 |  |  |  |  |  |  |  |  |  |  | C |  |  | Kamp 13
Kamp 6 | 1 |  |  |  |  |  |  |  |  |  |  | D |  |  | 2 |  |  |  |  |  |  |  |  |  |  | D |  |  | Kamp 14
Kamp 7 | 4 |  |  |  |  |  |  |  |  |  |  | A |  |  | 3 |  |  |  |  |  |  |  |  |  |  | A |  |  | Kamp 15
Kamp 8 | 3 |  |  |  |  |  |  |  |  |  |  | C |  |  | 4 |  |  |  |  |  |  |  |  |  |  | B |  |  | Kamp 16
 | Underskrift
 | Hjemmehold |  |  |  |  |  |  |  |  |  |  |  |  |  | Udehold
Spreadsheet: 156005d1337135523-excel-2007-semi-random-list-no-duplicates-planetary-sample
Sheet: Sheet11

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Primary Star Orbit Occlusion |  |  | K | <This is the star type. It is usually randomly generated from VLOOKUP tables.
 |  |  | Ia | <For simplicity's sake, I've just assigned the value K Ia for this example.
 | Ia | Ib | II | III | Other
O | 4 | 1 | 0 | 0 | -1 |  | Largest Orbit Occluded
B | 4 | 1 | 0 | 0 | -1
A | 5 | 2 | 0 | 0 | -1
F | 6 | 3 | 0 | 0 | -1
G | 7 | 4 | 1 | 0 | -1
K | 8 | 5 | 2 | 2 | -1
M | 9 | 6 | 3 | 5 | -1
Main Planet (HZ) Orbit |  |  | <This info is normally generated according to the size of the star, via a VLOOKUP table.
12 |  |  | <For simplicity, in this example sheet, it's just 12)
Planetary Data
Orbit | Size | Water | Atmosphere
 | 5 | 7 | 7 | <Main World - Its orbit is set by the data in A33.
2 | 3 | 0 | 1 | <Other worlds - There are a random number of additional worlds, from 0 to 18, possible.
10 | 8 | 8 | 8 | <They are assigned a type, and then an orbit for that type, via random numbers and VLOOKUP tables.
10 | 6 | 3 | 0 | <For simplicity's sake, I have skipped the lookups and written out some data here.
14 | 1 | 2 | 4 | <My spreadsheet already determines the number of worlds, their data, and orbit and
10 | 9 | 1 | 9 | <presents them in an unordered list. I can export this to Word or similar and manually assign
13 | 4 | 4 | 4 | <orbits, but would rather have Excel do it for me, if possible.
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Sept

 | TLR Max Level | Number of Incidents
 | 1 | 26
 | 2a | 28
 | 2b | 3
 | 2c | 2
 | 3 | 9
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-09-08 00:00:00 | 3 | 12 | MAIN | 10:10:00 | 18:10:00
1 | 1999-09-09 00:00:00 | 3 | 81 | AEP | 05:34:00 | 23:37:00
1 | 1999-09-09 00:00:00 | 3 | 24 | MAIN | 07:56:00 | 19:30:00
1 | 1999-09-16 00:00:00 | 3 | 374 | MAIN | 11:04:00 | 20:07:00
1 | 1999-09-20 00:00:00 | 3 | 402 | SPP | 14:00:00 | 22:00:00
1 | 1999-09-27 00:00:00 | 3 | 100 | MAPP | 08:30:00 | 22:00:00
1 | 1999-09-29 00:00:00 | 3 | 105 | AEP | 05:14:00 | 09:03:00
Spreadsheet: 0a39ef43-c72c-4cea-b2b8-b617c529d15a
Sheet: Ancillary Items

 | Various Consumables
UOM | [NAME] | PART NUMBER | PRICE
EA | [NAME] | NPJ131 | 0.39
EA | [NAME] White | NPJ13W | 0.39
EA | [NAME] | 430G | 36.04
RL | [NAME] | WP1800P/3000FT | 182.75
EA | Fire Stop Putty | SSP100 | 23.17
EA | 15' Velcro Roll | 43115-15 | 14.61
EA | 75' Velcro Roll | 189755 | 25.74
EA | B-Line 10' slot channel unistrut | P1100T-10PG | 15.62
EA | Brother P-Touch Tape | M21-500-595-WT | 32.24
EA | [NAME] screw cover box | ASE12X12X8 | 30.99
EA | PLP Mini-moray shield connector | 8000751 | 5.01
EA | 8' ground rod (10 mil) | 615880 | 17.16
BG | 11" Zip Ties | CC7-1150-9 | 5.15
BG | 7" Zip Ties | CC7-750-9 | 2.89
BX | Saddle Clamps TM3S10-C | TM3S10-C 100CT | 67.65
BX | Anchor Kit | PSA1K | 36.48
TB | Fire Stop Caulk | SSS100 | 12.34
EA | [NAME] (1" or 1 1/2") | 4BRT32 | 1.42
EA | Beam Clamp | BC | 0.94
EA | Innerduct (1" or 1 1/2") | CH4X1C-CUT  (FT) | 3.91
EA | 13' Comm Pole | 25DTC-415 | 238.7
EA | 12' Comm Pole | 25DTC-412 | 214.5
EA | 11' Power Pole | 25DTC-413 | 214.5
EA | 10' Comm Pole | 25DTC-4 | 176
EA | Tool Pouch | 11293400 | 55
EA | Palm Guard | 47615-PTT | 5.12
EA | [NAME] | CST200 (25PK) | 72.6
EA | [NAME] (metal) | TP588 | 1.38
EA | Outside Electrical Box | A12R126 | 45.1
FT | Coaxial cable (per foot) | [NAME] | 0.13
Spreadsheet: 475743d1471445803-multiple-data-sets-to-graph-help-with-graphing
Sheet: New % on Time

 | Group | June | July | Total Cases June | Total Cases July | Goal
 | Canada | 0.9940476190476191 | 1 | 46 | 164 | 0.9
 | Regional | 0.9315707620528771 | 0.8315585672797676 | 643 | 425 | 0.9
 | FAS | 0.8306104901117799 | 0.8002466091245376 | 1163 | 1033 | 0.9
 | National | 0.7793326157158235 | 0.8 | 929 | 811 | 0.9
 | CIT | 0.4285714285714285 | 0.25 | 28 | 8 | 0.9
Spreadsheet: 00c6d02f-6d88-4e59-9cb5-de66d6ef129e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Change4Life Sports Club - Primary Resources
 | Designer/Supplier | Units | Approx Cost | Timescales | Budget Code | Other Information
Equipment Bags |  | 4500
Filming |  | 2
CD Roms |  | 9000
Activity Cards |  | 4500
LogBooks |  | 90000
WorkBooks |  | 9000
Wristbands |  | 90000
Branding Packs |  | 4500
Spreadsheet: 74528d1275019401-removing-a-legend-entry-on-a-chart-optional-series
Sheet: Sheet1

 | Chart Data |  |  |  |  |  | Working
 | Yes | No | Yes | Dropdowns in yes no cells |  |  |  | Yes | No
 | A | #N/A | C
 | 50 | #N/A | 54 |  |  |  | 50 | 56 | 54
 | 55 | #N/A | 56 |  |  |  | 55 | 23 | 56
 | 60 | #N/A | 36 |  |  |  | 60 | 12 | 36
 | 45 | #N/A | 44 |  |  |  | 45 | 15 | 44
 |  |  |  |  |  |  | I don't want the B to be displayed if the no option is selected
Spreadsheet: 134216d1325095643-nested-if-statement-lender-pricing-worksheet
Sheet: Sheet1

Loan Amounts |  | Risk Rating | Rate | Yes or No
0 | 50000 | 1
0 | 50000 | 2
0 | 50000 | 3
0 | 50000 | 4
0 | 50000 | 5
0 | 50000 | 6
50001 | 150000 | 1
50001 | 150000 | 2
50001 | 150000 | 3
50001 | 150000 | 4
50001 | 150000 | 5
50001 | 150000 | 6
150001 | 500000
500001 | 1001000
1001001 | 2501000
2501001
Spreadsheet: 882806d1731279690-distribute-students-evenly-and-only-once-in-repeating-sessions-according-to-wishes-wishes-reading-day-norwegianteacher-
Sheet: Round 3

11.30 - 12.10
name | grade | which wish |  | ID | name | grade | which wish
Spreadsheet: 01b44826-1258-4f95-b396-36c481dc1b39
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
(Program Feature)
TROOP MEETING PLAN
 | Date |  |  |  | Week
ACTIVITY |  | [NAME] |  |  |  |  | RUN BY | TIME
Preopening
 | Minutes
Opening Ceremony
 | Minutes
Skills Instruction
 | Minutes
Patrol Meetings
 | Minutes
Interpatrol Activity
 | Minutes
Closing |  | Scoutmaster's Minute |  |  |  |  | SM
 | Minutes
(Total 90 minutes)
After the Meeting
Spreadsheet: 766912d1644164527-problem-regarding-building-a-portfolio-sheet-1portfolio-tracker
Sheet: All Positions

 | Position Tracking
 | Cash and Equivalents |  |  |  |  |  | Equities
 | Stablecoins are auto-filled from '[NAME] tab; don't edit |  |  |  |  |  | Input individual holdings or lump totals per account
 | Source |  |  | $ |  |  | Source |  |  | $
 | Bank Account(s) |  |  | 3000 |  |  | Brokerage |  |  | 15000
 | Stablecoins |  |  |  |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | Total |  |  |  |  |  | Total
 | Real Estate |  |  |  |  |  | Crypto
 | Only equity that you've established |  |  |  |  |  | This is auto-populated from '[NAME] tab; don't edit
 | Source |  |  | $ |  |  | Source |  |  | $
 | Equity in Home |  |  | 40000 |  |  | Net Position (Exluding Stablecoins)
 | REIT |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  | Total |  |  |  |  |  | Total
 | Commodities
 | Metals, materials, agriculture, etc.
 | Source |  |  | $ |  |  | Source |  |  | $
 | Gold |  |  | 10000 |  |  |  |  |  | 0
 | Silver |  |  | 5000 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | Total |  |  |  |  |  | Total
 | Source |  |  | $ |  |  | Source |  |  | $
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | Total |  |  |  |  |  | Total
Spreadsheet: 102942d1300819223-excel-formula-just-in-time-system-book1
Sheet: Sheet1

 |  |  | Paddington
 |  |  | Dr | Cr
Opening stock |  |  | 100
Date | Invoice No. | Account
2011-04-01 00:00:00 | 181532 | Myrt | 40
2011-04-02 00:00:00 | 52665 | Mood |  | 130
2011-04-11 00:00:00 | 154564sa | Ridd | 10
2011-04-12 00:00:00 | 51dsa | Myrt |  | 30
2011-04-13 00:00:00 | ef55e | Snap |  | 100
Spreadsheet: 789760d1659354549-need-help-with-tax-tables-tax-sample
Sheet: Sheet2

0 - 50 000 | Not taxable
50 0001 - 100 000 | 18% for each N$ above 50 000
100 001 - 300 000 | 9 000 + 25% for each N$ above 100 000
300 001 - 500 000 | 59 000 + 28% for each N$ above 300 000
500 001 - 800 000 | 115 000 + 30% for each N$ above 500 000
801 001 - 1 500 000 | 205 000 + 32% for each N$ above 800 000
Above 1 500 000 | 429 000 + 37% for each N$ above 1 500 000
 |  |  |  |  | 25572.58
 |  |  |  |  | 7541.04
 |  |  |  |  | 1156
 |  |  |  |  | 1790.08
 |  |  |  |  | Tax table | 300000
 |  |  |  |  |  |  | x | 0.28
 |  |  |  |  |  | 59000
Spreadsheet: 085bc641-66a1-48f2-a0ef-528a21d9c9fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Office of School Finance
SF-14 Per Diem Certification
School Age Form
Report to Certify the Per Diem Rate for Nonhandicapped School-Age Pupils
Who Were Provided Instructional Services and any Related Services
To Be Filed by the Educating District pursuant to 3313.64(C)(4) for school year 2013-2014
Section I:  Identifying Information
A.
 | IRN |  | Educating District - City, Exempted Village, Local |  |  |  |  |  |  | County
B. | July through December
 | January through June
C. | Is the required contract for educational services between the educating district and the residential facility attached in accordance
 | with Section 3313.64(C)(4) |  | Yes |  | No |  | (If marked No, be sure to read instructions before continuing)
D. | Enter contract per diem amount plus service fee
 | (Be sure to read this line of instructions before continuing)
Section II:  Salaries and Benefits
E. | Instructional Salaries and Benefits
Section III:  General Student Costs
F. | Instructional Supplies and Materials
G. | Instructional Equipment
H. | Administrative Costs
I. | Staff Support Costs
J. | Pupil Support Costs
K. | Operations Support Costs
Section IV:  Per Diem Calculation
L. | Total Line E through K |  |  |  |  |  | ÷ |  |  | =
 |  |  |  |  |  |  |  | Aggregate Days |  |  | Daily Per Diem Rate
Superintendent Signature - City, Exempted Village, Local |  |  |  |  |  |  |  | Treasurer
Spreadsheet: 855580d1705097244-dispaying-names-based-on-ranking-scores-from-another-sheet-champ-scoring
Sheet: Day 1 Top 10

CLUB CHAMPIONSHIP DAY 1
 | CATEGORY | [NAME] |  |  |  | CATEGORY | [NAME]
 | MEN'S GROSS |  | GROSS |  |  | MEN'S NET | OLYMPIC VIEW | NET
RANK | LAST | FIRST | SCORE |  | RANK | LAST | FIRST | SCORE
1
Spreadsheet: 57c14e08-7009-4335-817f-7b572625e0ac
Sheet: FY 2005-2006 Summary

USRC AWARDS SUMMARY FY 2005-2006
Month | Year | Proposals | Awards | % Funding | Amount Requested | Amount Awarded
May | 2005 | 10 | 10 |  | 13807.94 | 12620
September | 2005 | 8 | 7 |  | 9592 | 9300
October | 2005 | 9 | 3 |  | 24700 | 3500
November | 2005 | 13 | 10 |  | 14254.88 | 11293
December | 2005 | 13 | 12 |  | 12372 | 11662
February | 2006 | 24 | 18 |  | 25892.38 | 18869
March | 2006 | 36 | 26
SUMMARY
 | TOTAL AWARDS BY COLLEGE FOR FY 2005-2006
 | College/Academic Unit |  |  | # Proposals | # Awards | Amount Awarded
 | Business and Information Technology |  |  | 17 | 12 | 12000
 | Education and Educational Technology |  |  | 18 | 13 | 10722
 | Fine Arts |  |  | 9 | 7 | 8305
 | Health and Human Services |  |  | 12 | 8 | 7120
 | Humanities and Social Sciences |  |  | 32 | 26 | 24074
 | Natural Sciences and Mathematics |  |  | 21 | 18 | 22358
 | University Services |  |  | 4 | 2 | 1441
 | Totals
 | TOTAL AWARDS BY CATEGORY BY 2005-2006 YEAR
 | # | Category Description |  | # Proposals | # Awards | Amount Awarded
 | 1 | Coop. Pgms with Industry/Community |  | 0 | 0 | 0
 | 2 | Small Research Grants |  | 20 | 12 | 16105
 | 3 | Innovative Teaching Projects |  | 3 | 3 | 4500
 | 4 | To Present Papers at Int'l Meetings |  | 36 | 29 | 39919
 | 5 | Student/Faculty Research Awards |  | 6 | 4 | 4347
 | 6 | New Investigator Awards |  | 6 | 4 | 5975
 | 7 | Domestic Travel |  | 42 | 34 | 15174
 | Totals
Spreadsheet: 09c534ec-9561-4a73-981d-ae619512ba38
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2012-11-06 00:00:00 | State Senate District 12
 | [NAME], r | [NAME], d | [NAME]
Brookline | 1405 | 1362 | 2
Greenville | 403 | 477
Hollis | 2357 | 2531 | 13
Mason | 453 | 344
[NAME] | 2217 | 2930 | 5
[NAME] | 1831 | 2610 | 1
[NAME] | 2201 | 2854 | 1
New Ipswich | 1598 | 812 | 1
Rindge | 1636 | 1325 | 4
Totals | 14101 | 15245 | 27
 | State Senate District 13
 | [NAME], r | [NAME], d | [NAME]
[NAME] | 1511 | 2500 | 4
[NAME] | 774 | 2186 | 1
[NAME] | 1226 | 2620 | 5
[NAME] | 1246 | 2517 | 8
[NAME] | 1653 | 2737 | 3
[NAME] 9 | 1814 | 2754 | 8
Totals | 8224 | 15314 | 29
 | State Senate District 14
 | [NAME], r | [NAME], d | [NAME], [NAME] | [NAME]
Auburn | 1709 | 1081 | 137
Hudson | 5451 | 4689 | 776 | 9
[NAME] | 6541 | 4696 | 553 | 12
Totals | 13701 | 10466 | 1466 | 21
 | State Senate District 15
 | [NAME], r | [NAME], d | [NAME]
Concord Ward 1 | 626 | 1631 | 2
Concord Ward 2 | 588 | 1296 | 2
Concord Ward 3 | 413 | 1105 | 3
Concord Ward 4 | 477 | 1402
Concord Ward 5 | 592 | 1821 | 2
Concord Ward 6 | 460 | 1285 | 7
Concord Ward 7 | 607 | 1795
Concord Ward 8 | 542 | 1299
Concord Ward 9 | 576 | 1245
Concord Ward 10 | 866 | 1727 | 3
Henniker | 882 | 1433 | 2
[NAME] | 1152 | 2421 | 1
Warner | 601 | 925 | 2
Totals | 8382 | 19385 | 24
Spreadsheet: 186685d1350149471-help-merging-two-excel-together-report
Sheet: Sheet1

ItemCode | ItemCodeDesc | ItemType | SalesOrderNo | WarehouseCode | PromiseDate | QuantityOrdered | XS 30 | S 32 | M 34 | L 36 | XL 38 | XXL 40 | XXXL
90351 | MN O2 Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 17 |  | 3 | 6 | 6 | 1 | 1
90352 | WN O2 Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 5 |  | 1 | 2 | 2
90535 | MN Criterium Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 11 |  | 2 | 4 | 3 | 1 | 1
90536 | WN Criterium Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3 |  | 1 | 1 | 1
91183 | MN Pro_Mesh Jrsy Ferrari | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3 |  |  | 1 | 1 | 1
92455 | MN Undershort with pad | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 5 |  | 2 | 2 | 2 | 2 | 2
93185 | [NAME] BLK | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 5 |  |  |  | 2 | 2 | 1
93186 | WN Heatwave Jrsy BLK | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 6 |  | 1 | 1 | 1
93186 | WN Heatwave Jrsy Magenta | 1 | P250576 | PBW | 2013-02-15 00:00:00
93188 | WN Impulse Jersey | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3
93192 | WN [NAME] Ruby | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 4
93251 | MN Apex Jersey TI | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3
93253 | MN Sedona Jersey GREY | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3 |  |  | 1 | 1 | 1 | 1
93255 | MN Assault Jersey BLK | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 4 |  |  |  | 1 | 1
93255 | [NAME] | 1 | P250576 | PBW | 2013-02-15 00:00:00
93445 | MN Implant Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 6 |  |  | 1 | 1
93459 | MN Nemesis Short | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 5
99182 | WN Criterium Jrsy Emerald | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 3
99441 | [NAME] | 1 | P250576 | PBW | 2013-02-15 00:00:00 | 9 |  | 1 | 2 | 3 | 2 | 1
Spreadsheet: 772297d1647187706-lookup-and-find-the-last-2nd-3rd-or-the-nth-matching-value-in-excel-test
Sheet: Sheet1

Date | Name | Team | Points |  | Last |  |  |  | MIN | 3 | 2 | 1
2021-03-01 00:00:00 | [NAME] | MIN | 23 |  |  |  |  |  | [NAME] | 15 | 21
2021-03-01 00:00:00 | [NAME] | HOU | 15 |  |  |  |  |  | [NAME] | 19 | 30 | 21
2021-03-01 00:00:00 | [NAME] | MIN | 27 |  |  |  |  |  | [NAME] | 28 | 10 | 22
2021-03-01 00:00:00 | [NAME] | MIN | 15
2021-03-02 00:00:00 | [NAME] | MIN | 13
2021-03-02 00:00:00 | [NAME] | HOU | 22
2021-03-02 00:00:00 | [NAME] | MIN | 16
2021-03-02 00:00:00 | [NAME] | MIN | 0 |  |  |  |  |  | HOU | 3 | 2 | 1
2021-03-03 00:00:00 | [NAME] | MIN | 3 |  |  |  |  |  | [NAME] | 22 | 27 | 18
2021-03-03 00:00:00 | [NAME] | MIN | 31
2021-03-03 00:00:00 | [NAME] | HOU | 17
2021-03-03 00:00:00 | [NAME] | MIN | 0
2021-03-04 00:00:00 | [NAME] | MIN | 15 |  | 3
2021-03-04 00:00:00 | [NAME] | MIN | 19 |  | 3
2021-03-04 00:00:00 | [NAME] | HOU | 22 |  | 3
2021-03-04 00:00:00 | [NAME] | MIN | 28 |  | 3
2021-03-05 00:00:00 | [NAME] | MIN | 21 |  | 2
2021-03-05 00:00:00 | [NAME] | HOU | 27 |  | 2
2021-03-05 00:00:00 | [NAME] | MIN | 30 |  | 2
2021-03-05 00:00:00 | [NAME] | MIN | 10 |  | 2
2021-03-06 00:00:00 | [NAME] | HOU | 18 |  | 1
2021-03-06 00:00:00 | [NAME] | MIN | 21 |  | 1
2021-03-06 00:00:00 | [NAME] | MIN | 22 |  | 1
Spreadsheet: 777723d1650563853-serpentine-numbers-in-a-table-formula-serpentineformula_forum3
Sheet: Sheet2

Rows | 15
Columns | 23
Start | 1001
 | 1002 | 1003 | 1004 | 1005 | 1006 | 1007 | 1008 | 1009 | 1010 | 1011 | 1012 | 1013 | 1014 | 1015 | 1016 | 1017 | 1018 | 1019 | 1020 | 1021 | 1022 | 1023
1046 | 1045 | 1044 | 1043 | 1042 | 1041 | 1040 | 1039 | 1038 | 1037 | 1036 | 1035 | 1034 | 1033 | 1032 | 1031 | 1030 | 1029 | 1028 | 1027 | 1026 | 1025 | 1024
1047 | 1048 | 1049 | 1050 | 1051 | 1052 | 1053 | 1054 | 1055 | 1056 | 1057 | 1058 | 1059 | 1060 | 1061 | 1062 | 1063 | 1064 | 1065 | 1066 | 1067 | 1068 | 1069
1092 | 1091 | 1090 | 1089 | 1088 | 1087 | 1086 | 1085 | 1084 | 1083 | 1082 | 1081 | 1080 | 1079 | 1078 | 1077 | 1076 | 1075 | 1074 | 1073 | 1072 | 1071 | 1070
1093 | 1094 | 1095 | 1096 | 1097 | 1098 | 1099 | 1100 | 1101 | 1102 | 1103 | 1104 | 1105 | 1106 | 1107 | 1108 | 1109 | 1110 | 1111 | 1112 | 1113 | 1114 | 1115
1138 | 1137 | 1136 | 1135 | 1134 | 1133 | 1132 | 1131 | 1130 | 1129 | 1128 | 1127 | 1126 | 1125 | 1124 | 1123 | 1122 | 1121 | 1120 | 1119 | 1118 | 1117 | 1116
1139 | 1140 | 1141 | 1142 | 1143 | 1144 | 1145 | 1146 | 1147 | 1148 | 1149 | 1150 | 1151 | 1152 | 1153 | 1154 | 1155 | 1156 | 1157 | 1158 | 1159 | 1160 | 1161
1184 | 1183 | 1182 | 1181 | 1180 | 1179 | 1178 | 1177 | 1176 | 1175 | 1174 | 1173 | 1172 | 1171 | 1170 | 1169 | 1168 | 1167 | 1166 | 1165 | 1164 | 1163 | 1162
1185 | 1186 | 1187 | 1188 | 1189 | 1190 | 1191 | 1192 | 1193 | 1194 | 1195 | 1196 | 1197 | 1198 | 1199 | 1200 | 1201 | 1202 | 1203 | 1204 | 1205 | 1206 | 1207
1230 | 1229 | 1228 | 1227 | 1226 | 1225 | 1224 | 1223 | 1222 | 1221 | 1220 | 1219 | 1218 | 1217 | 1216 | 1215 | 1214 | 1213 | 1212 | 1211 | 1210 | 1209 | 1208
1231 | 1232 | 1233 | 1234 | 1235 | 1236 | 1237 | 1238 | 1239 | 1240 | 1241 | 1242 | 1243 | 1244 | 1245 | 1246 | 1247 | 1248 | 1249 | 1250 | 1251 | 1252 | 1253
1276 | 1275 | 1274 | 1273 | 1272 | 1271 | 1270 | 1269 | 1268 | 1267 | 1266 | 1265 | 1264 | 1263 | 1262 | 1261 | 1260 | 1259 | 1258 | 1257 | 1256 | 1255 | 1254
1277 | 1278 | 1279 | 1280 | 1281 | 1282 | 1283 | 1284 | 1285 | 1286 | 1287 | 1288 | 1289 | 1290 | 1291 | 1292 | 1293 | 1294 | 1295 | 1296 | 1297 | 1298 | 1299
1322 | 1321 | 1320 | 1319 | 1318 | 1317 | 1316 | 1315 | 1314 | 1313 | 1312 | 1311 | 1310 | 1309 | 1308 | 1307 | 1306 | 1305 | 1304 | 1303 | 1302 | 1301 | 1300
1323 | 1324 | 1325 | 1326 | 1327 | 1328 | 1329 | 1330 | 1331 | 1332 | 1333 | 1334 | 1335 | 1336 | 1337 | 1338 | 1339 | 1340 | 1341 | 1342 | 1343 | 1344 | 1345
Spreadsheet: 789328d1659038298-question-on-vlookup-etc-forumexample3
Sheet: Main Sheet

Name | Status | Directional | Report | Address | City | State | Zip | Country
Does Not matter | New | North | Comm AUSUM [BOP] | 678 Federal St | Paris | VA | 20130 |  | Would like County from Data sheet for this [NAME]
Does Not matter | New | North | Comm AUSUM [BOP] | 678-692 Federal St | Paris | VA | 20130
Does Not matter | New | North | Comm AUSUM [BOP] | 4970 Antioch Rd | Haymarket | VA | 20169
Does Not matter | New | North | Comm Farm | 1610 Delaplane Grade Rd | Upperville | VA | 20184
Does Not matter | New | North | Comm AUSUM [BOP] | 920 War Admiral St | [NAME] | VA | 20185
Does Not matter | New | North | Commercial EssentialVue Exterior Only | 4780 Northwestern Pike | Winchester | VA | 20187
Does Not matter | New | North | Commercial EssentialVue Exterior Only | 2578 Northwestern Pike | Winchester | VA | 20117
Does Not matter | New | North | [NAME] RiskVUE Interior High Value | 107 N [NAME] | Middleburg | VA | 20117
Does Not matter | New | North | [NAME] RiskVUE Interior High Value | 43133 Butterfly Way | Leesburg | VA | 20176