tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111456d1307822233-excel-2007-lookup-with-summing-problem
Sheet: Φύλλο1

Orders
 |  |  |  |  | Product
Name | Product | Amount |  |  | A | B | C | D
[NAME] | A | 320 |  | [NAME]
[NAME] | C | 300 |  | [NAME]
[NAME] | A | 430 |  | Gerard
Gerard | D | 300 |  | [NAME]
[NAME] | D | 300
[NAME] | B | 200
[NAME] | B | 600
[NAME] | B | 400
Spreadsheet: 103163d1300971867-rank-by-team-sample
Sheet: Sheet1

 | Team | Agent ID | [NAME] | Overall Rank | Team Ranking
 | A | 1 | 0.9999999999999999
 | A | 3 | 0.9999999999999999
 | B | 6 | 0.9999999999999999
 | B | 7 | 0.9999999999999999
 | B | 8 | 0.9999999999999999
 | A | 2 | 2
 | A | 4 | 3
 | B | 5 | 4
Spreadsheet: 704421d1605542200-calculate-total-s-to-display-2-different-sums-with-excess-of-the-second-to-add-to-first-cmf
Sheet: Sheet1

CMF Order Form
Item Name | [NAME] | Annex Packs | Back Boxes | Back Packs | Booth Boxes | Booth Packs | Boxes (total) | Packs (total)
Item One | 3 | 15 | 1 | 25 | 4 | 5
Item Two | 7 | 20 | 5 | 17 | 5 | 27
Spreadsheet: 263537d1378509016-filtering-subtotal-quantities-excel-help
Sheet: Sheet1

SOrg. | DChl | Dv | Customer | Name 1 | Name 2 | Street | City | Rg | Cty
 |  |  | 1000044 Count
1000 | 10 | 1 | 1000044 | Example |  | 1234 abc | Berlin | CT | US
1030 | 10 | 2 | 1000044 | Example |  | 1234 abc | Berlin | CT | US
1030 | 10 | 3 | 1000044 | Example |  | 1234 abc | Berlin | CT | US
 |  |  | 1000076 Count
1000 | 10 | 1 | 1000076 | Example |  | 1234 abc | Hudson | MA | US
 |  |  | 1000087 Count
1000 | 10 | 1 | 1000087 | Example |  | 1234 abc | Deltona | FL | US
 |  |  | 1000089 Count
1000 | 10 | 1 | 1000089 | Example |  | 1234 abc | Caguas | PR | PR
 |  |  | 1000090 Count
1000 | 10 | 1 | 1000090 | Example |  | 1234 abc | Orocovis | PR | PR
 |  |  | 1000093 Count
1000 | 10 | 1 | 1000093 | Example |  | 1234 abc | Manati | PR | PR
1030 | 10 | 2 | 1000093 | Example |  | 1234 abc | Manati | PR | PR
1030 | 10 | 3 | 1000093 | Example |  | 1234 abc | Manati | PR | PR
 |  |  | 1000094 Count
1000 | 10 | 1 | 1000094 | Example |  | 1234 abc | Humacao | PR | PR
1030 | 10 | 2 | 1000094 | Example |  | 1234 abc | Humacao | PR | PR
1030 | 10 | 3 | 1000094 | Example |  | 1234 abc | Humacao | PR | PR
 |  |  | 1000095 Count
1000 | 10 | 1 | 1000095 | Example |  | 1234 abc | Guaynabo | PR | PR
1030 | 10 | 2 | 1000095 | Example |  | 1234 abc | Guaynabo | PR | PR
1030 | 10 | 3 | 1000095 | Example |  | 1234 abc | Guaynabo | PR | PR
1030 | 10 | 4 | 1000095 | Example |  | 1234 abc | Guaynabo | PR | PR
1030 | 10 | 5 | 1000095 | Example |  | 1234 abc | Guaynabo | PR | PR
 |  |  | 1000096 Count
1000 | 10 | 1 | 1000096 | Example |  | 1234 abc | Aibonito | PR | PR
1030 | 10 | 2 | 1000096 | Example |  | 1234 abc | Aibonito | PR | PR
1030 | 10 | 3 | 1000096 | Example |  | 1234 abc | Aibonito | PR | PR
 |  |  | 1000097 Count
1000 | 10 | 1 | 1000097 | Example |  | 1234 abc | Aguada | PR | PR
1030 | 10 | 2 | 1000097 | Example |  | 1234 abc | Aguada | PR | PR
1030 | 10 | 3 | 1000097 | Example |  | 1234 abc | Aguada | PR | PR
 |  |  | 1000098 Count
1000 | 10 | 1 | 1000098 | Example |  | 1234 abc | Honolulu | HI | US
1030 | 10 | 2 | 1000098 | Example |  | 1234 abc | Honolulu | HI | US
1030 | 10 | 3 | 1000098 | Example |  | 1234 abc | Honolulu | HI | US
1030 | 10 | 4 | 1000098 | Example |  | 1234 abc | Honolulu | HI | US
Spreadsheet: eric_saibi__9768__012502
Sheet: Cholla 04 

Owner Name | Arizona Public Service Company
Station Name | Cholla Power Station
Unit Name | Cholla  04
NERC Region | WSCC
State | AZ
Fuel Type | Coal
Capacity | 414 MW
Start Date | 2002-01-24 00:00:00
End Date | 2002-01-28 00:00:00
Comments | Boiler Leak
SIC | 4911
Plant ID | 1016384
Unit ID | 1006666
Outage ID | 19644
Spreadsheet: 185350d1349673727-populaate-the-cells-in-a-different-colour-book1
Sheet: Sheet1

 |  | Km1 | KM2 | Km3 | Km4 | Km5 | Km6 | Km7 | Km8 | Km9
 | Deliverable 1 | a | a | a
 | Deliverable 2 | a | a
 | Deliverable 3 | a
 | Deliverable 4 | a
 | Deliverable 5 | a
 | Deliverable 6 | a | a |  | a
 | Deliverable 7 | a
 | Deliverable 8 | a | a
 | Deliverable 9 | a
 | Deliverable 10 | a
 | Deliverable 11 | a | a
 | Deliverable 12 | a
 | Deliverable 13 | a
 | Deliverable 14 | a
 | Deliverable 15 | a
 | Deliverable 16 | a
 | Deliverable 17 | a
 | Deliverable 18 | a
 | Deliverable 19 | a
 | Deliverable 20 | a
 | Deliverable 21 | a
 | Deliverable 22 | a
 | Deliverable 23 | a
 | Deliverable 24 | a
Spreadsheet: 26696d1219085275-what-function-to-use-to-populate-data-from-other-worksheet-autopopulatedatainfohelp-2-
Sheet: w.e. 6th july

 |  |  | 2008-06-30 00:00:00 | 2008-07-01 00:00:00 | 2008-07-02 00:00:00 | 2008-07-03 00:00:00 | 2008-07-04 00:00:00 | 2008-07-05 00:00:00 | 2008-07-06 00:00:00
 |  | st albans | 13 | 10 | 18 | 11 | 5 | 0 | 0
 |  | sunbury | 5 | 6 | 5 | 5 | 5 | 0 | 0
 |  | peterborough | 8 | 10 | 6 | 7 | 7 | 0 | 0
Spreadsheet: 120371d1315243153-latitude-and-longitude-to-eastings-and-northings-projectionandtransformationcalculations
Sheet: lat,long,H to XYZ

Latitude, longitude and Ellipsoidal height to [NAME]
latitude | N | 52 | 39 | 27.253085 | This is the input data
longitude | E | 1 | 43 | 4.517691613694296
Ellipsoidal height | 24.7 | m
X | 3874938.849676421 | m |  |  | This is the result of the calculation
Y | 116218.6236120159 | m
Z | 5047168.208116061 | m
e2 | 0.006670539761597337 |  |  |  | These values are intermediate calculation steps for the
n | 6391050.626022365 |  |  |  | formulae given in 'A Guide to Coordinate Systems in Great Britain'
X | 3874938.849676426 | m |  |  | This is the result of the calculation using user defined functions.
Y | 116218.6236120159 | m |  |  | To see the Visual Basic code of the functions -
Z | 5047168.208116058 | m |  |  | Menu = Tools, Macro, Visual Basic Editor,
 |  |  |  |  | then view the code in "Module 1".
Spreadsheet: 132021d1323442887-how-to-create-a-function-that-has-a-cell-reference-in-it-that-is-calculated-sme-planning-planning
Sheet: Analysis-2

 |  | Actvity | Dealer / Days
 |  |  | DK | GB
 |  | Create Test Company
 |  | Prepare for PS1 Parts
 |  | Prepare for PS1 Service
 |  | Prepare for PS1 Equipment
 |  | Prepare for PS1 Service & Equipment
 |  | Prepare for PS1 Finance
 |  | Integration Test
 |  | PS1 for Parts
 |  | PS1 for Service
 |  | PS1 for Equipment
 |  | PS1 for Service & Equipment
 |  | PS1 for Finance
 |  | Follow-up from PS1 Parts
 |  | Follow-up from PS1 Service
 |  | Follow-up from PS1 Equipment
 |  | Follow-up from PS1 Finance
 |  | Prepare for PS2 Parts
 |  | Prepare for PS2 Service
 |  | Prepare for PS2 Equipment
 |  | Prepare for PS2 Finance
 |  | PS2 for Parts
 |  | PS2 for Service
 |  | PS2 for Equipment
 |  | PS2 for Finance
 |  | Follow-up from PS2 Parts
 |  | Follow-up from PS2 Service
 |  | Follow-up from PS2 Equipment
 |  | Follow-up from PS2 Finance
 |  | Gap Review for Parts
 |  | Gap Review for Service
 |  | Gap Review for Equipment
 |  | Gap Review for Finance
 |  | Public Holiday
 |  | Holiday
Spreadsheet: 97323d1296539095-joining-columns-of-different-lengths-from-different-sheets-array3dvlookup
Sheet: Sheet4

26 | code26 | Name26 | [NAME] | City26 | Zip26 | Phone26
27 | code27 | Name27 | Addr27 | City27 | Zip27 | Phone27
28 | code28 | Name28 | Addr28 | City28 | Zip28 | Phone28
29 | code29 | Name29 | Addr29 | City29 | Zip29 | Phone29
30 | code30 | Name30 | Addr30 | City30 | [NAME] | Phone30
31 | code31 | Name31 | Addr31 | City31 | Zip31 | Phone31
32 | code32 | Name32 | Addr32 | City32 | Zip32 | Phone32
33 | code33 | Name33 | Addr33 | City33 | Zip33 | Phone33
34 | code34 | [NAME] | Addr34 | City34 | Zip34 | Phone34
35 | code35 | Name35 | [NAME] | City35 | [NAME] | Phone35
36 | code36 | Name36 | Addr36 | City36 | Zip36 | Phone36
37 | code37 | Name37 | Addr37 | City37 | Zip37 | Phone37
38 | code38 | Name38 | Addr38 | City38 | Zip38 | Phone38
39 | code39 | [NAME] | Addr39 | City39 | Zip39 | Phone39
Spreadsheet: 28067d1221879853-vlookup-issue-example_pivot
Sheet: Sheet1

NAME | TRADE | $ |  |  |  |  | PLUMBING |  |  | ROOFING |  |  | ELECTRIC
Able | Plumbing | 2500 |  |  |  |  | Name | Bid |  | Name | Bid |  | Name | Bid
Jornada | Roofing | 3700 |  |  | Over here --------->
B&R | Plumbing | 2500 |  |  | I would like to list
[NAME] | Electric | 2900 |  |  | all of my plumbers,
Legends | Roofing | 3900 |  |  | i.e. cell H3 should
Provident | Electric | 2400 |  |  | have "Able", cell
[NAME]'s | Plumbing | 2700 |  |  | H4 shoul have
 |  |  |  |  | "B&R", cell H5
 |  |  |  |  | should have "[NAME]'s"
Average of $ | Column Labels
Row Labels | Electric | Plumbing | Roofing |  | If it's not too much
Able |  | 2500 |  |  | trouble, I'd also like
B&R |  | 2500 |  |  | to list their bids
[NAME] | 2900 |  |  |  | using the same
Jornada |  |  | 3700 |  | method in the bid
Legends |  |  | 3900 |  | column.
Provident | 2400
[NAME]'s |  | 2700 |  |  | Thanks in advance!
Avergage Bid | 2650 | 2566.666666666667 | 3800
Spreadsheet: 79359d1279640512-excel-2007-loop-to-check-if-date-is-between-two-dates-from-2nd-workbook-and-loop-until-true-dates
Sheet: Sheet1

 | 2010 |  |  |  |  |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012
 | 2010-06-06 00:00:00
Job 1 | 90 | 180 | 90 | 180 | 180 | 180 | 90 | 45 |  | 90 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 90 | 90 |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90
Job 2 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
Job 3 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90
Job 4 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 |  | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 |  | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180
Spreadsheet: 872072d1718432079-advanced-sorting-matching-book1-330-aligw
Sheet: Sheet1

a | t | high | low
c | m | low | high
f | g | medium | medium
d | l
g |  |  |  |  |  |  | g | medium | medium
i
h
j
l |  |  |  |  |  |  | l
m |  |  |  |  |  |  | m | low | high
n
q
r
v
t |  |  |  |  |  |  | t | high | low
Spreadsheet: 58923d1259190525-counting-orders-book2
Sheet: Profits

Item | Quantity | Quantity In Inventory | Quantity In Mart | Total Cost | Cost Per Unit | Amount Sold | Price Sold At | Total Revenue | Profits Per Item | Amount Of Supply Missing
Cookies | 36 | 14 | 3 | 9.36 |  | 15 | 1
Cheez-It | 36 | 20 | 2 | 8.19 |  | 10 | 1
Lays Pack | 50 | 8 | 6 | 10.99 |  | 31 | 1
Poland Spring | 32 | 4 | 6 | 4.49 |  | 15 | 1
 | Total Profits |  |  | Total Cost |  |  | Total [NAME]
 |  |  |  | Total Stolen
Spreadsheet: 483076d1475482001-please-help-with-this-special-replacement-in-excel-sample_data
Sheet: Sheet1

sample1 | sample2 | [NAME]
-6.92288462242285 | -3.74026256903547 | -
-6.79159909188163 | -3.83366903484984 | -
-5.24512943730337 | -6.71716994952064 | -
- | -1.97307843889778 | -2.3999120834234
- | - | -2.07218213797189
- | - | 2.80532825285071
-5.65022837015127 | -3.47078716374301 | -
-8.0205495548295 | -3.59549054371579 | -
- | - | 2.47799781949796
- | - | 2.4305303174381
- | - | 2.37902239680841
-6.71154935723349 | -3.27648355369586 | -
-7.27431090575394 | - | -
- | - | -2.35078541247882
- | - | -2.75973168943968
-7.76636741996524 | - | -
3.16678741295184 | 9.32670300048379 | 9.33301787988534
- | 4.64908276305399 | -
- | 1.95499395302727 | 2.85080418024816
- | 1.85057064677929 | 2.78981650421477
- | 1.83877986798743 | 3.01615965158731
- | 1.79075176227813 | 2.77544361258986
- | - | 3.40335227126443
- | - | 3.03350994139349
- | - | 2.55518675876487
- | - | 2.04621995294125
4.23007486537736 | - | -
4.9327894056977 | 5.10973164670287 | 5.20463417078221
3.96965822444259 | - | -
2.72190469218783 | - | -
3.16678741295184 | - | -
4.32293839753209 | - | -
- | - | -6.65884286797385
- | - | -2.07035939041434
- | - | -7.40790170606169
- | - | -6.9779125611958
2.13239973703603 | 2.65082402707687 | -
- | -2.61531131713421 | -
- | 3.20229784544851 | -
-2.02653933211083 | -3.34737379849219 | -5.86219155950251
- | - | -2.67820564220164
4.760384249095 | 2.54392401108059 | 1.7892359829022
4.35376106123512 | 2.62730265428277 | 1.88519618536998
4.24858225115232 | 2.70949471797635 | 2.05614797356717
3.73865414093901 | 2.43807292721534 | 1.80519469979901
3.32288567384838 | 2.70082359582989 | 2.01272228077076
4.1211025712785 | 4.61355330650866 | 4.51187261333964
3.94806750489562 | 5.02357196048305 | 4.8565567749062
3.90996108141183 | 5.08218300378874 | 4.68076384417023
3.64872327061476 | 4.4981816846418 | 4.4109044170976
3.66089751763779 | 4.72261587453356 | 4.65019735136563
3.63594251580943 | 5.22546247817136 | 5.11272825460406
1.97357031719671 | 2.52760723361539 | -
-8.89602400206735 | -4.06621359455656 | -
- | 3.3942622239561 | 2.77984406573083
-6.98687378515905 | - | -
3.79429947286719 | 5.38693894448776 | 5.60216404657804
-2.32903642369128 | -2.35008703854325 | -2.63873976468571
Spreadsheet: 36058d1233819767-random-selection-of-a-data-located-in-a-column-by-text-color-randomnumgeneratorfromlist
Sheet: Sheet1

SUMMARY
Tesco | 24954.25 | 736 | 35907 | 73.37 | 1.51 | 0.4727
[NAME] | 14787.2 | 548 | 58633 | 50.79000000000001 | 0.46 | 0.2885
Morrisons | 7381.1 | 318 | 21829 | 52.64 | 0.76 | 0.1039
Others | 4184.2 | 252 | 22662 | 32.83 | 0.43 | 0.0493
Catering | 2973.89 | 104 | 9051 | 68.69 | 0.74 | 0.0762
Costco | 1038.84 | 37 | 1565 | 47.13 | 1.17 | 0.0094
Fruit for schools | 1106.02 | 57 | 3020 | 19.4 | 0.37 | 0
Week 1
Tesco | 5112.46 | 125 | 6049 | 40.9 | 0.85 | 0.4727
[NAME] | 3119.61 | 141 | 16086 | 22.12 | 0.19 | 0.2885
Morrisons | 1123.73 | 37 | 2542 | 30.37 | 0.44 | 0.1039
Others | 533.35 | 33 | 2094 | 16.16 | 0.25 | 0.0493
Catering | 824.57 | 19 | 1883 | 43.4 | 0.44 | 0.0762
Costco | 101.35 | 6 | 212 | 16.89 | 0.48 | 0.0094
Fruit for schools | 0 | 0 | 0 | 0 | 0 | 0
Week 2
Tesco | 19841.79 | 611 | 29858 | 32.47 | 0.66 | 0.435
[NAME] | 11667.59 | 407 | 42547 | 28.67 | 0.27 | 0.2558
Morrisons | 6257.37 | 281 | 19287 | 22.27 | 0.32 | 0.1372
Others | 3650.85 | 219 | 20568 | 16.67 | 0.18 | 0.08
Catering | 2149.32 | 85 | 7168 | 25.29 | 0.3 | 0.0471
Costco | 937.49 | 31 | 1353 | 30.24 | 0.69 | 0.0206
Fruit for schools | 1106.02 | 57 | 3020 | 19.4 | 0.37 | 0.0242
Spreadsheet: 120021d1314918646-how-do-i-return-nothing-in-excel-functions-workbookexample
Sheet: Sheet1

Conference |  | Division |  | Team |  | Position |  | Player |  | Stats
Western |  | Northwest |  | Ravens |  | Forward |  | [NAME] |  | Player's stats display here
 |  |  |  |  |  |  |  |  |  |  |  | Conference | Division | Team | Position | Player
 |  |  |  |  |  |  |  |  |  |  |  | Eastern | Northeast | Bulldogs | Center | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Western | Northwest | Jackals | Guard | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | N/A | Centeral | Ravens | Forward | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Pacific | Raiders | Power Forward | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | N/A | [NAME] | Point Guard | Toby
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wildcats | N/A | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Prospectors |  | Garret
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cavaliers |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blake
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ricky
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Junior
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Linas
Ex: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
Conference |  | Division |  | Team |  | Position |  | Player |  | Stats
Western |  | Northwest |  | N/A |  | N/A |  | N/A |  | Player's stats display here
 |  |  |  |  |  |  | I want to make it so that if a field is switched to "N/A", the field to the right of it is also switched to "N/A". If the field to the left has any value other than "N/A", I want my list date validation to function as defined.
Conference |  | Division |  | Team |  | Position |  | Player |  | Stats
Western |  | Northwest |  | Ravens |  | N/A |  | N/A |  | Player's stats display here
Conference |  | Division |  | Team |  | Position |  | Player |  | Stats
Western |  | N/A |  | N/A |  | N/A |  | N/A |  | Player's stats display here
Conference |  | Division |  | Team |  | Position |  | Player |  | Stats
Western |  | Northwest |  | Ravens |  | Guard |  | N/A |  | Player's stats display here
Spreadsheet: 763201d1642043029-vlookup-from-multiple-table-arrays-check-in-sheet-for-staff-covid-leave-excel
Sheet: Biosecurity

 | Quarantine Direction from Positive [NAME]
Region | First Name | Last Name | Contact Number | Type of Test (PCR / RAT) | Isolation Start Date | Isolation End Date | Day 2 Call | Day 5 Call | Test Date | Estimated Return to work | Comments
 | South FN1 | South LN 1
 |  | works | VLOOKUP(C3,'Contact Details'!B$3:C$114,2,FALSE)
 |  | works | VLOOKUP(B3 & C3,'Contact Details'!A$3:C$114,3)
 |  | N/A | VLOOKUP(B3 & C3,IF('Contact Details'!A3:C114,'Contact Details'!I3:[NAME])
Spreadsheet: 47e2f26e-07aa-4d47-bf74-40cda4d4ddf6
Sheet: STUDENT_FILE

Academic Year | District Number | District Name | School Number | School Name | SASID | Date of Birth | [NAME] (Y/N) | Grade | AYG | IEP | Committed | Detained | Dropout | Discontinued School 6+ Weeks | Habitually Truant | Expelled | Justified Expulsion | Drugs or Alcohol | [NAME] | Child Abuse or Neglect | Parent in prison | Domestic Violence | Repeat Suspensions | Pregnant or Parenting | Migrant | Homeless | Psych/behav Disorder | 15a. Total Credits Required to Graduate | 15b. Core Credits Required to Graduate | 15c. Total Credits Earned | 15d. Core Credits Earned | 15e. Total Expected Credits Earned | 15f. Core Expected Credits Earned | Over Age & Under Credit | 16a. High-Risk: CDE Pre-Screened | 16b. High-Risk: District Identified | 16c. High-Risk: Total
 |  |  |  |  |  |  |  |  |  | 1. | 2a. | 2b. | 3a. | 3b. | 3c. | 4a. | 4b. | 5. | 6. | 7. | 8. | 9. | 10. | 11. | 12. | 13. | 14. |  |  |  |  |  |  | 15.
Spreadsheet: 112527d1308649521-lead-time-formula-time
Sheet: Sheet1

Load | Creation Date | Creation Time | Load Date | Load Time | Lead Time
[PHONE] | 2011-06-19 00:00:00 | 13:11 | 2011-06-19 00:00:00 | 14:00
[PHONE] | 2011-06-19 00:00:00 | 12:41 | 2011-06-19 00:00:00 | 17:00
[PHONE] | 2011-06-19 00:00:00 | 17:57 | 2011-06-19 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 17:43 | 2011-06-20 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 17:43 | 2011-06-20 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 17:43 | 2011-06-20 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 17:43 | 2011-06-20 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 23:00:00 | 2011-06-20 00:00:00 | 23:00
[PHONE] | 2011-06-19 00:00:00 | 22:42 | 2011-06-21 00:00:00 | 00:00
[PHONE] | 2011-06-20 00:00:00 | 02:26 | 2011-06-21 00:00:00 | 01:00
[PHONE] | 2011-06-19 00:00:00 | 22:42 | 2011-06-21 00:00:00 | 02:00
[PHONE] | 2011-06-19 00:00:00 | 22:42 | 2011-06-21 00:00:00 | 05:00
Spreadsheet: 21899d1210087735-common-denominator-example2
Sheet: Sheet1

Product | Scenario | Type | Start | End |  | Start | End | Not available
Product 1 | Scenerio 1 | Type 1 | 2008-06-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 1 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 2 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 2 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 3 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 3 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 4 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 4 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 5 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 5 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 6 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 1 | Scenerio 6 | Type 2 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 |  | 2009-01-01 00:00:00 | 2008-06-30 00:00:00 | X
Product 2 | Scenerio 1 | Type 1 | 2008-06-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 1 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 2 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 2 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 3 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 3 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 4 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 4 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 5 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 5 | Type 2 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 6 | Type 1 | 2008-01-01 00:00:00 | 2008-06-30 00:00:00 |  | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Product 2 | Scenerio 6 | Type 2 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 |  | 2009-01-01 00:00:00 | 2008-06-30 00:00:00 | X
Spreadsheet: 678064d1589698725-return-results-based-on-selections-2020-05-15-oeldere2-ajhickin-pt-677803d1589531783-return-results-based-on-selections-sample
Sheet: Sheet1

content | Requirements | Kolom1 |  | Inventory
Content 1 | Box 1
Content 2 | Box 1 |  |  |  |  | Aantal [NAME] | Columnlabel
Content 3 | Box 1 |  |  |  |  | Rowlabel | Box 1 | [NAME] | Eindtotaal
Content 4 | [NAME] |  |  |  |  | Content 1 | 1 |  | 1
Content 5 | [NAME] |  |  |  |  | Content 10 | 1 | 1 | 2
Content 6 | [NAME] |  |  |  |  | Content 2 | 1 |  | 1
Content 7 | Box 1 | [NAME] |  |  |  | Content 3 | 1 |  | 1
Content 8 | Box 1 | [NAME] |  |  |  | Content 4 |  | 1 | 1
Content 9 | Box 1 | [NAME] |  |  |  | Content 5 |  | 1 | 1
Content 10 | Box 1 | [NAME] |  |  |  | Content 6 |  | 1 | 1
Content 7 | [NAME] |  |  |  |  | Content 7 | 1 | 1 | 2
Content 8 | [NAME] |  |  |  |  | Content 8 | 1 | 1 | 2
Content 9 | [NAME] |  |  |  |  | Content 9 | 1 | 1 | 2
Content 10 | [NAME] |  |  |  |  | Eindtotaal | 7 | 7 | 14
Spreadsheet: 691146d1597509883-vlookup-index-match-multiple-records-to-find-demo4-rrenzi-
Sheet: ABC CO

 | ABC CO
MEMBER_ID | PROD | DESC | CODE_1 | CATEGORY_1 | CODE_2 | CATEGORY_2 | CHARGE | COUNT | OWED | INDEX | LAST | START | GROUP | Name
Spreadsheet: 526114d1499128206-returning-most-recent-entries-from-a-dataset-return-most-recent-entries
Sheet: Sheet1

How to return the 3 most recent entries of data from TODAY
dataset: |  |  |  |  |  |  | Type name here:
Date | Name | Fruit |  |  |  |  | Name: | [NAME]
2017-01-12 00:00:00 | [NAME] | Apple
2017-01-14 00:00:00 | Carol | Pear |  |  |  |  | Forumla will then lookup and return the 3 most recent entries:
2017-01-16 00:00:00 | [NAME] | [NAME] |  |  |  |  | Date | Fruit
2017-01-18 00:00:00 | [NAME] | Mango
2017-01-22 00:00:00 | Carol | Orange
2017-01-25 00:00:00 | [NAME] | Lemon
2017-01-26 00:00:00 | [NAME] | Lime
2017-01-31 00:00:00 | Carol | Pear |  |  |  |  | NB IF only 2 entries exist then only 2 are returned.
 |  |  |  |  |  |  | using array fomula
 |  |  |  |  |  |  | Azumi