tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145148d1331316778-combine-formulas-book-2
Sheet: Sheet1

 | Code | Taxability | Function
 | AFN | T | VLOOKUP(F2,'[Classified Function.xls]Sch'!B$6:D$20,3)
 | ALP | NT
 | BEL | T
 | CNP | T
 | CNU | T
 | DEN | T
 | DME & DMT |  | IF(OR(F2="DME   ",F2="DMT   "),IF(SUMPRODUCT(COUNTIF(I12,"*"&Sch!B$25:$B$52&"*"))>0,"NT","T")) |  | 0 |  | #N/A
 | GFT | i) Less than 50: NT                       ii)More than 50 and column G is blank , and column I has “25 year”, “long service”: NT                                iii)Others: T | IF(F2="GFT   ",IF(B12>50,IF(H2=" ",IF(SUMPRODUCT(COUNTIF(I2,"*"&Sch!B$57:B$58&"*"))>0,"NT","T"),"T"),"NT"))
 | GFTVOC | T
 | GFTTOT | i) Less than 50: NT                           ii)250 and more: T                                iii)Others:Analyse | IF(H2="GFTTOT",IF(D2<=50,"NT",IF(D2>=250,"T","")))
 | HBC | NT
 | HTL
 | LHT
 | MSA | T
 | MES | offshore | IF(F2="MES   ",IF(SUMPRODUCT(COUNTIF(I2,"*"&Sch!$B$66:$B$77&"*"))>0,"T",IF(SUMPRODUCT(COUNTIF(I2,"*"&Sch!B$79:B$97&"*"))>0,"NT","")))
 | MSO & MSR |  | IF(OR(F487="MSO   ",F487="MSR   "),IF(SUMPRODUCT(COUNTIF(H487,"*"&Sch!B$100:B$122&"*"))>0,"NT","")) | CONCATENATE(J12," ",[NAME])
 | OTX |  | IF(F2="OTX   ",IF(SUMPRODUCT(COUNTIF(H2,"*"&'[Classified Function.xls]Sch'!B$136:B$144&"*"))>0,"T",IF(SUMPRODUCT(COUNTIF(H2,"*"&'[Classified Function.xls]Sch'!$B$147:$B$156&"*"))>0,"NT",""))) |  |  |  | 0
 | PHL |  | IF(F2="PHL   ",IF(SUMPRODUCT(COUNTIF(I579,"*"&Sch!$B$163:$B$169&"*"))>0,"NT","T")) |  |  | 0
 | POOBIC | NT
 | RAM | T
 | RAU | less than 600: NT | IF(H2="RAU   ",IF(D2<600,"NT","T"))
 | TIP | T
 |  |  |  |  | 0
Spreadsheet: 736568d1623745833-help-finding-data-and-returning-in-vertical-cells-master-lead-time-tracker-1
Sheet: National Lead Time

INSTALL LEAD-TIME TRACKER
Postcode | Installer / Company  Name | Weeks to next available install | Date Installer provided information | Comments | Store Average lead Time
National Lead time average
AB
AL
B
BA
BB
BD
BH
BH
BL
BN
BR
BS
CA
CB
CF
CH
CM
CO
CR
CT
[NAME]
CW
DA
DD
DE
DG
DH
DL
DN
DT
DY
E
EC
EH
EN
EX
FK
FY
G
GL
GU
HA
HD
HG
HP
HR
HS
[NAME]
HX
IG
IP
IV
KA
KT
KW
KY
L
LA
LD
LE
LL
LN
LS
LU
M
ME
MK
ML
N
NE
NG
NN
NP
NR
NW
OL
OX
PA
PE
PH
PL
PO
PR
RG
RH
RM
S
SA
SE
SG
SK
SL
SM
SN
SO
SP
SR
SS
ST
SW
SY
TA
TD
TF
TN
TQ
TR
TS
TW
UB
W
WA
WC
WD
WF
WN
WR
WS
WV
YO
 | Installer A
 | Installer B
 | Insatller C
Spreadsheet: 774830d1648675434-combining-2-countif-formulas-test12
Sheet: Sheet1

 | Type | Status | ID |  |  |  |  |  |  |  |  |  | Expires | Valid | New? | Expected | Old Only
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | RENEWED | 560828464107 |  |  |  |  |  |  |  |  |  | 2021-02-19 12:46:35
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2018-04-06 10:20:51 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2019-09-12 09:35:30 |  |  | New
 | GMP2 | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2021-06-11 10:12:51 |  |  | New
 | GMP | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2023-06-10 09:35:53 |  |  | New
 | GMP | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2020-07-17 10:29:32 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2022-06-27 14:09:07 |  |  | New
 | GMP | ISSUED | 563269721104 |  |  |  |  |  |  |  |  |  | 2023-02-22 10:00:04 |  |  | Old
 | OT | EXPIRED | 563269721104 |  |  |  |  |  |  |  |  |  | 2020-02-08 13:11:40 |  |  | Old
Spreadsheet: 675801d1588499254-create-list-from-non-error-rows-sample01
Sheet: Match

Code1 | Description1 | Code2 | Description2 | Notes
Spreadsheet: 835676d1688718744-task-is-to-get-the-sum-qty-for-each-day-for-each-machine-requirement-line-wise-cpu
Sheet: Sheet2

Module | 07/07/2023 | 07/10/2023 | 07/11/2023 | 07/12/2023 | 07/13/2023 | 07/14/2023 | 07/17/2023 | 07/18/2023 | 07/19/2023 | 07/20/2023 | 07/21/2023 | 07/24/2023 | 07/25/2023 | 07/26/2023 | 07/27/2023
VD001 | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-8LXMYP | PID-5G7LL1 | PID-5G7LL1 | PID-5G7LL1
M/R | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT
QTY | 5722 | 6127 | 5961 | 6123 | 6123 | 6120 | 6124 | 6124 | 6124 | 6124 | 6124 | 6124 | 5770 | 4881 | 4881
VD002 |  |  |  |  |  |  |  |  |  |  |  |  |  | PID-5G7LL1 | PID-5G7LL1
M/R | #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 | US DYE CUT | US DYE CUT
QTY |  |  |  |  |  |  |  |  |  |  |  |  |  | 4881 | 4881
[NAME] | PID-5G7LL1 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-Z9Y5E3 | PID-5G7LL1 | PID-5G7LL1 | PID-5G7LL1 | PID-5G7LL1 | PID-5G7LL1
M/R | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT
QTY | 7214 | 7217 | 7058 | 7058 | 7063 | 7082 | 7087 | 7093 | 7087 | 7087 | 7152 | 7322 | 7322 | 4882 | 4884
VD004 | NB3764 | NB3764 | NB3764 | NB3764 | NB3764 | NB3873 | NB3873 | NB3873 | NB3873 | NB3873 | KE1007 | KE1007 | KE1007 | KE1007 | KE1168
M/R | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US DYE CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT
QTY | 1490 | 1381 | 1653 | 1978 | 1956 | 1981 | 2073 | 2072 | 2071 | 2073 | 1845 | 1718 | 1853 | 1897 | 1622
VD005 | KE1008 | KE1008 | KE1008 | KE1008 | KE1007 | KE1008 | 50475274 | 50475274 | 50475274 | 50475274 | 50475274 | 50475274 | 50475274 | 50475274 | 50475274
M/R | US AUTO CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT | US AUTO CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT | US BOTH CUT
QTY | 1852 | 1853 | 1808 | 1834 | 1827 | 1662 | 1368 | 1353 | 1554 | 1684 | 1713 | 1713 | 1713 | 1713 | 153
MACHINE | 07/07/2023 | 07/10/2023 | 07/11/2023 | 07/12/2023 | 07/13/2023 | 07/14/2023 | 07/17/2023 | 07/18/2023 | 07/19/2023 | 07/20/2023 | 07/21/2023 | 07/24/2023 | 07/25/2023 | 07/26/2023 | 07/27/2023
US BOTH CUT
US AUTO CUT
US DYE CUT
CHOPPER
RR
Spreadsheet: 753072d1635232910-extracting-text-variable-formatted-string-into-two-columns-attempt-to-use-mid-and-right-garden00_sample
Sheet: Sheet1

 |  |  |  |  |  | Desired Return
 |  |  | Visitor | Home |  | Visitor | Home
 |  |  |  |  |  |  | Oklahoma St
 |  |  |  |  |  | N Carolina
 |  |  |  |  |  | St Bonavent | St Louis
 |  |  |  |  |  | Notre Dame | GA Tech
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Miss State | S Carolina
#68 Mt St Mary at #1 Gonzaga |  |  |  |  |  | Mt St Mary
Goal: Return the Visitor and Home Team Name Only in colmn's D and E.  Notice in highlighted cells only portions of the names are returned because I am premising the return based on the space " ".
Hoping there is a formula in each instance (Colmn D and E) that can return based on flexible formating of string (notice varying length and location of  spaces).
Spreadsheet: 798093d1664297695-need-help-combining-the-large-formula-with-finding-the-nth-row-value-tournament-tracker
Sheet: Team Names

Team Name
Pimp the Pinz
It Ain't My Fault
[NAME]
Oh No He Didn't
Team 6
Team 7
Team 8
Team 9
Team 10
Team 11
Team 12
Team 13
Team 14
Team 15
Team 16
Team 17
Team 18
Team 19
Team 20
Team 21
Team 22
Team 23
Team 24
Team 25
Team 26
Team 27
Team 28
Team 29
Team 30
Team 31
Team 32
Team 33
Team 34
Team 35
Team 36
Team 37
Team 38
Team 39
Team 40
Team 41
Team 42
Team 43
Team 44
Team 45
Team 46
Team 47
Team 48
Team 49
Team 50
Team 51
Team 52
Team 53
Team 54
Team 55
Team 56
Team 57
Team 58
Team 59
Team 60
Team 61
Team 62
Team 63
Team 64
Team 65
Team 66
Team 67
Team 68
Team 69
Team 70
Team 71
Team 72
Team 73
Team 74
Team 75
Team 76
Team 77
Team 78
Team 79
Team 80
Team 81
Team 82
Team 83
Team 84
Team 85
Team 86
Team 87
Team 88
Team 89
Team 90
Team 91
Team 92
Team 93
Team 94
Team 95
Team 96
Team 97
Team 98
Team 99
Team 100
Team 101
Team 102
Team 103
Team 104
Team 105
Team 106
Team 107
Team 108
Team 109
Team 110
Team 111
Team 112
Team 113
Team 114
Team 115
Team 116
Team 117
Team 118
Team 119
Team 120
Team 121
Team 122
Team 123
Team 124
Team 125
Team 126
Team 127
Team 128
Team 129
Team 130
Team 131
Team 132
Team 133
Team 134
Team 135
Team 136
Team 137
Team 138
Team 139
Team 140
Team 141
Team 142
Team 143
Team 144
Team 145
Team 146
Team 147
Team 148
Team 149
Team 150
Team 151
Team 152
Team 153
Team 154
Team 155
Team 156
Team 157
Team 158
Team 159
Team 160
Team 161
Team 162
Team 163
Team 164
Team 165
Team 166
Team 167
Team 168
Team 169
Team 170
Team 171
Team 172
Team 173
Team 174
Team 175
Team 176
Team 177
Team 178
Team 179
Team 180
Team 181
Team 182
Team 183
Team 184
Team 185
Team 186
Team 187
Team 188
Team 189
Team 190
Team 191
Team 192
Team 193
Team 194
Team 195
Team 196
Team 197
Team 198
Team 199
Team 200
Spreadsheet: 714201d1611140137-creating-rows-in-another-sheet-based-on-data-one-sheet-problem-2-ans
Sheet: Sheet2-Splitted values

 | STATION | P1 | P2 | P3 | P4 | P5 | P6 | TOTAL
 | NOIDA | 330 | 650 | 790 | 650 | 530 | 200 | 3150
1 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
2 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
3 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
4 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
5 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
6 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
7 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
8 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
9 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
10 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
11 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
12 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
13 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
14 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
15 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
16 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
17 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
18 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
19 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
20 | NOIDA | 10 | 20 | 30 | 30 | 20 | 10
21 | NOIDA | 10 | 20 | 30 | 30 | 20
22 | NOIDA | 10 | 20 | 30 | 20 | 20
23 | NOIDA | 10 | 20 | 30 |  | 20
24 | NOIDA | 10 | 20 | 30 |  | 20
25 | NOIDA | 10 | 20 | 30 |  | 20
26 | NOIDA | 10 | 20 | 30 |  | 20
27 | NOIDA | 10 | 20 | 10 |  | 10
28 | NOIDA | 10 | 20
29 | NOIDA | 10 | 20
30 | NOIDA | 10 | 20
31 | NOIDA | 10 | 20
32 | NOIDA | 10 | 20
33 | NOIDA | 10 | 10
 | DELHI | 230 | 300 | 390 | 300 | 210 | 130 | 1560
1 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
2 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
3 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
4 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
5 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
6 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
7 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
8 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
9 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
10 | DELHI | 10 | 20 | 30 | 30 | 20 | 10
11 | DELHI | 10 | 20 | 30 |  | 10 | 10
12 | DELHI | 10 | 20 | 30 |  |  | 10
13 | DELHI | 10 | 20 | 30 |  |  | 10
14 | DELHI | 10 | 20
15 | DELHI | 10 | 20
16 | DELHI | 10
17 | DELHI | 10
18 | DELHI | 10
19 | DELHI | 10
20 | DELHI | 10
21 | DELHI | 10
22 | DELHI | 10
23 | DELHI | 10
Spreadsheet: 38e5d012-5ebe-4644-802c-a1617bcd7583
Sheet: Draw

Wednesday 31st men's & Womens's
6pm
Field 1 | Black Mountain Bears | vs | [NAME]
Field 2 | NEGS | vs | Sisters
Field 3 | PLC | vs | Touch of allstars
Field 4 | RossBuild | vs | [NAME] Plumbing
Field 6 | Turn It up | vs | ANZ
Ref Duty | [NAME] touching it, High Velocity, oh what a feeling, [NAME] farmstay, Clontarf brumbies
 | Sportsune, Rams, Gladaitors, The Blur, Sportsune
6.45pm
Field 1 | [NAME] touching it | vs | High Velocity
Field 2 | Oh what a feeling | vs | Wattleton farmstay
Field 3 | Clontarf Brumbies | vs | Sportsune
Field 4 | [NAME] | vs | Gladaitors
Field 6 | The Blur | vs | Sportsune
Ref Duty | Black Mountain Bears, pork hunters, NEGS, Sisters, PLC, Touch of allstars
 | Rossbuils, [NAME], turn it up, ANZ
Thursady 1st Mixed
5.45pm
Field 1 | Tropics | vs | [NAME] $7 Snitzels
Field 2 | We not fit | vs | [NAME]
Field 3 | Impies Select | vs | Low Velocity
Field 4 | T-Birds & Pink Ladies | vs | The Goers
Field 5 | The Royal | vs | Tooheys
Field 6 | Rage | vs | [NAME]
Field 7 | Marble Hill Magic | vs | Imperial Invincibles
Ref duty | Flugal Bangers, Parmies, Pan handle Warriors, Mixed lollies, Bullfrogs, Roberts & morrow
Maccas, Supers, GrazAg, Blue Steel, Comets, [NAME], Mix-A-Rabbits, Imperial impacts
6.30pm
Field 1 | Flugal Bangers | vs | Parmies
Field 2 | [NAME] | vs | [NAME]
Field 3 | Bullfrogs | vs | Roberts & Morrow
Field 4 | Maccas | vs | Supers
Field 5 | GrazAg | vs | Blue Steel
Field 6 | Comets | vs | [NAME]
Field 7 | Mix-A-Rabbits | vs | Imperial Impact
Ref Duty | Tropics, St Kilda $[NAME], we not fit, green monkeys, impies select, rage,[NAME]
low velocity. T-birds & pink ladies, the goers, the royal, tooheys, marble hill magic, imperial invincibles
Spreadsheet: 390720d1429737128-dynamic-array-with-index-without-forcing-a-save-sample_wb-jacc
Sheet: Sheet1

a | b | a |  | Row number of last cell with data in Column A | Row number of last cell with data in Column B | Row number of last cell with data in Column C |  | Last row with data | Last Row Containing Blank Data
b | c | b |  | 150 | 152 | 147 |  | 152 | 53
c | a | c |  |  |  |  |  |  | 53
d | b | d
e | c | e
a | d | a |  | Data Validation
b | e | b |  | [NAME] 53
c | a | c
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a | c
d | b | d
e | c | e
a | d | a
b | e | b
c | a
d | b
e | c
 | d
 | e
Spreadsheet: 468726d1467480579-combining-two-worksheets-excel-2016-example-query
Sheet: Sheet1

part no. | random data
1 | random [NAME]
2 | random [NAME]
3 | random [NAME]
4 | random [NAME]
5 | random [NAME]
A1 | random [NAME]
A2 | random [NAME]
A3 | random [NAME]
A4 | random [NAME]
A5 | random [NAME]
Spreadsheet: 348775d1412097825-reorganizing-data-in-excel-rowstocolumns
Sheet: Sheet7

Country | 2004 | 2005 | 2006 |  | Country | Year | Rate
Algeria | 1.2 | 1.3 | 1.4
Ireland | 2.1 | 2.3 | 1.3
Spain | 1.4 | 1.5 | 1.7
Spreadsheet: 876106d1722775429-match-function-compare-numbers-vs2
Sheet: Blad2

Sample A | Sample B | In sample A and Samble B
82827262 | 2882067037
88255202207 | 2882067037
285277224294 | 2882067037
2882067037 | 2882067037
285277224200 | 2882067037
926443230 | 32262204227
24934244242 | 926443230
8429522229 | 32262204227
24934244255 | 32262204227
622339822 | 32262204227
32262237208 | 32262204227
32262224289 | 32262204227
28820677234 | 288206206206
28820670265 | 288206206206
8920025226 | 926443230
892008250 | 926443230
288206222287 | 8920045262
2882066890 | 8920045262
6220568220 | 926443230
285277224292 | 28820670265
26925022868 | 288206220232
28820620962 | 288206220232
28820668223 | 28820673252
8920022225 | 28820673252
28820620794 | 2423222568
8920047292 | 2423222568
32262207222 | 28820676232
288288258235 | 28820676232
28820620322 | 32262245268
28820673278 | 32262245268
89200328 | 32262245268
832325767 | 32262245268
 | 32262245268
 | 3226228633
 | 3226228633
 | 3226220293
 | 3226220293
 | 926443230
 | 926443230
 | 926443230
 | 926443230
 | 926443230
 | 926443230
 | 926443230
 | 8920023265
 | 8920023265
 | 8920023265
 | 926443230
 | 926443230
 | 3226228528
Spreadsheet: 165499d1341250339-vlookup-forumula-that-has-more-than-on-set-search-value-sample-v3
Sheet: Sheet B

Rating Range
0 | 0
0.0025 | 0
0.005 | 0
0.0075 | 0
0.01 | 0
0.0125 | 0
0.015 | 0
0.0175 | 0
0.02 | 0
0.0225 | 0
0.025 | 0
0.0275 | 0
0.03 | 0
0.0325 | 0
0.035 | 0
0.0375 | 0
0.04 | 0
0.0425 | 0
0.045 | 0
0.0475 | 0
0.05 | 0
0.0525 | 0
0.055 | 0
0.0575 | 0
0.06 | 0
0.0625 | 0
0.065 | 0
0.0675 | 0
0.07 | 0
0.0725 | 0
0.075 | 0
0.0775 | 0
0.08 | 0
0.0825 | 0
0.085 | 0
0.0875 | 0
0.09 | 0
0.0925 | 0
0.095 | 0
0.0975 | 0
0.1 | 0
0.1025 | 0
0.105 | 0
0.1075 | 0
0.11 | 0
0.1125 | 0
0.115 | 0
0.1175 | 0
0.12 | 0
0.1225 | 0
0.125 | 0
0.1275 | 0
0.13 | 0
0.1325 | 0
0.135 | 0
0.1375 | 0
0.14 | 0
0.1425 | 0
0.145 | 0
0.1475 | 0
0.15 | 0
0.1525 | 0
0.155 | 0
0.1575 | 0
0.16 | 0
0.1625 | 0
0.165 | 0
0.1675 | 0
0.17 | 0
0.1725 | 0
0.175 | 0
0.1775 | 0
0.18 | 0
0.1825 | 0
0.184999999999999 | 0
0.1875 | 0
0.19 | 0
0.1925 | 0
0.194999999999999 | 0
0.197499999999999 | 0
0.199999999999999 | 0
0.202499999999999 | 0
0.204999999999999 | 0
0.207499999999999 | 0
0.209999999999999 | 7
0.212499999999999 | 7
0.214999999999999 | 7
0.217499999999999 | 7
0.219999999999999 | 7
0.222499999999999 | 7
0.224999999999999 | 7
0.227499999999999 | 7
0.229999999999999 | 7
0.232499999999999 | 7
0.234999999999999 | 7
0.237499999999999 | 7
0.239999999999999 | 10
0.242499999999999 | 10
0.244999999999999 | 10
0.247499999999999 | 10
0.249999999999999 | 10
0.252499999999999 | 10
0.254999999999999 | 10
0.257499999999999 | 10
0.259999999999999 | 10
0.262499999999999 | 10
0.264999999999999 | 10
0.267499999999999 | 10
0.269999999999999 | 12
0.272499999999999 | 12
0.274999999999999 | 12
0.277499999999999 | 12
0.279999999999999 | 12
0.282499999999999 | 12
0.284999999999999 | 12
0.287499999999998 | 12
0.289999999999998 | 12
0.292499999999998 | 12
0.294999999999998 | 12
0.297499999999998 | 12
0.299999999999998 | 15
0.302499999999998 | 15
0.304999999999998 | 15
0.307499999999998 | 15
0.309999999999998 | 15
0.312499999999998 | 15
0.314999999999998 | 15
0.317499999999998 | 15
0.319999999999998 | 15
0.322499999999998 | 15
0.324999999999998 | 15
0.327499999999998 | 15
0.329999999999998 | 15
0.332499999999998 | 15
0.334999999999998 | 15
0.337499999999998 | 15
0.339999999999998 | 15
0.342499999999998 | 15
0.344999999999998 | 15
0.347499999999998 | 15
0.349999999999998 | 15
0.352499999999998 | 15
0.354999999999998 | 15
0.357499999999998 | 15
0.359999999999998 | 15
0.362499999999998 | 15
0.364999999999998 | 15
0.367499999999998 | 15
0.369999999999998 | 15
0.372499999999998 | 15
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 33 | 33
Index | 3248 | 1395 | 4643
Asia | - | 81 | 81
Europe | 1423 | 550 | 1973
North America | 1762 | 675 | 2437
Other | 63 | 89 | 152
Other | 19 | 141 | 160
Exotic | - | - | -
Swaptions | 19 | 138 | 157
Total Return Swap | - | 3 | 3
TOTAL | 3267 | 1569 | 4836
Spreadsheet: 748739d1632320073-work-out-daily-amount-to-target-31-day-figures
Sheet: 18th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: For Lang 2

 |  |  | 11-12 |  |  |  |  | 11-12 Total | 12-13 |  |  |  |  | 12-13 Total | 13-14 |  |  |  |  | 13-14 Total
Major | [NAME] | CrseNum | A | B | C | D | F |  | A | B | C | D | F |  | A | B | C | D | F
Foreign [NAME] 6-12 | SPAN | 302 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  | 312 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  | 315 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
Foreign [NAME] 6-12 Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | 3
Spreadsheet: 152841d1335548031-vlookup-or-something-else-book2
Sheet: Sheet1

 | Vendor | Approved By |  |  | Vendor | Approved by
 | Xxyy | [NAME] |  |  | Abcd
 | Abcd | [NAME]
 | PPll | [NAME]
 | [NAME] | [NAME]
 | Xxyy | [NAME]
 | Wxrt | [NAME]
 | Abcd | [NAME]
Spreadsheet: 56c2309c-3d0e-442d-bc4f-3782e648493a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7846 | 58946 | [NAME] | Smith | GBR | 184 | [NAME] | 00:02:04 | 01:33:51 | 00:01:46 | 00:52:23 | 1 | 02:49:33
7846 | 58947 | Dearbhla | Breen | GBR | 183 | 00:23:16 | 00:02:59 | 01:51:17 | 00:02:09 | 00:56:00 | 2 | 03:15:39
Spreadsheet: 763380d1642148811-attendance-calculation-book_shiva
Sheet: Sheet1

Location |  | Shifts |  |  | Name1 | Amount1 | [NAME] | Amount2 | Name3 | Amount3 | Name4 | Amount4 | Name5 | Amount5 |  |  | Attendance | Total Amount
[NAME] | 2021-12-01 00:00:00 | Shift-1 | 50 | 22 | M | 100 | N | 600 | O | 600 | P | 600 | Q | 400 |  | M
[NAME] |  | Shift-2 | 45 | 17 | M | 200 | N | 400 | O | 400 | P | 200 | Q | 100 |  | N
XYZ-02 | 2021-12-01 00:00:00 | Shift-1 | 0 | 1 | M | 100 | N | 500 | O | 250 | P | 480 | Q | 200 |  | O
XYZ-02 |  | Shift-2 | 0 | 1 | M | 200 | N | 140 | O | 350 | P | 300 | Q | 100 |  | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q
Spreadsheet: 686257d1594465140-exporting-specific-columns-of-data-based-on-rand-columns-newworkbookname
Sheet: Sheet1

Random 1 | Random 2 | Random 3 | List 1 | List 2
 |  |  | Apples | Fruit
 |  |  | [NAME] | Vegetables
 |  |  | Shirt | Clothings
 |  |  | Table | Furniture
 |  |  | Computer | Electronics
Spreadsheet: 454371d1459813679-looking-for-some-help-with-a-function-sample-knife-setups
Sheet: Sheet1

Sample knife setup for slitter
Target |  |  | Target |  |  | Knife Spacers
Spacers | 0.4 |  | Spacers | 0.2 |  | 0.03
 | 0.2 |  |  | 0.155 |  | 0.05
 | 0.03 |  |  | 0.03 |  | 0.14
 | 0.03 |  |  |  |  | 0.155
 |  |  |  |  |  | 0.175
 |  |  |  |  |  | 0.2
Total |  |  | Total |  |  | 0.22
 |  |  |  |  |  | 0.25
 |  |  |  |  |  | 0.28
 |  |  |  |  |  | 0.4
Target |  |  | Target |  |  | 0.465
 |  |  |  |  |  | 0.5
Spacers | 0.9 |  | Spacers | 0.5 |  | 0.517
 | 0.517 |  |  | 0.28 |  | 0.575
 | 0.22 |  |  | 0.155 |  | 0.6325
 |  |  |  |  |  | 0.67
 |  |  |  |  |  | 0.71
 |  |  |  |  |  | 0.761
Total |  |  | Total |  |  | 0.797
 |  |  |  |  |  | 0.832
 |  |  |  |  |  | 0.9
 |  |  |  |  |  | 0.95
 |  |  |  |  |  | 1