tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64702d1265502312-complex-calculations-competition-partisipants-and-scores-09-10
Sheet: February

February Competition - Service Stations |  |  |  |  | 42 | Total Partisipants |  |  | 0.5382775119617225 | want to see edits
Beginners | Image | Score | Place | Edit | 19 | 0.8421052631578947
Agnieszka Szczurowska | Fading Beauty | 14 | 2 | X
[NAME]
[NAME]
[NAME] | Diamond D-X | 13 | 7 | X
[NAME] | Forget the Old | 15 | 1 | X
[NAME] | Days Gone By | 10 | 15 | X
[NAME]
[NAME] | old [NAME] in Farmers Branch | 13 | 4 | X
[NAME] | Out of order | 14 | 3
[NAME] | Rainbow Sinclair Station | 9 | 18 | X
[NAME] | $24.9 per gallon | 13 | 5 | X
[NAME]
[NAME]
[NAME]
[NAME] | Nighhtly Service | 12 | 9 | X
[NAME]
[NAME] | Pump & Skulls | 10 | 12 | X
[NAME] | helena exxon | 10 | 11
[NAME]
[NAME] | Gulf Filling Station Denton Texas | 10 | 14
[NAME]
[NAME] | Tireflator | 13 | 6 | X
[NAME] | [NAME] in [NAME] | 11 | 10 | X
[NAME] | marina at dusk | 10 | 13 | X
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | Corner Shell Station | 12 | 8 | X
[NAME]
[NAME] | Bells | 8 | 19 | X
[NAME]
[NAME] | Pumps On The Moon | 9 | 17 | X
[NAME] | Sweeny's | 9 | 16 | X
[NAME]
Advanced | Image | Score | Place | Edit | 12 | 0.5 |  | * no attchment, sent by email dennis Fritche
[NAME] | Gas & Shave | 11 | 9 | X
[NAME] | Extra Service | 13 | 6 | X
[NAME]
[NAME]
[NAME]
[NAME] | Texaco in Decatur,Tx.jpg * | 14 | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | Country Station | 14 | 4 | X
[NAME] | oil and gas | 15 | 1 | X
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | Gasoline and a Haircut | 12 | 7 | X
[NAME]
[NAME] | [NAME] | 13 | 5
[NAME]
[NAME] | All in a days work | 14 | 2
[NAME] | A dark and rainy night | 11 | 8
[NAME] | TEXACO manual pump | 10 | 11
[NAME] | Old Mango | 9 | 12 | X
[NAME] | [NAME]--RETIRED | 10 | 10
Masters | Image | Score | Place | Edit | 11 | 0.2727272727272727
[NAME] | Do Not Park | 11 | 9
[NAME] | Western Gas Station | 11 | 8
[NAME]
Eleanore Avery | Gased up Pump | 14 | 2
[NAME] | Shelter from Storm - Christmas Eve | 12 | 6 | X
[NAME] | Petrified Wood Station | 13 | 5
[NAME] | Gas Pump [NAME] | 9 | 11 | X
[NAME] | Tire Stacks | 15 | 1
[NAME] | Set Aside | 14 | 3
[NAME] | Gulf Station | 10 | 10 | X
[NAME]
[NAME] | Abandoned on Corner | 14 | 4
[NAME]
[NAME]
[NAME] | Fifty-Cents Worth, Please! | 11 | 7
Spreadsheet: 164378d1340738206-bucket-filling-based-on-range-of-values-for-excel-forum
Sheet: Sheet1

Loan | Principal Balance
L1 | 3000
L2 | 6000
L3 | 8000
[NAME] | 5500
L5 | 6000
L6 | 6500
L7 | 4000
L8 | 9000
L9 | 10000
L10 | 150000
Buckets | Buckets size
Bucket 1 | 5000
Bucket 2 | 8000
Bucket 3 | 6000
Bucket 4 | 7000
Bucket 5 | 7000000
Solution should look like this
Loan | Amount of Principal Balance | Bucket
L1 | 3000 | BUCKET 1
L2 | 2000 | BUCKET 1 | At this point bucket 1 is full but loan 2 has 3k remaining
L2 | 3000 | BUCKET 2 | At this point bucket 2 can take 5k capacity left
L3 | 5000 | BUCKET 2 | At this point bucket 2 is full
L3 | 3000 | BUCKET 3 | At this point bucket 3 has 3k capacity left
[NAME] | 3000 | BUCKET 3 | At this point bucket 3 is full
[NAME] | 2500 | BUCKET 4 | At this point bucket 4 has 4500 capacity left
L5 | 4500 | BUCKET 5 | At this point bucket 5 has enough capacity to handle remaining loan
L6 | 6500 | BUCKET 5
L7 | 4000 | BUCKET 5
L8 | 9000 | BUCKET 5
L9 | 10000 | BUCKET 5
L10 | 150000 | BUCKET 5
In general the 10 loans are now reported in 13 rows…
Based on the buckets they fell into, each row on the result will have some calculation run, which is the simple part.
Spreadsheet: 123172d1317389336-excel-2007-converting-raw-data-into-rows-columns-example
Sheet: Sheet1

1-1BB-1111 Some Company Limited
Address Line 1
Address Line 2
AA1 1AA  £1,234 Account handled 1-1AA-1111
1-1BB-1112 Some Other Company Limited
Address Line 1
Address Line 2
Address Line 3
AA1 1AA  £1,222,434 Account handled 1-1AA-1111
1-1BB-1113 Yet Another Company Limited
Address Line 1
Address Line 2
Address Line 3
AA1 1AA  £1,222,434
1-1BB-1114 Similar Company Limited
Address Line 1
Address Line 2
AA1 1AA  £1,234
1-1BB-1115 Last Company Limited
Address Line 1
Address Line 2
Address Line 3
AA1 1AA  £1,222,434
Spreadsheet: 216884d1361912560-time-log-for-various-employees-on-various-projects-on-various-days-labor-expense-reclass-to-afe-pcb-2
Sheet: Example

Plant | A
Month | 2013-02-01 00:00:00 |  |  | AFE Description
Labor Expense reclass to AFE
AFE | Employee Name | Date | Rate | Reg Hours | OT Hours | Total | Reg $ | OT $ | Total
1952 | Bubba |  | 12.14 | 8 | 2 | 10 | 97.12 | 36.42 | 133.54
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
Total |  |  |  | 8 | 2 | 10 | 97.12 | 36.42 | 133.54
Spreadsheet: michelle_lokay__26553__Nov00pnr
Sheet: USGT 500622

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 00/11 | 500622 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
2 |  |  |  |  |  |  | -12036 |  |  |  | 0.1 | 0.03
3 |  |  |  |  |  | 12036 |  |  |  |  | 0.1 | 0.03
4 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
5 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
6 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
7 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.03
8 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.03
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05
10 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
11 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
12 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
13 |  |  |  |  |  | 34688 |  |  |  |  | 0.03 | 0.08
14 |  |  |  |  |  |  | -14993 |  |  |  | 0.03 | 0.08
15 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
16 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
17 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
18 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
19 |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
20 |  |  |  |  |  |  | -677 |  |  |  | 0.03 | 0.25
21 |  |  |  |  |  |  | -15373 |  |  |  | 0.03 | 0.3883
22 |  |  |  |  |  |  | -3645 |  |  |  | 0.03 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 169140d1342710255-unique-values-without-remove-duplicates-0a3
Sheet: Sheet1

 |  |  |  | What it Should BE!
salearners.co.za | 41.215.236.76 |  |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
salearners.co.za | 41.215.236.76 |  |  | 0
salearners.co.za | 41.76.211.235 |  |  | 1
k53.gavinhoole.ws | 66.43.60.212 |  |  | 1
salearners.co.za | 74.54.27.173 |  |  | 1
getyourlearners.co.za | 74.55.245.28 |  |  | 1
k53.gavinhoole.ws | 78.46.99.8 |  |  | 1
salearners.co.za | 78.46.99.8 |  |  | 1
getyourlearners.co.za | 85.25.120.116 |  |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
getyourlearners.co.za | 85.25.120.116 |  |  | 0
k53.gavinhoole.ws | 85.25.120.116 |  |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
k53.gavinhoole.ws | 85.25.120.116 |  |  | 0
salearners.co.za | 85.25.120.116 |  |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
salearners.co.za | 85.25.120.116 |  |  | 0
Spreadsheet: 719377d1613652605-compare-the-value-to-matrix-and-provide-out-as-count-compare-and-count-1-
Sheet: Sheet1

 | Table 1 |  | Class
 | Topics | Category | BC | CD | AB
 | 1+1 = 2 | A | Y | Y
 | Enjoy View | A | Y | Y
 | Sky is blue | B |  | Y | Y
 | Love Earth | B | Y | Y | Y
 | Sun is RED | C | Y | Y | Y
 | Grow Trees | C | Y | Y
 | Water is colurless | D |  | Y | Y
 | Conserve Water | D |  | Y | Y
 |  |  | Class
 |  | Category | AB | BC | CD
 |  | A
 |  | B
 |  | C
 |  | D
 | No. of Topics under each category to be updated against respective class
 | Input details are section in YELLOW and based on the input, output to be updated in GREY
Spreadsheet: 81799d1281963937-pivottable-question-how-do-i-count-cells-with-multiple-pieces-of-data-example
Sheet: PivotTable

Count of Name |  |  | Want it to look like:
OS Used | Total
OSX | 1 |  | OS Used
Ubuntu, XP | 1 |  | OSX | 1
Win7 | 1 |  | Ubuntu | 2
Win7, Ubuntu | 1 |  | Win7 | 2
Grand Total | 4 |  | XP | 1
Spreadsheet: tracy_geaccone__40225__enron corp infomation request
Sheet: ENW OFF BS

Contingencies |  |  | Comments
Sub total
Commitments |  |  |  | Liquidation % | Expected $
Sub total |  |  |  | total
TOTAL Commitments and Contingencies |  |  |  | TOTAL
Spreadsheet: 853887d1703847820-need-help-with-numbering-the-rows-in-certain-way-in-an-arrayformula-test
Sheet: sheet1

 | A |  | A
 | x |  | A
 | x |  | A
 | x |  | A
 | B |  | B
 | x |  | B
 | x |  | B
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 162000 | 164214
2 | 165112 | 164214
3 | 166252 | 167214
4 | 159596 | 159052
5 | 151508 | 151275
6 | 111224 | 110803
7 | 147182 | 147214
8 | 148253 | 147214
9 | 142380 | 142638
10 | 146106 | 146975
11 | 157270 | 157014
12 | 157058 | 157014
13 | 157082 | 157014
14 | 146041 | 145920
15 | 151778 | 149946
16 | 144193 | 142114
17 | 120202 | 117223
18 | 111013 | 109963
19 | 134243 | 132114
20 | 134276 | 133856
21 | 139949 | 139991
22 | 128967 | 128807
23 | 124954 | 125143
24 | 152646 | 151273
25 | 126791 | 125765
26 | 126699 | 125765
27 | 138175 | 138021
28 | 154721 | 153816
29
30
31
2001-06-30 00:00:00 |  |  | 0
2001-07-28 00:00:00
Spreadsheet: 71558d1272342198-lookup-range-between-2-numbers-and-3rd-value-zipcode
Sheet: Hoja1

Zip | Street Name | Start | End |  |  | Street | Zip
1407 | ACOSTA | 1 | 1300 |  |  | ACOSTA 2650
1407 | ACOSTA | 1301 | 2600
1407 | ACOSTA | 2601 | 2700
1437 | ACOSTA | 2701 | 3400
1437 | ACOSTA | 3401 | 3700
1405 | ACOYTE | 1 | 200
1405 | ACOYTE | 201 | 1100
1414 | ACOYTE | 1101 | 1700
Spreadsheet: 330b3f80-b1f5-4998-a854-75c7f88dda5d
Sheet: Sheet1

Permit # | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | LPP DESIGN | Unnamed: 7 |  | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
[NAME] |  | is = 100.00 | set at |  | PumpTank elev |  | 100 | Pump | 95 |  |  | Manifold Elevation | 101
subfield 1
line | color | rod read | elev. | elev. dif. | head | length | hole size | flow/hole | spacing | # holes | 1st/last | flow/lat | inst. flow rate
1 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
2 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
3 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
4 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
5 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
6 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
7 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
8 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
 |  |  |  | total | feet  = | 0 |  |  |  |  | gal/min = | 0
subfield 2
1 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
2 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
3 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
4 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
5 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
6 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
7 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
8 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
 |  |  |  | total | feet  = | 0 |  |  |  |  | gal/min = | 0
subfield 3
1 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
2 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
3 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
4 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
5 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
6 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
7 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
8 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
 |  |  |  | total | feet  = | 0 |  |  |  |  | gal/min = | 0
subfield 4
1 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
2 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
3 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
4 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
5 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
6 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
7 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
8 |  |  | 100 | 0 | 4 |  |  | 0 | 0 |  |  | 0
 |  |  |  | total | feet  = | 0 |  |  |  |  | gal/min = | 0
 |  |  |  | Total Feet = |  | 0 |  |  |  |  | Total gal/min = | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] =
Spreadsheet: 889600d1740475697-one-more-issue-in-excel-test
Sheet: Day Total

 | Date: | 2025-01-01 00:00:00 | Keep Date 01-Jan-25 to check all Departments total for the same
 | All |  |  |  |  |  | Deisel + Diesel to Petrol
 | S# | Department Name (Summary) | Type | Total (Ltrs) | Total Amount (Fixed PKR) |  | S# | Department Name | Type | Total Amount ([NAME]) |  | S# | Department Name | Type | Total (Ltrs) |  | S# | Department Name | Type | Total (Ltrs) |  | S# | Department Name | Type | Total (Ltrs)
 |  | Ali Gohar & Co (AG & C) | Diesel | 230
 |  | Capital City Police (CCP) | Diesel | 1325
 |  | Sui-Gas (Ikram) | Diesel | 124
 |  | Capital City Police (CCP) | Diesel to Petrol | 156
 |  | Ali Gohar & Co (AG & C) | Filter |  | 1100
 |  | Ali Gohar & Co (AG & C) | Grease |  | 400
 |  | Ali Gohar & Co (AG & C) | [NAME] |  | 3330
 |  | Capital City Police (CCP) | [NAME] |  | 9600
 |  | Governor [NAME] (GH) | [NAME] |  | 1810
 |  | Ali Gohar & Co (AG & C) | Petrol | 25
 |  | Capital City Police (CCP) | Petrol | 663
 |  | City Patrolling | Petrol | 345
 |  | Forest (Ghani) | Petrol | 60
 |  | Governor [NAME] (GH) | Petrol | 120
 |  | SSU CPEC | Petrol | 5
 |  | Sui-Gas (Ikram) | Petrol | 8
 |  | Ali Gohar & Co (AG & C) | Service |  | 1000 |  |  | Need no name which doesn't have Total Ltrs Value |  |  |  |  | Need no name which doesn't have Total Ltrs Value |  |  |  |  | Need no name which doesn't have Total Ltrs Value |  |  |  |  | Need no name which doesn't have Total Ltrs Value
 |  | Just to extract & filter the data to show here without those departments which doesn’t have any value in E & F columns |  |  |  |  |  | The departmentS IN (RED) doesn’t have values. So it should be filtered |  |  |  |  | The departmentS IN (RED) doesn’t have values. So it should be filtered |  |  |  |  | The departmentS IN (RED) doesn’t have values. So it should be filtered |  |  |  |  | The departmentS IN (RED) doesn’t have values. So it should be filtered
 |  | it's a SAMPLE did it [NAME]
 |  | This is [NAME] with "TEST" Sheet
Spreadsheet: 132300d1323687980-problem-pain-with-offset-looking-for-other-formula-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Week | 2
 | Week | Date | H Teams | BHpts | HS | AS | Bapts | A Teams |  |  | Date | H Teams | BHpts | HS | AS | Bapts | A Teams
 | 1 | 2011-10-20 00:00:00 | Sherwood S.C. |  |  |  |  | Bye |  |  | 2011-11-10 00:00:00 | The [NAME] |  |  |  |  | Bye
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME] |  |  | 2011-11-10 00:00:00 | Riley's A |  | 4 | 6 |  | [NAME]
 | 1 | 2011-10-20 00:00:00 | Riley's A |  | 4 | 6 |  | Winning Post |  |  | 2011-11-10 00:00:00 | [NAME] |  | 2 | 8 |  | [NAME]
 | 1 | 2011-10-20 00:00:00 | [NAME] |  | 5 | 5 | 1 | [NAME] |  |  | 2011-11-10 00:00:00 | Spot on Badgers |  | 4 | 6 |  | Winning Post
 | 1 | 2011-10-20 00:00:00 | Spot on Badgers |  | 8 | 2 |  | Phoenix Master |  |  | 2011-11-10 00:00:00 | Phoenix Master |  | 3 | 7 |  | [NAME]
 | 1 | 2011-10-20 00:00:00 | Phoenix One |  | 7 | 3 |  | [NAME] |  |  | 2011-11-10 00:00:00 | Sherwood S.C. |  | 2 | 8 |  | Phoenix One
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 4 | 6 |  | Spot on Badgers
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | Riley's A
 | 2 | 2011-10-27 00:00:00 | [NAME] |  | 7 | 3 |  | The [NAME]
 | 2 | 2011-10-27 00:00:00 | Bye |  |  |  |  | Phoenix One
 | 2 | 2011-10-27 00:00:00 | Phoenix Master |  | 8 | 2 |  | Sherwood S.C.
 | 3 | 2011-11-10 00:00:00 | The [NAME] |  |  |  |  | Bye
 | 3 | 2011-11-10 00:00:00 | Riley's A |  | 4 | 6 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | [NAME] |  | 2 | 8 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | Spot on Badgers |  | 4 | 6 |  | Winning Post
 | 3 | 2011-11-10 00:00:00 | Phoenix Master |  | 3 | 7 |  | [NAME]
 | 3 | 2011-11-10 00:00:00 | Sherwood S.C. |  | 2 | 8 |  | Phoenix One
 | 4 | 2011-11-24 00:00:00 | Winning Post |  | 3 | 7 |  | Phoenix Master
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 5 | 5 |  | [NAME]
 | 4 | 2011-11-24 00:00:00 | Bye |  |  |  |  | Riley's A
 | 4 | 2011-11-24 00:00:00 | Phoenix One |  | 4 | 6 |  | The [NAME]
 | 4 | 2011-11-24 00:00:00 | [NAME] |  | 6 | 4 |  | Sherwood S.C.
 | 4 | 2011-11-24 00:00:00 | Sherwood S.C. |  | 7 | 3 |  | The [NAME]
 | 5 | 2011-12-01 00:00:00 | [NAME] |  |  |  |  | Bye |  |  | Date | H Teams | BHpts | HS | AS | Bapts | A Teams
 | 5 | 2011-12-01 00:00:00 | Spot on Badgers |  | 6 | 4 |  | [NAME] |  |  |  |  |  |  |  |  |  | 6
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 4 | 6 |  | Phoenix Master |  |  |  |  |  |  |  |  |  | 6
 | 5 | 2011-12-01 00:00:00 | [NAME] |  | 5 | 5 | 1 | Winning Post |  |  |  |  |  |  |  |  |  | 6
 | 5 | 2011-12-01 00:00:00 | Riley's A |  | 3 | 7 |  | Phoenix One |  |  |  |  |  |  |  |  |  | 6
 | 5 | 2011-12-01 00:00:00 | Sherwood S.C. | 1 | 5 | 5 |  | [NAME] |  |  |  |  |  |  |  |  |  | 6
 | 5 | TBA | Winning Post |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: 792873d1661191490-hlookup-returning-multiple-dates-and-value-of-filled-cell-2022-08-22-oeldere-jaapaap-schedule
Sheet: data source

 | Kolom1 | 1-1-2022 | 2-1-2022 | 3-1-2022 | 4-1-2022 | 5-1-2022 | 6-1-2022 | 7-1-2022 | 8-1-2022 | 9-1-2022 | 10-1-2022 | 11-1-2022 | 12-1-2022 | 13-1-2022 | 14-1-2022 | 15-1-2022 | 16-1-2022 | 17-1-2022 | 18-1-2022 | 19-1-2022 | 20-1-2022 | 21-1-2022 | 22-1-2022 | 23-1-2022 | 24-1-2022 | 25-1-2022 | 26-1-2022 | 27-1-2022 | 28-1-2022 | 29-1-2022 | 30-1-2022 | 31-1-2022 | 1-2-2022 | 2-2-2022 | 3-2-2022 | 4-2-2022 | 5-2-2022 | 6-2-2022 | 7-2-2022 | 8-2-2022 | 9-2-2022 | 10-2-2022 | 11-2-2022 | 12-2-2022 | 13-2-2022 | 14-2-2022
 | name
 | name 1 | ob |  |  | bb |  |  |  | ob |  |  |  |  |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 2 |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 3 |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 4 |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 5 |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  |  |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  |  |  |  | ob |  |  | bb |  |  |  | ob
 | name 6 |  |  | ob |  |  | ob |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | ob |  |  |  | ob |  |  |  | ob
 | name 7 |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | bb
 | name 8 | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 9 |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob
 | name 10 |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | ob |  |  | ob |  |  | bb |  |  |  | ob |  |  |  | bb
Spreadsheet: 869500d1716065087-vllook-up-or-a-similar-function-to-look-up-a-date-range-vllook-up-or-a-similar-function-to-look-up-a-date-range-v-2-checked
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00 | 2024-08-12 00:00:00
 |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
 |  | Billing Amount | Payment terms | Days | Billing date | Billing date | Billing date | Billing date | Billing date | Billing date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date | Payment Date
 | A | 15000 |  | 7 | 2024-04-22 00:00:00
 | B | 75000 |  | 35 | 2024-04-30 00:00:00 |  |  |  |  |  | 2024-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 75000 | 0 | 0 | 0 | 0 | 0 | 0
 | C | 12500 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 0 | 0 | 0 | 0 | 0
 | D | 7000 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 7000 | 0 | 0 | 0 | 0 | 0 | 0
 | E | 75000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F | 12500 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | G | 7000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | H | 12000 |  | 21 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | I | 12500 |  | 35 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 0 | 0 | 0 | 0 | 0
 | J | 13000 |  | 14 | 2024-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 13000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | =MATCH(1,--ISNUMBER((MATCH($L$6:$V$6,SEQUENCE(W$4-W$3+1,,W$3),0))),0)