tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 14894185-1169-4112-ae34-30b8584307ae
Sheet: Sheet1

 | Room & Crawl Space Temperature & Humidity |  |  |  |  |  |  |  | Attic Temperature & Humidity
 | DATE | TIME | date TIME | TEMPERATURE |  | RELATIVE HUMIDITY |  | TEMP. OUTSIDE | Temperature | Humidity | VAPOR PRESSURE (psi)
 |  |  |  | room | crawl space | room | crawl space |  |  |  | room | crawl | outdoor
 | 2011-07-28 00:00:00 | 650 |  | 83 | 70 | 70 | 63 | 74 | 82 | 65
DHP on | 2011-07-28 00:00:00 | 1235 |  | 85 | 69 | 70 | 65 | 93
46 kWh | 2011-07-28 00:00:00 | 1315 |  | 82 | 83 | 58 | 52 | 95
 | 2011-07-28 00:00:00 | 1350 |  | 81 | 85 | 55 | 52 | 96
 | 2011-07-28 00:00:00 | 1430 |  | 80 | 86 | 53 | 54 | 95
 | 2011-07-28 00:00:00 | 1520 |  | 79 | 86 | 52 | 53 | 94
 | 2011-07-28 00:00:00 | 1650 |  | 78 | 83 | 54 | 62 | 93
 | 2011-07-28 00:00:00 | 1750 |  | 78 | 82 | 55 | 64 | 93
 | 2011-07-28 00:00:00 | 2105 |  | 77 | 81 | 53 | 66 | 82
 | 2011-07-28 00:00:00 | 2200 |  | 78 | 81 | 54 | 64 | 80 | 98 | 52
 | 2011-07-29 00:00:00 | 605 |  | 77 | 75 | 65 | 70 | 72 | 80 | 63
 | 2011-07-29 00:00:00 | 1200 |  | 79 | 73 | 65 | 67 | 94
 | 2011-07-29 00:00:00 | 1700 |  | 80 | 71 | 66 | 69 | 92
 | 2011-07-29 00:00:00 | 2100 |  | 81 | 71 | 68 | 69 | 89
 | 2011-07-29 00:00:00 | 2150 |  | 80 | 79 | 62 | 56 | 77
 | 2011-07-29 00:00:00 | 2250 |  | 79 | 84 | 54 | 54 | 76 | 91 | 55
 | 2011-07-30 00:00:00 | 730 |  | 76 | 78 | 61 | 64 | 75 | 79 | 63
 | 2011-07-30 00:00:00 | 1500 |  | 79 | 71 | 64 | 67 | 86
 | 2011-07-30 00:00:00 | 1625 |  | 80 | 71 | 66 | 66 | 87
 | 2011-07-30 00:00:00 | 1950 |  | 81 | 71 | 66 | 64 | 85
 | 2011-07-30 00:00:00 | 2225 |  | 82 | 71 | 66 | 66 | 74 | 90 | 54
 | 2011-07-31 00:00:00 | 715 |  | 81 | 70 | 69 | 64 | 66 | 75 | 68
 | 2011-07-31 00:00:00 | 1210 |  | 81 | 70 | 69 | 65 | 90
 | 2011-07-31 00:00:00 | 1250 |  | 81 | 70 | 68 | 70 | 93 | 80 | 71
 | 2011-07-31 00:00:00 | 1640 |  | 78 | 80 | 55 | 62 | 90 | 101 | 58
 | 2011-07-31 00:00:00 | 1915 |  | 77 | 81 | 54 | 63 | 88
54 kWh | 2011-07-31 00:00:00 | 2245 |  | 77 | 80 | 56 | 63 | 72
 | 2011-08-01 00:00:00 | 800 |  | 78 | 73 | 66 | 65 | 70 | 75 | 67
 | 2011-08-01 00:00:00 | 1320 |  | 79 | 73 | 67 | 64 | 93
 | 2011-08-01 00:00:00 | 1750 |  | 80 | 71 | 67 | 67 | 92
 | 2011-08-01 00:00:00 | 2255 |  | 81 | 70 | 67 | 64 | 73 | 91 | 55
 | 2011-08-02 00:00:00 | 750 |  | 81 | 70 | 69 | 65 | 74 | 78 | 65
 | 2011-08-02 00:00:00 | 1130 |  | 81 | 78 | 64 | 55 | 91
 | 2011-08-02 00:00:00 | 1350 |  | 79 | 82 | 58 | 59 | 90
 | 2011-08-02 00:00:00 | 1700 |  | 77 | 81 | 58 | 63 | 90 | 93 | 59
 | 2011-08-02 00:00:00 | 2050 |  | 76 | 82 | 57 | 64 | 82
 | 2011-08-02 00:00:00 | 2230 |  | 76 | 82 | 56 | 64 | 79 | 91 | 55
 | 2011-08-03 00:00:00 | 750 |  | 78 | 74 | 65 | 68 | 72 | 78 | 62
58 kWh | 2011-08-03 00:00:00 | 1045 |  | 78 | 73 | 69 | 68 | 75
DHP off | 2011-08-03 00:00:00 | 1235 |  | 79 | 73 | 71 | 67 | 79
Spreadsheet: 1c36d14f-0313-476c-ba7f-810691c252e6
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
 | Time Series Workbook
 | 6457.0 International Trade Price Indexes, Australia
 | Table 19. Export Price Index by Selected ANZSIC Division and Subdivision, Index Numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  (A) Agriculture, forestry and fishing ; |  |  | Original | A3343431J | 1974-09-01 00:00:00 | 2011-06-01 00:00:00 | 148 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  (B) Mining ; |  |  | Original | A3343433L | 1974-09-01 00:00:00 | 2011-06-01 00:00:00 | 148 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  06 Coal mining ; |  |  | Original | A3343389R | 1974-09-01 00:00:00 | 2011-06-01 00:00:00 | 148 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  08 Metal ore mining ; |  |  | Original | A3343413C | 1974-09-01 00:00:00 | 2011-06-01 00:00:00 | 148 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  (C) Manufacturing ; |  |  | Original | A3343417L | 1974-09-01 00:00:00 | 2011-06-01 00:00:00 | 148 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  11 Food product manufacturing ; |  |  | Original | A3343423J | 2001-09-01 00:00:00 | 2011-06-01 00:00:00 | 40 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  12 Beverage and tobacco product manufacturing ; |  |  | Original | A3343437W | 2001-09-01 00:00:00 | 2011-06-01 00:00:00 | 40 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  17 Petroleum and coal product manufacturing ; |  |  | Original | A3343409L | 2001-09-01 00:00:00 | 2011-06-01 00:00:00 | 40 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  18 Basic chemical and chemical product manufacturing ; |  |  | Original | A3343403X | 2001-09-01 00:00:00 | 2011-06-01 00:00:00 | 40 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  19 Polymer product and rubber product manufacturing ; |  |  | Original | A3343427T | 2001-09-01 00:00:00 | 2011-06-01 00:00:00 | 40 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 583768d1532630698-index-match-for-sheet-name-in-another-workbook-md_de_dash
Sheet: Actuals

 | Operating Income
 | Code | January | February | March | April | May | June | July | August | September | October | November | December
 | 033300-020
 | 033302-020
 | 033310-020
 | 054400-020
 | 063600-020
Spreadsheet: 32991f1e-1a55-4285-8350-e2c0d7499a3e
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Special Education (TExES EC-12) | 7 | 6 |  | 7 | 6 |  | 16 | 13 |  | 16 | 13 |  | 10 | 10 |  | 10 | 10 |  | 15 | 13 |  | 18 | 17 | 0.944 | 20 | 18 | 0.9 | 20 | 18 | 0.9 | 4 | 3 | 0.75 | 14 | 12 | 0.857
Special Education Supplemental (TExES) | 3 | 1 |  | 4 | 2 |  | 6 | 5 |  | 6 | 5 |  | 2 | 2 |  | 2 | 2 |  | - | - | - | - | - | - | 1 | 0 | 0 | 1 | 0 | 0 | - | - | - | - | - | -
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
90
Spreadsheet: 765071d1643146555-messy-best-value-from-selected-drop-down-to-auto-drive-a-filter-on-another-worksheet-more-dependent-drop-downs-hawkdaddy404-
Sheet: todays players

Visitor |  |  |  | Home
DAL |  |  |  | PHI
Vis Goalie |  |  |  | Home Goalie
[NAME] |  |  |  | [NAME]
Vis Center |  |  |  | Home Center
Vis Left Wing |  |  |  | Home Left Wing
Vis Right Wing |  |  |  | Home Right Wing
Vis LD |  |  |  | Home LD
Vis RD |  |  |  | Home RD
[NAME] |  |  |  | [NAME]
Spreadsheet: 150380d1334494647-sumproduct-countif-array-error-sample
Sheet: Total Surveys Q1 2012 Summary

Customer Satisfaction Survey Results Q1 2012
Division | [NAME] | Surveys Completed | [NAME]
Northeast
 | Lewis | 96 | 3.801180310839278
 | Rappa | 212 | 3.926841680732148
 | [NAME] | 404 | 4.146264557543122
 | Total (NE) | 712 | 4.034402566577538
Southeast
 | [NAME], [NAME] | 140 | 4.30271443125348
 | Henderson | 106 | 4.179795206667676
 | Total (SE) | 246 | 4.24974923691976
Mideast | Agonis | 378 | 3.862426989877199
 | [NAME], D | 215 | 4.081374509925602
 | Schrader | 304 | 3.878804713026993
 | Total (ME) | 897 | 3.920456582572789
Central | Inman | 335 | 4.152003824544576
 | Meyer | 90 | 4.233769526813117
 | Total (Central) | 425 | 4.169318914436738
West | Swart | 192 | 4.264577387778127
 | Solaro | 192 | 4.057681523999638
 | Wood | 330 | 3.962372363079883
 | Total (West) | 714 | 4.06926693400237
Omnicare Totals
Week Ending: | # of Surveys
 |  | running total
2012-01-18 00:00:00 | 146 | 146
2012-01-25 00:00:00 | 232
2012-02-01 00:00:00 | 238
2012-02-08 00:00:00 | 225
2012-02-15 00:00:00 | 360
2012-02-22 00:00:00 | 313
2012-02-29 00:00:00 | 226
2012-03-07 00:00:00 | 181
2012-03-14 00:00:00 | 437
2012-03-21 00:00:00 | 267
2012-03-28 00:00:00
Spreadsheet: 01389a40-e0a6-4e1a-a66f-f307950d4480
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
SCOC | Test | SCOC | [NAME], Serum | [NAME], S | Complement Fixation (CF) Using [NAME]: IgG Immunodiffusion: IgG and IgM | Serum Gel Tube: SGT |  |  | 2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL | 1.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | COMPLEMENT FIXATION Negative If positive, results are titered.  IMMUNODIFFUSION Negative Results are reported as positive, negative, or equivocal. | Monday through Friday; 9:30 a.m. | 4 days | 7 days | 3 | 86635 |  |  |  |  | Rochester
SCOC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SCOC | Result | 8295 | Cocci Complement F | Cocci Complement F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5096-3
SCOC | Result | 21649 | Cocci Immunodiffusion-IgG | Cocci Immunodiffusion-IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62458-5
SCOC | Result | 21648 | Cocci Immunodiffusion-IgM | Cocci Immunodiffusion-IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62459-3
Spreadsheet: 37950d1236070627-data-validation-problem-cricket
Sheet: Player Details

PLAYER DETAILS |  |  |  |  |  |  |  |  |  |  |  | Availability | Weeks 1 > 22
 | Name | Mobile Number | Home Number |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | BARBER, [NAME] | 07506 560022
 | BARBER, [NAME]. |  | 01937 572294
 | BISHOP, [NAME] | 07855 252462
 | CHAPMAN, [NAME] | 07921 459849 | 01937 530270
 | COSGROVE, [NAME] | 07920 001503
 | COSGROVE, [NAME]
 | COUCHMAN, [NAME] | 07969 784956
 | GOODWIN, [NAME] | 07929 209756
 | HIRST, [NAME] |  | [PHONE]
 | [NAME], [NAME] |  | 01937 581784
 | MEREDITH, [NAME] | 07541 001562 | [PHONE]
 | RICHARDSON, [NAME] | 07710 106473
 | SIMPSON, [NAME] | 07722 170280 | [PHONE]
 | SKERRETT, [NAME] | 07960 784956
Spreadsheet: 685844d1594222851-needing-help-with-find-and-add-between-dates-type-formulas-fuel-tracking
Sheet: Sheet1

Date | Hours | Gallons
Spreadsheet: 861960d1709773242-use-a-number-in-a-cell-as-a-cell-reference-in-a-formula-test-10-
Sheet: Address Sheet

1 |  | 2 |  | 3
 | ABC Company |  | Best Buy |  | [NAME]'s Dog Grooming
 | 123 Rocky Rd |  | 456 [NAME] |  | 567 Third St
 | Chicago IL 60061 |  | Unit 2 |  | Quebec QC G1J 1R8
 | United States |  | Nashville TN 37201 |  | Canada
 |  |  | United States
4 |  | 5 |  | 6
7 |  | 8 |  | 9
Spreadsheet: richard_ring__31569__EPMI clarification attempt
Sheet: Sheet2

Purchased from EPMI
 | EESI | EEM | Total
2000-06-01 00:00:00 |  | 720 |  | 168
2000-07-01 00:00:00
2000-08-01 00:00:00 | 155826
2000-09-01 00:00:00 | 72483
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00 | 31081.08 |  |  | 126
Total
Spreadsheet: 60906d1261485061-please-help-sorting-numbers-make-gap-where-missing-number-now-with-example-i-xlsx-problem
Sheet: Ark1

Orginal
8769 |  | 9049
8770 |  | 9050
8833 |  | 9052
8835 |  | 9078
8836 |  | 9053
8849 |  | 9047
8850 |  | 9055
8851 |  | 9056
8944 |  | 9070
8945 |  | 9069
8946 |  | 9068
8947 |  | 9072
Result that i want
8849 |  | 9047
 |  | Missing Nr.
8769 |  | 9049
8770 |  | 9050
 |  | Missing Nr.
8833 |  | 9052
8836 |  | 9053
 |  | Missing Nr.
8850 |  | 9055
8851 |  | 9056
 |  | Missing Nr.
8946 |  | 9068
8945 |  | 9069
8944 |  | 9070
 |  | Missing Nr.
8947 |  | 9072
 |  | Missing Nr.
 |  | Missing Nr.
 |  | Missing Nr.
 |  | Missing Nr.
 |  | Missing Nr.
8835 |  | 9078
Spreadsheet: 128237d1320868197-if-function-psh9
Sheet: LookUp

Postal Abbreviation | Value
AL | 35
AK | 50
AS
AZ | 35
AR | 65
CA | 35
CO | 35
CT | 65
DE | 65
DC
FM
FL | 50
GA | 80
GU
HI | 35
ID | 65
IL | 65
IN | 50
IA | 50
KS | 65
KY | 80
LA | 65
ME | 35
MH
MD | 35
MA | 35
MI
MN | 65
MS | 35
MO | 65
MT | 50
NE | 35
NV
NH | 50
NJ | 35
NM | 35
NY | 35
NC | 50
ND | 35
MP
OH | 35
OK | 50
OR | 35
PW
PA | 65
PR
RI | 35
SC | 35
SD
TN | 65
TX | 35
UT | 35
VT | 50
VI
VA | 35
WA | 35
WV
WI | 65
WY | 50
Spreadsheet: 856347d1705607255-dynamic-conditional-formatting-on-activity-calendar-cal-workbook-billbalint-
Sheet: Week 2

 | STUDY SCHEDULE |  |  |  |  | SCHEDULE START | TIME INTERVAL | Class List
 |  |  |  |  |  | 06:00:00 | 15 MIN
 | TIME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SATURDAY2
 |  |  | WAKE UP | WAKE UP | WAKE UP | WAKE UP | WAKE UP | WAKE UP
 |  |  | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST
 |  |  | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST
 |  |  | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST
 |  |  | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST
 |  |  | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST | BREAKFAST
 |  |  | LUNCH |  | LUNCH |  | LUNCH
 |  |  | LUNCH |  | LUNCH |  | LUNCH
 |  |  | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH
 |  |  | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH
 |  |  | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH
 |  |  |  | LUNCH |  | LUNCH |  | LUNCH
 |  |  |  | LUNCH |  | LUNCH |  | LUNCH
 |  |  |  | LUNCH |  | LUNCH |  | LUNCH
 |  |  | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE
 |  |  | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE
 |  |  | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE
 |  |  | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE
 |  |  | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE | EXERCISE
 |  |  | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER
 |  |  | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER
 |  |  | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER
 |  |  | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER
 |  |  | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER | DINNER
Spreadsheet: 270026d1381347661-if-not-working-brokenif-statement-1-
Sheet: Sheet1

1 | A1 can be any one of these characters: [NAME], 2, 3, 4, 5, 6, 7, 8, 9,A,B,C,D,E,F
 |  |  |  |  |  |  |  | X | XXXX
 |  |  |  |  |  |  |  | 1 | 0001
 |  |  |  |  |  |  |  | 2 | 0010
 |  |  |  |  |  |  |  | 3 | 0011
 |  |  |  |  |  |  |  | 4 | 0100
 |  |  |  |  |  |  |  | 5 | 0101
 |  |  |  |  |  |  |  | 6 | 0110
 |  |  |  |  |  |  |  | 7 | 0111
 |  |  |  |  |  |  |  | 8 | 1000
 |  |  |  |  |  |  |  | 9 | 1001
 |  |  |  |  |  |  |  | A | 1010
 |  |  |  |  |  |  |  | B | 1011
 |  |  |  |  |  |  |  | C | 1100
 |  |  |  |  |  |  |  | D | 1101
 |  |  |  |  |  |  |  | E | 1110
 |  |  |  |  |  |  |  | F | 1111
Spreadsheet: 147213d1332603120-need-to-transpose-game-results-to-another-sheet-test
Sheet: Important Formulas

 | Searches Game Results for Wins by Team w/ Specific Seed | =SUM(('Average Seed'!TEAMRESULTS_COLUMNARRAY=Team_search)*('Average'!SEEDRESULTS_COLUMNARRAY=VALUE(INDEX(SEEDS_ROWARRAY,1,COLUMN()-Difference between index# and column))))   {[NAME]}
 | (in a single column) |  |  |  |  |  |  |  |  |  |  |  |  | Rd. of 32 | --> | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweet 16 | --> | 31
Team_search | Searches for same team name as given row | =T(INDEX(TEAMS_COLUMNARRAY,[NAME])) |  |  |  |  |  |  |  |  |  |  |  | Elite 8 | --> | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Final 4 | --> | 79
Wins_search | Searches for total wins by a team in same row as given | =VALUE(INDEX(WINS_COLUMNARRAY,[NAME]))
Previous_wins | Searches for total wins by a team in the previous round | =VALUE(INDEX(WINS_COLUMNARRAY,[NAME])
 | Calculates Average Seed | =SUMPRODUCT(TEAMSEEDS_ROWARRAY,SEEDS_ROWARRAY)/TOTALWINS_CELL
 | Creates a value for sorting recency of qualification (in years) | =IF((YEAR(NOW())-MOSTRECENT_CELL)<5,1,IF((YEAR(NOW())-MOSTRECENT_CELL)>14,-1,0))
 | Finds most recent year of qualification (in a round) for a team | =MAX(IF('Average Seed'!QUALIFIERS_ARRAY=Team_search,'Average Seed'!YEAR_COLUMNARRAY))  {[NAME]}
Previous_rank | Previous Round Rank for a team (i.e. [NAME] rank when | =ROW(INDEX(PREVIOUS_COLUMNARRAY,MATCH(Team_search,PREVIOUS_COLUMNARRAY,0)))-2
 | current round is Elite 8)
Current_rank | pretty straight forward… | =ROW()-2
 | Calculates change in rank or elimination between rounds | =IF(Wins_search=0, IF(Previous_wins=1, "XX", CONCATENATE("X (",[NAME],")")), IF(Current_rank<[NAME],CONCATENATE("+",Previous_rank-Current_rank), IF(Current_rank>Previous_rank,CONCATENATE("–",Current_rank-Previous_rank),"±0")))
Spreadsheet: 796070a5-3a76-496a-990a-5c874f97e3d5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5027 | 30801 | [NAME] | Brewer | RSA | 0 | 00:23:17 | 00:00:00 | 01:13:51 | 00:00:00 | 00:40:24 | 1 | [NAME]
5027 | 30125 | Britt | [NAME] | RSA | 0 | 00:22:33 | 00:00:00 | 01:16:22 | 00:00:00 | 00:44:27 | 2 | 02:23:22
5027 | 5443 | [NAME] | Charlmersfulton | ZIM | 0 | 00:24:33 | 00:00:00 | 01:18:04 | 00:00:00 | 00:45:08 | 3 | 02:27:46
5027 | 16440 | Michelle | Staal | RSA | 0 | [NAME] | 00:00:00 | 01:24:08 | 00:00:00 | 00:43:42 | 4 | 02:34:57
5027 | 30151 | Trish | Hodgson | RSA | 0 | 00:27:05 | 00:00:00 | 01:28:44 | 00:00:00 | 00:45:25 | 5 | 02:41:15
Spreadsheet: 857836d1706714585-sum-of-amounts-with-criteria-above-the-cell-with-values-sample-data
Sheet: NEW SUMMARY TAB

 |  |  | 2023 |  |  | 2024
 | Project |  | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
 | Project 1 | Project Stage | Stage 1 | Stage 1 | Stage 2 | Stage 2 | Stage 3 | Stage 3
 |  | Resource Requirement | 3 | 3 | 2.5 | 2.5 | 5 | 5
 | Project 2 | Project Stage | Stage 1 | Stage 1 | Stage 1 | Stage 2 | Stage 2 | Stage 2
 |  | Resource Requirement | 3 | 3 | 3 | 2.5 | 2.5 | 2.5
 | Project 3 | Project Stage | Stage 2 | Stage 2 | Stage 2 | Stage 3 | Stage 3 | Stage 3
 |  | Resource Requirement | 2.5 | 2.5 | 2.5 | 5 | 5 | 5
 | Project 4 | Project Stage | Stage 2 | Stage 3 | Stage 3 | Stage 3 | Stage 3 | Stage 3
 |  | Resource Requirement | 2.5 | 5 | 5 | 5 | 5 | 5
 | Project 5 | Project Stage | Stage 3 | Stage 3 | Stage 3 | Stage 3 | Stage 3 | Stage 3
 |  | Resource Requirement | 1 | 1 | 1 | 1 | 1 | 1
 | Expected Results Total | Stage 1
 |  | Stage 2
 |  | Stage 3
Spreadsheet: 693254d1598885364-trying-to-figure-out-a-vlookup-with-multiple-arguments-example
Sheet: Sheet1

Tier | Status | Name | Review date
[NAME] | Contractor | name 1 |  | Need to add 365 to date |  | Tier 1 | 2020-03-01 00:00:00 |  | Contractor
[NAME] | Employee | name 2 |  |  |  | [NAME] | 2020-04-01 00:00:00 |  | Employee
 |  | name 3 |  |  |  | Tier 3 | 2020-05-01 00:00:00
 |  | name 4 |  |  |  | [NAME] | 2020-06-01 00:00:00
 |  | name 5
 |  | name 6
 |  | name 7
 |  | name 8
 |  | name 9
 |  | name 10
 |  | name 11
Spreadsheet: 725197d1616585488-count-of-which-people-got-any-target-over-6-months-across-all-categories-excel-example
Sheet: Sheet1

Category | Name | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 |  |  |  | What I'd like
Blue | [NAME] | 45 |  |  |  |  |  |  |  |  | 1
Green | [NAME] |  |  | 34 |  |  | 24
Pink | [NAME] |  | 4 |  |  | 16
Blue | [NAME]
Green | [NAME]
Yellow | [NAME]
Red | [NAME]
Pink | [NAME]
Blue | [NAME] |  | 23 |  |  |  |  |  |  |  | 1
Green | [NAME]
Red | [NAME] |  |  |  |  | 12
Pink | [NAME]
Blue | [NAME] |  |  |  | 13 |  |  |  |  |  | 1
Green | [NAME]
Yellow | [NAME] |  |  |  |  |  | 3
Pink | [NAME]
Green | [NAME]
Yellow | [NAME]
Red | [NAME]
Pink | [NAME]
Spreadsheet: 687053d1594928629-vat-report-on-excel-vat-report
Sheet: Sheet1

Purchases Ledger
Date | [NAME] | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount incl [NAME]
aaa | Gauge Pvt Ltd | 10004690 | 100 | 2000 | 0.15
2020-01-10 00:00:00 | Key  Masters | 10004589 | 200 | 1000 | 0.15
2020-01-15 00:00:00 | Gauge Pvt Ltd | 10004690 | 300 | 3000 | 0.15
2020-01-16 00:00:00 | RBZ |  | 400
2020-01-17 00:00:00 | [NAME] | 10004789 | 500 | 500 | 0.15
2020-01-29 00:00:00 | MARGARET |  | 600 | 4000
2020-01-30 00:00:00 | Key  Masters | 10004589 | 700 | 2000 | 0.15
2020-01-31 00:00:00 | RBZ |  | 800
2020-02-09 00:00:00 | [NAME] | 10004789 | 900 | 500 | 0.15
2020-02-10 00:00:00 | Gauge Pvt Ltd | 10004690 | 1000 | 4000 | 0.15
2020-02-15 00:00:00 | RBZ |  | 1100
2020-02-16 00:00:00 | [NAME] | 10004789 | 1200 | 500 | 0.15
2020-02-24 00:00:00 | MARGARET |  | 1300
2020-02-28 00:00:00 | [NAME] | 10004789 | 1400 | 4000 | 0.15
Question:  I want a formula which can extract some of the information from [NAME] to VAT report . Please not that those which do not have VAT Numbers
are not included in the VAT REPORT. I have been using INDEX and MATCH but it capture only one transaction even if the supplier has more than one. For
example Gauge Pvt Ltd and Key Masters. Pivot tables, VBA and Macro are don't understand them and they confuse me, if possible give me excel formula
Below are the VAT REPORTS.
VALUE ADDED TAX REPORT FOR JANUARY 2020 |  |  |  |  |  |  |  | VALUE ADDED TAX REPORT FOR FEBRUARY 2020
PURCHASES: VAT |  |  |  |  |  |  |  | PURCHASES: VAT
Date | Invoice Number | Supplier | VAT Number | Amount | VAT |  |  | Date | Invoice Number | Supplier | VAT Number | Amount | VAT
2020-01-01 00:00:00 | 100 | Gauge Pvt Ltd | 10004690 | 2000 | 300 |  |  | 2020-02-09 00:00:00 | 900 | [NAME] | 10004789 | 500 | 75
2020-01-10 00:00:00 | 200 | Key  Masters | 10004589 | 1000 | 150 |  |  | 2020-02-10 00:00:00 | 1000 | Gauge Pvt Ltd | 10004690 | 4000 | 600
2020-01-15 00:00:00 | 300 | Gauge Pvt Ltd | 10004690 | 3000 | 450 |  |  | 2020-02-16 00:00:00 | 1200 | [NAME] | 10004789 | 500 | 75
2020-01-17 00:00:00 | 500 | [NAME] | 10004789 | 500 | 75 |  |  | 2020-02-28 00:00:00 | 1400 | [NAME] | 10004789 | 4000 | 600
2020-01-30 00:00:00 | 700 | Key  Masters | 10004589 | 2000 | 300