tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 264420d1378882131-check-if-any-entry-in-list-older-than-7-days-delete-second-double-entry-sample-20130911
Sheet: After

 |  |  |  |  |  |  |  |  | [NAME]
 | Conf. No. | Market | Rate |  |  | Survey Date: | Title | First | Last | [NAME] |  | Custom Data | [NAME] | 1 = entries from less than a week ago were found, 0 = no records from within the last 7 days of last entry
 | 13194084 | W | 100 |  |  | 2013-01-09 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 0
 | 13194814 | L | 100 |  |  | 2013-01-10 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13184615 | L | 100 |  |  | 2013-01-11 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13196692 | W | 100 |  |  | 2013-01-12 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13196702 | W | 100 |  |  | 2013-01-13 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1 |  | 1 = entries from less than a week ago were found
 | 13190395 | L | 100 |  |  | 2013-01-14 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1 |  | 0 = no records from within the last 7 days of last entry
 | 13190338 | P | 100 |  |  | 2013-01-15 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13192443 | P | 100 |  |  | 2013-01-16 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 0 |  | VBA Macro:
 | 13196790 | S | 100 |  |  | 2013-01-17 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1 |  | If range("N3:N65536") equals 1 then entirerow.hidden
 | 13196716 | S | 100 |  |  | 2013-01-18 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13196660 | D | 100 |  |  | 2013-01-19 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-20 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-21 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-22 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-23 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 0
 | 13137846 | L | 100 |  |  | 2013-01-24 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-25 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-26 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-27 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
 | 13137846 | L | 100 |  |  | 2013-01-28 00:00:00 | Mr | [NAME] | Skywalker | [EMAIL] | Death Star Association |  | 1
Spreadsheet: 31361d1227182420-multiple-dependent-dropdown-sample
Sheet: LookUp

Level one Drop down
Accounts | Marketing | Finance | Sales
Unit 1 | [NAME] | Fin 1 | Sales 1
Unit 2 | [NAME] | Fin 2 | Sales 2
Unit 3
Level 2 Drop down
Unit 1 | Unit 2 | Unit 3
New Account | Current Account | Other Accounts
Old Account | Not So Current Accounts
[NAME] | [NAME]
Team A | Best Team
Team B | Bad Team
Fin 1 | Fin 2
Office Team | Other Fin Matters
Client Team
Sales 1 | Sales 2
Area 1 | Mexico
Area 2 | Germany
Spreadsheet: 3cd9d649-a19d-49f4-89e5-312b21f5f72a
Sheet: PRE-POST SANDY CHANGE

Institution | Dataset | Description | Scale | Format | Location | Year
USGS | Aerial Imagery (Hazards Response) | Disaster event aerial imagery (pre- and post-Hurricane Sandy) from numerous contributed sources: oblique aerial handheld imagery (CAP); georeferenced and orthoimagery (NC DOT, NOAA, USNG, [NAME], USGS) | Variable | Variable (generally [NAME]) | http://hdds.usgs.gov/hdds2/ | 2012
USGS | Satellite Radar Imagery (Hazards Response) | Disaster event satellite imagery (pre- and post-Hurricane Sandy) from numerous contributed sources:  electro-optical satellite imagery ([NAME], ASTER, SPOT, EO-1 ALI, NASA ISS, DMCii, WorldView-1/2, QuickBird-2, IKONOS, RapidEye-3); radar imagery (COSMO-2/4, RadarSat-2/3, TerraSAR-X) | Variable | Variable (generally [NAME]) | http://hdds.usgs.gov/hdds2/ | 2012
USGS | Pre-Hurricane Sandy Lidar Datasets | 89 coastal lidar datasets were downloaded from various Federal agencies, such as USACE, USGS, and NOAA and gridded at a 1 meter spatial resolution. | Varied | GeoTIFF | http://hdds.usgs.gov/hdds/ | 01/01/2007 to 11/02/2011
USGS | Sandy impacts at Fire Island | profile change, shoreline change and overwash volumes from Sandy and winter of 2012-13 | Fire Island, NY | Excel databases | TBD | tentative publication date July 2013
USGS | lidar-derived post-Sandy topography | elevations of sandy open-coast beaches | NC to DE; Fire Island NY | LAS point files, DEMs, WMS | http://pubs.usgs.gov/ds/765/pubs765/index.html | 2012
USGS | lidar-derived post-Sandy beach morphology | elevation and position of seaward most dune, location of mean-high-water shoreline | NC to DE; Fire Island NY, measured every 1 km. | [NAME] shapefiles, WMS | http://pubs.usgs.gov/ds/765/pubs765/index.html | 2012
USGS | Hazard Products | [NAME] and assessment products from the Hurricane Sandy Response:  damage assessment, flood maps, flood polygons | Variable | Variable | http://hdds.usgs.gov/hdds2/ | 2012
Spreadsheet: 72bc997c-ee93-40c3-a5f4-9d2e13d9b527
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5175 | 42294 | Róbert | Ocelka | HUN | 540 | 00:44:49 | 00:01:39 | 01:13:44 | 00:02:55 | 00:23:29 | 1 | 02:26:39
Spreadsheet: 2d366a90-4a88-454a-ab15-62b113036c5b
Sheet: Power by Week

Team | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Average | Highest | Lowest | Biggest Gap | Team Change Code | Change from Last Week | Change from Week 1
Houston Texans | 6 | 4 | 2 | 1 | 1 | 1
San Francisco 49ers | 5 | 2 | 1 | 4 | 4 | 3
Baltimore Ravens | 4 | 3 | 6 | 3 | 3 | 4
Atlanta Falcons | 12 | 6 | 3 | 2 | 2 | 2
New England Patriots | 2 | 1 | 5 | 8 | 6 | 5
New York Giants | 1 | 7 | 8 | 6 | 10 | 7
Green Bay Packers | 3 | 5 | 4 | 7 | 8 | 12
Philadelphia Eagles | 7 | 12 | 7 | 9 | 7 | 11
Chicago Bears | 11 | 8 | 12 | 11 | 9 | 6
Pittsburgh Steelers | 8 | 11 | 9 | 16 | 16 | 10
Arizona Cardinals | 19 | 20 | 14 | 5 | 5 | 9
Denver Broncos | 10 | 9 | 10 | 14 | 13 | 17
San Diego Chargers | 15 | 14 | 11 | 13 | 11 | 14
Dallas Cowboys | 14 | 10 | 15 | 12 | 15 | 13
Cincinnati Bengals | 16 | 18 | 16 | 15 | 12 | 15
Detroit Lions | 9 | 13 | 13 | 18 | 20 | 20
[NAME] | 22 | 26 | 17 | 10 | 17 | 16
New York Jets | 20 | 17 | 18 | 17 | 23 | 25
Washington Redskins | 25 | 15 | 20 | 22 | 18 | 21
Minnesota Vikings | 31 | 28 | 29 | 21 | 14 | 8
Tampa Bay Bucs | 24 | 21 | 21 | 20 | 22 | 23
New Orleans Saints | 13 | 16 | 24 | 28 | 28 | 24
Carolina Panthers | 21 | 23 | 19 | 23 | 24 | 26
Buffalo Bills | 23 | 24 | 22 | 19 | 21 | 27
St. Louis Rams | 29 | 27 | 23 | 25 | 19 | 18
Tennessee Titans | 18 | 22 | 26 | 24 | 25 | 28
Kansas City Chiefs | 17 | 19 | 28 | 26 | 27 | 30
[NAME] | 27 | 30 | 25 | 29 | 26 | 19
Oakland Raiders | 26 | 25 | 30 | 27 | 29 | 29
Indianapolis Colts | 32 | 32 | 27 | 31 | 31 | 22
[NAME] | 28 | 29 | 31 | 30 | 30 | 31
[NAME] | 30 | 31 | 32 | 32 | 32 | 32
Spreadsheet: 841863d1694000773-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-jacc
Sheet: Good Year

Sr.No | Product_Name | Quantity | MRP | DLP | Combined_Name
1 | Powermax 80w90 | 20L | 5985 | 4160
2 | Powermax 80w90 | 5L | 1800 | 1059
3 | Ultra 75w90 | 2.5L |  | 629
4 | FormulaMax 15w40 | 5L | 1661 | 1015
5 | CNG 20w50 | 1L | 299 | 166
6 | PowerMax 90EP | 1L | 345 | 206
Spreadsheet: 7009fd13-f099-43be-ae1a-8089d350192a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ETOHU | Test | ETOHU | Ethanol, [NAME] | Ethanol, U | Gas-Liquid Chromatography (GLC) | [NAME]: Urine |  |  | 2 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 1 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK  Lipemia	NA Icterus	NA Other	NA | None detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL | Monday through Friday, Sunday; 3rd shift | 1 day | 1 day | 1 | 82055 |  |  |  |  | New England
ETOHU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
ETOHU | Result | 11137 | Ethanol, U | Ethanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5645-7 | Ethanol:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2003-04

Table C
Graduate Student Numbers by Faculty and Year Group
2003-04
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Year 6+ | Total
Arts and Humanities | 394 | 169 | 41 | 24 | 3 | 4
Built Environment | 549 | 209 | 45 | 18 | 11 | 17
Clinical Sciences | 349 | 376 | 315 | 116 | 30 | 6
Eastman Dental Institute | 90 | 90 | 57 | 58 | 54 | 2
Engineering | 514 | 210 | 142 | 109 | 55 | 9
Laws | 377 | 21 | 4 | 3 | 0 | 2
Life Sciences | 440 | 277 | 187 | 66 | 17 | 6
Mathematical and Physical Sciences | 213 | 95 | 72 | 17 | 1 | 0
Social and Historical Sciences | 782 | 200 | 105 | 32 | 12 | 10
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 150783d1334678992-combining-table-tab-information-startup-prl
Sheet: Electrical

Project Name:
Project Team: |  |  | G.C. Super:
Project Manager:
Mechancial Engineer:
Controls Engineer:
Field Technician (TAB):
 |  |  |  |  | Problem-Resolution Log (PRL) - General Contactor
Issue No. | Date Entered | Entered By: | Equipment or System | Description of Issue | Action By | Progress | Date Corrected | Corrected By: | Date Approved | Resolved by | [NAME] | Approved By:
1 | 2012-04-10 00:00:00 | EM | FCU-2403 | Flexible conduit restricting access to filter compartment.  Can be moved up higher to clear access area. | Cochran
 | 2012-04-11 00:00:00 | EM | 23rd [NAME] | No power to Fans.  Short in line voltage | Cochran | Fixed | 2012-04-12 00:00:00
Spreadsheet: 107783d1304942436-how-to-return-a-value-a-row-below-the-search-value-excel-problem_friend11_6
Sheet: Sheet1

Report |  |  | What I'm trying to get
Invoice No.
Invoice Value
Inv 123/2011 |  |  | Inv 123/2011 | 10000
10000 |  |  | Inv 124/2011 | 15000
 |  |  | Inv 125/2011 | 20000
Inv 124/2011 |  |  | Inv 126/2011 | 25000
15000 |  |  | Inv 127/2011 | 30000
Inv 125/2011
20000
Inv 126/2011
25000
Inv 127/2011
30000
Spreadsheet: 732136d1620792585-returning-unique-value-with-multiple-criteria-timecard-ans
Sheet: TIMECARD DATA

CREW | PERSON | DATE
ABC | SUSAN | 2017-01-17 00:00:00
ABC | DOUG | 2017-04-18 00:00:00
ABC | PETER | 2017-04-18 00:00:00
ABC | SUSAN | 2017-04-18 00:00:00
ABC | STEVE | 2017-05-09 00:00:00
ABC | SUSAN | 2017-05-09 00:00:00
ABC | DOUG | 2017-06-01 00:00:00
ABC | [NAME] | 2017-06-01 00:00:00
ABC | [NAME] | 2017-06-01 00:00:00
ABC | SUSAN | 2017-06-01 00:00:00
ABC | STEVE | 2017-11-03 00:00:00
ABC | SUSAN | 2018-02-06 00:00:00
ABC | DOUG | 2018-03-05 00:00:00
ABC | [NAME] | 2018-03-05 00:00:00
ABC | SUSAN | 2018-03-05 00:00:00
ABC | DOUG | 2018-05-12 00:00:00
ABC | DOUG | 2018-05-12 00:00:00
ABC | PETER | 2018-05-12 00:00:00
ABC | SUSAN | 2018-05-12 00:00:00
ABC | SUSAN | 2019-01-08 00:00:00
ABC | [NAME] | 2019-05-19 00:00:00
ABC | [NAME] | 2019-05-19 00:00:00
ABC | [NAME] | 2019-08-03 00:00:00
ABC | [NAME] | 2019-08-03 00:00:00
ABC | DOUG | 2019-12-01 00:00:00
ABC | DOUG | 2019-12-01 00:00:00
ABC | [NAME] | 2019-12-01 00:00:00
ABC | SUSAN | 2019-12-01 00:00:00
ABC | DOUG | 2020-02-03 00:00:00
ABC | SUSAN | 2020-02-03 00:00:00
ABC | SUSAN | 2020-03-15 00:00:00
ABC | DOUG | 2020-07-18 00:00:00
DEF | [NAME] | 2017-01-17 00:00:00
DEF | JOE | 2017-01-17 00:00:00
DEF | [NAME] | 2017-04-18 00:00:00
DEF | JOE | 2017-04-18 00:00:00
DEF | DOUG | 2017-05-09 00:00:00
DEF | DOUG | 2017-06-01 00:00:00
DEF | [NAME] | 2017-06-01 00:00:00
DEF | [NAME] | 2017-11-03 00:00:00
DEF | [NAME] | 2017-11-03 00:00:00
DEF | [NAME] | 2017-11-03 00:00:00
DEF | [NAME] | 2018-02-06 00:00:00
DEF | [NAME] | 2018-02-06 00:00:00
DEF | [NAME] | 2018-02-06 00:00:00
DEF | [NAME] | 2018-03-05 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | STEVE | 2018-05-12 00:00:00
DEF | [NAME] | 2018-05-12 00:00:00
DEF | STEVE | 2019-01-08 00:00:00
DEF | [NAME] | 2019-05-19 00:00:00
DEF | DOUG | 2019-08-03 00:00:00
DEF | [NAME] | 2019-08-03 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | STEVE | 2019-12-01 00:00:00
DEF | STEVE | 2019-12-01 00:00:00
DEF | JOE | 2019-12-01 00:00:00
DEF | [NAME] | 2019-12-01 00:00:00
DEF | DOUG | 2020-02-03 00:00:00
DEF | [NAME] | 2020-02-03 00:00:00
DEF | STEVE | 2020-02-03 00:00:00
DEF | JOE | 2020-02-03 00:00:00
DEF | STEVE | 2020-03-15 00:00:00
DEF | [NAME] | 2020-03-15 00:00:00
DEF | JOE | 2020-07-18 00:00:00
GHI | PETER | 2017-05-09 00:00:00
GHI | JOE | 2017-05-09 00:00:00
GHI | [NAME] | 2017-05-09 00:00:00
GHI | PETER | 2017-06-01 00:00:00
GHI | JOE | 2017-06-01 00:00:00
GHI | PETER | 2018-03-05 00:00:00
GHI | JOE | 2018-05-12 00:00:00
GHI | [NAME] | 2019-01-08 00:00:00
GHI | JOE | 2019-05-19 00:00:00
GHI | [NAME] | 2019-05-19 00:00:00
GHI | [NAME] | 2020-02-03 00:00:00
GHI | [NAME] | 2020-03-15 00:00:00
GHI | [NAME] | 2020-07-18 00:00:00
JKL | SUSAN | 2017-01-17 00:00:00
JKL | SUSAN | 2018-05-12 00:00:00
JKL | SUSAN | 2018-05-12 00:00:00
JKL | [NAME] | 2019-01-08 00:00:00
JKL | [NAME] | 2019-08-03 00:00:00
JKL | [NAME] | 2019-12-01 00:00:00
JKL | [NAME] | 2020-02-03 00:00:00
JKL | SUSAN | 2020-07-18 00:00:00
Spreadsheet: 683310d1592610752-index-match-4-variables-criteria-or-product-copy
Sheet: Sheet1

 | Criteria: | NAP1 | NAP5 | NAN3 | NAN4
 | Product | Industry |  | Unique List
 | QWE | NAP2 |  | if list in c4 is one of 4 criteria above, I need the corresponding Product in B:B to be returned here.
 | WER | NAN7
 | ERT | [NAME] |  | previously tried (index match small) and (index match countif)
 | RTY | [NAME]
 | TYU | NAP4
 | YUI | NAP5
 | UIO | NAP7
 | IOP | NAN3
 | ASD | NAN3
 | SDF | NAP6
 | DFG | [NAME]
 | FGH | NAP5
 | GHJ | NAP5
 | HJK | NAP7
 | JKL | NAP9
 | KLL | NAP4
 | ZXC | [NAME]
 | XCV | [NAME]
 | CVB | NAP8
 | VBN | NAP9
 | BNM | NAP4
 | NMM | NAP4
 | QAA | NAN6
 | WSS | NAN4
 | EDD | NAP8
 | RFF | NAP7
 | TGG | [NAME]
 | YHH | NAP2
 | UJJ | NAP7
Spreadsheet: 9288d669-5fb7-45df-aa39-d157b5e00fa1
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 | Unnamed: 12
 |  | [NAME] |  |  |  |  | Junioren   juniors
 |  | Championnat suisse de groupes
 |  | Gewehr 50m / carabine 50m
Stellung  Position: |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: | Auswechselschütze tireurs remplaçants |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: | Auswechselschütze tireurs remplaçants
liegend/couché:
liegend/couché:
kniend/à genou:
kniend/à genou: |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | [NAME]. / groupe no: |  |  |  | Elektronische Scheiben/                     Cibles électronique:
Verein/Société:
Vereinsnummer |  |  |  |  |  |  |  |  | Ja
 |  |  |  |  |  |  |  |  | [NAME]:
Gruppenchef/chef du group:
Name/Nome:
Adresse/adresse: |  |  |  |  |  |  |  |  | 1. [NAME].
PLZ+Ort/lieau |  |  |  |  |  |  |  |  | 1. Carton-no:
Tel./tél: |  |  |  |  |  |  |  |  | Elektronisch
E-Mail: |  |  |  |  |  |  |  |  | cibles électronique
Erläuterungen / remarques:
Bei Auswechselschützen muss ein x in die entsprechende Spalte eingetragen werden
Die Scheibenart muss mit einem x im entsprechenden Feld eingetragen werden
Die erste Nummer der ausgeteilten Kartons ist im entsprechenden Feld einzutragen.
Signalez les tireurs remplaçants par un x dans la colonne correspondante
Placez un x dans la case correspondant au type de cibles.
Le numéro du 1er des cartons distribués doit figurer dans la casse prévue à cet effet
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 17 - table 2

 |  | December 2010 |  |  | December 2011
 | [NAME] | Current | Non-current | Total | Current | Non-current | Total
 | Local Currency | 1156.735221706781 | 2817.49115704039 | 3974.226378747171 | 2089.22538184 | 1632.38471444 | 3721.61009628
 | Foreign Currency | 1449.493168744004 | 1346.722452508825 | 2796.215621252829 | 122.85261816 | 257.82331137 | 380.67592953
 | Consolidated Debt | 2606.228390450785 | 4164.213609549215 | 6770.442000000001 | 2212.078 | 1890.20802581 | 4102.28602581
 | Cash and Cash Equivalents |  |  | 5908.299 |  |  | 8076.241
 | Current Investment Securities |  |  | 1069.276 |  |  | 193.385
 | Net Debt/ (Cash) |  |  | -207.1329999999991 |  |  | -4167.33997419
Spreadsheet: 855409d1704983213-updating-a-calendar-from-dates-test-calendar-v1
Sheet: Event List

 | YEAR |  |  | 2024
TO DO LIST |  |  |  |  |  | HOLIDAY LIST |  |  |  | EVENT LIST
NO | Start Date | End Date | TIME | TO DO |  | NO | DATE | HOLIDAY |  | NO | DATE | EVENT
1 | 2024-01-01 00:00:00 | 2024-01-03 00:00:00 | 10:00:00 | Class |  | 1 | 2024-01-01 00:00:00 | New Year’s Day |  | 1 | 2024-01-02 00:00:00 | Staff Day off
2 |  |  |  |  |  | 2 |  |  |  | 2
3 |  |  |  |  |  | 3 |  |  |  | 3
4 |  |  |  |  |  | 4 |  |  |  | 4
5 |  |  |  |  |  | 5 |  |  |  | 5
6 |  |  |  |  |  | 6 |  |  |  | 6
7 |  |  |  |  |  | 7 |  |  |  | 7
8 |  |  |  |  |  | 8 |  |  |  | 8
9 |  |  |  |  |  | 9 |  |  |  | 9
10 |  |  |  |  |  | 10 |  |  |  | 10
11 |  |  |  |  |  | 11 |  |  |  | 11
12 |  |  |  |  |  | 12 |  |  |  | 12
13 |  |  |  |  |  | 13 |  |  |  | 13
14 |  |  |  |  |  | 14 |  |  |  | 14
15 |  |  |  |  |  | 15 |  |  |  | 15
16 |  |  |  |  |  | 16 |  |  |  | 16
17 |  |  |  |  |  | 17 |  |  |  | 17
18 |  |  |  |  |  | 18 |  |  |  | 18
19 |  |  |  |  |  | 19 |  |  |  | 19
20 |  |  |  |  |  | 20 |  |  |  | 20
21
22
23 |  |  |  |  |  | To Do List
24 |  |  |  |  |  | List of to do/events/schedules or any information you want to put in calendar. Type your dates, time and description. It doesn't have to be sorted because formula in calendar will automatically placed related dates in its date boxes (6 events per dates)
25
26
27 |  |  |  |  |  | Holiday/Event List
28 |  |  |  |  |  | List of holidays/more priority events which will be placed next to related dates in date boxes inside calendar.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
Spreadsheet: 123756d1317838457-excel-list-help-excel-list-example
Sheet: Sheet1

Score | Location | Plot Designation | Location | Rank | Score
15 | A | A | A | 1 | 20
20 | B |  | J | 2 | 18.5
0 | C |  | M | 3 | 18
3 | D |  | A | 4 | 15
12 | E |  | I | 5 | 15
8.5 | F | B | L | 6 | 15
4 | G |  | E | 7 | 12
12 | H |  | H | 8 | 12
15 | I |  | N | 9 | 10
18.5 | J |  | F | 10 | 8.5
5 | K | C | K | 11 | 5
15 | L |  | G | 12 | 4
18 | M |  | D | 13 | 3
10 | N |  | C | 14 | 0
0 | O |  | O | 15 | 0
20 |  | 18.5 |  | 18
1st Place |  | 2nd Place |  | 3rd Place
B |  | J |  | M
 |  | 15
 |  | 4th Place
 |  | A
Spreadsheet: 162407d1339856226-excel-2007-how-to-do-anova-with-data-analysis-tool-pack-on-the-data-enclosed-excelforumquestionanova
Sheet: Sheet1

Age | Tot Emp Enagement
40 | 29
26 | 24
26 | 23
27 | 10
22 | 25
40 | 30
21 | 27
24 | 18
28 | 26
25 | 27
23 | 27
20 | 26
25 | 27
27 | 24
45 | 26
24 | 26
23 | 22
48 | 27
33 | 26
26 | 30
24 | 27
24 | 27
30 | 17
44 | 25
38 | 27
20 | 22
47 | 26
46 | 26
50 | 30
29 | 30
26 | 28
38 | 25
37 | 28
45 | 28
24 | 28
26 | 22
26 | 24
24 | 30
24 | 23
31 | 28
24 | 9
28 | 25
26 | 18
27 | 24
25 | 26
36 | 24
37 | 16
48 | 24
40 | 27
30 | 24
30 | 28
25 | 30
25 | 28
26 | 10
43 | 25
31 | 13
60 | 27
24 | 23
24 | 21
35 | 27
27 | 23
40 | 30
32 | 30
50 | 28
32 | 29
24 | 25
40 | 29
27 | 26
24 | 25
26 | 23
30 | 26
22 | 25
32.84 | 24
32.84 | 24
47 | 27
43 | 28
42 | 24
31 | 24
40 | 26
42 | 30
43 | 27
58 | 29
32 | 28
54 | 30
39 | 29
44 | 22
Spreadsheet: 677180d1589226905-color-third-cell-if-cell-1-is-filled-and-cell-2-is-not-formatting
Sheet: Ark1

What I would like to achieve: |  |  |  | My best attempt:
fsdfds | sdfdsf |  |  | fsdfds | sdfdsf
dfsfsd | fdsfssdf |  |  | dfsfsd | fdsfssdf
fnsdnf | fkdsnf |  |  | fnsdnf | fkdsnf
fsds |  |  |  | fsds
fsfs |  |  |  | fsfs
fsfsfsd | fdsf |  |  | fsfsfsd | fdsf
Spreadsheet: 686954d1594886031-ranking-with-indiex-match-fucntion-match-function-test_ram-2
Sheet: Sheet1

 | Data source |  |  |  |  | Overall Ranking |  |  |  | Asia only
Continental | Country | No of case | Rank | Rank Asia Unique |  | Rank | Country | No of case |  | Rank | Country | No of case
Europe | Spain | 26 |  |  |  | 1 |  |  |  | 1
Europe | London | 33 |  |  |  | 2 |  |  |  | 2
Asia | Japan | 26 |  |  |  | 3 |  |  |  | 3
Asia | Singapore | 22 |  |  |  | 4 |  |  |  | 4
Asia | India | 38 |  |  |  | 5 |  |  |  | 5
N America | Canada | 48 |  |  |  | 6 |  |  |  | 6
N America | Alaska | 24 |  |  |  | 7 |  |  |  | 7
Asia | Thailand | 38 |  |  |  | 8 |  |  |  | 8
Asia | Malaysia | 31 |  |  |  | 9 |  |  |  | 9
Spreadsheet: 769160d1645357956-want-to-have-a-value-but-not-repeat-it-book2
Sheet: Sheet1

USA
Australia
India
Chaina
Japan
Pakistan
India
USA
USA
Australia
Spreadsheet: 823638d1680066380-using-let-to-collate-data-and-sorting-data-based-off-date-column-excel-help-8
Sheet: Jane

 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Completed | Start Date
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | True | 2022-09-14 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | True | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | True | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Casual | True | 2022-10-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Fixed Casual | True | 2022-09-19 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | True | 2022-09-05 00:00:00
 | Essence Esparza | NER | WA | ERD | [NAME] | 1 | PPT | True | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | True | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | True | 2022-10-06 00:00:00
Spreadsheet: 866394d1713318073-help-with-basic-table-example
Sheet: Data

ID | NAME | START | END | CAR
12 | [NAME] | 2024-04-19 17:15:00 | 2024-04-24 17:15:00 | Toyota
13 | [NAME] | 2024-04-19 11:00:00 | 2024-04-22 08:00:00 | [NAME]
14 | [NAME] | 2024-04-19 08:00:00 | 2024-04-19 17:00:00 | Kia
15 | [NAME] | 2024-04-19 10:00:00 | 2024-04-19 16:00:00 | Ute