tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: MORROCO

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 51972d1251612377-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-697484_surfol
Sheet: Price List

Product | Type | 1 Size | 100 | 120 | 160 | 180
ABC | Bed |  | 250 | 275
ABC | Box |  | 150 | 175
ABC | Set |  | 400 | 450
ABC 2 | Bed |  | 300 | 350 | 400 | 450
ABC 2 | Box |  | 200 | 250 | 300 | 350
ABC 2 | Set |  | 500 | 600 | 700 | 800
Accessories | Pillow | 30
Accessories | Memory Pillow | 65
Accessories | Mattress Pad |  | 75 | 85 | 95 | 105
XYZ | Bed |  |  | 850 | 950 | 1050
XYZ | Box |  |  | 400 | 450 | 500
XYZ | Set |  |  | 1250 | 1400 | 1550
*** As you can see, each product has its different types. And each product with a certain type also has different size
I would like the dropdown list in the 'Invoice' workbook' in the '[NAME]' column to show ONLY the size available for
that particular product and type.
Spreadsheet: 85697d1285759591-automatic-sorting-by-price-wine-list-trial
Sheet: Under 50

wines under 50 | Price
Light and Aromatic Whites
[NAME], Napa Valley 2008 | 32
Grand Amis Pinot Grigio, Mokelumne River, Lodi 2008 | 32
L' Uvaggio di Giacomo Dry Moscato, Lodi  2008 | 32
[NAME]Russian River Ranches' Chard, Sonoma 2007 | 34
Domaine [NAME] Sparkling, California NV | 45
Smooth Whites
[NAME]'s Grove [NAME], 2008 | 32
[NAME], Lodi 2009 | 32
Lucas Chardonnay, Lodi  2006 | 36
Fruity & Delicate Reds
[NAME], [NAME]  2005 | 34
McCay Cellars '[NAME]' Red Wine, Lodi  2007 | 36
McCay Cellars 'Jupiter' Zinfandel, Lodi 2007 | 36
Mettler [NAME], Lodi  2006 | 38
M2 'Old Vine' Zinfandel, Lodi  2008 | 42
[NAME], Carneros  2007 | 45
[NAME] Cabernet Sauvignon, Napa Valley 2006 | 46
[NAME],  Napa Valley 2006 | 48
Full Bodied Reds
Ironstone Reserve [NAME], Sierra Foothills  2007 | 34
Borra Vineyards Merlot, Clements Hills, Lodi  2005 | 34
Grands [NAME] [NAME], Lodi  2004 | 35
Macchia Mischievous 'Old Vine' Zinfandel, Lodi  2008 | 40
[NAME]American Oak', Lodi 2007 | 40
[NAME], Napa Valley 2006 | 40
[NAME], Lodi  2007 | 40
Onus [NAME], Lodi 2005 | 40
[NAME], Sierra Foothills  2004 | 42
Mauritson Zinfandel, Dry Creek Valley  2005 | 46
Spreadsheet: 3d036fac-368f-4635-9e03-4fc68616ff21
Sheet: Credit Recovery & AP

Credit Recovery-Supplemental | 9 | 10 | 11 | 12 | Total
Yearly registrations
Yearly completionss
Total
Advanced Placement | 9 | 10 | 11 | 12 | Total
Course Registrations
Course Completions
AP Exams Completed
AP Exams Scores >3
Spreadsheet: 192373d1352390059-exact-all-text-except-last-2-characters-example-problem
Sheet: Sheet1

Customer | Line | Note | Stamp
12345 | 1 |  | 12345   112110615051400001
12345 | 1 |  | 12345   112110615051500001
12345 | 2 |  | 12345   112110615051500002
12345 | 3 |  | 12345   112110615051500003
2345621 | 1 |  | 2345621  112110609311200001
2345621 | 2 |  | 2345621  112110609311200002
564321 | 1 |  | 564321  112110609355700001
564321 | 1 |  | 564321  112110611464700001
564321 | 2 |  | 564321  112110611464700002
564321 | 3 |  | 564321  112110611464700003
564321 | 4 |  | 564321  112110611464700004
564321 | 5 |  | 564321  112110611464700005
564321 | 6 |  | 564321  112110611464700006
564321 | 7 |  | 564321  112110611464700007
564321 | 8 |  | 564321  112110611464700008
564321 | 9 |  | 564321  112110611464700009
564321 | 10 |  | 564321  112110611464700010
564321 | 11 |  | 564321  112110611464700011
564321 | 12 |  | 564321  112110611464700012
Spreadsheet: 197390d1354318005-how-to-determine-the-number-of-hours-and-minutes-between-a-start-time-and-an-end-time-timetable
Sheet: Sheet1

 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Time in (AM) | 09:15:00 | 10:05:00 | 09:00:00 | 09:00:00 | 08:30:00
 | Time Out (PM) | 05:30:00 | 08:30:00 | 06:00:00 | 02:30:00 | 07:00:00
 | Daily Time |  |  |  |  |  | Weekly Hours
 | Daily Hours (Hrs)
Spreadsheet: larry_may__21650__Balance Sheet0721
Sheet: Sheet3

Alabama | 1 |  | old
Arizona | 2 |  | CONSUMPTION |  | NOV | DEC | JAN | FEB | MAR
Arkansas | 3 |  | LAKES |  | 0.93 | 1.127 | 1.122 | 1.278 | 1.111
California | 4
Colorado | 5 |  | NORTHEAST |  | 0.93 | 1.06 | 1.178 | 1.119 | 1.102
Connecticut | 6
D.C. | 7 |  | GULFCOAST |  | 0.97 | 0.979 | 1.026 | 1.006 | 0.994
Delaware | 8
Florida | 9 |  | SOUTHEAST |  | 1.004 | 1.005 | 1.005 | 1.099 | 1.046
Georgia | 10
Idaho | 11 |  | MOUNTAIN |  | 0.918 | 0.969 | 1.094 | 1.086 | 0.956
Illinois | 12
Indiana | 13 |  | PACIFICNW |  | 0.985 | 0.981 | 0.875 | 0.897 | 0.916
Iowa | 14
Kansas | 15 |  | SOUTHCENTRAL |  | 0.957 | 0.985 | 0.986 | 0.983 | 1.054
Kentucky | 16
Louisiana | 17 |  | CALIFORNIA |  | 1.024 | 1.06 | 1.048 | 0.95 | 0.865
Maine | 18
Maryland | 19 |  | new
Massachusetts | 20 |  | CONSUMPTION |  | NOV | DEC | JAN | FEB | MAR
Michigan | 21 |  | LAKES |  | 0.88 | 1.057 | 1.047 | 1.277 | 1.06
Minnesota | 22
Mississippi | 23 |  | NORTHEAST |  | 0.915 | 1.054 | 1.097 | 1.118 | 1.083
Missouri | 24
Montana | 25 |  | GULFCOAST |  | 0.957 | 0.965 | 1.004 | 0.991 | 0.99
Nebraska | 26
Nevada | 27 |  | SOUTHEAST |  | 0.92 | 0.97 | 0.982 | 1 | 0.938
New Hampshire | 28
New Jersy | 29 |  | MOUNTAIN |  | 0.92 | 0.924 | 1.012 | 1.032 | 0.949
New Mexico | 30
New York | 31 |  | PACIFICNW |  | 1.18 | 1.078 | 1.116 | 1.224 | 1.172
North Carolina | 32
North Dakota | 33 |  | SOUTHCENTRAL |  | 0.946 | 0.962 | 0.972 | 1.056 | 0.946
Ohio | 34
Oklahoma | 35 |  | CALIFORNIA |  | 1.42 | 1.132 | 1.084 | 1.05 | 1.113
Oregon | 36
Pennsylvania | 37
Rhode Island | 38
South Carolina | 39
South Dakota | 40
Tennessee | 41
Texas | 42
Utah | 43
Vermont | 44
Virginia | 45
Washington | 46
West Virginia | 47
Wisconsin | 48
Wyoming | 49
Spreadsheet: 00c29aa8-b6b9-44e2-ab5f-e4d0f8f3238f
Sheet: UP

Place | Address | Contact Person / NO | Mutt | Other Places near by
AYODHYA | Madhwashrama, | Phone 05278 - 232 378. | [NAME] mutt | [NAME]
 | [NAME], [NAME], | Tel : 05278-232378, (Yogish-[PHONE] |  | [NAME] of Palimar mutt around 1378
 | Pramodavana, Ayodhya (U.P.) |  |  | [NAME] of Adamar mutt around 1378
 |  |  |  | [NAME] of [NAME] 1400
Prayaga | Sri Madhwa Matha | Shri [NAME] | Shri Palimaru Matha
(ALLAHABAD) | 63/59, [NAME], [NAME] | 0532 – 2504487
 | Allahabad – 211 006, Uttar Pradesh | Phone No: [PHONE]
 | PRAYAG | 0532 – 3217531
Prayaga | [NAME] | Phone No.: [PHONE] | [NAME]
(ALLAHABAD) | No. 77/98, [NAME],
 | [NAME],
 | Prayag - 211 006,
Prayaga |  | Venu achar | [NAME]
(ALLAHABAD) |  | mobile no - [PHONE]
Varanasi | Shri. Bhavuacharya Tonape | Phone No.one No. : [PHONE] | [NAME]
 | B-4/61, [NAME], | Shri Bahu Acharya Tonape
 | Dr. [NAME] Marg
 | Hanumanghat,
 | Varanasi - 221 001.
Varanasi | karnataka Bhavan, |  | Gov Of Karnataka
 | [NAME], Varanasi-221 001.
Varanasi | Shri Krishna Madhwashram | 0542 – 2310260 | [NAME]
 | Panchakosi Road, Assi Ghat | 098386 16375
 | Varanasi – 221 001, Uttar Pradesh | Cell:098386 15375, 097934 07403
 | KASHI
Varanasi | [NAME]
 |  |  |  | PALIMAR MUTT SAMBHAVA THEERTHA AND ADAMAR MUTT PONTIFF WHO ENTERED BRINDAVAN IN AYODHYA IN 14TH CENTURY
Spreadsheet: 32999d1229195192-center-wingding-checkmarks-xlsworkbook121520058
Sheet: Sheet1

 |  |  |  |  | ~TrdReference Master [NAME]...............................................................................
[NAME] |  | 30Day
 | Up | Down |  |  |  | Earnings
 |  | ü | $DXY(D) | U.S Dollar Index
ü |  | ü | $CRY(D) | Reuters/Jefferies CRB Index
 | Up | Down |  |  |  | Earnings
 | ü |  | $GOX.X | CBOE Gold Index
 | ü |  | $XAU | PHLX Gold And Silver Sector In
 | ü |  | ABX | [NAME] |  | 2009-02-19 00:00:00 | -68
 | ü |  | AU | Anglogold Ashanti Ltd
 | ü |  | GG | Goldcorp Inc
 | ü |  | NEM | Newmont Mining |  | 2009-02-19 00:00:00 | -68
0 | 0 | 0 | 6 |  |  |  | 0
 | Up | Down |  |  |  | Earnings
ü | ü |  | $OIX.X | CBOE Oil Index
ü | ü |  | XLE | S&P Sel Energy Spdr Fund
 | ü |  | ACI | [NAME] |  | 2009-02-02 00:00:00 | -51
 | ü |  | APA | Apache Corp |  | 2009-02-05 00:00:00 | -54
 | ü |  | APC | Anadarko Petroleum |  | 2009-02-04 00:00:00 | -53
 | ü |  | BP | British Petroleum |  | 2009-02-03 00:00:00 | -52
 | ü |  | CHK | [NAME] |  | 2009-02-19 00:00:00 | -68
 | ü |  | COP | ConocoPhillips |  | 2009-01-22 00:00:00 | -40
 | ü |  | CVX | Chevron Corporation |  | 2009-02-02 00:00:00 | -51
 | ü |  | DVN | [NAME] |  | 2009-01-26 00:00:00 | -44
 | ü |  | ECA | [NAME] |  | 2009-02-12 00:00:00 | -61
 |  | ü | HAL | [NAME] |  | 2009-01-26 00:00:00 | -44
 | ü |  | NUE | Nucor Corp |  | 2009-01-22 00:00:00 | -40
ü |  | ü | OIH | Oil Service HOLDRS
ü | ü |  | OXY | Occidental Petroleum |  | 2009-01-29 00:00:00 | -47
ü |  | ü | RIG | TransOcean Inc |  | 2009-02-19 00:00:00 | -68
 |  | ü | SLB | Schlumberger Ltd |  | 2009-01-20 00:00:00 | -38
ü |  | ü | STP | Suntech Power Holdings Co Ltd |  | 2009-02-20 00:00:00 | -69
ü |  | ü | UPL | Ulta Petroleum |  | 2009-02-19 00:00:00 | -68
 |  | ü | USO | United States Oil Fund LP
 | ü |  | VLO | [NAME] |  | 2009-01-29 00:00:00 | -47
 | ü |  | XOM | Exxon Mobil |  | 2009-02-02 00:00:00 | -51
0 | 0 | 0 | 22 |  |  |  | 0
Spreadsheet: 222332d1363816217-times-name-appears-given-a-condition-in-a-table-sample
Sheet: Report

Auditor Name: | Review Date: | Loan #: | Borrower name: | ,[NAME] | r,978r,9 | ,76r969 | ,9rr6, | 9797 | r56.6 | r9r76k68 | ouiouo | ouio | gdrghdgd | MI Name: | Comments
[NAME] | 2013-03-19 00:00:00 | 53643 | Smith | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] | gfd
[NAME] | 2013-03-19 00:00:00 | 3123 | Munster | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | [NAME] | gdfgd
[NAME] | 2013-03-19 00:00:00 | 12123 | Jones | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Eva | gdfgh
[NAME] | 2013-03-19 00:00:00 | 1212 | [NAME] | No | No | Yes | No | No | Yes | No | No | No | No | [NAME] | hgfhf
[NAME] | 2013-03-19 00:00:00 | 1212 | [NAME] | No | No | Yes | No | No | Yes | No | No | No | No | [NAME] | [NAME]
Spreadsheet: 274641d1383168212-function-vlookup-but-need-index-match-thorrrrrrrrrrr-example
Sheet: Sheet1

Products | Unit Cost | [NAME] | Vat % | Total Per Unit |  |  |  |  |  |  | [NAME] | [NAME]
Panasonic MP-BDT230EB | 84.99 | 2 |  |  |  |  |  |  |  |  | 2 | 0.2
Panasonic Wireless Speaker SC-NE3EBK | 139.99 | 1 |  |  |  |  |  |  |  |  | 3 | 0.15
LG Music in Style ND4520 | 79.97 | 3 |  |  |  |  |  |  |  |  | 1 | 0
Bosu | 64.99 | 2
Spreadsheet: 838178d1690807043-date-range-by-person-shown-another-sheet-by-person-in-a-grid-tasking
Sheet: Sheet7

[NAME] | Start Date | End Date | Date Range
Name 1 | 2023-06-12 00:00:00
name 4 | 2023-06-12 00:00:00
name 5 | 2023-06-12 00:00:00
name 2 | 2023-06-19 00:00:00 | 2023-06-22 00:00:00
name 3 | 2023-06-19 00:00:00 | 2023-06-22 00:00:00
name 2 | 2023-06-26 00:00:00 | 2023-06-30 00:00:00
name 2 | 2023-07-04 00:00:00 | 2023-07-06 00:00:00
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: volvalue

VOLUMETRIC IMBALANCES
Operator | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00
Mojave Pipeline | 75659 | 63393 | 41052 | 3829 | 26482 | 3949 | 133095 | 135803 | 151464 | 134900.51
SoCal | -42847 | -2392 | -1948 | 47976 | 39224 | -21565 | 123192 | 145102 | 151133 | 294649
PG&E Topock | 147492 | 59676 | 69410 | 93592 | 38770 | -10045 | -12760 | 24900 | 43542 | 73067
El Paso - Window Rock | -7121 | -7121 | -7121 | 23739 | 47545 | 47545 | 50521 | 64269 | 64269 | 64269
NGPL - Winkler | -32074 | -32074 | -25783 | -25783 | 19880 | 37616 | 72277 | 30271 | 12393 | 8222
NGPL - Gray | 81654 | 79650 | 30618 | 43969 | 37185 | 54911 | 120061 | 120061 | 127284 | 107975
Panhandle Eastern | 11018 | 12567 | 19121 | 30904 | 33216 | 27926 | 95102 | 76325 | 48988 | -29618
Oasis | 70928 | 24533 | 29886 | 22591 | 45729 | 1307 | 28278 | 34979 | 47553 | 58685
Lonestar | -7752 | 3487 | 3487 | 6729 | 54217 | 61895 | 69314 | 36339 | 73003 | 69880
TW average index |  | 8.21 | 5.62 | 4.98 | 4.87 | 3.82 | 3.2 | 2.77 | 2.77 | 1.88
[NAME] | -70145 | -44467 | -9747 | 30129 | 121747 | 278779 | 286331 | 310267 | 275390 | 230460
Amoco-Florida Plant | -55807 | -32211 | -38475 | -32230 | 82528 | 94855 | 59179 | 54883 | 87070 | 50022
El Paso - Blanco | 268892 | 198073 | 173680 | 168646 | 255346 | 300960 | 170528 | 27596 | -65974 | -75692
Northwest | -119838 | -60187 | 6957 | -37371 | -18982 | -386 | 11234 | 5110 | 70754 | 51156
TW San Juan Blanco |  | 8.1 | 5.61 | 4.87 | 4.62 | 3.44 | 2.58 | 2.45 | 2.61 | 1.73
 |  |  |  |  |  |  |  |  |  | 2037075.88
Red Cedar | 3246 | 30877 | 40063 | 48379 | 80516 | 96175 | 140689 | 147133 | 143078
Spreadsheet: 121010d1315765389-setting-up-a-project-point-sheet
Sheet: September

 | First | Last | Teacher | M/F | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday
 |  |  |  |  | 2011-09-12 00:00:00 |  |  |  |  |  |  | 2011-09-13 00:00:00 |  |  |  |  |  |  | 2011-09-14 00:00:00 |  |  |  |  |  |  | 2011-09-15 00:00:00 |  |  |  |  |  |  | 2011-09-16 00:00:00
1 | Jeremiah | [NAME] | 4-1 | m | t1
2 | [NAME] | Blackshire | 4-2 | m
3 | Amber | Clemons | 4-3 | F |  |  |  |  |  |  |  |  | h1
4 | Damont'e | [NAME] | 5-1 | m | r2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r3
5 | [NAME] | [NAME] | 5-2 | f
6 | S'Jamin | Cotton | 5-3 | m | t3 |  |  |  |  |  |  |  | h1 |  |  |  |  |  |  |  | rs
7 | [NAME] | Dover | 6-1 | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r3
8 | Jakob | Ertzbischoff | 6-2 | m
9 | [NAME] | Hall | 6-3 | m | rs1
10 | Maya | Hall | 4-1 | f |  |  |  |  |  |  |  |  | h1
11 | Sydney | [NAME] | 4-2 | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r3
12 | [NAME] | Jenkins | 4-3 | m |  |  |  |  | cz1 |  |  |  |  |  |  |  |  |  |  |  |  |  | r3
13 | Faith | Kmieske | 5-1 | f
14 | [NAME] | Knight | 5-2 | m |  |  |  |  |  |  |  |  | h1
15 | Hope | Kulka | 5-3 | f
16 | Cuny'a | [NAME] | 6-1 | f |  |  |  |  | cz1
17 | [NAME] | Lias | 6-2 | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rs1
18 | Maya | [NAME] | 6-3 | f |  |  |  |  |  |  |  |  | h1
19 | LaKenya | [NAME] | 4-1 | f |  |  |  |  | cz1
20 | [NAME] | Palazzola | 4-2 | f
21 | [NAME] | Raheem | 4-3 | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r3
22 | [NAME] | Roberson | 5-1 | m
23 | [NAME] | Smith | 5-2 | m
24 | Jayla | Sudduth | 5-3 | f |  |  |  |  | r2
25 | Tierra | Vaughn | 6-1 | f
26 | Terrence | Washington | 6-2 | m
Spreadsheet: 81257d1281497129-organizing-data-by-time-on-a-different-sheet-tournament-software-template
Sheet: Day 1 - Tee Sheet (THC)

Tee Sheet - Day 1 - THC
Starting Time/Tee | Player 1 | Player 2 | Player 3 | Player 4
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
1st Tee
10th Tee
Spreadsheet: 682792d1592332632-combining-3-array-formulas-to-one-sample
Sheet: Collections

Name | Phone | Date | Time | Quantity | Type | Paid | Balance Due | Confirmed | Collected |  |  | Dates are consecutive
 |  |  |  |  |  |  |  |  |  |  |  | Times within dates are consecutive
 |  |  |  |  |  |  |  |  |  |  |  | I would like the data from all 3 sheets NO,PO,HO brought into this  sheet as shown on the left here.
 |  |  |  |  |  |  |  |  |  |  |  | Currently only data from Sheet "NO" is pulled into this sheet
Spreadsheet: 106670d1303892680-lookup-latest-entry-of-a-value-from-chronological-entries-book2
Sheet: Sheet1

S.no | DFO Xmit Number | Document Number | Submit Number | Date | Direction | Status
1 | DFO-T034-XMITTAL-003 | QA-I1-SNL-F16-[PHONE] | 04L | 2011-02-08 00:00:00 | DFO OUT
2 | Approved (2011-03-27) | QA-I1-SNL-F56-[PHONE] | 04L | 2011-03-27 00:00:00 | DFO IN | APPROVED
3 | Approved (2011-03-27) | QA-I1-SNL-F56-[PHONE] | 04L | 2011-03-27 00:00:00 | DFO IN | APPROVED
4 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 03L | 2011-03-28 00:00:00 | PDM OUT AS BUILT | CLOSED
5 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 03L | 2011-03-28 00:00:00 | PDM OUT AS BUILT | CLOSED
6 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 04L | 2011-03-28 00:00:00 | PDM OUT AS BUILT | CLOSED
7 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 03L | 2011-03-28 00:00:00 | PDM OUT AS BUILT | CLOSED
8 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 04L | 2011-03-30 00:00:00 | PDM OUT AS BUILT | PDM AS BUILD
9 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F16-[PHONE] | 04L | 2011-04-12 00:00:00 | PDM OUT AS BUILT | TEST
10 | 1040340-FLK-SNL-0298 | QA-I1-SNL-F56-[PHONE] | 05L | 2011-04-12 00:00:00 | PDM OUT AS BUILT | TEST
Spreadsheet: 478824d1473087461-how-to-find-high-and-low-game-and-enter-that-week-bowling-help
Sheet: Sheet1

Bowling
week | game 1 | game 2 | game 3
1 | 90 | 119 | 98
2 | 115 | 80 | 111
3 | 112 | 88 | 104
4 | 78 | 105 | 83
5 | 127 | 99 | 105
6 | 100 | 129 | 102
7 | 82 | 82 | 82
8 | 89 | 119 | 133
9 | 134 | 93 | 98
10 | 129 | 116 | 115
Weekly high game
Weekly low game
Spreadsheet: 582881d1532092356-vlookup-table-for-supplier-name-cost-and-status-table-active-x-sample-new
Sheet: Sales Overview

 | Date  Created | Client | Supplier | List Price [NAME] | Quote Ref | Location | Postcode | Sale Price | Discount | Gross Profit | Status | Latest Comments | Next Follow Up Date | Required On Site | Comments
 | 2018-07-01 00:00:00 | Customer 1 | Supplier 1 | 20000 | 123456789 | Edinburgh | EH1 | 12000 | 3000 | 2500 | Sold |  | 2018-07-25 00:00:00 | 2018-11-01 00:00:00
 | 2018-07-02 00:00:00 | Customer 2 | Supplier 2 | 2000 | 325875615 | Edinburgh | EH2 | 1100 | 200 | 400 | Lost
 | 2018-07-03 00:00:00 | Customer 3 | Supplier 1 | 10000 | 198756423 | Edinburgh | EH3 | 5900 | 590 | 1500 | Sold
 | 2018-07-04 00:00:00 | Customer 4 | Supplier 3 | 1000 | 25486.01 | Edinburgh | EH1 | 1000 | 0 | 300 | Quote
Spreadsheet: 713142d1610565387-database-information-to-dashboard-training-matrix-3-
Sheet: Sheet1

 | State TT Attendance per Month for 2020
 | State | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
 | CA
 | AR
 | [NAME]
 | HE
 | DL
 | MS
 | IL
 | GE
 | VC
 | TX
 | ZA
Spreadsheet: 3764bb25-313a-4008-b183-98931fef243a
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8208 |  | 12.4 |  | 9343 |  | 15.9 |  | 2285 |  | 19 |  | 2041
September | 14.1 | 1/ |  |  | 13.7 |  | 10310 |  | 16.9 | 1/ |  |  | 17.8 |  | 2197
October |  |  |  |  | 14.1 |  | 8703 |  |  |  |  |  | 16.5 |  | 3074
November |  |  |  |  | 13.9 |  | 7205 |  |  |  |  |  | 16.9 |  | 4410
December |  |  |  |  | 13.8 |  | 9947 |  |  |  |  |  | 16.6 |  | 5007
January |  |  |  |  | 13.6 |  | 9491 |  |  |  |  |  | 16.7 |  | 5896
February |  |  |  |  | 13.2 |  | 9926 |  |  |  |  |  | 16 |  | 3712
March |  |  |  |  | 13 |  | 10050 |  |  |  |  |  | 16 |  | 4733
April |  |  |  |  | 13.2 |  | 9432 |  |  |  |  |  | 15.8 |  | 3904
May |  |  |  |  | 13.3 |  | 9698 |  |  |  |  |  | 16.3 |  | 3262
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.4 |  | 3395
July |  |  |  |  | 13.5 |  | 7492 |  |  |  |  |  | 16 |  | 2707
Average to date 2/ | 14.05 |  |  |  |  |  |  |  | 16.4
Season-average farm price | 13.7 | 3/ |  |  | 13.4 |  |  |  | 17 | 3/ 4/ |  |  | 16.5
Average marketings |  |  | 8208 |  |  |  | 9060.5 |  |  |  | 2285 |  |  |  | 3694.833333333333
Total volume marketed |  |  | 8208 |  |  |  | 108726 |  |  |  | 2285 |  |  |  | 44338
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated October 11, 2012.
Spreadsheet: 809638d1671192813-how-to-prevent-duplicate-outcome-in-excel-formula-excel-forum-help_how-to-prevent-duplicate-outcom-in-formula
Sheet: Sheet1

Channel Partner | Total Stock Days |  | Conclusion
[NAME] (Jodhpur) | 40 |  |  | Here, I want to prevent duplicate outcome.
[NAME] (Osian) | 31
Fair Deal (Jodhpur-3) | 29 |  | Matoshree (Phalodi), [NAME] ([NAME]) (21 Days & 21 Days)
Sohan Communication Private Limited (Jodhpur-4) | 38
Matoshree (Phalodi) | 21
[NAME] (Jaisalmer) | 21
Global System(Pali) | 38
[NAME] ([NAME]) | 36
[NAME] (Balotra) | 27
Adarsh [NAME] (Jalore) | 31
[NAME] (Sanchor) | 28
Gaurav Marketing (Sirohi) | 37
Spreadsheet: 881022d1728924574-match-multiple-criteria-fruit-workbook
Sheet: Sheet1

Company | Fruit |  | East coast | West coast | Central | Mountain |  |  | Company | Nestle
Nestle | Orange |  | 1 | 2 | 1 | 2 |  |  | Region | Central
Nestle | Apple |  | 2 | 1 | 3 |  |  |  | 1 | Orange
Nestle | Kiwi |  |  | 4 | 4 | 1 |  |  | 2 | [NAME]
Nestle | [NAME] |  | 3 | 3 | 2 |  |  |  | 3 | Apple
 |  |  |  |  |  |  |  |  | 4 | Kiwi