tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 752404d1634743241-index-match-horizontal-and-vertical-array-book2
Sheet: Sheet2

Switzerland | Benelux | CEE | CKA | France | Germany | Iberia | Italy | Nordic | UK/Ireland
 | Belgium | Croatia |  |  | Germany | Portugal |  | Sweden | Ireland
 | Luxembourg | Czech Republic |  |  | Austria | Spain |  | Denmark | United Kingdom
 | Netherlands | Greece |  |  |  |  |  | Finland
 |  | Latvia |  |  |  |  |  | Norway
 |  | Poland
 |  | Romania
 |  | Russia
 |  | Slovenia
 |  | Turkey
 |  | Ukraine
 |  | Hungary
 |  | Estonia
Spreadsheet: 449212d1457055359-breaks-lunch-counter-copy-of-breakscounterv2
Sheet: Sheet2

DATE | NAME | FIRST BREAK | LUNCH | SECOND BREAK | End 1st Break | End Lunch | End 2nd Break |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 |  | 23:30:00 | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00
2016-03-03 00:00:00 | Name 1 | 13:30:00 | 15:45:00
2016-03-03 00:00:00 | Name 2 | 14:55:00 | 11:30:00
2016-03-03 00:00:00 | Name 3 | 15:30:00 | 09:01:00 | 16:45:00
2016-03-03 00:00:00 | Name 4 | 23:50:00 | 14:50:00
2016-03-03 00:00:00 | Name 5
2016-03-03 00:00:00 | Name 6
2016-03-03 00:00:00 | Name 7
2016-03-03 00:00:00 | Name 8
2016-03-03 00:00:00 | Name 9
2016-03-03 00:00:00 | Name 10
2016-03-03 00:00:00 | Name 11
2016-03-03 00:00:00 | Name 12
2016-03-03 00:00:00 | Name 13
2016-03-03 00:00:00 | Name 14
2016-03-03 00:00:00 | Name 15
Spreadsheet: 149749d1334114494-sales-comparisson-2011-and-2012-sales-comparisson
Sheet: Sheet1

 | Hi
 | I want to put all the information in just one [NAME] (in my case Tab # 1)
 | It is a sales comparisson 2011 and 2012.
 | Tab # 1 is what i am looking as result --> (Tab # 2 , Tab # 3 = Tab # 1)
 | I prefer not to use a Macro.
 | 1- What is the formula in each cell painted in yellow ?
 | I want to keep the order of the metals as shown
 | 2- What is the formula in each cell painted in grenn ?
 | Thanks
 | [NAME]
 | in tab # 2
 | Metal | 2011 January | 2011 February
 | Iron | AAA | DDD
 | Zinc | BBB | EEE
 | Cooper | CCC | FFF
 | in tab # 3
 | Metal | 2012 January | 2012 February
 | Cooper | 22 | 66
 | Gold | 33 | 77
 | Silver | 44 | 88
 | Zinc | 55 | 99
 | in tab # 1 ( result)
 | Metal | 2011 January | 2012 January | 2011 February | 2012 February
 | Iron | AAA |  | DDD
 | Zinc | BBB | 55 | EEE | 99
 | Cooper | CCC | 22 | FFF | 66
 | Gold |  | 33 |  | 77
 | Silver |  | 44 |  | 88
Spreadsheet: 762834d1641842871-how-to-use-if-or-something-else-to-insert-a-value-based-on-percentage-of-change-file2
Sheet: Sheet1

Deposit | 100
Rate | 0.015
Units | 0.01 | 0.1
 |  |  | Transaction No. | Deposit | Rate | Final Deposit | Units
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 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
 |  |  | 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
Spreadsheet: 136110d1326409076-take-data-from-one-sheet-to-another-depending-on-date-selected-test
Sheet: Historic Daily Data

Date | SLA 1 | SLA 2 | SLA 3
2012-01-01 00:00:00 | 0.1 | 1 | 21
2012-01-02 00:00:00 | 0.15 | 0.95 | 23
2012-01-03 00:00:00 | 0.2 | 0.9 | 25
2012-01-04 00:00:00 | 0.25 | 0.85 | 27
2012-01-05 00:00:00 | 0.3 | 0.8 | 29
2012-01-06 00:00:00 | 0.35 | 0.75 | 31
2012-01-07 00:00:00 | 0.4 | 0.7 | 33
2012-01-08 00:00:00 | 0.45 | 0.65 | 35
2012-01-09 00:00:00 | 0.5 | 0.6 | 37
2012-01-10 00:00:00 | 0.55 | 0.55 | 39
2012-01-11 00:00:00 | 0.6 | 0.5 | 41
2012-01-12 00:00:00 | 0.65 | 0.45 | 43
2012-01-13 00:00:00 | 0.7 | 0.399999999999999 | 45
2012-01-14 00:00:00 | 0.75 | 0.349999999999999 | 47
2012-01-15 00:00:00 | 0.8 | 0.299999999999999 | 49
Spreadsheet: 0066fdeb-b94f-4cba-b321-21e197ec9492
Sheet: Sheet1

Commodity Complaint Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Utah Child Nutrition Program
USDA Food Distribution Program
Fax or mail completed form to: |  | [PHONE]
 |  | Child Nutrition Programs
 |  | P.O. Box 144200
 |  | Salt Lake City, UT 84114-4200
**Commodity Name: |  |  |  |  | Commodity Code:
** One commodity per report
 |  |  |  |  |  |  | page 1
Complainant Name: |  |  |  |  | [NAME]
Telephone: |  |  |  |  | Fax:
Complainant e-mail:
Recipient Agency:
Address:
City, State, Zip:
Incident Date:
Date of Receipt:
Amount Received: |  |  |  |  | Amount affected:
Amount Remaining:
Street address of              remaining product:
Vendor: |  |  |  |  |  | provide information if available
Contract #:
DO #:
N/D #:
Pack Date:
Box #:
Lot #:
Can Codes:
Select all that apply: | page 2
Quality of Product: |  | Taste/Order |  |  | Excess liquid by volume
 |  | Mold |  |  | Defects
 |  | Appearance/Color |  |  | Other _____________________________________
Foreign material in product: |  | Bones |  |  | [NAME]
 |  | Insect/Insect parts |  |  | Stems, Leaves, etc.
 |  | Rock |  |  | Plastic
 |  | Metal/Machine Parts |  |  | Other _____________________________________
 |  |  |  |  | include measurements of foreign objects in inches
If the problem is foreign material in product, please mail the foreign object, or email a digital picture of it.
Packaging condition: |  | Cans dented beyond use |  |  | Corrosion in cans
 |  | Leaking cans |  |  | Bag tear/pin holes
 |  | Possible evidence of tampering |  |  | Bulging cans
 |  | Exposure to contaminant |  |  | Not properly sealed
 |  | Other _____________________________________
Cooking or preparation issues: |  | Wrong color when cooked |  |  | Excess breading
 |  | Product does not perform well |  |  | Undersooked
 |  | Other _____________________________________
Commodity caused: |  | Allergic reaction |  |  | Injury
 |  | Illness |  |  | Other _____________________________________
What resolution is sought? |  | replacement |  |  | isolated incident
 |  | information only |  |  | other (specify)
 |  | vendor response
Signature of Authorized Representative |  |  |  |  | Title
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 8b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | - | 1 | - | 8 | 2 | - | - | 11
Cap/Floor | 12 | 5 | - | 53 | - | - | - | 70
Debt Option | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | -
Fixed-Fixed | - | - | 1 | 3 | - | - | - | 4
Fixed-Float | 997 | 4842 | 210 | 4420 | 357 | 176 | 294 | 11296
FRA | 20 | 1 | - | 17 | 13 | 5 | 26 | 82
Inflation | 19 | 3 | - | 12 | 1 | - | - | 35
OIS | 9 | 3 | - | 5 | 4 | 2 | 35 | 58
Swaption | 63 | 12 | 33 | 159 | 2 | 5 | 30 | 304
TOTAL | 1120 | 4867 | 244 | 4677 | 379 | 188 | 385 | 11860
Spreadsheet: 763317d1642100305-value-of-every-nth-row-in-a-column-every-nth-row
Sheet: Sheet1

Data |  | Desired Results
 |  |  | 17 | 17
 |  |  | 87 | 87
 |  |  | 45 | 45
 |  |  | 6 | 6
14
17
87
45
6
Spreadsheet: 545118d1509282991-can-anyone-help-on-this-golf-scorecard-challenge-scorecard
Sheet: Course 1

School | Player | Hole | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Out | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total | -2 | -1 | 0 | +1 | +2
 |  | Yard | 291 | 381 | 190 | 377 | 124 | 304 | 563 | 419 | 491 |  | 364 | 337 | 595 | 347 | 419 | 193 | 460 | 180 | 368
 |  | Par | 4 | 4 | 3 | 4 | 3 | 4 | 5 | 4 | 5 |  | 4 | 4 | 5 | 4 | 4 | 3 | 5 | 3 | 4
School 1 | Arvay, [NAME] | Score | 1 |  |  |  |  |  |  |  |  |  | 1
 |  | Point | 2 |  |  |  |  |  |  |  |  |  | 2
School 1 | Atkins, Merne | Score | 3 |  |  |  |  |  |  |  |  |  | 3
 |  | Point | 4 |  |  |  |  |  |  |  |  |  | 4
School 1 | Bailey, Victor | Score | 5 |  |  |  |  |  |  |  |  |  | 5
 |  | Point | 6 |  |  |  |  |  |  |  |  |  | 6
School 1 | Bell, Jermaine | Score | 7 |  |  |  |  |  |  |  |  |  | 7
 |  | Point | 8 |  |  |  |  |  |  |  |  |  | 8
School 2 | Bonin, [NAME] | Score | 9 |  |  |  |  |  |  |  |  |  | 9
 |  | Point | 10 |  |  |  |  |  |  |  |  |  | 10
School 2 | Bousfield, Rita | Score | 11 |  |  |  |  |  |  |  |  |  | 11
 |  | Point | 12 |  |  |  |  |  |  |  |  |  | 12
School 2 | Bradley, [NAME] | Score | 13 |  |  |  |  |  |  |  |  |  | 13
 |  | Point | 14 |  |  |  |  |  |  |  |  |  | 14
School 2 | Brethet, Lana | Score | 15 |  |  |  |  |  |  |  |  |  | 15
 |  | Point | 16 |  |  |  |  |  |  |  |  |  | 16
School 3 | Bryant, [NAME] | Score | 17 |  |  |  |  |  |  |  |  |  | 17
 |  | Point | 18 |  |  |  |  |  |  |  |  |  | 18
School 3 | Callan, [NAME] | Score | 19 |  |  |  |  |  |  |  |  |  | 19
 |  | Point | 20 |  |  |  |  |  |  |  |  |  | 20
School 3 | Childs, Marion | Score | 21 |  |  |  |  |  |  |  |  |  | 21
 |  | Point | 22 |  |  |  |  |  |  |  |  |  | 22
School 3 | Cortez, [NAME] | Score | 23 |  |  |  |  |  |  |  |  |  | 23
 |  | Point | 24 |  |  |  |  |  |  |  |  |  | 24
School 4 | Curtis, Bradley | Score | 25 |  |  |  |  |  |  |  |  |  | 25
 |  | Point | 26 |  |  |  |  |  |  |  |  |  | 26
School 4 | Dales, [NAME] | Score | 27 |  |  |  |  |  |  |  |  |  | 27
 |  | Point | 28 |  |  |  |  |  |  |  |  |  | 28
School 4 | [NAME], [NAME] | Score | 29 |  |  |  |  |  |  |  |  |  | 29
 |  | Point | 30 |  |  |  |  |  |  |  |  |  | 30
School 4 | Barton, Cliff | Score | 31 |  |  |  |  |  |  |  |  |  | 31
 |  | Point | 32 |  |  |  |  |  |  |  |  |  | 32
Spreadsheet: 290156d1389804304-moving-target-item-match-between-two-sheets-itemmatchsheet
Sheet: Sheet2

 | QOH ON Hand | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00
ITEM1 | 18 | 16 | 8 | 18 | 28 | 43 | 33 | 38 | 30 | 31 | 11 | 14 | 288
ITEM2
ITEM3
ITEM4 | 18 | 16 | 8 | 18 | 28 | 43 | 33 | 38 | 30 | 31 | 11 | 14 | 288
ITEM5
ITEM6
ITEM7
ITEM8
ITEM9 | 76 | 91 | 58 | 59 | 135 | 141 | 71 | 75 | 75 | 92 | 62 | 70 | 1005
ITEM10
ITEM11
ITEM12
ITEM13
ITEM14 | 11 | 34 | 7 | 9 | 68 | 173 | 22 | 7 | 10 | 16 | 26 | 5 | 388
ITEM15
ITEM16
ITEM17
ITEM18
ITEM19
ITEM20 | 1736 |  |  |  |  |  |  |  |  |  |  |  | 1736
ITEM21 | 200 | 262 | 512 | 225 | 137 | 370 | 250 | 502 | 493 | 545 | 393 | 235 | 4124
ITEM22
ITEM23
Spreadsheet: 686111d1594368421-to-return-values-based-on-criteria-sample
Sheet: Sheet1

Input | 1 |  |  |  | A |  |  |  |  |  | Output | 1 |  |  |  | A | 1,2,3,4,G1,F1
 | 2 |  |  |  | A |  |  |  |  |  |  | 2 |  |  |  | A | 1,2,3,4,G1,F1
 | 3 |  |  |  | A |  |  |  |  |  |  | 3 |  |  |  | A | 1,2,3,4,G1,F1
 | 4 |  |  |  | A |  |  |  |  |  |  | 4 |  |  |  | A | 1,2,3,4,G1,F1
 | [NAME] |  |  |  | A |  |  |  |  |  |  | [NAME] |  |  |  | A | 1,2,3,4,G1,F1
 | G2 |  |  |  | B |  |  |  |  |  |  | G2 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | G3 |  |  |  | B |  |  |  |  |  |  | G3 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | G4 |  |  |  | B |  |  |  |  |  |  | G4 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | G5 |  |  |  | B |  |  |  |  |  |  | G5 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | F1 |  |  |  | A |  |  |  |  |  |  | F1 |  |  |  | A | 1,2,3,4,G1,F1
 | F2 |  |  |  | B |  |  |  |  |  |  | F2 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | F3 |  |  |  | B |  |  |  |  |  |  | F3 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | 7 |  |  |  | B |  |  |  |  |  |  | 7 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | 7 |  |  |  | B |  |  |  |  |  |  | 7 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | 7 |  |  |  | B |  |  |  |  |  |  | 7 |  |  |  | B | G2,G3,G4,G5,F2,F3,7,Z3
 | 7 |  |  |  | C |  |  |  |  |  |  | 7 |  |  |  | C
 | Z1 |  |  |  | C |  |  |  |  |  |  | Z1 |  |  |  | C
 | [NAME] |  |  |  | C |  |  |  |  |  |  | [NAME] |  |  |  | C
 | Z3 |  |  |  | B |  |  |  |  |  |  | Z3 |  |  |  | B
Spreadsheet: 157539d1337785849-want-to-count-number-of-student-grades-in-each-group-and-subject-assessment_2011-12_1
Sheet: Dashboard

 | SUBJECT: | English Language
 | Teacher | Group | A* | A | B | C | D | E | F | G | U | TOTAL
 |  |  |  | 2 | 7 | 17 | 3
Spreadsheet: kevin_hyatt__19598__Derailment data
Sheet: Budgeted

Transwestern Pipeline Company
Train Derailment Oct/Nov 2000
Volume Information - Budgeted
(000) MMBtu
Month |  | West | [NAME] | San Juan | East
Demand Volumes
2000-10-01 00:00:00 |  | 1128.9 | 538.5 | 469 | 695.9
2000-11-01 00:00:00 |  | 1105.9 | 538.5 | 469 | 695.9
Commodity Volumes
2000-10-01 00:00:00 |  | 940 | 438.7 | 459.6 | 393.2
2000-11-01 00:00:00 |  | 1000 | 438.7 | 459.6 | 393.2
Spreadsheet: 220083d1363049486-function-like-vlookup-that-can-be-used-to-lookup-sequential-values-based-on-same-criteria-example-9-
Sheet: Sheet2

Spell List
Spreadsheet: 160322d1339049484-comparing-a-certain-number-of-text-in-a-different-worksheet-sample
Sheet: Sheet1

72ND SCIENTIFIC SESSIONS AMERICAN D
79 SOUTH CHINA IMPORT INC.
834TH US ARMY TRANS BATALLION
A   B WIPER SUPPLY INC.
A.G. [NAME] BRASIL
A.HARTRODT CANADA LTD.2355
A.J. HENDRIKS & SONS GREENHOUSES IN
A.PACIFIC EXPRESS ENTERPRISES
A.S. MILL PRODUCTS INC.
A.W. Faber-Castell USA, Inc.
A.W.R INC
A1 GRANITE LTD.
AAVANTI INDUSTRIES PTE., LTD
AB MAURI FOOD INC
ABA PACKAGING CORPORATION
ABASTOS TELENO S.A. DE C.V.
ABBOTS JEWELLERY   PERFUMERY
ABBOTT NUTRITION
ABC NEW YORK CORP.
[NAME] AND MOPS
ABE JANITORIAL SUPPLY INC
Spreadsheet: andy_zipper__191__Global_Prod 5-22-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
Credit Dflt Swap BMW AG                  5 Years         bpa/USDm
Credit Dflt Swap DaimlerChrysler         5 Years         bpa/USDm
Credit Dflt Swap Fiat SpA                5 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           5 Years         bpa/USDm
Credit Dflt Swap Vattenfall              5 Years         bpa/USDm
Credit Dflt Swap Volkswagen              5 Years         bpa/USDm
Credit Dflt Swap Volvo                   5 Years         bpa/USDm
Gasoil CIF Med   Platts Hi               Jun01           USD/mt
SG Dub Time Spd  Platts                  Q3 01 v Q4 01   USD/bl/m
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
US Crude Fin Opt NYMEX WTI    EC30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC30.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC31.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC32.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC32.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC33.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP27.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP28.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP28.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP29.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP29.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.5     Jul01           USD/bl/m
US METH FOB Phy  Houston                 Jun01           USD/Gl-b
US METH FOB Phy  Houston                 May01           USD/Gl-b
US Methanol Swap ICIS-LOR                Jul01           USD/Gl-b
US Methanol Swap ICIS-LOR                Jul-Sep01       USD/Gl-b
US Prop Swap     OPIS MB TET             Jan-Mar02       c/Gl-b
US WTI [NAME] 01      USD/bbl
US WTI Index     Calendar                Jul01           USD/bl/d
US WTI Swap      Nymex PEN               Jun01           USD/bl/m
Spreadsheet: 684447d1593369710-how-to-coerce-array-passed-to-rank-function-rank_if_problem
Sheet: Sheet1

 |  | row by row |  |  | spilled
Data |  | Data >0 | Rank |  | Data >0 | Rank |  | As 1 formula | Replace F3# by the respective formula |  |  |  | Alternative Rank(IF ?
10 |  |  |  |  |  |  |  |  | Why does this result in an error? |  |  |  |  | [NAME]:A33>0,A3:A33) can be properly evaluated
27 |  |  |  |  | 27 | 2 |  | #[NAME]! |  |  |  |  | #[NAME]! | But passing this to the rank function results in an error, too.
20 |  |  |  |  | 20 | 9 |  | #[NAME]! |  |  |  |  | #[NAME]!
3 |  |  |  |  | 3 | 26 |  | #[NAME]! |  |  |  |  | #[NAME]!
11 |  |  |  |  | 11 | 15 |  | #[NAME]! |  |  |  |  | #[NAME]!
0 |  |  |  |  | False | False |  | False |  |  |  |  | #[NAME]!
8 |  |  |  |  | 8 | 20 |  | #[NAME]! |  |  |  |  | #[NAME]!
9 |  |  |  |  | 9 | 19 |  | #[NAME]! |  |  |  |  | #[NAME]!
10 |  |  |  |  | 10 | 16 |  | #[NAME]! |  |  |  |  | #[NAME]!
2 |  |  |  |  | 2 | 28 |  | #[NAME]! |  |  |  |  | #[NAME]!
5 |  |  |  |  | 5 | 24 |  | #[NAME]! |  |  |  |  | #[NAME]!
26 |  |  |  |  | 26 | 3 |  | #[NAME]! |  |  |  |  | #[NAME]!
23 |  |  |  |  | 23 | 6 |  | #[NAME]! |  |  |  |  | #[NAME]!
26 |  |  |  |  | 26 | 3 |  | #[NAME]! |  |  |  |  | #[NAME]!
8 |  |  |  |  | 8 | 20 |  | #[NAME]! |  |  |  |  | #[NAME]!
8 |  |  |  |  | 8 | 20 |  | #[NAME]! |  |  |  |  | #[NAME]!
16 |  |  |  |  | 16 | 11 |  | #[NAME]! |  |  |  |  | #[NAME]!
16 |  |  |  |  | 16 | 11 |  | #[NAME]! |  |  |  |  | #[NAME]!
29 |  |  |  |  | 29 | 1 |  | #[NAME]! |  |  |  |  | #[NAME]!
16 |  |  |  |  | 16 | 11 |  | #[NAME]! |  |  |  |  | #[NAME]!
2 |  |  |  |  | 2 | 28 |  | #[NAME]! |  |  |  |  | #[NAME]!
4 |  |  |  |  | 4 | 25 |  | #[NAME]! |  |  |  |  | #[NAME]!
17 |  |  |  |  | 17 | 10 |  | #[NAME]! |  |  |  |  | #[NAME]!
21 |  |  |  |  | 21 | 8 |  | #[NAME]! |  |  |  |  | #[NAME]!
7 |  |  |  |  | 7 | 23 |  | #[NAME]! |  |  |  |  | #[NAME]!
0 |  |  |  |  | False | False |  | False |  |  |  |  | #[NAME]!
23 |  |  |  |  | 23 | 6 |  | #[NAME]! |  |  |  |  | #[NAME]!
14 |  |  |  |  | 14 | 14 |  | #[NAME]! |  |  |  |  | #[NAME]!
10 |  |  |  |  | 10 | 16 |  | #[NAME]! |  |  |  |  | #[NAME]!
25 |  |  |  |  | 25 | 5 |  | #[NAME]! |  |  |  |  | #[NAME]!
3 |  |  |  |  | 3 | 26 |  | #[NAME]! |  |  |  |  | #[NAME]!
Spreadsheet: 701969d1604020312-number-of-days-it-took-a-stock-to-rise-sink-above-a-certain-level-file1
Sheet: Sheet1

STOCK | LAST | LOW | HIGH | DIF | CLOSE | DATE | BUY | SELL | 1 | 2 | 3 | 5 | 10 | 1 | 2 | 3 | 5 | 10
AAP | 155.5 | 151.66 | 156.35 |  | 152.24 | 2020-10-05 00:00:00 |  |  |  |  |  |  |  | 8 | 14 | 17 | 23
AAP | 155.16 | 155.06 | 160.775 |  | 160.26 | 2020-10-06 00:00:00 |  |  | 1 | 1 | 1
PNRG | 67.06 | 67.06 | 72.4 | 5.340000000000003 |  | 2020-09-23 00:00:00
ATRI | 626 | 626 | 633.35 |  | 628.68 | 2020-09-30 00:00:00
BH/A | 487.797 | 487.797 | 500 |  | 490 | 2020-09-30 00:00:00
CTApB | 103.5 | 103.5 | 107.54 |  | 105.7 | 2020-09-30 00:00:00
#1 - find this stock in 'file 2' |  |  |  |  |  | #2 - find the date AFTER this date in 'file 2' | #3 - this determines whether to sell/buy the stock. Whichever value is lowest determines this. |  | BUY |  |  |  |  | SELL
 |  |  |  |  |  |  |  |  | #4 - This is how many days AFTER the date in Column G that it took for the stock to sell/buy from the price in Column B. These are taken from 'file 2'. You can see that it took 1 day for the stock to rise above $1-$3, but it never rose above $5. |  |  |  |  | You can see that it took 8 days for the stock to sink below $1 and 14 days to sink below $3, but it never rose above $10.  ALSO, I was wondering if its possible to combine the buy/sell columns and just use Conditional Formatting to tell the difference?
Spreadsheet: 456070d1460630617-using-index-on-dates-book2
Sheet: Sickness

 | NAME | OPS NUMBER | DATE | REASON | LAST DATE OFF | DAYS | WORK DAYS |  | OPS NUMBER | DATE | WORK DAYS | BRADFORD
 | jo1 | 312 | 2016-01-01 00:00:00 |  | 2016-01-01 00:00:00 |  | 1 |  | 312
 | [NAME] | 311 | 2016-01-02 00:00:00 |  | 2016-01-03 00:00:00 |  | 1 |  |  | 2016-02-02 00:00:00
 | jo1 | 312 | 2016-02-02 00:00:00 |  | 2016-02-04 00:00:00 |  | 2 |  | enter ops number into j2 to pull in dates
 | jo1 | 312 | 2016-03-01 00:00:00 |  | 2016-03-03 00:00:00 |  | 3
 | jo1 | 312 | 2016-04-01 00:00:00 |  | 2016-04-05 00:00:00 |  | 4
 | [NAME] | 311 | 2016-02-01 00:00:00 |  | 2016-02-03 00:00:00 |  | 3
 | [NAME] | 311 | 2016-04-02 00:00:00 |  | 2016-04-07 00:00:00 |  | 4
 | jo3 | 313 | 2016-01-01 00:00:00 |  | 2016-01-05 00:00:00 |  | 4
 |  |  |  |  |  |  |  |  | Column K  only pulling in 2 dates, should be 4
Spreadsheet: 160948d1339334056-matching-when-values-are-in-several-possible-columns-match-example
Sheet: Sheet1

Observation |  |  |  | Bird |  |  |  |  | Observation
2012-03-12 00:00:00 | Habitat | Location |  | Metal | Plastic 1 | Plastic 2 | Plastic 3 |  | 2012-03-12 00:00:00 | Habitat | Location
GW;A2 | KP | S46 53.913 E37 53.773 |  | 6-48757 | YB;AJJ | [NAME]
[NAME] | KP | S46 53.091 E37 52.099 |  | 6-48759 | GW;CS
GW;AC | C | S46 53.694 E37 52.812 |  | 6-48765 | GW;HV | GW;MO
GW;AD | C | S46 53.691 E37 52.704 |  | 6-48766 | GW;DG
GW;MO | C | S46 53.694 E37 52.812 |  | 6-48775 | GW;H5 | GW;LU
GW;AP | SS | S46 53.903 [NAME] 53.745 |  | 6-48929 | YB;AAU
GW;AV | KP | S46 53.913 E37 53.773 |  | 6-55464 | YB;AAA
GW;B8 | KP | S46 53.091 E37 52.099 |  | 6-55465 | GW;A1 | YB;AJA | YB;ALJ
GW;BK | C | S46 52.777 [NAME] 52.011 |  | 6-55466 | GW;A2 | YB;AJI
GW;BP | KP | S46 53.091 E37 52.099 |  | 6-55467 | GW;A3
GW;CC | KP | S46 53.913 E37 53.773 |  | 6-55468 | [NAME] | GW;L8
GW;CI | KP | S46 53.913 E37 53.773 |  | 6-55469 | GW;A5 | [NAME]
GW;CL | C | S46 53.275 E37 52.295 |  | 6-55470 | YB;AAM | YB;ALA
GW;CU | C | S46 53.393 E37 52.528 |  | 6-55471 | YB;AAN
YB;ALA | KP | S46 53.913 E37 53.773 |  | 6-55472 | GW;A6
YB;AJJ | aa | [NAME]