tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 555699d1515700189-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-3-
Sheet: Tournament 6

 |  |  | Tournament 6 |  |  |  |  |  |  | DNP
 |  |  |  |  |  |  |  |  | # of Members Played | Did not Play | # of Players with Low Score | # of Players with MAX Score
 |  |  |  | Tournament |  | After Adjustments
 |  |  | Player | Score | Sub - Points | Actual Score | Actual Points |  | Tournament low score [NAME] (s)
 |  |  |  |  |  |  |  |  | Player | Points | Low Score
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Enter Data into the Tournament Score column only
 |  |  |  |  |  |  |  |  | Enter DNP against the Members who DID NOT PLAY
 |  | x | x | x
Spreadsheet: 810700d1671970082-index-match-column-row-with-duplicate-variables-in-the-row-ddd
Sheet: Sheet2

 | site 1
 | 2023-01-09 00:00:00
[NAME] | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  |  | [NAME] | 2023-01-15 00:00:00 |  | <<  I want to be able to see 1800-0600
Shanker | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
Parbhjot |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800
Januar |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800
 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
Casuals
Arif
Ayhan
[NAME]
 | Site 2
[NAME] | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
Roman |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800
Zeeshan |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800
Hussain | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
Zulqurnain |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
Ahmed |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
[NAME] | 0600-1800 | 0600-1800 | 0600-1800 | 0600-1800 |  |  |  | 0600-1800 | 0600-1800 | 0600-1800 | 0600-1800
Casuals
[NAME] D
Arslan
Ayhan
Dimpy
Lala
[NAME]
Zulqarnain
[NAME] | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
XTrained FT
[NAME]
Haroon
[NAME] |  |  |  |  |  |  | 1800-0600
Spreadsheet: 13798a7d-9ca2-4d28-987f-ea09105df8ec
Sheet: FIXTUR

ABIERTA VARONES |  |  |  |  |  | 1 | X | 1
 |  |  |  |  |  | 2 | 5
RANKING 2012 ABIERTA VARONES | INSCRIPCIONES |  | GRUPO A | GRUPO B |  | 3 | 4
 | 2a PARADA CALI 2013 |  |  |  |  | 1 | 5 | 2
PATIN SPORT | 1 | [NAME] |  |  |  | X | 4
MIMBRE | 2 | MIMBRE - QUINDIO | CORAZONISTA ATLANTICO | REAL HC. ANTIOQUIA |  | 2 | 3
MANIZALES HC | 3 | MANIZALES - CALDAS | [NAME] | [NAME] |  | 1 | 4 | 3
INTER AZUL/A | 4 | INTER AZUL - BOGOTA |  |  |  | 5 | 3
INTER NEGRO/B | 5 | INTER NEGRO - BOGOTA |  |  |  | X | 2
HURACANES | 6 | HURACANES A - VALLE | GRUPO C | GRUPO D |  | 1 | 3 | 4
BUFALOS/A | 7 | BUFALOS - CUNDINAMARCA |  |  |  | 4 | 2
CORAZONISTA A ANTIOQUIA | 8 | CORAZONISTA - ANTIOQUIA |  |  |  | 5 | X
D´RAPEG/A | 9 | D'RAPEG - TOLIMA | HALCONES - ANTIOQUIA | DRAPEG - TOLIMA |  | 1 | 2 | 5
HALCONES | 10 | HALCONES - ANTIOQUIA | SUPER PATIN-SANTANDER | RISARALDA |  | 3 | X
REAL H.C. | 11 | REAL HC - ANTIOQUIA |  |  |  | 4 | 5
CORAZONISTA ATLANTICO | 12 | CORAZONISTA - ATLANTICO | GRUPO E | GRUPO F
PATIN SPORT DRIF | 13 | SUPER PATIN - SANTANDER | INTER NEGRO - BOGOTA | HURACANES A - VALLE |  | 1 | 4 | 1
RACING | 14 | [NAME] | CORAZONISTA - ANTIOQUIA | BUFALOS - CUNDINAMARCA |  | 2 | 3
FMC ROLLING | 15 | M/ZALES RECARGADO - CALDAS | SABANETA - META | [NAME] |  | 1 | 3 | 2
COR B ANTIOQUIA | 16 | [NAME] |  |  |  | 4 | 2
D´RAPEG B | 17 | SABANETA - META |  |  |  | 1 | 2 | 3
PATIN SPORT AGUA | 18 | [NAME] |  |  |  | 3 | 4
BUFALOS B | 19
 |  |  |  |  |  | 1 | X | 1
INFANTIL MIXTO |  |  |  |  |  | 2 | 5
 |  |  |  |  |  | 3 | 4
POSICIONES RANKING 2012 INFANTIL MIXTO | INSCRIPCIONES |  | GRUPO | GRUPO |  | 1 | 5 | 2
 | 2a PARADA CALI 2013 |  | A | B |  | X | 4
FCM ROLLING (3) | 1 | [NAME] |  |  |  | 2 | 3
PATIN SPORT (3) | 2 | CORAZONISTA - BOGOTA | BARCELONA A - VALLE | MANIZALES HC- CALDAS |  | 1 | 4 | 3
CORAZ.BOGOTA (2) | 3 | BENGALA - VALLE | INTER NEGRO - BOGOTA | BARCELONA B- VALLE |  | 5 | 3
BENGALA (3) | 4 | HURACANES - VALLE |  |  |  | X | 2
HURACANES (1) | 5 | INTER AZUL - BOGOTA |  | GRUPO D |  | 1 | 3 | 4
CORAZONISTA ANT. A (2) | 6 | REAL HC - ANTIOQUIA | GRUPO C | HURACANES - VALLE |  | 4 | 2
INTERNACIONAL (2) | 7 | MANIZALES - CALDAS |  | INTER AZUL - BOGOTA |  | 5 | X
REAL HC (1) | 8 | BARCELONA A - VALLE |  | SABANETA - ANTIOQUIA |  | 1 | 2 | 5
MANIZALES.H.C (1) | 9 | INTER NEGRO - BOGOTA | REAL HC -ANTIOQUIA | [NAME] |  | 3 | X
BARCELONA (1) | 10 | BARCELONA B - VALLE | CORAZONISTA - ATLANTICO |  |  | 4 | 5
CORAZ. AZUL BOG (1) | 11 | CORAZONISTA - ATLANTICO
MIMBRE (1) | 12 | SABANETA - ANTIOQUIA |  |  |  | 1 | 4 | 1
GACELAS (1) | 13 | [NAME] |  |  |  | 2 | 3
MANYANET (1) | 14 |  |  |  |  | 1 | 3 | 2
CORAZONISTA ANT. B (1) | 15 |  |  |  |  | 4 | 2
INTERNACIONAL NEGRO (1) | 16 |  |  |  |  | 1 | 2 | 3
 |  |  |  |  |  | 3 | 4
Spreadsheet: 115050d1310673011-problem-working-out-a-couple-of-formulas-excelhelp
Sheet: Sheet1

List of Expenses | Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4 |  |  | Day 5 |  |  | Day 6 |  |  | Day 7
 | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over | Budgeted | Actual | Spend Carry Over
Food | 50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50
Day Trip | 200 |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  |  |  |  | 200
Spending Money
Spreadsheet: 838830d1691430113-sortby-not-populating-with-data-stored-in-circular-references-circular-reference-schedule-simulation
Sheet: Sheet 1

[NAME] | [NAME] | [NAME] |  | Merge | Merge | Merge |  | Memory | Memory | Memory |  | Δ seq | Δ machine |  | Switch |  | [NAME] |  | User Display Array
1 | [NAME] | M01 |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | [NAME] | M01
3 | [NAME] | M01
4 | [NAME] | M01 |  |  |  |  |  |  |  |  |  | 1 | M02
5 | Riley | M01 |  |  |  |  |  |  |  |  |  | 2 | M02
6 | [NAME] | M01 |  |  |  |  |  |  |  |  |  | 3 | M02
Spreadsheet: 870203d1716755439-trim-and-clean-results-cant-be-used-excel-forum-sample-2024
Sheet: Sheet1

Major League Baseball 2024
 | Card Names | Card Title | No. of Dupe Cards | Brand/Year |  | Avg. Cost
1 | Christian | Guzman |  | [NAME] | 2001 | 0.18 |  |  |  | Card Names | Card Title | No. of Dupe Cards | Brand/Year |  | Avg. Cost
2 | Rafael | [NAME] |  | [NAME] | 2001 | 2 |  |  | 1 | Christian | Guzman |  | [NAME] | 2001 | 0.18
3 | Rafael | [NAME] |  | [NAME] | 1999 | 0.38 |  |  | 2 | Rafael | [NAME] |  | [NAME] | 2001 | 2
4 | [NAME] | [NAME] |  | Donruss | 1989 | 0.56 |  |  | 3 | Rafael | [NAME] |  | [NAME] | 1999 | 0.38
5 | [NAME] | [NAME] |  | Donruss | 1988 | 1.29 |  |  | 4 | [NAME] | [NAME] |  | Donruss | 1989 | 0.56
6 | Greg | Maddox |  | Donruss | 1995 | 2 |  |  | 5 | [NAME] | [NAME] |  | Donruss | 1988 | 1.29
7 | [NAME] | [NAME] |  | Donruss | 1995 | 1.5 |  |  | 6 | Greg | Maddox |  | Donruss | 1995 | 2
8 | [NAME] | [NAME] |  | Donruss | 1989 | 2.44 |  |  | 7 | [NAME] | [NAME] |  | Donruss | 1995 | 1.5
9 | Ozzie | Smith |  | Donruss | 1991 | 0.03 |  |  | 8 | [NAME] | [NAME] |  | Donruss | 1989 | 2.44
10 | [NAME] | [NAME] |  | Donruss | 1993 | 0.3 |  |  | 9 | Ozzie | Smith |  | Donruss | 1991 | 0.03
11 | [NAME] | Clemens |  | Donruss | 1989 | 1.17 |  |  | 10 | [NAME] | [NAME] |  | Donruss | 1993 | 0.3
12 | Dennis | [NAME] |  | Donruss | 1991 | 0.11 |  |  | 11 | [NAME] | Clemens |  | Donruss | 1989 | 1.17
13 | [NAME] | Henderson |  | Donruss | 1989 | 7.86 |  |  | 12 | Dennis | [NAME] |  | Donruss | 1991 | 0.11
14 | Orel | [NAME] |  | Donruss | 1989 | 0.01 |  |  | 13 | [NAME] | Henderson |  | Donruss | 1989 | 7.86
15 | [NAME] | Justice |  | Donruss | 1990 | 1.5 |  |  | 14 | Orel | [NAME] |  | Donruss | 1989 | 0.01
16 | [NAME] | Justice |  | Donruss | 1995 | 1.5 |  |  | 15 | [NAME] | Justice |  | Donruss | 1990 | 1.5
17 | Rafael | [NAME] |  | Donruss | 1995 | 1.5 |  |  | 16 | [NAME] | Justice |  | Donruss | 1995 | 1.5
18 | Ozzie | Smith |  | Donruss | 1993 | 1.13 |  |  | 17 | Rafael | [NAME] |  | Donruss | 1995 | 1.5
 |  |  |  |  |  |  |  |  | 18 | Ozzie | Smith |  | Donruss | 1993 | 1.13
Spreadsheet: 713587d1610817361-translating-multiple-column-index-to-other-work-sheets-film-tester
Sheet: Directors

Director | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME]
[NAME]
The Coen Brothers
[NAME]
[NAME]
Tyler Nilson, [NAME]
[NAME] Coppola
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tyler Nilson
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 34592 | 34133
2 |  |  | 34669 | 34133
3 |  |  | 34620 | 33692
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183967 | -149923
2002-01-31 00:00:00 | Balance | -1035385.61 |  | -616208.42
2002-02-03 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1167820 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -154244
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: 18th

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
9467 | 0840 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | Hallett Cove school | Chalkers Pool Hall Glenelg 112 [NAME] | y | 90 | 0 |  | acct | 20 |  |  |  |  | claudio
 | 1020 | [NAME] Cove | 83921020 |  |  |  | 1 |  |  |  | 112 Jetty Rd Glenelg Chalkers Pool Hall | Hallett Cove School | n | 90 | 0 |  | acct | 20 |  |  |  |  | claudio
 | 1145 | Encounter SA | DT [NAME] |  |  |  |  | 1 |  |  | QF 741 | Grand Chifley | n | 143 | 0 |  | acct | 17 | yes |  |  |  | cat
 | 0915 | Lockleys Primary School 29 [NAME] | nicole [PHONE] |  |  |  |  |  | 1 |  | Lockleys Primary 29 [NAME] | Adelaide Zoo rear ent | y | 145 | 0 |  | acct | 29 | no |  |  |  | [NAME]
 | 1415 | Lockleys Primary School 29 [NAME] | nicole [PHONE] |  |  |  |  |  | 1 |  | Adelaide Zoo | Lockleys Primary | n | 145 | 0 |  | acct | 29 | no |  |  |  | [NAME]
 | 1445 | Adelaide High School |  |  |  | 1 |  |  |  |  | Adelaide High | Unley High & then to Mitchum Girls | y | 110 | 0 | 110 | acct | 20 | no |  |  |  | [NAME]
 | 1630 | Adelaide High School |  |  |  | 1 |  |  |  |  | Mitchum Girls then to Unley High School | Adelaide High | y | 110 | 0 |  | acct | 20 | no |  |  |  | [NAME]
 | 1500 | Sa [NAME] |  |  |  | 1 |  |  |  |  | Self Drive 2.5 days |  |  | 400 | 400 | c/card | acct | 12 | no |  |  |  | self drive
 | 1915 | Sinclair Refridgeration | [NAME] | 1 |  |  |  |  |  |  | 10 Aspiring Court Greenwith | Airport |  | 94 | 0 |  | acct | 1 | no |  |  |  | Connors
 | 1330 | St Domenics School | Dolores 82673818 |  |  |  |  |  | 1 |  | St Domenics | Racket & Strings 139 Henely Bch Rd | y | 135 | 0 |  | acct | 25 | no |  |  |  | [NAME]
 | 1450 | St Domenics School | Dolores 82673818 |  |  |  |  |  | 1 |  | Racket & Strings | St Domenics | n | 135 | 0 |  | acct | 25 | no |  |  |  | [NAME]
 | 1330 | St Domenics School | Dolores 82673818 |  |  |  |  |  | 1 |  | St Domenics | Ice Arena | y | 135 | 0 |  | acct | 27 | no |  |  |  | [NAME]
 | 1450 | St Domenics School | Dolores 82673818 |  |  |  |  |  | 1 |  | Ice Arena | St Dominics | n | 135 | 0 |  | acct | 27 | no |  |  |  | [NAME]
 | 1300 | Marryarville High School | [NAME] |  |  |  |  | 1 |  |  | Marryatville High | Verical Reality Climbimg Holden Hill | y | 110 | 0 |  | acct | 24 | no |  |  |  | dom
 | 1500 | Marryarville High School | [NAME] |  |  |  |  | 1 |  |  | Vertical Reality Holden Hill | Marryatville High | n | 110 | 0 |  | acct | 24 | no |  |  |  | dom
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0800 Hotel
 |  |  |  |  |  |  |  |  |  |  | Air Asia x - 0900 Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 0715  -Apt
 |  |  |  |  |  |  |  |  |  |  | Malaysia 1230 - Hotel
TOTAL
Spreadsheet: 758132d1638690006-dynamic-formula-to-determine-max-values-based-on-year-and-quarter-max-values-by-year-and-quarter_2
Sheet: Sheet1

Date of Sale | Price |  |  |  |  | 2019 | 2020
2019-01-01 00:00:00 | 994 |  |  |  | Q1
2019-01-08 00:00:00 | 777 |  |  |  | Q2
2019-02-12 00:00:00 | 358 |  |  |  | Q3
2019-03-16 00:00:00 | 974 |  |  |  | Q4
2019-03-28 00:00:00 | 561
2019-04-02 00:00:00 | 654
2019-04-11 00:00:00 | 883
2019-06-16 00:00:00 | 214
2019-07-14 00:00:00 | 501
2019-07-23 00:00:00 | 318
2019-08-04 00:00:00 | 892
2019-09-24 00:00:00 | 285
2019-09-27 00:00:00 | 912
2019-09-30 00:00:00 | 218
2019-10-03 00:00:00 | 500
2019-12-29 00:00:00 | 905
2020-01-04 00:00:00 | 966
2020-02-10 00:00:00 | 138
2020-02-16 00:00:00 | 917
2020-03-21 00:00:00 | 146
2020-04-04 00:00:00 | 356
2020-04-12 00:00:00 | 512
2020-04-15 00:00:00 | 864
2020-04-15 00:00:00 | 123
2020-04-19 00:00:00 | 295
2020-04-23 00:00:00 | 320
2020-04-30 00:00:00 | 135
2020-04-30 00:00:00 | 957
2020-05-01 00:00:00 | 237
2020-06-10 00:00:00 | 751
2020-06-11 00:00:00 | 312
2020-06-21 00:00:00 | 908
2020-07-08 00:00:00 | 543
2020-08-05 00:00:00 | 636
2020-08-15 00:00:00 | 529
2020-08-16 00:00:00 | 338
2020-09-03 00:00:00 | 649
2020-09-23 00:00:00 | 125
2020-09-24 00:00:00 | 952
2020-09-30 00:00:00 | 580
2020-10-16 00:00:00 | 727
2020-10-29 00:00:00 | 199
2020-12-09 00:00:00 | 268
2020-12-27 00:00:00 | 182
Spreadsheet: 818334d1676745468-need-help-with-countif-perform-a-percentile-and-rank-example-01
Sheet: Sheet - Try Example

Below are the marks scored by 7 students. 150 is the total score they are required to achieve. Please use excel formuales to derive answers to the below question:
 |  | Rank each student as per the percentage achieved. Use the rank table which is in column M9
 |  |  |  |  |  |  |  |  |  |  |  | Rank Table
 |  | >> Using If Condition |  |  |  | Name | Marks | Rank | % of Marks |  |  | Lower Limit | Upper Limit | Rank
 |  |  |  |  |  | Dennis | 40 |  |  |  |  | 0 | 0.4 | 5
 |  |  |  |  |  | Dev | 60 |  |  |  |  | 0.41 | 0.6 | 4
 |  |  |  |  |  | [NAME] | 33 |  |  |  |  | 0.61 | 0.7000000000000001 | 3
 |  |  |  |  |  | Mark | 23 |  |  |  |  | 0.71 | 0.9 | 2
 |  |  |  |  |  | [NAME] | 45 |  |  |  |  | 0.91 | 1 | 1
 |  |  |  |  |  | Billy | 65
 |  |  |  |  |  | Scot | 98
 |  | >> Using Vlookup |  |  |  | Name | Marks | Rank | % of Marks
 |  |  |  |  |  | Dennis | 40
 |  |  |  |  |  | Dev | 60
 |  |  |  |  |  | [NAME] | 33
 |  |  |  |  |  | Mark | 23
 |  |  |  |  |  | [NAME] | 45
 |  |  |  |  |  | Billy | 65
 |  |  |  |  |  | Scot | 98
 | >>Rank the student based on the percentile |  |  |  |  | Name | Marks | Rank | Percentile
 |  |  |  |  |  | Dennis | 40
 |  |  |  |  |  | Dev | 60
 |  |  |  |  |  | [NAME] | 33
 |  |  |  |  |  | Mark | 23
 |  |  |  |  |  | [NAME] | 45
 |  |  |  |  |  | Billy | 65
 |  |  |  |  |  | Scot | 98
Spreadsheet: 48468d1247672155-recognize-the-1st-value-on-a-list-and-ignore-the-repeats-excel-help
Sheet: Sheet1

 |  | I haven't figured out a way to do this, but my goal is to
 |  | (ideally) use a "IF" statement that will recognize the 1st "2"
 |  | on the list and ignore the repeats
 |  | Example 1: |  | Variable
 |  |  |  | (either values 1 or 2) |  |  |  | This is the result I'm looking for:
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 2 |  |  |  | Yes
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 2 |  |  |  | No |  |  |  |  |  | Any Suggestions?
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 2 |  |  |  | No
 |  |  |  | 1 |  |  |  | No
 |  | Example 2: |  | Variable
 |  |  |  | (either values 1 or 2) |  |  |  | This is the result I'm looking for:
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 2 |  |  |  | Yes
 |  |  |  | 2 |  |  |  | No
 |  |  |  | 2 |  |  |  | No
 |  |  |  | 1 |  |  |  | No
 |  |  |  | 2 |  |  |  | No
 |  |  |  | 2 |  |  |  | No
Spreadsheet: 684344d1593315665-data-analysis-on-variance-reporting-wanted-maybe-pivot-tables-shifts-and-targets-taranakigirl-
Sheet: Pivot Table

Date | Shift Code | Actual Hours | Required Hours | Day of the week | [NAME] | % Variance
2020-06-01 00:00:00 | A | 63 | 44.49994 | Monday | -18.50006 | 0.293651746031746
 | D | 74 | 48.58339 | Monday | -25.41661 | 0.3434677027027027
 | N | 31.5 | 25.08335 | Monday | -6.416650000000001 | 0.2037031746031747
2020-06-02 00:00:00 | D | 69 | 55.16674 | Tuesday | -13.83326 | 0.2004820289855073
2020-06-03 00:00:00 | N | 43.25 | 34.91672 | Wednesday | -8.333280000000002 | 0.1926769942196532
2020-06-04 00:00:00 | A | 57 | 40.25002 | Thursday | -16.74998 | 0.2938592982456141
 | N | 36 | 19.50001 | Thursday | -16.49999 | 0.4583330555555556
2020-06-05 00:00:00 | A | 49 | 41.22919 | Friday | -7.770809999999997 | 0.1585879591836734
 | N | 31 | 23.83335 | Friday | -7.166650000000001 | 0.2311822580645162
2020-06-06 00:00:00 | A | 65.5 | 49.91667 | Saturday | -15.58333 | 0.2379134351145038
 | D | 61 | 46.33341 | Saturday | -14.66659 | 0.2404359016393443
2020-06-08 00:00:00 | A | 78 | 63.41669 | Monday | -14.58331 | 0.1869655128205128
 | D | 93 | 73.00009 | Monday | -19.99991 | 0.2150527956989248
 | N | 46 | 40.00005 | Monday | -5.999949999999998 | 0.1304336956521739
2020-06-09 00:00:00 | A | 65 | 56.33339 | Tuesday | -8.666609999999999 | 0.1333324615384616
2020-06-10 00:00:00 | A | 70 | 56.00004 | Wednesday | -13.99996 | 0.1999994285714286
 | N | 47 | 37.00002 | Wednesday | -9.99998 | 0.2127655319148937
2020-06-12 00:00:00 | D | 104.5 | 87.66675 | Friday | -16.83325000000001 | 0.1610837320574163
2020-06-13 00:00:00 | A | 65 | 56.58338 | Saturday | -8.416620000000002 | 0.1294864615384616
 | N | 51 | 43.6667 | Saturday | -7.333300000000001 | 0.1437901960784314
2020-06-14 00:00:00 | A | 80 | 64.50004 | Sunday | -15.49996 | 0.1937495
 | D | 93.25 | 80.58342 | Sunday | -12.66658 | 0.1358346380697051
Spreadsheet: 75607d1276152948-summing-totals-by-time-interval-dtel2cs-xfers-03102010-06072010
Sheet: TOTAL BY INTERVAL BY CENTER

 | 74 | 221 | 216 | 511
EASTERN TIME | AUSTIN | CHESAPEAKE | SAN ANTONIO | TOTAL
07:00:00 | 0 | 0 | 2 | 2
07:15:00 | 0 | 0 | 1 | 1
07:30:00 | 0 | 0 | 4 | 4
07:45:00 | 0 | 0 | 1 | 1
08:00:00 | 0 | 2 | 1 | 3
08:15:00 | 0 | 0 | 3 | 3
08:30:00 | 0 | 2 | 5 | 7
08:45:00 | 0 | 6 | 2 | 8
09:00:00 | 0 | 4 | 2 | 6
09:15:00 | 0 | 7 | 2 | 9
09:30:00 | 0 | 5 | 5 | 10
09:45:00 | 1 | 7 | 4 | 12
10:00:00 | 1 | 7 | 3 | 11
10:15:00 | 2 | 4 | 6 | 12
10:30:00 | 1 | 6 | 0 | 7
10:45:00 | 4 | 5 | 1 | 10
11:00:00 | 0 | 4 | 5 | 9
11:15:00 | 2 | 4 | 6 | 12
11:30:00 | 1 | 9 | 4 | 14
11:45:00 | 1 | 9 | 3 | 13
12:00:00 | 0 | 13 | 1 | 14
12:15:00 | 1 | 9 | 4 | 14
12:30:00 | 3 | 5 | 3 | 11
12:45:00 | 1 | 14 | 3 | 18
13:00:00 | 2 | 7 | 2 | 11
13:15:00 | 2 | 6 | 5 | 13
13:30:00 | 1 | 4 | 8 | 13
13:45:00 | 1 | 3 | 5 | 9
14:00:00 | 2 | 3 | 8 | 13
14:15:00 | 2 | 6 | 10 | 18
14:30:00 | 2 | 4 | 7 | 13
14:45:00 | 1 | 5 | 4 | 10
15:00:00 | 3 | 6 | 4 | 13
15:15:00 | 0 | 3 | 4 | 7
15:30:00 | 0 | 6 | 8 | 14
15:45:00 | 2 | 2 | 6 | 10
16:00:00 | 6 | 5 | 4 | 15
16:15:00 | 4 | 6 | 3 | 13
16:30:00 | 1 | 5 | 4 | 10
16:45:00 | 4 | 6 | 4 | 14
17:00:00 | 0 | 2 | 5 | 7
17:15:00 | 1 | 4 | 4 | 9
17:30:00 | 0 | 5 | 2 | 7
17:45:00 | 2 | 4 | 5 | 11
18:00:00 | 2 | 0 | 2 | 4
18:15:00 | 2 | 3 | 2 | 7
18:30:00 | 2 | 1 | 2 | 5
18:45:00 | 0 | 1 | 0 | 1
19:00:00 | 3 | 0 | 4 | 7
19:15:00 | 2 | 0 | 2 | 4
19:30:00 | 2 | 1 | 4 | 7
19:45:00 | 0 | 0 | 3 | 3
20:00:00 | 0 | 1 | 5 | 6
20:15:00 | 1 | 0 | 5 | 6
20:30:00 | 2 | 0 | 5 | 7
20:45:00 | 0 | 0 | 2 | 2
21:00:00 | 1 | 0 | 2 | 3
21:15:00 | 0 | 0 | 3 | 3
21:30:00 | 1 | 0 | 2 | 3
21:45:00 | 0 | 0 | 0 | 0
22:00:00 | 2 | 0 | 0 | 2
22:15:00 | 0 | 0 | 0 | 0
22:30:00 | 0 | 0 | 0 | 0
22:45:00 | 0 | 0 | 0 | 0
23:00:00 | 0 | 0 | 0 | 0
Spreadsheet: 153080d1335759341-index-match-help-example-6-
Sheet: Sheet1

Heading 1 | Division | Heading 3 | Heading 4 | Heading 5 | Heading 6 | Heading 7 | Heading 8 | Heading 9 | Heading 10
A | Y | 86 | 27 | 97 | 76 | 46 | 95 | 40 | 95
A | Y | 88 | 78 | 68 | 13 | 13 | 35 | 27 | 85
A | X | 99 | 23 | 65 | 33 | 56 | 26 | 87 | 64 | DATA SOURCE
A | Y | 17 | 41 | 71 | 37 | 78 | 67 | 28 | 16
A | Z | 91 | 62 | 33 | 84 | 66 | 24 | 43 | 30
A | Z | 39 | 33 | 82 | 57 | 85 | 85 | 97 | 34
A | Z | 51 | 19 | 98 | 74 | 17 | 45 | 77 | 17
A | X | 100 | 89 | 53 | 81 | 83 | 97 | 63 | 86
A | Y | 23 | 70 | 40 | 58 | 14 | 34 | 86 | 24
DIVISION X
Heading 1 | Division | Heading 3 | Heading 4 | Heading 5 | Heading 6 | Heading 7 | Heading 8 | Heading 9 | Heading 10 | DATA OUTCOME
A | X | 99 | 23 | 65 | 33 | 56 | 26 | 87 | 64
A | X | 100 | 89 | 53 | 81 | 83 | 97 | 63 | 86
DIVISION Y
Heading 1 | Division | Heading 3 | Heading 4 | Heading 5 | Heading 6 | Heading 7 | Heading 8 | Heading 9 | Heading 10 | DATA OUTCOME
A | Y | 86 | 27 | 97 | 76 | 46 | 95 | 40 | 95
A | Y | 88 | 78 | 68 | 13 | 13 | 35 | 27 | 85
A | Y | 17 | 41 | 71 | 37 | 78 | 67 | 28 | 16
A | Y | 23 | 70 | 40 | 58 | 14 | 34 | 86 | 24
DIVISION Z
Heading 1 | Division | Heading 3 | Heading 4 | Heading 5 | Heading 6 | Heading 7 | Heading 8 | Heading 9 | Heading 10 | DATA OUTCOME
A | Z | 91 | 62 | 33 | 84 | 66 | 24 | 43 | 30
A | Z | 39 | 33 | 82 | 57 | 85 | 85 | 97 | 34
A | Z | 51 | 19 | 98 | 74 | 17 | 45 | 77 | 17