tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867397d1714226750-trying-to-find-the-earliest-and-latest-date-occurrence-in-year-earliest-and-latest-date
Sheet: Sheet1

 | Data Table |  |  | My curent table |  |  |  | Desired Results
 |  |  |  |  | Earliest | Latest |  |  | Earliest | Latest
 | 1996 | 2024-07-06 00:00:00 |  | 1996 |  |  |  | 1996 | 2024-02-16 00:00:00 | 2024-07-06 00:00:00
 | 1996 | 2024-02-16 00:00:00 |  | 1997 |  |  |  | 1997 |  |  | Blank if no warnings that year
 | 1996 | 2024-05-15 00:00:00 |  | 1998 |  |  |  | 1998 | 2024-02-12 00:00:00 | 2024-12-15 00:00:00
 | 1998 | 2024-12-15 00:00:00 |  | 1999 |  |  |  | 1999 | 2024-06-15 00:00:00 | 2024-06-15 00:00:00
 | 1998 | 2024-04-13 00:00:00
 | 1998 | 2024-02-12 00:00:00 |  | Average |  |  |  | Average
 | 1999 | 2024-06-15 00:00:00
Spreadsheet: 781365d1653284157-transpose-headers-and-line-items-sample
Sheet: Expected Result

NAME | TEXT | TYPE | LENGTH | FIELD_POS | CHARACTER_FIRST | CHARACTER_LAST
TABNAM | Name of Table Structure | CHARACTER | 10 | 1 | 1 | 10
MANDT | Client | CHARACTER | 3 | 2 | 11 | 13
[NAME] | IDoc number | CHARACTER | 16 | 3 | 14 | 29
Spreadsheet: 127229d1320245197-3-month-moving-average-dashboard-forum_sample
Sheet: List

Country |  |  | Month |  | Type | Baseline |  | Region Table
Country 1 |  |  |  |  | Type 1 | 0.95 |  | R1
Country 2 |  |  |  |  | Type 2 Patch | 0.95 |  | R2
Country 3 |  |  |  |  | Type 3 Patch | 0.95 |  | R3
Country 4 |  |  |  |  |  |  |  | R4
Country 5
Country 6
Country 7
Country 8
Country 9
Country 10
Country 11
Country 12
Country 13
Country 14
Country 15
Country 16
Country 17
Country 18
Country 19
Country 20
Country 21
Country 22
Country 23
Country 24
Country 25
Country 26
Country 27
Country 28
Country 29
Country 30
Country 31
Country 32
Country 33
Spreadsheet: 889982d1741078658-custom-formatting-with-condition-achu23186-cf-365-aligw
Sheet: Sheet1

Component | Metric / KPIs | Target | Actual | Delta
Overdue | Overdue % on AR | 0.28 | 0.2524776249603203
 | Overdue >15 days % on AR | 0.07 | 0.07038162844427359
 | Overdue >30 days % on AR | 0.03 | 0.02431615268359405
 | Overdue >90 days % on AR | 0.01 | 0.00587625961094681
Spreadsheet: joe_parks__14830__el paso wire request_lk
Sheet: Wsuppl 8-7-00

 | FOR SAP COMPANIES ONLY
 | Supplemental Wire Transfer Request
 |  | Attach to Wire Transfer Request Form
For Further Credit | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
Accounting Code | Amount |  | Co Number | Tax Code | City/        outside city | ZIP where Consumed | Trading Partner
 |  |  | GL Account | Cost Center | Order | WBS Element
 |  |  | Network | Activity | Allocation |  | Profit Center
 |  |  |  | Material | Asset | Description
Spreadsheet: 476475d1471889334-combine-data-from-rows-of-duplicate-id-numbers-characters
Sheet: Sheet1

ID - RecNo |  |  | 1 | 1 | 1 | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"") | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5
 | Constituent Number | Last or Org Name | Value | Is Primary | Notes | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"") | Is Primary | Value | Notes | Is Primary | Value | Notes | Is Primary | Value | Notes | Is Primary | Value | Notes
A3=Countifs($B$3:B3) | 465 | Daffy | 111-1111 |  | Histerical | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 465 | Daffy | 111-1112 | T |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 984 | Santa | 222-2222 |  | hohoho | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 984 | Santa | 222-2223 |  | [NAME] | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 984 | Santa | 222-2224 | T |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 273 | Minnie | 333-3333 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 273 | Minnie | 333-3334 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 273 | Minnie | 333-3335 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 273 | Minnie | 333-3336 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 273 | Minnie | 333-3337 | T |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 33 | Tweety | 444-4444 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 33 | Tweety | 444-4445 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 33 | Tweety | 444-4446 | T |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 722 | Sleepy | 555-5555 |  | Yawn | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 722 | Sleepy | 555-5556 | T |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 39 | [NAME] | 666-6666 |  |  | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
A3=Countifs($B$3:B3) | 39 | [NAME] | 666-6667 | T | [NAME] slipper | G3=IF($A3=1,=IF(COUNTIFS($B:$B,$B3)>=G$1+1,OFFSET($D3,F$1,0),""),"")
Spreadsheet: 0206efd8-f0d8-420d-b485-bd3bf75d849c
Sheet: +60 MD

BWF World Senior Championships 2013
MD 60
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Quarterfinals | Semifinals | Final | Winner
 | 52420 |  | ENG |  | [NAME] [1]
1 | 84122 |  | ENG |  | [NAME]
 | 87839 |  | FRA |  | [NAME]
2 | 55616 |  | FRA |  | [NAME]
 | 95236 |  | FIN |  | [NAME]
3 | 88362 |  | FIN |  | [NAME]
 | 60280 |  | CAN |  | [NAME]
4 | 95301 |  | CAN |  | [NAME]
 | 98294 |  | JPN |  | Katsuhiro Miyamoto [5/8]
5 | 90310 |  | JPN |  | Hideo Yamamoto
 | 62070 |  | IND |  | Raja Bose
6 | 95861 |  | IND |  | [NAME]
 | 86233 |  | SWE |  | [NAME]
7 | 62963 |  | SWE |  | [NAME]
 | 52507 |  | RUS |  | [NAME]
8 | 52506 |  | RUS |  | [NAME]
 | 77892 |  | DEN |  | Arne Gjelstrup [3/4]
9 | 50074 |  | DEN |  | [NAME]
 | 84226 |  | RSA |  | [NAME]
10 | 69406 |  | RSA |  | Harvey Pieter Christoffel Ferreira
 | 98645 |  | FRA |  | [NAME]
11 | 75708 |  | FRA |  | [NAME]
 | 80500 |  | THA |  | Bandid Jaiyen
12 | 73232 |  | THA |  | [NAME]
 | 58494 |  | DEN |  | Per Dabelsteen [5/8]
13 | 58209 |  | NOR |  | Terje  Dag Osthassel
 | 97361 |  | TUR |  | [NAME]
14 | 72302 |  | TUR |  | Mehmet Yavas
 | 63342 |  | SRI |  | [NAME]
15 | 98822 |  | SRI |  | [NAME] Nallathamby
 | 99789 |  | IND |  | Bendangnukshi Jamir
16 | 87417 |  | IND |  | Kelhousithie Kire
 | 52508 |  | RUS |  | [NAME]
17 | 89577 |  | RUS |  | Yury Pustyakov
 | 86591 |  | IND |  | [NAME]
18 | 75841 |  | IND |  | Shirish Nadkarni
 | 5890 |  | BUL |  | Delcho Kolev
19 | 63860 |  | BUL |  | [NAME]
 | 65347 |  | SWE |  | [NAME] [5/8]
20 | 52392 |  | SWE |  | [NAME]
 | 84491 |  | GER |  | [NAME]
21 | 88848 |  | NED |  | [NAME]
 | 61110 |  | FRA |  | [NAME]
22 | 60407 |  | FRA |  | Alain Sistac
 | 81220 |  | NOR |  | Helge Hansen
23 | 68742 |  | SWE |  | Per-Arnold Hoij
 | 2770 |  | ENG |  | [NAME] [3/4]
24 | 89392 |  | ENG |  | [NAME]
 | 78315 |  | CAN |  | [NAME]
25 | 86070 |  | CAN |  | [NAME]
 | 52438 |  | GER |  | [NAME]
26 | 52437 |  | GER |  | Claus-Peter Lienig
 | 76503 |  | FIN |  | [NAME]
27 | 80496 |  | FIN |  | Lars-Henrik Nybergh
 | 71999 |  | JPN |  | [NAME] [5/8]
28 | 97981 |  | JPN |  | [NAME]
 | 72053 |  | ENG |  | [NAME]
29 | 88980 |  | ENG |  | [NAME]
 | 99123 |  | THA |  | [NAME]
30 | 75994 |  | THA |  | [NAME]
 | 85023 |  | IND |  | [NAME]
31 | 88937 |  | IND |  | Darayas Surti
 | 62649 |  | DEN |  | [NAME] [2]
32 | 61590 |  | DEN |  | [NAME]
Spreadsheet: 694990d1599937000-extract-unique-distinct-pairs-from-a-range-book1
Sheet: Sheet1

[NAME] | [NAME] |  | This is what the formula should return:
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  | <--Correct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Spreadsheet: 172851d1344355695-auto-fill-with-data-from-other-worksheet-example-of-file-1-day92
Sheet: Dashboard

account # | name | [NAME]? | Birthdate | Documentation | Date approved
01-23-456-789
25-58-456-745
08-15-758-586
03-25-125-548
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: East Power Trading

 | East Power Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 2
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  | 0 |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  |  |  | Director | 156000
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000
 |  |  |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 888327d1738830710-dynamic-indirect-lookup-formula-example-2
Sheet: (MatchUp)

2025-02-06 00:00:00 |  |  |  |  |  |  |  |  |  | OFFENSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEFENSE
 |  |  |  |  |  |  |  | Rest |  | Tm | Opp | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF |  | FG | FGA | FG % | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | TRB | AST | STL | BLK | TOV | PF
Alb |  |  |  |  | Conf, [NAME] |  | 135.3333333333333 | 5 |  | 65.66666666666667 | 69.66666666666667 | 23 | 53.66666666666666 | 0.4285714285714285 | 5 | 20.33333333333333 | 0.2459016393442623 | 14.66666666666667 | 20 | 0.7333333333333333 | 10 | 32.33333333333334 | 9 | 7.666666666666667 | 2.666666666666667 | 14.66666666666667 | 12.66666666666667 |  | 26 | 54.66666666666666 | 0.475609756097561 | 8.333333333333334 | 22 | 0.3787878787878788 | 9.333333333333334 | 11.66666666666667 | 0.8 | 5 | 24 | 15.33333333333333 | 8 | 4 | 12.33333333333333 | 15.33333333333333
AP |  |  |  |  | Conf, Home |  | 154.25 | 4 |  | 77.75 | 76.5 | 25.75 | 62 | 0.4153225806451613 | 11.75 | 30.25 | 0.3884297520661157 | 14.5 | 20.75 | 0.6987951807228916 | 7.5 | 32 | 13.25 | 7.75 | 3.5 | 9.75 | 16 |  | 27.75 | 63.75 | 0.4352941176470588 | 6.75 | 19.75 | 0.3417721518987342 | 14.25 | 19.25 | 0.7402597402597403 | 10 | 39.75 | 11.25 | 6 | 4.25 | 11.25 | 17.5
Spreadsheet: 105645d1302946700-2-way-lookup-with-rule-2-way-lookup
Sheet: Sheet1

Wall | 1 | 2 | 3 | 4 | 5 |  | Colors
Back wall | Green | Blue | Yellow | Red | Green |  | Green
Front Wall | Yellow | Red | Orange | Blue | Green |  | Blue
Side Wall | Yellow | Green | Yellow | Orange | Orange |  | Yellow
Ceiling | Blue | Red | Orange | Green | Yellow |  | Red
 |  |  |  |  |  |  | Orange
Wall | 1 | 2 | 3 | 4 | 5
Back wall
Front Wall | Yellow |  |  | Blue | Green
Side Wall
Ceiling
Spreadsheet: 781311d1653210760-help-with-determining-the-right-formula-to-use-sample-worksheet-bar-tab
Sheet: Raw Data

Drink | Category | Normal | Happy Hour
Beer (Can) | Beer | 1 | 0.75
Draft Beer | Beer | 1 | 0.75
Coca Cola | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | Category | Standard Price | Happy Hour Price
Coke Light | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | Beer | 1 | 0.75
Coke Zero | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | [NAME] | 1 | 0.75
Sprite | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | Juice | 1 | 1
7Up | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | House Spirit | 1.5 | 1
[NAME] | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | [NAME] | 2 | 1.8
Tonic Water | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | [NAME] | 2.5 | 2.25
[NAME] | [NAME] | 1 | 0.75 |  |  |  |  |  |  |  | Premium Spirit | 3 | 2.7
Orange Juice | Juice | 1 | 1 |  |  |  |  |  |  |  | Mocktail | 2 | 1.5
Pineapple Juice | Juice | 1 | 1 |  |  |  |  |  |  |  | Cocktail 1 | 3 | 2.25
Apple Juice | Juice | 1 | 1 |  |  |  |  |  |  |  | Cocktail 2 | 3.25 | 2.5
[NAME] | Juice | 1 | 1 |  |  |  |  |  |  |  | Wine | 2.5 | 2
House Whisky with mixer | House Spirit | 1.5 | 1 |  |  |  |  |  |  |  | Jug | 8 | 6
House Vodka & mixer | House Spirit | 1.5 | 1
House Gin & mixer | House Spirit | 1.5 | 1
House Rum & mixer | House Spirit | 1.5 | 1
[NAME] with mixer | House Spirit | 1.5 | 1
[NAME] shot | House Spirit | 1.5 | 1
PASTIS with Coke | House Spirit | 1.5 | 1
[NAME] with mixer | Branded Spirit 1 | 2
Gordons & mixer | Branded Spirit 1 | 2
Bombay & Mixer | Branded Spirit 1 | 2
Stoli & Mixer | Branded Spirit 1 | 2
[NAME] | Branded Spirit 1 | 2
Mocktail JRP | Mocktail | 2 | 1.5
Mocktail Mojito | Mocktail | 2 | 1.5
[NAME] | Mocktail | 2 | 1.5
Blue hawaiian mocktail | Mocktail | 2 | 1.5
Virgin sunrise | Mocktail | 2 | 1.5
[NAME] | Mocktail | 2 | 1.5
Jamesons with mixer | Branded Spirit 2 | 2.5 | 2.25
Hendricks with mixer | Branded Spirit 2 | 2.5
[NAME] | Branded Spirit 2 | 2.5
[NAME] | Branded Spirit 2 | 2.5
Sangria glass | Wine | 2.5 | 2
White Wine | Wine | 2.5 | 2
[NAME] | Wine | 2.5 | 2
Red Wine | Wine | 2.5 | 2
Grey Goose & Mixer | Premium Spirit | 3
Glenfiddich with mixer | Premium Spirit | 3
[NAME] | Cocktail 1 | 3 | 2.25
Mojito | Cocktail 1 | 3 | 2.25
Old Fashioned | Cocktail 1 | 3 | 2.25
Dark n Stormy | Cocktail 1 | 3 | 2.25
Antiqua rum punch | Cocktail 1 | 3 | 2.25
Jamican rum punch | Cocktail 1 | 3 | 2.25
Blue Lagoon | Cocktail 1 | 3 | 2.25
[NAME] | Cocktail 1 | 3 | 2.25
[NAME] | Cocktail 1 | 3 | 2.25
Vodka sour | Cocktail 1 | 3 | 2.25
Vodka sunrise | Cocktail 1 | 3 | 2.25
Long Island Ice Tea | Cocktail 2 | 3.25 | 2.5
[NAME] | Cocktail 2 | 3.25 | 2.5
Blue Hawaiian | Cocktail 2 | 3.25 | 2.5
Sangria jug | Jug | 8 | 8
Spreadsheet: 773478d1647879579-nested-formulas-in-excel-sheet-sample
Sheet: Master

Produk | Prys | Virginia | [NAME] | Cindy/Jenny | Yolandie | Sus | Moniqudex | [NAME] | [NAME] | Andrisa | Name | [NAME] | Name3 | Name4 | Name5 | Name6 | Name7 | Name8 | Name9 | Name10 | Name11 | Name12 | Totaal Produk Bestel | Totaal Per Produk
Sunlight Liq | 60 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 8
Jik | 80 |  | 0 | 1
[NAME] | 120 |  | 1 | 1
Sunlight Liq
Vanish
Totaal Per Persoon
Spreadsheet: 485680d1477012234-return-a-count-based-on-date-and-type-from-closed-workbook-sumifs
Sheet: Sheet1

Date | Qty | Type
2015-09-12 00:00:00 | 2 | sq |  | sq
2015-09-16 00:00:00 | 1 | sq |  | ow
2015-09-30 00:00:00 | 2 | ow
2015-10-12 00:00:00 | 2 | sq
2015-10-13 00:00:00 | 4 | ow
2015-11-17 00:00:00 | 2 | ow
2015-11-21 00:00:00 | 2 | ow
2015-12-13 00:00:00 | 1 | sq
2015-12-19 00:00:00 | 1 | sq
2015-12-21 00:00:00 | 2 | sq
2016-01-02 00:00:00 | 1 | sq
2016-01-07 00:00:00 | 2 | sq
2016-01-12 00:00:00 | 2 | ow
[NAME] need to find earliest date in col A (dates could be random) use as start date and count QTY for sq up to and including todays date, 20th October.
This would return : 5
Spreadsheet: 271721d1382027346-get-the-top-5-values-and-associated-names-deals-data
Sheet: Version 2

 |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | Win/Loss Analysis
 |  |  | Select Month |  | 2013-09-01 00:00:00
 |  |  |  |  |  |  |  | Average Life cycle |  | Days
 |  |  |  |  |  |  |  | Average Win time |  | Days
 |  |  |  |  |  |  |  | Average Loss time |  | Days
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Montly Target |  | USD
 |  |  |  |  |  |  |  | Achieved (Won) |  | USD
 |  |  |  |  |  |  |  | Month (%)
 |  |  |  |  |  |  |  | Difference |  | USD
 |  |  |  |  |  |  | Pipeline - Number of Deals | Pipeline - Revenue
 |  |  |  |  |  |  |  | Month
 |  |  | Biggest Deals Open |  |  |  |  | Targets |  |  |  |  |  |  | Biggest Open Deals
 |  |  | Advertiser |  |  | Amount [USD] |  | Won
Need help here. |  |  |  |  |  |  |  | Loss
Name shoud depend |  |  |  |  |  |  |  | Pending |  |  |  |  |  | Very media
on the name of the sheet |  |  |  |  |  |  |  |  |  |  |  |  |  | AEG Live
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange Nation
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Esmale.com
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PrimeGaming
This is the other issue
I mentioned
It should be PrimeGaming |  |  | Longest Pending Deals |  | Days | Amount
 |  |  | Lost Deal Analysis |  |  |  |  |  | Pending Deal Analysis
 |  |  | Stage | No. of Deals |  |  |  |  | Stage | No. of Deals | Revenue
 |  |  | [NAME] (S1) |  |  |  |  |  | [NAME] (S1)
 |  |  | Sent Proposal (S2) |  |  |  |  |  | Sent Proposal (S2)
 |  |  | Sent Proposal (S3) |  |  |  |  |  | Sent Proposal (S3)
 |  |  | [NAME] ([NAME]) |  |  |  |  |  | [NAME] ([NAME])
 |  |  |  |  | Recent Log
 |  |  | Recent activies from Highrise
 |  |  | 2.15 pm | Note: Meeting with Adconion tomorrow
 |  |  | 1.45 pm | email: [NAME] ……
 |  |  | Monthly Performance
 |  |  | [NAME] | Won | Lost | Pending | Total | Won % | Lost % | Pending %
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 682662d1592240248-data-validation-with-an-extra-entry-for-all-in-the-list-gl3
Sheet: Invoice Detail

Invoice No | Inv Date | Customer | Factory | Product | Qty | Price | Adj Type | Adj Value | Total | Comm. % | Comm. | Year | Perf
1 |  |  |  | X1 | 10 | 10 | None |  |  | 9
1 |  |  |  | X14 | 10 | 20 | None |  |  | 9
1 |  |  |  | X15 | 25 | 15 | None |  |  | 9
2 |  |  |  | X1 | 50 | 10 | None |  |  | 9
3 |  |  |  | X4 | 60 | 5 | None |  |  | 9
3 |  |  |  | X7 | 50 | 25 | None |  |  | 9
4 |  |  |  | Y12 | 60 | 35 | None |  |  | 9
4 |  |  |  | [NAME] | 50 | 25 | None |  |  | 9
5 |  |  |  | X7 | 50 | 25 | None |  |  | 9
5 |  |  |  | X8 | 80 | 40 | None |  |  | 9
5 |  |  |  | X15 | 10 | 15 | None |  |  | 9
6 |  |  |  | [NAME] | 20 | 2 | None |  |  | 9
7 |  |  |  | Z6 | 30 | 8 | None |  |  | 9
8 |  |  |  | X8 | 30 | 14 | None |  |  | 9
9 |  |  |  | Y6 | 40 | 15 | None |  |  | 9
Spreadsheet: 86510d1286470116-auto-delete-cell-value-after-selection-from-list-new-microsoft-office-excel-worksheet
Sheet: item

 |  | MCB | SiemensPart | Siemens
 |  | Sp 2A
 |  | Dp 2A
 |  |  | MCCB | terminal | pb | Ind_Lamp | wire | smps
 |  |  | 3 pole 60Amp | terminal [NAME]. [NAME] | PB 16 Sq.mm | Ind Lamp 22.5 sq.mm | wire 0.5 sq.mm | 1ph 24 VDC /5 A
 |  |  | 4 pole 60Amp | terminal 4 Sq. [NAME] | PB 22.5 Sq.mm | Ind Lamp 16 sq.mm | wire1.0 sq.mm | 3ph 24 VDC /5 A
Spreadsheet: 104047d1301672988-adding-a-header-forces-new-page-pm-list-a-g
Sheet: BLANK - Single

 |  |  |  | OVERHEAD DOOR COMPANY OF GREATER MILWAUKEE
 |  |  |  | A Division of J.F. Cook Co., Inc.
 |  |  |  | 7830 S. 10th St. | P.O. Box 88 | Oak Creek, WI 53154             www.jfcookco.com | Phone: [PHONE] | Fax: [PHONE]
 |  | Customer: |  |  |  | Contact:
 |  | Address:
 |  |  |  | DOOR NUMBERS:
 |  | LOCATION:
 |  | DOORS
 | 1 | Inspect Section Condition
 | 2 | Inspect & Adjust Door Alignment
 | 3 | Lubricate & Inspect Rollers & Bearings
 | 4 | Adjust & Lubricate Springs
 | 5 | Inspect Spring for Secure Mounting
 | 6 | Inspect & Tighten Hingest & Hardware
 | 7 | Inspect Cables for Wear or Damage
 | 8 | Inspect Drums for Wear or Damage
 | 9 | Inspect Locks for Proper Operation
 | 10 | [NAME] or Damage
 | 11 | Inspect Track Fasteners & Hangers
 | 12 | Lubricate & Inspect Chain Hoise
 |  | OPERATOR
 | 13 | Inspect & Adjust Limit Switches
 | 14 | Inspect & Adjust Belts
 | 15 | Inspect & Lubricate Roller Chain
 | 16 | Inspect & Adjust Brake
 | 17 | Inspect & Adjust clutch
 | 18 | Inspect Operator Mounting
 | 19 | Inspect & Test Disconnect
 | 20 | Inspect & Tighten All Sprockets
 | 21 | Lubricate All Bearings
 | Door | Comment or Description of Needed Repair |  |  |  |  |  | Approval | Complete
Spreadsheet: 852628d1702596391-trying-to-set-up-a-formula-that-enables-a-leapfrog-points-system-for-a-sports-ladder-tennis-ladder
Sheet: Ladder

 | Men's Team  Tennis Ladder
 | Player | Total Matches Played | Total Wins | Total Losses | Challenges made | Challenges Won |  | Points from challenges | Total Points
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15
 | Zak | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13
 | Martin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
 | Clive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
 | Ian | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
 | [NAME] | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 7
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6
 | Julian | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
 | Nick | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | Guy | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1
RAW DATA
Player | [NAME] | Total Wins | Total Losses | Total Challenges | Challenges Won | Challenges Won (%) | Points Won | Total Points | Initial Ladder Ranking
[NAME] |  |  |  |  |  |  |  |  | 15
Zak |  |  |  |  |  |  |  |  | 14
[NAME] |  |  |  |  |  |  |  |  | 13
Martin |  |  |  |  |  |  |  |  | 12
Clive |  |  |  |  |  |  |  |  | 11
[NAME] |  |  |  |  |  |  |  |  | 10
[NAME] |  |  |  |  |  |  |  |  | 9
Ian |  |  |  |  |  |  |  |  | 8
[NAME] |  |  |  |  |  |  |  |  | 7
[NAME] |  |  |  |  |  |  |  |  | 6
[NAME] |  |  |  |  |  |  |  |  | 5
Julian |  |  |  |  |  |  |  |  | 4
Nick |  |  |  |  |  |  |  |  | 3
[NAME] |  |  |  |  |  |  |  |  | 2
Guy |  |  |  |  |  |  |  |  | 1