tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 791083d1660146971-days-in-market-days-in-market
Sheet: Sheet1

 | Comment | Ticket Number | [NAME] | [NAME] | Departure Date | [NAME] | Nett Days for trip |  | 180 Days including arrival date
1 | Outbound to France | 123345679 | LHR | CDG | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 |  |  |  |  |  | Scenario
1 | Inbound from France | 123345679 | CDG | LHR | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 |  |  |  |  |  | I need to count how many days someone has spent in the EU from any given start point
2 | Outbound to France | 98765431 | LHR | CDG | 2022-12-20 00:00:00 | 2022-12-20 00:00:00 |  |  |  |  |  | For Trip 1 the traveller has arrived in the EU on 10th August 2022 and this starts the clock running
2 | Inbound from France | 98765431 | CDG | LHR | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  |  | Any days spent in the EU for traveller within the 180 days window needs to be counted
3 | Outbound to France | 1233456179 | LHR | CDG | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 |  |  |  |  |  | So the days for trips 2 and 3 would be counted in totality
3 | Inbound from France | 1233456179 | CDG | LHR | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 |  |  |  |  |  | But only 2 out of trip 4 would count in the total
4 | Outbound to France | 1254879865 | LHR | CDG | 2023-02-04 00:00:00 | 2023-02-04 00:00:00
4 | Inbound from France | 1254879865 | CDG | LHR | 2023-02-06 00:00:00 | 2023-02-06 00:00:00 |  |  |  |  |  | This counter would need threfore to be able to a do a lot of "Sumifs", but I can't seem to get my brain around it.
 |  |  |  |  |  |  |  |  |  |  |  | But for every trip made into the EU  adds a new [NAME] of information required
5 | Outbound to Spain | 15948267398 | LHR | MAD | 2022-02-06 00:00:00 | 2022-02-06 00:00:00
5 | Outbound from Spain | 15948267398 | MAD | WAW | 2022-02-08 00:00:00 | 2022-02-08 00:00:00 |  |  |  |  |  | These are simple trips to and from 1 pair of airports
5 | Outbound from Poland | 15948267398 | WAW | CDG | 2022-02-10 00:00:00 | 2022-02-10 00:00:00
5 | Outbound from France | 15948267398 | Paris gare du Nord | [NAME] | 2022-02-13 00:00:00 | 2022-02-14 00:00:00 |  |  |  |  |  | But where the trip involves multiple sectors this calculation gets more complex
 |  |  |  |  |  |  |  |  |  |  |  | Eg Scenario 5
6 | Outbound to France | 15948267398 | LHR | CDG | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
6 | Outbound from France | 15948267398 | Paris gare du Nord | [NAME] | 2023-02-03 00:00:00 | 2023-02-03 00:00:00
6A | Outbound from Netherlands | A6598745 | AMS | GVA | 2023-02-09 00:00:00 | 2023-02-09 00:00:00 | 6
6A | Outbound from Switzerland |  | GVA | AMS | 2023-02-11 00:00:00 | 2023-02-11 00:00:00 | 1 |  | to be Excluded 10th Feb 2023 spent in Geneva)
6 | Outbound from Netherlands | 15948267398 | [NAME] | Brussels Central | 2023-02-12 00:00:00 | 2023-02-12 00:00:00
6 | Outbound from France | 15948267398 | Brussels Central | [NAME] | 2023-02-13 00:00:00 | 2022-02-14 00:00:00 | 1 |  | Very Late Night Train
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: April

 |  |  | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Name | Entitlement | Total Holiday's Used | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | Full days Booked | 1/2 Days Booked | Holiday's Used | Lateness | Sickness Absence (Current Months Total) | Sickness Absence (Days - Rolling 12 Months) | Sickness Absence Periods (Current Months Total) | Sickness Absence (Periods - Rolling 12 Months) | Bradford Index Score (Rolling 12 Months)
A.N.Other | 25 | 21.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 21 | 0 | 3 | 189
 |  |  |  | 0.5 |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | H |  |  |  |  |  | H | H |  |  |  |  |  |  | 3 | 1
S 1 | L
S 2 | H
S 3 | 0.5
S 4 | AA
S 5 | UA
S 6 | TR
Spreadsheet: 889490d1740328928-charts-drop-to-zero-cedward-dynamic-charting-with-zeros
Sheet: Expense Data  Redesign

Item | Primary_Expense_Type | Secondary_Expense_Type | Date | Quarter | Week | Units | Amount | Credit_Card | Notes
1 | Personal | Other | 2025-01-08 00:00:00 |  |  |  | 82.28469359306696 | Yes
2 | Automobile | Fuel | 2025-01-11 00:00:00 |  |  |  | 39.67646811998389 | Yes
3 | Food and Grocery | Restaurant | 2025-01-11 00:00:00 |  |  |  | 69.49156098438239 | Yes
4 | Personal | Fitness | 2025-01-15 00:00:00 |  |  |  | 27.00071645922524 | Yes
5 | Personal | Fitness | 2025-01-15 00:00:00 |  |  |  | 27.27007857126716 | Yes
6 | Food and Grocery | Grocery | 2025-01-21 00:00:00 |  |  |  | 40.23349101544306 | Yes
7 | Food and Grocery | Grocery | 2025-01-21 00:00:00 |  |  |  | 1.77496263783441 | Yes
8 | Food and Grocery | Restaurant | 2025-01-24 00:00:00 |  |  |  | 10.47362691963408 | Yes
9 | Personal | Cellphone | 2025-01-26 00:00:00 |  |  |  | 68.51561115593057 | Yes
10 | Personal | Haircut | 2025-01-29 00:00:00 |  |  |  | 20.99786215005292 | No
11 | Food and Grocery | Restaurant | 2025-01-31 00:00:00 |  |  |  | 15.6726373816967 | No
12 | Food and Grocery | Restaurant | 2025-02-08 00:00:00 |  |  |  | 85.03630631856943 | Yes
13 | Personal | Fitness | 2025-02-15 00:00:00 |  |  |  | 0.2970894519524148 | Yes
14 | Food and Grocery | Restaurant | 2025-02-17 00:00:00 |  |  |  | 45.87093496177452 | No
15 | Food and Grocery | Restaurant | 2025-02-17 00:00:00 |  |  |  | 55.56755005130659 | Yes
16 | Personal | Other | 2025-03-08 00:00:00 |  |  |  | 70.06680509369569 | Yes
17 | Automobile | Fuel | 2025-04-11 00:00:00 |  |  |  | 0.008073296978694522 | Yes
18 | Food and Grocery | Restaurant | 2025-04-11 00:00:00 |  |  |  | 72.64749208524513 | Yes
19 | Personal | Fitness | 2025-04-15 00:00:00 |  |  |  | 61.150854846462 | Yes
20 | Personal | Fitness | 2025-04-15 00:00:00 |  |  |  | 47.89256024024242 | Yes
21 | Food and Grocery | Grocery | 2025-04-21 00:00:00 |  |  |  | 67.56404058358221 | Yes
22 | Food and Grocery | Grocery | 2025-05-21 00:00:00 |  |  |  | 90.68280686729653 | Yes
23 | Food and Grocery | Restaurant | 2025-05-24 00:00:00 |  |  |  | 12.75993719602585 | Yes
24 | Personal | Cellphone | 2025-05-26 00:00:00 |  |  |  | 43.28814696362605 | Yes
25 | Personal | Haircut | 2025-05-29 00:00:00 |  |  |  | 60.31789064881792 | No
26 | Food and Grocery | Restaurant | 2025-07-01 00:00:00 |  |  |  | 7.626052286511575 | No
27 | Food and Grocery | Restaurant | 2025-06-08 00:00:00 |  |  |  | 47.39192672557332 | Yes
28 | Personal | Fitness | 2025-07-15 00:00:00 |  |  |  | 42.33140448638142 | Yes
29 | Food and Grocery | Restaurant | 2025-07-17 00:00:00 |  |  |  | 4.043278454776278 | No
30 | Food and Grocery | Restaurant | 2025-07-17 00:00:00 |  |  |  | 25.1857198775677 | Yes
Spreadsheet: 792719d1661098486-summarizing-weeklies-into-a-monthly-2022-08-21-oeldere2-ryba-testrunyearxls
Sheet: KW03

ID | Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Week03
100 | [NAME] | 8 | 5 | 6 | 8 | 10 | 0 | 0
101 | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5
102 | Fredericson | 8 | 4 | 8 | 4 | 6 | 6 | 0
103 | [NAME] | 6 | 6 | 6 | 6 | 6 | 0 | 0
Spreadsheet: 128636d1321129929-vlookup-in-different-coumns-hooves-world-racing-syndicate-updated
Sheet: Racing History

MEMBERS | # | TUE | THU
[NAME] Condely | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
[NAME] | 5
[NAME] | 6
[NAME]* | 7
[NAME] | 8
[NAME]  ** | 9
[NAME] | 10
[NAME] | 11
[NAME] | 12
[NAME]* | 13
[NAME] | 14
[NAME] | 15
STANDBY
[NAME]
[NAME]
[NAME]
J T Patryck Voie
[NAME]
Jane-Marie Nash
Spreadsheet: 330544d1404792763-match-2-values-and-match-array-problem-solved
Sheet: Sheet3

 |  | 2014
 | Division | 42
 | Customer Service
 | Customer Service
 | Customer
 | Area 1
 | Area 2
 | Total
 | SBO
 | SBO
 | Operations
 | Operations
 | Box
 | Total
 | [NAME]
 | Mainenance
 | Workforce
 | Team 1
 | Team 2
 | Total
 | Other
 | Other
 | Idk
 | Got no imagination
 | Hard trying to come up with names
 | Total
 | Grand TOTAL
 |  | * If year = 2014, if week number = 4X, if value is in division list
 | Division | Week No. | Date
 | Customer | 42 | 2014-01-01 00:00:00
 | Area 1 | 42 | 2014-01-02 00:00:00
 | Mainenance | 43 | 2013-01-03 00:00:00
 | Workforce | 43 | 2014-01-04 00:00:00
 | Team 1 | 42 | 2014-01-05 00:00:00
 | Customer service | 42 | 2014-01-06 00:00:00
 | Customer | 45 | 2014-01-07 00:00:00
 | Area 1 | 45 | 2014-01-08 00:00:00
 | Mainenance | 44 | 2014-01-09 00:00:00
 | Workforce | 44 | 2014-01-10 00:00:00
 | Team 1 | 42 | 2014-01-11 00:00:00
 | Idk | 42 | 2013-01-12 00:00:00
 | Got no imagination | 45 | 2014-01-13 00:00:00
 | SBO | 45 | 2014-01-14 00:00:00
 | Operations | 44 | 2014-01-15 00:00:00
 | Workforce | 42 | 2013-01-16 00:00:00
 | Team 1 | 45 | 2014-01-17 00:00:00
 | Mainenance | 45 | 2014-01-18 00:00:00
 | Workforce | 44 | 2014-01-19 00:00:00
Spreadsheet: a8b5ee1d-0749-4f7b-9c5c-766f7dd66b7f
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
FWHG4 | Test | FWHG4 | Wheat IgG4 | Wheat IgG4 | Enzyme immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <0.15 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG4 tests has not been clearly established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food related complaints, and to evaluate food allergic patients prior to food challenges. The presence of food-specific IgG4 alone cannot be taken as evidence of food allergy and only indicated immunologic sensitization to the food allergen in question.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 2 - 3 days | 4 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FWHG4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FWHG4 | Result | FWHG4 | Wheat IgG4 | Wheat IgG4 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 218742d1362566337-ctrl-shift-enter-search
Sheet: Sheet1

 | Order: | A001-2004 | <- This one is filled in by me!
 | Order: | File: | Sum:
 | A001-2004 | 010 | 130 |  | <- These rows are supposed to be filled in automatically.
 |  | 020 | 45
 |  | 030 | 318
 |  | 040 | 254
 |  | 050 | 658
 |  | 060 | 4
 |  | 070 | 548
 |  | 080 | 25
 |  | 090 | 54
 |  | 100 | 87
 |  | 110 | 835
 |  | 120 | 224
 |  | 130 | 654
 |  | 140 | 543
 |  | 150 | 2533
 |  | 160 | 1
 |  | 170 | 564
 |  | 171 | 359
 |  | 180 | 349
Spreadsheet: 55240d1255397925-trying-to-work-formula-for-work-time-sheet-using-if-formula-time-sheet
Sheet: Sheet1

Product Activity/ Application
pack up
Product Activity / Application |  | 10 | 8 | 9
Workshop Duties / Admin |  | 2 | 0.5
unload |  | 4
[NAME]
Total Hours | 0 | 16 | 8.5 | 9 | 0
[NAME] |  | 8 | 8 | 8
1.5 x Normal Rate |  | 2 | 0.5 | 1
2 x Normal Rate |  | 6
Weekend/Away Rate
1.5 x Weekend / Away rate
Allowance: ([NAME], Fibreglass, MV, Meal) |  | 10.5
Private MV Use Km Travelled
Spreadsheet: 93957d1293719136-finding-the-greatest-number-758268_hhr
Sheet: Sheet1

SOURCE | # of times as source | Row Labels | Sum of # of times as source
[NAME] | 100 | [NAME] | 591
Billy | 100 | [NAME] | 100
Danielle | 25 | Billy | 100
George | 69 | [NAME] | 88
Sara | 3 | George | 69
Franny | 4
Deb | 4
[NAME] | 88
[NAME] | 591
[NAME] | 6
Carol | 17
Spreadsheet: 848633d1699327797-newbie-help-if-vlookup-not-sure-which-formula-to-use-formula-help-example
Sheet: Data Sheet

STORE NAME | # | BOARD APPROVED DATE | CONSTRUCTION START DATE | FY DATE
OPEN
Store 1 |  |  |  | FY22
Store 2 |  |  | TBC | FY22
Store 3 |  |  | 2021-06-01 00:00:00 | FY21
Store 4 |  |  |  | FY24 | <--  Left Date Cells Blank as this may happen
Store 5 |  |  |  | FY22
Store 6 |  |  | 2020-09-01 00:00:00 | FY21
Store 7 |  |  | 2020-10-01 00:00:00 | FY21
Store 8 |  |  | 2022-11-01 00:00:00 | FY23
Store 9
Store 10 |  |  |  | FY21
Store 11 |  |  |  | FY21
TOTAL
UNDER CONSTRUCTION
Store 12 |  |  | 2020-01-10 00:00:00 | FY20
Store 13 |  |  | 2023-02-01 00:00:00 | FY23
Store 14 |  |  | 2024-03-01 00:00:00 | FY24
Store 15 |  |  | 2020-04-01 00:00:00 | FY20
Store 16 |  |  | 2021-05-01 00:00:00 | FY21
TOTAL
BOARD APPROVED
Store 17 |  | 2022-01-01 00:00:00 |  | FY22
Store 18 |  | 2021-02-02 00:00:00 |  | FY21
Store 19 |  | 2022-03-03 00:00:00 |  | FY22
Store 20 |  | 2024-04-04 00:00:00 |  | FY24
Store 21 |  | 2024-05-05 00:00:00 |  | FY24
Store 22 |  | 2024-06-06 00:00:00 |  | FY24
TOTAL
Spreadsheet: 888870d1739464806-copying-data-to-a-new-sheet-and-moving-its-position-in-table-activity-test
Sheet: activity

team | subteam | week 1 | week 2 | week 3
a | 1 | test 1 |  | test 2
a | 1 | test 3 | test 1
b | 2
b | 2 |  | test 2 | test 3
c | 1 | test 1 | test 2 | test 3
c | 1 | test 2
b | 3 |  | test 4
a | 2 |  |  | test 5
 |  |  | ‹
Spreadsheet: 117b6807-22fa-4f89-87b9-a0364d12cc2f
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
 | 6202.0 Labour Force, Australia
 | Table 10. Labour force status by Sex - Northern Territory - Trend and Original
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
Employed - full-time ;  [NAME] ; |  |  | Trend | A184131L | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184148J | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184165K | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184133T | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184150V | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | [NAME] | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184136X | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184153A | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184170C | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184143W | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184160X | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184177V | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184142V | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184159R | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184176T | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163486J | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163503X | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163520A | 1978-02-01 00:00:00 | 2012-06-01 00:00:00 | 413 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 770930d1646337240-need-help-with-adding-new-criteria-to-formula-book1
Sheet: Ref 2

ID | [NAME] | Cov N
1 | Complete | Death
1 | Complete | Right
1 | Complete | See
1 | Complete | Only
1 | Complete | PI
2 | Cancelled | Only
2 | Cancelled | BL
2 | Cancelled | See
2 | Cancelled | Death
3 | Complete | Right
3 | Complete | Death
3 | Complete | Work
3 | Complete | Table
3 | Complete | BL
3 | Complete | VL
3 | Complete | Den
3 | Complete | PI
4 | Complete | See
4 | Complete | Death
4 | Complete | Circle
4 | Complete | Right
4 | Complete | Only
4 | Complete | Work
4 | Complete | Table
4 | Complete | BL
5 | Complete | Death
5 | Complete | Death
5 | Complete | Only
5 | Complete | Only
5 | Complete | PI
5 | Complete | Only
Spreadsheet: 813744d1673966275-moving-data-from-rows-to-columns-grade-rows-to-columns1
Sheet: Desired structure

Employee | [NAME] From | [NAME] To | [NAME] | [NAME] From | [NAME] To | [NAME] | [NAME] From | [NAME] To | [NAME]
10000 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 5
10001 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 7
10002 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 4
10003 | 2003-08-01 00:00:00 | 2010-10-31 00:00:00 | Senior Staff | 2010-11-01 00:00:00 | 2018-04-22 00:00:00 | Board Member | 2018-04-23 00:00:00 | 2099-12-31 00:00:00 | Senior Staff
10004 | 2003-07-01 00:00:00 | 2013-03-21 00:00:00 | Level 5 | 2013-03-22 00:00:00 | 2099-12-31 00:00:00 | Level 6
10005 | 2003-06-01 00:00:00 | 2016-07-03 00:00:00 | Level 4 | 2016-07-04 00:00:00 | 2099-12-31 00:00:00 | Level 5
10007 | 2003-10-01 00:00:00 | 2009-11-12 00:00:00 | Level 4 | 2009-11-13 00:00:00 | 2019-04-14 00:00:00 | Level 5 | 2019-04-15 00:00:00 | 2099-12-31 00:00:00 | Level 6
10007 | 2009-11-13 00:00:00 | 2019-04-14 00:00:00 | Level 5
10008 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 6
10009 | 2003-12-01 00:00:00 | 2005-03-31 00:00:00 | Level 3 | 2005-04-01 00:00:00 | 2099-12-31 00:00:00 | Level 4
10010 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 6
10011 | 2003-06-01 00:00:00 | 2007-11-30 00:00:00 | Level 3 | 2008-04-01 00:00:00 | 2099-12-31 00:00:00 | Level 3
10012 | 2003-06-01 00:00:00 | 2099-12-31 00:00:00 | Level 3
10013 | 2003-06-01 00:00:00 | 2004-10-31 00:00:00 | Level 1 | 2004-11-01 00:00:00 | 2099-12-31 00:00:00 | Level 3
10014 | 2003-12-01 00:00:00 | 2005-03-31 00:00:00 | Level 3 | 2005-04-01 00:00:00 | 2022-09-08 00:00:00 | Level 4 | 2022-09-09 00:00:00 | 2099-12-31 00:00:00 | Level 5
Spreadsheet: 99462d1298068983-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: SS

Column1 | First name | Last Name | Team | Owner |  | Position | My Team
1 | Hanley | [NAME], | FLA |  |  | C
2 | Troy | Tulowitzki, | COL |  |  | 1B
3 | Derek | Jeter, | NY-A |  |  | 2B
4 | [NAME] | Reyes, | NY-N |  |  | 3B
5 | Stephen | Drew, | AZ |  |  | SS
6 | Alexei | [NAME], | CHI-A |  |  | OF
7 | [NAME] | Rollins, | PHI |  |  | OF
8 | Starlin | [NAME], | CHI-N |  |  | OF
9 | Elvis | Andrus, | TEX |  |  | Util
10 | Ian | [NAME], | WAS |  |  | Util
11 | Yunel | Escobar, | TOR |  |  | BN
12 | Cristian | Guzman, |  |  |  | BN
13 | Orlando | Cabrera, |  |  |  | BN
14 | [NAME] | Scutaro, | BOS |  |  | BN
15 | Rafael | Furcal, | LA |  |  | SP
16 | Asdrubal | Cabrera, | CLE |  |  | SP
17 | Erick | Aybar, | ANA |  |  | SP
18 | [NAME] | [NAME], | SD |  |  | SP
19 | Cliff | Pennington, | OAK |  |  | RP
20 | Miguel | Tejada, | SF |  |  | RP
21 | [NAME] | Hardy, | BAL |  |  | P
22 | [NAME] | Peralta, | DET
23 | [NAME] | Theriot, | STL
24 | [NAME] | Brignac, | TB
25 | Yuniesky | Betancourt, | MIL
26 | Jed | [NAME], | BOS
27 | [NAME] | [NAME], | ATL
28 | [NAME] | [NAME], | CLE
29 | Ronny | Cedeno, | PIT
30 | Alcides | Escobar, | KC
31 | [NAME] | [NAME], | WAS
32 | Alexi | Casilla, | MIN
33 | Everth | Cabrera, | SD
34 | [NAME] | Ryan, | SEA
35 | Edgar | Renteria, | CIN
36 | [NAME] | Wilson, | SEA
37 | [NAME] | Janish, | CIN
38 | Cesar | Izturis, | BAL
39 | Adrian | Cardenas, | OAK
40 | [NAME] | [NAME], | COL
41 | Eduardo | Nunez, | NY-A
42 | Tyler | Greene, | STL
43 | Ruben | Tejada, | NY-N
44 | Adeiny | Hechavarria, | TOR
45 | [NAME] | Gordon, | LA
46 | Grant | Green, | OAK
47 | [NAME] | Iglesias, | BOS
Spreadsheet: 154276d1336351520-need-formula-to-count-number-of-distinct-organizational-represented-on-worksheet-company-number-example
Sheet: Sheet1

REC_NUM | WKSHT_ID | LINE_NUM | CLMN_NUM | ITM_VAL | ORG_NUM | FY_END_DT
251909 | [NAME] | 00500 | 0100 | 49607 | 29900 | 2009-11-14 00:00:00
251909 | [NAME] | 00610 | 0100 | 9553 | 29900 | 2009-11-14 00:00:00
851909 | [NAME] | 00620 | 0100 | 56109 | 29900 | 2009-11-14 00:00:00
851909 | [NAME] | 00640 | 0100 | 181042 | 29900 | 2009-11-14 00:00:00
851909 | [NAME] | 00660 | 0100 | 333728 | 29900 | 2009-11-14 00:00:00
851909 | [NAME] | 00700 | 0100 | 34634 | 29900 | 2009-11-14 00:00:00
851909 | [NAME] | 01000 | 0100 | 70844 | 29900 | 2009-11-14 00:00:00
252041 | [NAME] | 00500 | 0100 | 128082 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 00600 | 0100 | 406224 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 00700 | 0100 | 112452 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 01000 | 0100 | 163985 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 01100 | 0100 | 213207 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 01400 | 0100 | 237495 | 75014 | 2009-12-31 00:00:00
252041 | [NAME] | 01600 | 0100 | 220610 | 75014 | 2009-12-31 00:00:00
Spreadsheet: 104367d1302009849-comparing-tables-looking-for-diferences-book1_xanduba
Sheet: Sheet1

exams done: |  |  |  |  | exams paid: |  |  |  | How it works > | exams not paid: |  |  |  | exams paid in error:
2011-01-01 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-01 00:00:00 | 2000111 | [NAME] |  | These Tables
2011-01-01 00:00:00 | 2001122 | [NAME] |  |  | 2011-01-02 00:00:00 | 2000111 | [NAME] |  | are not required | 2011-01-01 00:00:00 | 2001122 | [NAME]
2011-01-01 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-02 00:00:00 | 2929292 | [NAME] |  | if you use | 2011-01-01 00:00:00 | 2000111 | [NAME]
2011-01-02 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-03 00:00:00 | 2001122 | Russian Troll |  | Conditional Formatting only
2011-01-02 00:00:00 | 2929292 | [NAME] |  |  | 2011-01-03 00:00:00 | 4823111 | [NAME] |  |  |  |  |  |  | 2011-01-03 00:00:00 | 4823111 | [NAME]
2011-01-03 00:00:00 | 2000111 | [NAME] |  |  |  |  |  |  |  | 2011-01-03 00:00:00 | 2000111 | [NAME]
2011-01-03 00:00:00 | 2001122 | Russian Troll