tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94486d1294284572-two-filter-items-how-to-combine-or-create-or-statement-double-filter-or-question
Sheet: Sheet1

Client Name | Client Resource 1 | Client Resource 2 | Date of Engagement |  | Client Resource 1 | (All)
ABC inc | [NAME] | [NAME] | 2011-01-05 00:00:00 |  | Client Resource 2 | (All)
123 Company | [NAME] | [NAME] | 2011-01-05 00:00:00
Acme | [NAME] | [NAME] | 2011-01-08 00:00:00
[NAME] | [NAME] | [NAME] | 2011-01-01 00:00:00 |  | Client Name | Date of Engagement
 |  |  |  |  | 123 Company | 2011-01-05 00:00:00
 |  |  |  |  | ABC inc | 2011-01-05 00:00:00
 |  |  |  |  | Acme | 2011-01-08 00:00:00
 |  |  |  |  | [NAME] | 2011-01-01 00:00:00
 |  |  |  |  | Grand Total
Spreadsheet: 841304d1693493579-match-date-on-two-different-pages-and-paste-data-in-columns-ef-file
Sheet: 3-13 Day

 | CR1 | Priority | Headcount
1 | Alinity RV | High | 0.25
2 | Alinity RV | High | 0.25
3 | Alinity RV | High | 0.25
4 | Alinity RV | High | 0.25
5 | Alinity RV | High | 0.25
12 | [NAME] | Low
13 | Baxter cap | High | 0.25
9 | Architect RV | High | 0.25
15 | [NAME] tray | Med/High | 0.5
16 | Architect RV | High | 0.25
17 | Alinity RV | High | 0.25
50 | Baxter SIV Assy | Medium | 2
31 | Architect RV | High | 0.25
8 | Alinity RV | High | 0.25
10 | Architect RV | High | 0.25
11 | [NAME] | Low
18 | Architect RV | High | 0.25
19 | Architect RV | High | 0.25
20 | Beckman 3ml | High | 0.25
21 | Architect RV | High
22 | Architect RV | High | 0.25
23 | Architect RV | High | 0.25
30 | Architect RV | High | 0.25
7 | Architect SC | Med/High | 0.25
Total
 | CR2 | Priority
71 | PP4 | High | 0.25
72 | 8ul ES | *
73 | PP1 | High | 0.25
74 | Side Cassette A | High | 0.25
76 | PP3 OQ | *
77 | Base Cassette | High | 1
78 | Side Cassette B | High | 0.25
79 | [NAME] | High | 0.25
87 | Top Frame A | High | 0.25
52 | Architect RV | High | 0.25
53 | Architect RV | High | 0.25
54 | Siemens KS860 | High | 0.5
59 | Architect RV | High | 0.25
61 | [NAME] trays | High | 0.5
66 | [NAME] | High | 0.5
83 | Over [NAME] | Medium | 2
84 | Ceph MB#1 | Med/High
86 | [NAME] | Med/High | 0.25
62 | NP227 | Low
63 | NP Birdcage | Low
64 | Siemens 1ML
67 | [NAME] | High
69
88 | Side Pump | High | 0.25
89 | Top Frame B | High | 0.25
95 | Beckman Unicel E | Low
96 | Beckman Unicel F | Low
106 | [NAME] shell key assembly | High | 2
107 | Snap Ring | Medium
108 | [NAME] shell | High | 0.25
109 | over cap | Medium | 0.25
Total
 | [NAME] |  | 1.25
 | [NAME] |  | 1
 |  |  |  |  |  | 20
Spreadsheet: 120723d1315485875-pivot-table-analysis-using-a-formula-nigel-002
Sheet: PIVOT

Parent | Component | Type
A00001 | 10001 | A
 | 10002 | C
 | 10003 | B
 | 10004 | C
 | 10005 | C
A00002 | 10002 | C
 | 10004 | C
 | 10005 | C
Grand Total
Spreadsheet: 715054d1611522777-populate-calendar-in-excel-from-list-help-calendar-1-
Sheet: Month

Budget Calendar with Daily Balance
Year: 2021 |  | Month: |  | 1 |  | Start Day: | 1 | 1=Sun, 2=Mon …
Date:
 |  |  |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  | [NAME] |  | [NAME]
 |  | [NAME] ♥ |  | [NAME] †
Spreadsheet: 136813d1326831581-lookup-a-value-and-sum-relative-to-that-value-position-sum-relative-to-variable-cell
Sheet: Sheet1

Sheet 1 |  |  |  |  | Sheet 2
Daily |  |  |  |  | Weekly | Total
Date | 1 | 2 | Total
2011-01-01 00:00:00 | 0.5 | 0.5 | 1 |  | 2011-01-01 00:00:00
2011-01-02 00:00:00 | 0.5 | 0.5 | 1
2011-01-03 00:00:00 | 0.5 | 0.5 | 1
2011-01-04 00:00:00 | 0.5 | 0.5 | 1
2011-01-05 00:00:00 | 0.5 | 0.5 | 1
2011-01-06 00:00:00 | 0.5 | 0.5 | 1
2011-01-07 00:00:00 | 0.5 | 0.5 | 1 |  | BASED ON DATE ON SHEET 2, GO TO SHEET 1, FIND SAME DATE, AND SUM FROM THAT ROW +7 DOWN
2011-01-08 00:00:00 | 1 | 1 | 2
2011-01-09 00:00:00 | 1 | 1 | 2
2011-01-10 00:00:00 | 1 | 1 | 2
2011-01-11 00:00:00 | 1 | 1 | 2
2011-01-12 00:00:00 | 1 | 1 | 2
2011-01-13 00:00:00 | 1 | 1 | 2
2011-01-14 00:00:00 | 1 | 1 | 2
2011-01-15 00:00:00 | 1.5 | 1.5 | 3
2011-01-16 00:00:00 | 1.5 | 1.5 | 3
2011-01-17 00:00:00 | 1.5 | 1.5 | 3
2011-01-18 00:00:00 | 1.5 | 1.5 | 3
2011-01-19 00:00:00 | 1.5 | 1.5 | 3
2011-01-20 00:00:00 | 1.5 | 1.5 | 3
2011-01-21 00:00:00 | 1.5 | 1.5 | 3
Spreadsheet: d14c0816-f139-4466-a0df-5db8f4bc87bf
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
Arne Domnerus | Jazz At The Pawnshop 30th Anniversary |  | CPRO 7879 SA | Hybrid Multichannel SACD & DVD Video | 4 | Jazz | Proprius | 90
Genesis | Nursery Cryme | (DVDs are PAL) | CVIR 519547 SA | Hybrid Multichannel SACD & DVD Video | 2 | Pop/Rock | Virgin | 44.99 | 509995195472
Genesis | Calling All Stations | (DVDs are PAL) | CVIR 503835 SA | Hybrid Multichannel SACD & DVD Video | 2 | Pop/Rock | Virgin | 29.99
Genesis | Calling All Stations | (DVDs are NTSC) | CVIR 503837 SA | Hybrid Multichannel SACD & DVD Video | 2 | Pop/Rock | Virgin | 19.99 | 509995038372
[NAME] | I Hate Mozart | 2 SACDs + DVD | CCLG 20277 SA | Hybrid Multichannel SACD & DVD Video | 3 | Classical | [NAME] | 56.99
Genesis | Foxtrot | (DVDs are PAL) | CVIR 519552 SA | Hybrid Multichannel SACD & DVD Video | 2 | Pop/Rock | Virgin | 69.99
Spreadsheet: 34876c14-ad6b-4942-acfa-ddcd382c1776
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 9/30/07
(As of 10/29/07)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | City Commissioner | 575
Ames, [NAME] | At-will Staff for Comm. Adams
[NAME], [NAME] | At-will Staff for Comm. Adams
Birge, [NAME] | At-will Staff for Comm. Adams | 40 | 150
Blackmer, [NAME] | City Auditor
Callahan, Shannon | At-will Staff for Comm. Saltzman
Chlapowski, Roland | At-will Staff for Comm. Adams
Hanson, [NAME] | Portland Planning Commission Member
[NAME], [NAME] | At-will Staff for Comm. Sten | 80
Kovatch, [NAME] | At-will Staff for Comm. Leonard
Leonard, [NAME] | City Commissioner | 168.5
Lim, [NAME] | At-will Staff for Comm. Adams
Lowthian, Amanda | At-will Staff for Mayor [NAME] | 25
Marriott, [NAME] | Director of Bureau of Environmental Services
Middaugh, [NAME] | At-will Staff for Comm. Sten | 80
[NAME], [NAME] | At-will Staff for Comm. Adams | 80
Oppenheim, [NAME] | At-will Staff for Comm. Adams | 140
Potter, [NAME] | Mayor | 415 | 490
Saltzman, [NAME] | City Commissioner | 265
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will Staff for Comm. Adams | 75
[NAME], [NAME] | Director of Bureau of Police | 75
Sprando, [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
[NAME], [NAME] | City Commissioner | 650 | 1500
Spreadsheet: 197808d1354565517-look-up-dummy1
Sheet: Transaction

Associate_Name | Process_Code | Amount
[NAME] | 1111 | 100
[NAME] | 2222 | 200
[NAME] | 7777 | 300
[NAME] | 1111 | 400
[NAME] | 5555 | 500
Adam | 4444 | 600
Adam | 7777 | 700
Adam | 2222 | 800
Adam | 9999 | 900
Adam | 1111 | 1000
Spreadsheet: 4ceda4ac-198b-4fbc-9c13-bbd6b8e87bfa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7771 | 25445 | [NAME] | [NAME] | GER | 0 | 01:35:52 | 00:03:36 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: john_griffith__16159__1_25_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 165 | 230 | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 53 | 575 | 675 | 46.8 | 55 | 1.7 | 2002-01-25 15:07:00
 | HO J2 | 53 | 815 | 915 | 48.3 | 54.2 | 1.71 | 2002-01-25 15:07:00
 | HO K2 | 53 | 940 | 1040 | 45.3 | 50.1 | 1.59 | 2002-01-25 15:07:00
 | HO M2 | 54 | 1060 | 1160 | 43.1 | 47.1 | 1.53 | 2002-01-25 15:07:00
 | HO N2 | 54 | 1115 | 1215 | 41 | 44.7 | 1.45 | 2002-01-25 15:07:00
 | HO Q2 | 55 | 1190 | 1280 | 39.3 | 42.3 | 1.41 | 2002-01-25 15:07:00
 | HO U2 | 56 | 1270 | 1375 | 38.2 | 41.4 | 1.4 | 2002-01-25 15:07:00
 | [NAME] | 57 | 1300 | 1400 | 36.1 | 38.9 | 1.34 | 2002-01-25 15:07:00
 | HO X2 | 58 | 1350 | 1500 | 34.8 | 38.7 | 1.34 | 2002-01-25 15:07:00
 | [NAME] | 58 | 1400 | 1550 | 34.5 | 38.2 | 1.33 | 2002-01-25 15:07:00
 | HO F3 | 58 | 1450 | 1625 | 34.3 | 38.5 | 1.33 | 2002-01-25 15:07:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 51336d1250886200-how-can-i-remove-multiple-data-by-multiple-conditions-florins
Sheet: Sheet3

 |  |  | Account1 | Sum1 |  |  |  | Account2 | Sum2
 |  |  | 151 | 93.79 | Delete |  |  | BF2479 | 30 | Delete | You would have to highlight column K, copy it, and
 |  |  | 1476757 | 93.79 |  |  |  | BF7 | 22 |  | Edit > Paste Special > Values over the top of column K
 |  |  | BF2479 | 30 | Delete |  |  | 151 | 93.79 | Delete | to turn the formulas intoo fixed values so the "delete" would
 |  |  | 86041 | 84.03 |  |  |  | 23235 | 30 |  | stay showing as you make deletions in columns D:E
 |  |  | 534 | 6608.45
Spreadsheet: 844938d1696529567-priority-task-list-book3
Sheet: Top 10

Priority | Task # | Title | Desciption
1 | 1004 | Title 4 | [NAME] 4 |  | 1004 | Title 4 | [NAME] 4
2 | 1020 | Title 20 | [NAME] 20 | 2 | 1020 | Title 20 | [NAME] 20
3 | 1006 | Title 6 | [NAME] 6 | 3 | 1006 | Title 6 | [NAME] 6
4 | 1024 | Title 24 | [NAME] 24 | 4 | 1024 | Title 24 | [NAME] 24
5 | 1016 | Title 16 | [NAME] 16 | 5 | 1016 | Title 16 | [NAME] 16
6 | 1008 | Title 8 | [NAME] 8 | 6 | 1008 | Title 8 | [NAME] 8
7 | 1018 | Title 18 | [NAME] 18 | 7 | 1018 | Title 18 | [NAME] 18
8 | 1010 | Title 10 | [NAME] 10 | 8 | 1010 | Title 10 | [NAME] 10
9 | 1028 | Title 28 | [NAME] 28 | 9 | 1028 | Title 28 | [NAME] 28
10 | 1032 | Title 32 | [NAME] 32 | 10 | 1032 | Title 32 | [NAME] 32
1
2
3
4
5 |  |  |  | What I'm getting
6
7
8
9
10
VLOOKUP(LARGE($D$2:$D$36,37-ROW()),$D$2:$F$36,2,) |  |  |  | Works on Top 20 Tab
VLOOKUP(LARGE(List!$A$2:$A$41,42-ROW()),List!$A$2:$D$41,2,) |  |  |  | Does not work on this tab
Spreadsheet: 739818d1625979603-sumproduct-with-multiple-criteria-and-partial-text-match-help-new-excel-help-sample-workbook
Sheet: Sheet1

 |  |  |  | City |  |  |  |  |  |  | Public v. Private |  |  |  |  |  |  | Type1 | Type2 | [NAME] | Network? | City A Public Non-Network Type1 | City H Public Type2 Networked | City D Private Networked Type3
 |  |  |  | Z |  |  |  |  |  |  | Private |  |  |  |  |  |  | 8 | 4 | 8 | Non-Netork | 5 | 3 | 5
 |  |  |  | A |  |  |  |  |  |  | Public - New |  |  |  |  |  |  | 6 | 6 | 6 | [NAME]
 |  |  |  | A |  |  |  |  |  |  | Public - Limited |  |  |  |  |  |  | 5 | 7 | 5 | Non-Netork
 |  |  |  | C |  |  |  |  |  |  | Public - Yes |  |  |  |  |  |  | 4 | 6 | 4 | Network
 |  |  |  | F |  |  |  |  |  |  | Private |  |  |  |  |  |  | 6 | 5 | 6 | High Network
 |  |  |  | C |  |  |  |  |  |  | Public - Sure |  |  |  |  |  |  | 7 | 4 | 7 | [NAME]
 |  |  |  | D |  |  |  |  |  |  | Public - Y |  |  |  |  |  |  | 8 | 6 | 6 | Network
 |  |  |  | E |  |  |  |  |  |  | Private |  |  |  |  |  |  | 6 | 7 | 5 | [NAME]
 |  |  |  | G |  |  |  |  |  |  | Public - New |  |  |  |  |  |  | 5 | 8 | 5 | [NAME]
 |  |  |  | H |  |  |  |  |  |  | Public - Limited |  |  |  |  |  |  | 4 | 6 | 4 | Non-Netork
 |  |  |  | R |  |  |  |  |  |  | Public - Yes |  |  |  |  |  |  | 3 | 5 | 3 | [NAME]
 |  |  |  | T |  |  |  |  |  |  | Private |  |  |  |  |  |  | 4 | 4 | 4 | Non-Netork
 |  |  |  | R |  |  |  |  |  |  | Public - Sure |  |  |  |  |  |  | 6 | 5 | 6 | non-Netork
 |  |  |  | F |  |  |  |  |  |  | Public - Y |  |  |  |  |  |  | 7 | 6 | 4 | Network
 |  |  |  | H |  |  |  |  |  |  | Private |  |  |  |  |  |  | 8 | 4 | 5 | [NAME]
 |  |  |  | H |  |  |  |  |  |  | Public - New |  |  |  |  |  |  | 9 | 3 | 6 | [NAME]
 |  |  |  | F |  |  |  |  |  |  | Public - Limited |  |  |  |  |  |  | 9 | 9 | 4 | Non-Netork
 |  |  |  | D |  |  |  |  |  |  | Public - Yes |  |  |  |  |  |  | 6 | 8 | 3 | High Network
 |  |  |  | D |  |  |  |  |  |  | Private |  |  |  |  |  |  | 5 | 6 | 5 | [NAME]
 |  |  |  | F |  |  |  |  |  |  | Public - Sure |  |  |  |  |  |  | 4 | 5 | 7 | Non-Netork
 |  |  |  | V |  |  |  |  |  |  | Public - Y |  |  |  |  |  |  | 4 | 4 | 9 | [NAME]
 |  |  |  | N |  |  |  |  |  |  | Private |  |  |  |  |  |  | 3 | 4 | 9 | Non-Netork
 |  |  |  | M |  |  |  |  |  |  | Public - New |  |  |  |  |  |  | 4 | 4 | 8 | [NAME]
 |  |  |  | I |  |  |  |  |  |  | Public - Limited |  |  |  |  |  |  | 4 | 3 | 3 | [NAME]
 |  |  |  | Y |  |  |  |  |  |  | Public - Yes |  |  |  |  |  |  | 4 | 4 | 6 | Non-Netork
 |  |  |  | F |  |  |  |  |  |  | Private |  |  |  |  |  |  | 5 | 4 | 4 | [NAME]
Spreadsheet: 838894d1691500814-need-warehouse-to-store-product-transfer-equation-work-book
Sheet: Sheet1

 | Product | WH Stock | Transfer from WH to Store | Store Demand | Transfer from WH to Store
 | Soap | 500 | Store 1 | 100
 | Soap | 500 | Store 2 | 300
 | Detergent | 100 | Store 3 | 150
 | Detergent | 100 | Store 4 | 150
 | Soap | 500 | Store 3 | 200
 | Soap | 500 | Store 7 | 200
 | Hand Wash | 800 | Store 1 | 500
 | Hand Wash | 800 | Store 2 | 400
 | Soap | 500 | Store 4 | 150
 | Soap | 500 | Store 5 | 150
 | Soap | 500 | Store 6 | 200
 | Hand Wash | 800 | Store 3 | 300
 | Hand Wash | 800 | Store 4 | 300
 | Hand Wash | 800 | Store 5 | 300
 | Detergent | 100 | Store 1 | 250
 | Detergent | 100 | Store 2 | 250
 | Detergent | 100 | Store 5 | 200
 | Detergent | 100 | Store 6 | 100
Spreadsheet: f5875eb1-7742-45f5-9abc-774034c5b94e
Sheet: Sheet1

1.4.6 - Evolución de los hogares según la posibilidad de ahorrar. 1998-2005 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005
Sí | 3971998 | 4475466 | 5191256 | 5344973 | 5351900 | 5334884 | 5789520 | 6349465
No o muy poco | 7846280 | 7842422 | 7795184 | 8009447 | 8391388 | 8749806 | 8646603 | 8436334
No consta | 445134 | 353778 | 99758 | 113648 | 99452 | 102753 | 92136 | 79907
Total | 12263412 | 12671666 | 13086198 | 13468068 | 13842740 | 14187443 | 14528259 | 14865706
Fuente: Elaboración [NAME] partir de INE, Encuesta continua de presupuestos familiares. Resultados anuales (publicación electrónica), varios años; y datos INE.
Spreadsheet: 123347d1317592718-excel-2007-calculating-bonus-formula-retail-sales-incentive-program
Sheet: OCTOBER

October Retail Sales Incentive Program
Date | Order # | Amount | Item # | Qty | Type | Payment | Bonus Bike
 |  | 10000
 |  | 10000 |  |  |  |  |  | $30,000-$50,000 @ .5% | $50,001+ @ 1%
 |  | 10000
 |  | 10000 |  |  |  |  |  | I need this cell to calculate .5% for the total on C13's if total is from $30K-$50K | I need this cell to calculate 1% for the total on C13's if total is from $50001 and above
 |  | 10000
 |  | 10000
 |  | 10000
 |  | 10000 |  |  |  |  |  | Bonus should equal $100 | Bonus should equal $299.99
Total
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: visit types

visit type | person |  | 0 | No revisit
Survey | GC |  | 1 | Revisit-1
Installation | GC |  | 2 | Revisit-2
Integration | FE |  | 3 | Revisit-3
Call and Data testing | FE |  | 4 | Revisit-4
Alarm clearing | FE |  | 5 | Revisit-5
Others |  |  | 6 | Revisit-6
 |  |  | 7 | Revisit-7
 |  |  | 8 | Revisit-8
 |  |  | 9 | Revisit-9
 |  |  | 10 | Revisit-10
Spreadsheet: 857997d1706807860-index-small-repeatation-excel-test
Sheet: Statement

 | Customer Name | Customer 3
 | Month of Claim | March
 |  |  |  | Total:
 | Account Number | Ref No | Month | Discount | Usage in KWH | Total Value | [NAME] | Sub Total.
Spreadsheet: kate_symes__18195__EESSales_dailyfeb
Sheet: 2-19

NP15 | 2001-02-19 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 315.6 | Fixed Off Peak | 227.11 |  |  |  | Fixed Peak | 295.83 |  | Fixed Off Peak | 202.27 |  |  | Fixed Peak | 295.83 | Fixed Off Peak | 202.27
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -8.89 | -8.89 |  |  | 1 | -191.39 | 0 | -54 | -174.23 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | 0 | 0 | -8.12 | -8.12 |  |  | 2 | -192.24 | 0 | -54 | -164.31 |  |  | 2 | -1.95 | 0 | 0 | -1.95
3 | 0 | 0 | -7.73 | -7.73 | 0 |  | 3 | -193.35 | 0 | -44 | -161.03 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | 0 | 0 | -7.62 | -7.62 |  |  | 4 | -193.28 | 0 | -44 | -160.39 |  |  | 4 | -1.92 | 0 | 0 | -1.92
5 | 0 | 0 | -7.83 | -7.83 |  |  | 5 | -192.85 | 0 | -44 | -164.39 |  |  | 5 | -1.93 | 0 | 0 | -1.93
6 | 0 | 0 | -9.74 | -9.74 |  |  | 6 | -190.98 | 0 | -54 | -177.31 |  |  | 6 | -2.01 | 0 | 0 | -2.01
7 | 0 | 0 | -13.07 | -13.07 |  |  | 7 | -244.93 | 0 | -54 | -192.47 |  |  | 7 | -2.15 | 0 | 0 | -2.15
8 | -1.61 | 0 | -14 | -15.61 |  |  | 8 | -243.02 | 0 | -54 | -199.56 |  |  | 8 | -2.26 | 0 | 0 | -2.26
9 | -2.71 | 0 | -14 | -16.71 |  |  | 9 | -241.59 | 0 | -54 | -211.16 |  |  | 9 | -2.3 | 0 | 0 | -2.3
10 | -2.66 | 0 | -14 | -16.66 |  |  | 10 | -241.13 | 0 | -54 | -221.27 |  |  | 10 | -2.3 | 0 | 0 | -2.3
11 | -3.05 | 0 | -14 | -17.05 |  |  | 11 | -241.56 | 0 | -54 | -229.6 |  |  | 11 | -2.31 | 0 | 0 | -2.31
12 | -4.32 | 0 | -14 | -18.32 |  |  | 12 | -239.98 | 0 | -54 | -233.2 |  |  | 12 | -2.36 | 0 | 0 | -2.36
13 | -4.16 | 0 | -14 | -18.16 |  |  | 13 | -239.76 | 0 | -54 | -235.76 |  |  | 13 | -2.36 | 0 | 0 | -2.36
14 | -3.92 | 0 | -14 | -17.92 |  |  | 14 | -239.8 | 0 | -54 | -237.07 |  |  | 14 | -2.36 | 0 | 0 | -2.36
15 | -3.51 | 0 | -14 | -17.51 |  |  | 15 | -241.16 | 0 | -54 | -235.42 |  |  | 15 | -2.33 | 0 | 0 | -2.33
16 | -3.35 | 0 | -14 | -17.35 |  |  | 16 | -240.8 | 0 | -54 | -235.3 |  |  | 16 | -2.33 | 0 | 0 | -2.33
17 | -3.68 | 0 | -14 | -17.68 |  |  | 17 | -240.16 | 0 | -54 | -237.42 |  |  | 17 | -2.34 | 0 | 0 | -2.34
18 | -5.15 | 0 | -14 | -19.15 |  |  | 18 | -238.93 | 0 | -54 | -247.45 |  |  | 18 | -2.41 | 0 | 0 | -2.41
19 | -7.32 | 0 | -14 | -21.32 |  |  | 19 | -236.97 | 0 | -54 | -250.91 |  |  | 19 | -2.49 | 0 | 0 | -2.49
20 | -5.59 | 0 | -14 | -19.59 |  |  | 20 | -238.63 | 0 | -54 | -244.44 |  |  | 20 | -2.43 | 0 | 0 | -2.43
21 | -3.66 | 0 | -14 | -17.66 |  |  | 21 | -240.98 | 0 | -54 | -234.98 |  |  | 21 | -2.35 | 0 | 0 | -2.35
22 | -1.91 | 0 | -14 | -15.91 |  |  | 22 | -242.56 | 0 | -54 | -221.88 |  |  | 22 | -2.27 | 0 | 0 | -2.27
23 | 0 | 0 | -13.5 | -13.5 |  |  | 23 | -186.52 | 0 | -54 | -205.88 |  |  | 23 | -2.17 | 0 | 0 | -2.17
24 | 0 | 0 | -10.98 | -10.98 |  |  | 24 | -189 | 0 | -54 | -188.98 |  |  | 24 | -2.06 | 0 | 0 | -2.06
Spreadsheet: 0369fc77-a8ca-46c3-91ee-64cdfc673e9c
Sheet: +65 MD

BWF World Senior Championships 2013
MD 65
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Quarterfinals | Semifinals | Final | Winner
 | 85194 |  | THA |  | [NAME] [1]
1 | 64685 |  | THA |  | Chaisak Thongdejsri
2 |  |  |  |  | Bye 1
 | 77004 |  | IND |  | [NAME] [NAME]
3 | 70925 |  | IND |  | Pradeep  [NAME]
 | 92502 |  | ENG |  | [NAME]
4 | 78734 |  | ENG |  | [NAME]
 | 77878 |  | GER |  | Dieter Eichhorn
5 | 71962 |  | GER |  | [NAME]
6 |  |  |  |  | Bye 5
 | 81075 |  | DEN |  | [NAME]
7 | 71040 |  | DEN |  | [NAME]
 | 78353 |  | JPN |  | [NAME]
8 | 89957 |  | JPN |  | [NAME]
 | 90498 |  | ENG |  | [NAME] [3/4]
9 | 59462 |  | ENG |  | [NAME]
10 |  |  |  |  | Bye 3
 | 63679 |  | FRA |  | [NAME]
11 | 71462 |  | FRA |  | [NAME]
 | 85043 |  | IRL |  | [NAME]
12 | 69317 |  | IRL |  | [NAME]
 | 88819 |  | JPN |  | [NAME]
13 | 65243 |  | JPN |  | [NAME]
 | 88821 |  | IND |  | Raj Pal Kapoor
14 | 86684 |  | IND |  | Ramakant Sharma
 | 62913 |  | CAN |  | [NAME]
15 | 75686 |  | CAN |  | [NAME]
 | 66407 |  | GER |  | Dieter Prax
16 | 52441 |  | GER |  | [NAME]
 | 52486 |  | NOR |  | [NAME]
17 | 78927 |  | NOR |  | Knut  Sverre Liland
 | 81085 |  | RUS |  | [NAME]
18 | 63916 |  | FRA |  | [NAME]
 | 61812 |  | GER |  | [NAME]
19 | 91575 |  | GER |  | [NAME]
 | 79465 |  | THA |  | Pramot Khaosamang
20 | 60023 |  | THA |  | Apirat Siwapornpitak
 | 62275 |  | IND |  | [NAME]
21 | 99310 |  | IND |  | [NAME]
 | 58470 |  | JPN |  | Yoshio Terasaki
22 | 52485 |  | JPN |  | Toshihiko Yamamoto
23 |  |  |  |  | Bye 4
 | 58435 |  | ENG |  | [NAME] [3/4]
24 | 64487 |  | ENG |  | [NAME]
 | 7129 |  | SVK |  | [NAME]
25 | 94352 |  | FIN |  | [NAME]
 | 67459 |  | IND |  | [NAME]
26 | 82212 |  | IND |  | [NAME]
27 |  |  |  |  | Bye 6
 | 92239 |  | GER |  | Gerd Pigola
28 | 74411 |  | GER |  | [NAME]
 | 95278 |  | SWE |  | [NAME]
29 | 65082 |  | DEN |  | [NAME]
 | 68519 |  | ENG |  | [NAME]
30 | 72576 |  | ENG |  | [NAME]
31 |  |  |  |  | Bye 2
 | 61393 |  | JPN |  | [NAME] [2]
32 | 57893 |  | JPN |  | [NAME]
Spreadsheet: 687493d1595250571-extract-date-in-middle-test-sum-date_chris
Sheet: Chris Solution - Power Query

Text | Rate | Date |  |  | Sum of Rate | Column Labels
BROCKLE | 30 | 29/5/2020 |  |  | Row Labels | BROCKLE | HANWORTH | WATFORD | Grand Total
HANWORTH | 20 | 27/5/2020 |  |  | 27/5/2020 |  | 35 |  | 35
WATFORD | 40 | 30/5/2020 |  |  | 29/5/2020 | 30 |  |  | 30
HANWORTH | 15 | 27/5/2020 |  |  | 30/5/2020 |  |  | 40 | 40
BROCKLE | 50 | 4/6/2020 |  |  | 4/6/2020 | 50 |  |  | 50
 |  |  |  |  | Grand Total | 80 | 35 | 40 | 155
Spreadsheet: 192622d1352476765-how-could-i-group-the-date-by-value-workbook1
Sheet: Sheet1

 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00
Item 1 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.1 | 3.1
Item 2 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5
Item 3 | 2.8 | 2.8 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 | 2.6 | 2.6
Item 4 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 | 3.6 | 3.6 | 3.6 | 3.6
Item 5 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 2.6 | 2.6 | 2.6 | 2.6
Item 6 | 2.6 | 2.6 | 2.6 | 2.6 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1
Item 7 | 1.1 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2
Item 8 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 3.2
Spreadsheet: 878193d1725253265-power-query-column-values-to-new-columns-cat
Sheet: Sheet1

 | Initial |  |  |  | Desired
 | Date | Category | Branch | Value |  | Branch | Date | Red | Blue | Green
 | 2024-08-01 00:00:00 | Red | A | 5 |  | A | 2024-08-01 00:00:00 | 5 | 12 | 15
 | 2024-08-01 00:00:00 | Blue | A | 12 |  | B | 2024-08-01 00:00:00 | 12 | 45 | 5
 | 2024-08-01 00:00:00 | Green | A | 15 |  | A | 2024-08-02 00:00:00 | 45 | 78 | 5
 | 2024-08-02 00:00:00 | Red | A | 45 |  | B | 2024-08-02 00:00:00 | 5 | 18 | 20
 | 2024-08-02 00:00:00 | Blue | A | 78
 | 2024-08-02 00:00:00 | Green | A | 5
 | 2024-08-01 00:00:00 | Red | B | 12 |  | Branch | Date | Red | Blue | Green
 | 2024-08-01 00:00:00 | Blue | B | 45 |  | A | 2024-08-01 00:00:00 | 5 | 12 | 15
 | 2024-08-01 00:00:00 | Green | B | 5 |  | B | 2024-08-01 00:00:00 | 12 | 45 | 5
 | 2024-08-02 00:00:00 | Red | B | 5 |  | A | 2024-08-02 00:00:00 | 45 | 78 | 5
 | 2024-08-02 00:00:00 | Blue | B | 18 |  | B | 2024-08-02 00:00:00 | 5 | 18 | 20
 | 2024-08-02 00:00:00 | Green | B | 20
Spreadsheet: 699527d1602648689-looking-for-help-with-formula-to-bring-back-first-date-in-a-set-of-rows-excel-formula-initial-date-column
Sheet: Sheet1

Current Date | Previous Date | Previous Date | Previous Date | Previous Date | Previous Date |  |  | Initial date
2020-10-13 00:00:00 | 2020-09-20 00:00:00 | 2018-04-12 00:00:00 |  |  |  |  |  | 2018-04-12 00:00:00
2019-06-30 00:00:00 | 2015-02-01 00:00:00 |  |  |  |  |  |  | 2015-02-01 00:00:00
2019-04-19 00:00:00 | 2019-02-05 00:00:00 | 2016-07-01 00:00:00 | 2012-04-03 00:00:00 | 2012-12-31 00:00:00 |  |  |  | 2012-12-31 00:00:00
2020-06-30 00:00:00 |  |  |  |  |  |  |  | 2020-06-30 00:00:00
2014-05-09 00:00:00 | 2014-05-03 00:00:00 | 2010-03-22 00:00:00 | 2005-10-06 00:00:00 | 2004-07-04 00:00:00 | 2000-01-01 00:00:00 |  |  | 2000-01-01 00:00:00
In column 'I' I would like a formula that brings back the 1st date in each row which I have hardcoded so you can see the desired result
The data table represents a 'date' field in our system and how many times it has been changed in the past, I am looking to quickly find the original date entered for each row.