tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Orioles

Baltimore Orioles | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Baltimore Orioles | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -0.5
Hoes, L.J. | ML | ML | ML | ML | ML | ML
Rodriguez, Rafael | ML | ML | ML | ML | ML | ML |  | Expenses
Skipworth, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 1.2
[NAME] | ML | ML | ML | ML | ML | ML |  | Mitre, Sergio | 0.7
Almanzar, [NAME] | ML | ML | ML | ML | ML | ML |  | Putz, [NAME] | 6.2 | 6.2
Arencibia, J.P. | ML | ML | ML | ML | ML | ML |  | Rauch, [NAME] | 1.2
Brignac, [NAME] | ML | ML | ML | ML | ML | ML |  | To Diamondbacks | 29.9
Bowden, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 1.3
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Doubront, Felix | ML | ML | ML | ML | ML | ML
Drabek, Kyle | ML | ML | ML | ML | ML | ML
Fowler, [NAME] | ML | ML | ML | ML | ML | ML
Guerra, Deolis | ML | ML | ML | ML | ML | ML
Hellickson, Jeremy | ML | ML | ML | ML | ML | ML
Heyward, Jason | ML | ML | ML | ML | ML | ML
Kalish, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Main, [NAME] | ML | ML | ML | ML | ML | ML
Manship, Jeff | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], Sean | ML | ML | ML | ML | ML | ML
Patton, Troy | ML | ML | ML | ML | ML | ML
Poveda, [NAME] | ML | ML | ML | ML | ML | ML
Romine, [NAME] | ML | ML | ML | ML | ML | ML
Sampson, [NAME] | ML | ML | ML | ML | ML | ML
Sanchez, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Weathers, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | 10.3 | 10.3
[NAME], Adrian | 5 | A3
[NAME], [NAME] | 5 | A3
Sizemore, Grady | 5 | A3
Peralta, [NAME] | 4.6 | A3
Cantu, [NAME] | 4.2 | A3
Martin, [NAME] | 3 | A2 | A3
Hill, [NAME] | 2.7 | A3
Garko, [NAME] | 2 | A2 | A3
[NAME], [NAME] | 1.2 | A2 | A3
Carmona, Fausto | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.7 | A1 | A2 | A3
Hammel, [NAME] | 0.7 | A1 | A2 | A3
Petit, Yusmeiro | 0.7 | A1 | A2 | A3
Salas, [NAME] | 0.7 | A1 | A2 | A3
DeWitt, Blake | 0.3 | 0.7 | A1 | A2 | A3
Samardzija, Jeff | 0.3 | 0.7 | A1 | A2 | A3
Hughes, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Riske, [NAME] | 0.1 | 0.1
Guerrier, [NAME] | 0.1 | 0.1
Spreadsheet: 871064d1717508068-sum-up-meet-and-concatenate-city-concatenate-cities-aligw
Sheet: Sheet1

NAME | PLACE | MEET
SYDNEY | CITY1 | 5
SYDNEY | CITY2 | 1
SYDNEY | [NAME] | 2 |  |  |  | MEET | PLACE
SYDNEY | CITY4 | 1 |  |  | SYDNEY | 12 | CITY1, CITY2, [NAME], [NAME], CITY5, CITY6, CITY7
SYDNEY | CITY5 | 1 |  |  | TAIWAN | 9 | CITY1, CITY2, [NAME]
SYDNEY | CITY6 | 1 |  |  | [NAME] | 2 | CITY1, CITY2
SYDNEY | CITY7 | 1 |  |  | CHINA | 2 | CITY1
TAIWAN | CITY1 | 6
TAIWAN | CITY2 | 2
TAIWAN | [NAME] | 1
[NAME] | CITY1 | 1
[NAME] | CITY2 | 1
CHINA | CITY1 | 2
Spreadsheet: 677628d1589446049-concatenate-values-in-range-if-value-in-multiple-columns-is-true-ex
Sheet: Ark1

 |  | Probability
 |  |  | 5
 |  |  |  |  | 5 |  |  | 10
 |  |  | 4
 |  |  |  |  | 2, 7, 8
 |  |  | 3
 |  |  |  |  |  |  | 4, 9
 |  |  | 2 |  |  |  |  |  |  | Concatenate range C29:C50 if E29:E50=2 and F29:F50=4
 |  |  |  | 1 | 3, 6
 |  |  | 1
 |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | Consequence
 |  |  |  |  |  |  |  | How can I make the risk matrix update dynamically with changes in
 |  |  |  |  |  |  |  | 1. the risk name in the # column
 |  |  |  |  |  |  |  | 2. the risk score based on  Prob/Cons coordinates
Risk |  | # | Name | Prob | Cons
 |  | 1 | ASDF 1 | 1 | 1
 |  | 2 | ASDF 2 | 3 | 2
 |  | 3 | ASDF 3 | 1 | 2
 |  | 4 | ASDF 4 | 2 | 4
 |  | 5 | ASDF 5 | 4 | 2
 |  | 6 | ASDF 6 | 1 | 2
 |  | 7 | ASDF 7 | 3 | 2
 |  | 8 | ASDF 8 | 3 | 2
 |  | 9 | ASDF 9 | 2 | 4
 |  | 10 | ASDF 10 | 4 | 5
Spreadsheet: 488717d1478794236-advanced-filter-three-conditions-does-not-contain-between-and-contain-advance-filter-not-parameter-and-type-2
Sheet: Sheet1

CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | QUERY |  |  | Cities |  | CriteriaFormula
 |  |  |  |  |  |  |  |  | Show venues that meet all three criteria |  |  | Arbroath
 |  |  |  |  |  |  |  |  |  |  |  | Derby
 |  |  |  |  |  |  |  |  |  |  |  | Newport
CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | Criteria 1
Arbroath | Webster Theatre | 550 | 120 |  | AR@WT | TH@WT | O |  | SHOW VENUES THAT ARE NOT IN THE FOLLOWING CITIES: ARBROATH, DERBY, NEWPORT
[NAME] | Market Place Theatre | 397 |  |  | AR@MPT | GH@MPT | T
Clacton-On-Sea | West Cliff Theatre | 600 |  |  | CL@WCT | EA@WCT | ALL
Coventry | Belgrade Theatre | 850 |  | 250 | CO@BT | RY@BT | O
Cromer | Pavilion | 510 |  |  | CR@P | ER@P | T
Derby | Conkers Amphitheatre | 700 |  |  | DE@CA | BY@CA | ALL
DORKING | Dorking Hall | 790 |  | 176 | DO@DH | NG@DH | ALL
Gravesend | Woodville | 700 |  |  | GR@W | ND@W | ALL |  | [NAME]
Loughborough | Loughborough Town Hall | 550 | 120 |  | LO@LTH | GH@LTH | O |  | Only show venues with capacities in either of the three rooms that are between 100 and 200 and does not include Blanks
Musselburgh | Brunton Theatre | 550 | 120 | 300 | MU@BT | GH@BT | T
Newport | Medina Theatre | 400 |  |  | NE@MT | RT@MT | ALL
Penistone | Paramount | 350 |  |  | PE@P | NE@P | T
PORT SUNLIGHT | Gladstone Theatre |  |  |  | PO@GT | HT@GT | T
Radlett | [NAME] | 300 |  |  | RA@RC | TT@RC | O
Rotherham | [NAME] | 356 |  |  | RO@RCT | AM@RCT | ALL
Swindon | Wyvern Theatre | 635 | 635 |  | SW@WT | ON@WT | O |  | Criteria 3
Yeovil | Octagon Theatre | 622 |  |  | YE@OT | IL@OT | O |  | Only show venues that have type T or ALL
Bury St Edmunds | The Apex | 650 | 516 |  | BU@TA | DS@TA | T
Cockermouth | The Kirkgate | 125 |  |  | CO@TK | TH@TK | O
Aberdare | Coliseum Theatre | 300 | 376 |  | AB@CT | RE@CT | T
Aberdeen | The Lemon Tree | 550 |  |  | AB@TLT | EN@TLT | ALL |  | result should be
Aberdeen | Tunnels | 300 |  |  | AB@T | EN@T | T |  | Brunton Theatre
Aberdeen | Krakatoa | 200 |  |  | AB@K | EN@K | O
Aberdeen | Music Hall | 1000 | 1300 |  | AB@MH | EN@MH | ALL |  | DORKING HALL
Spreadsheet: 851737d1701883839-trying-to-create-formula-to-break-down-water-usage-into-several-tiers-txxx2-reierme-1-
Sheet: TXXX1

 |  |  |  |  |  |  |  |  |  | TIER 1 | TIER 2 | TIER 3 | TIER 4 | TIER 5 | TIER 6 | TIER 7 | TIER 8 | TIER 9 | TIER 10
TranDate | Acct. # | BilledUsage | Charges | MeterSizeDesc | StartReading | StartReadDate | EndReading | EndReadDate |  | 0 - 2,000 | 2,001 - 5,000 | 5,001 - 7,500 | 7,501 - 10,000 | 10,001 - 15,000 | 15,001 - 25,000 | 25,001 - 35,000 | 35,001 - 45,000 | 45,001 - 55,000 | 55,001 +
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55001
2019-12-10 00:00:00 | 25 | 19992600 | 76.31 | 5/8" METER | 5850 | 2019-12-02 00:00:00 | 5850 | 2019-12-10 00:00:00
2023-01-10 00:00:00 | 236 | 392910 | 2573.71 | 5/8" METER | 225460 | 2022-12-01 12:47:00 | 618370 | 2023-01-03 08:58:00
2019-10-10 00:00:00 | 56 | 264250 | 0 | 5/8" METER | 27310 | 2019-08-30 00:00:00 | 291560 | 2019-09-30 00:00:00
2020-07-10 00:00:00 | 1115 | 215940 | 0 | 5/8" METER | 0 | 2020-06-01 00:00:00 | 0 | 2020-07-10 00:00:00
Spreadsheet: 141405d1329248963-need-help-finding-formula-for-monthly-numbers-put-in-daiily-numbers
Sheet: Sheet1

 | HSI |  |  | DTV |  | Access Lines |  | Bundles | Verizon | Upgrades | Add-ons
 | 1.5M | 3-12M | 20M+ | Choice | Xtra+ | 1FR | 1FB | Packages | New | 1.5M+ | LD | VM | LB | @ | HD | Opt | DVR | [NAME] | Sprts Ch
Juan |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 2
Totals |  |  |  | Totals | February |  |  | Goals |  |  | % to Goal
HSI |  |  |  | HSI |  |  |  | HSI |  | 49
DTV |  |  |  | DTV |  |  |  | DTV |  | 7
Access Lines |  |  |  | Access Lines |  |  |  | Access Lines |  | 5
Bundles |  |  |  | Bundles |  |  |  | Bundles |  | 12
Verizon |  |  |  | Verizon |  |  |  | Verizon |  | 1
Upgrades |  |  |  | Upgrades |  |  |  | Upgrades |  | 15
Add-ons |  |  |  | Add-ons |  |  |  | Add-ons |  | 23
Spreadsheet: 857031d1706119561-need-help-to-optimize-formula-for-automatic-spilling-1-spill-array-formula-02
Sheet: WIP

 | ID | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  |  |  | column | [NAME] |  |  | Expected Result as Spill Array
 | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  |  |  | g,i |  |  |  |  | 1,1
 | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  |  | h,i |  |  |  | h,i | 2,1
 | 3 | 13 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  |  | d,e,f |  |  |  | d,e,f | 3,0,2
 | 4 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,g |  |  |  | d,e,g | 3,0,1
 | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,h |  |  |  | d,e,h | 3,0,2
 | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  | d,g,h |  |  |  | d,g,h | 3,1,2
 | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  | d,g,i |  |  |  | d,g,i | 3,1,1
 | 8 | 18 | 7 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,g,i |  |  |  | d,e,g,i | 3,0,1,1
 | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  |  | e,f,g |  |  |  | e,f,g | 0,2,1
 | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  |  | e,f,h |  |  |  | e,f,h | 0,2,2
 | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  |  | e,f,i |  |  |  | e,f,i | 0,2,1
 | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  |  | e,g,h |  |  |  | e,g,h | 0,1,2
 | 13 | 20 | 1 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  |  | e,g,i |  |  |  | e,g,i | 0,1,1
 | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  |  | e,h,i |  |  |  | e,h,i | 0,2,1
 | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  |  | f,g,h |  |  |  | f,g,h | 2,1,2
 | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
 | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
 | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
 | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
Spreadsheet: 54a8b062-7e82-44d6-b13d-2e1fd0b7c48f
Sheet: Report

Department | Department Priority | Unit | Unit Priority | Unit Goal Id | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Accounting | 1 |  |  |  | Increase A/P training districtwide. | 1.1 | Conduct at least 1 workshop. | 1 | None | -- Pick One --
Accounting | 3 |  |  |  | Move to one accounting system that consolidates databases, provides online A/P payment inquiries and provides paperless A/P and balance transfers. | 2.1 | Explore accounting systems. | 2 | None | -- Pick One --
Accounting | 3 |  |  |  | Move to one accounting system that consolidates databases, provides online A/P payment inquiries and provides paperless A/P and balance transfers. | 2.2 | Determine appropriate system. | 2 | None | -- Pick One --
Accounting | 3 |  |  |  | Move to one accounting system that consolidates databases, provides online A/P payment inquiries and provides paperless A/P and balance transfers. | 2.3 | Purchase if appropriate. | 2 | None | -- Pick One --
Accounting | 1 |  |  |  | Improve accounting communication districtwide. | 3.1 | Disseminate accounting information. | 1 | None | -- Pick One --
Accounting | 1 |  |  |  | Improve accounting communication districtwide. | 3.2 | Enhance website information. | 1 | None | -- Pick One --
Accounting | 1 |  |  |  | Improve accounting services districtwide. | 4.1 | Explore accounting services. | 1 | None | -- Pick One --
Accounting | 1 |  |  |  | Improve accounting services districtwide. | 4.2 | Determine services for alignment. | 1 | None | -- Pick One --
Accounting | 1 |  |  |  | Improve accounting services districtwide. | 4.3 | Align services. | 1 | None | -- Pick One --
Spreadsheet: 218108d1362350332-table-with-2-variables-solved
Sheet: Sheet1

 | p | N1 | N2
 | 1 | 18 | 12 | 16 | 22 | 24
 |  | 24 | 18 | 20 | 22 | 28 | 30
 |  | 30 | 18 | 22 | 24 | 34 | 36
 |  | 36 | 24 | 28 | 30 | 46
 |  | 42 | 24 | 30 | 34 | 36 | 48 | 52
 |  | 48 | 30 | 36 | 40 | 58 | 60
 |  | 54 | 30 | 36 | 46 | 48 | 60 | 64 | 66
 |  | 60 | 36 | 48 | 50 | 52 | 70 | 72
 |  | 72 | 48 | 52 | 54 | 60 | 66 | 76 | 82 | 90
 | 2 | 24 | 18 | 30
 |  | 36 | 24 | 30 | 42
 |  | 48 | 30 | 36 | 40 | 58 | 60
 |  | 60 | 36 | 42 | 48 | 50 | 70 | 72 | 74
 |  | 72 | 42 | 48 | 54 | 58 | 60 | 62 | 82 | 86 | 90
 | 3 | 36 | 20 | 22 | 26 | 28 | 44 | 46
 |  | 54 | 34 | 36 | 38 | 40 | 44 | 46 | 62 | 64 | 68
 |  | 72 | 44 | 46 | 50 | 52 | 54 | 56 | 58 | 62 | 82 | 86 | 88 | 90
 | 4 | 48 | 26 | 30 | 34 | 36 | 38 | 58 | 60
 |  | 72 | 42 | 46 | 48 | 50 | 52 | 54 | 58 | 60 | 62 | 82 | 84 | 86 | 90
 | p | N1 | N2
 | 2 | 24
Spreadsheet: 289780d1389691445-consolidating-data-from-many-worksheets-example
Sheet: Sheet1

Employee | Payroll No. | Paycode | Hours | Adjustment/Notes | Amount
Employee 1 | 1
 |  | LE Company Basic | 30.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 246.615
 |  | Employee Totals : | 30.75 |  | 246.615
Employee 2 | 2
 |  | LE Company Basic | 31 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 248.619997
 |  | Employee Totals : | 31 |  | 248.619997
Employee 3 | 3
 |  | LE Company Basic | 31 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 248.62
 |  | Employee Totals : | 31 |  | 248.62
Employee 4 | 4
 |  | LE Company Basic | 30.5 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 244.61
 |  | Employee Totals : | 30.5 |  | 244.61
Employee 5 | 5
 |  | LE Company Basic | 23.25 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 186.464999
 |  | LE Company BH | 7.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 80.3675
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 35.28
 |  | Employee Totals : | 31 |  | 302.112499
Employee 6 | 6
 |  | LE Company Basic | 15.5 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 124.31
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 17.64
 |  | Employee Totals : | 15.5 |  | 141.95
Employee 7 | 7
 |  | LE Company Basic | 23.25 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 186.465
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 26.46
 |  | Employee Totals : | 23.25 |  | 212.925
Employee 8 | 8
 |  | LE Company Basic | 23.5 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 188.47
 |  | LE Company BH | 7.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 80.3675
 |  | LE Company Late Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 4.42
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 35.28
 |  | Employee Totals : | 31.25 |  | 308.5375
Spreadsheet: 140729d1328874235-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-example_tiggi
Sheet: RESULT

NAME | SEX | GOLF | TENNIS | RUGBY | POKER | SNOOKER
test1 | F
test2 | F
test3 | M
test4 | M
test5 | F
test6 | F
[NAME] | F
test8 | M
test9 | M
test10 | M
test11 | M
test12 | M
test13 | M
test14 | M
test15 | M
Spreadsheet: 67284d1267885330-if-dates-return-value-if-dates-return-value-rev1
Sheet: Sheet1

 | SCENARIO 1:  From start then every N days as per cell C4 the amount will be posted and zero to the last date if not up to N days as per C4.
 | AMOUNT: | 34000
 | DAYS: | 75
 | [NAME] | START | FINISH | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
 | International Ticket | 2010-05-15 00:00:00 | 2011-01-25 00:00:00 | 0 | 0 | 0 | 0 | 34000 | 0 | 0 | 0 | 0 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Should be in row 7 |  |  | 0 | 0 | 0 | 0 | 34000 | 0 | 34000 | 0 |  | 34000 |  | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 15 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 25
 |  |  |  |  |  |  |  |  |  | 1 | 31 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 25
 | SCENARIO 2:  From start then every N days as per cell c18 the amount will be posted and also if there is any balance to the last date even if it is not up to N days (C18).
 | AMOUNT: | 34000
 | DAYS: | 75
 | [NAME] | START | FINISH | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
 | International Ticket | 2010-05-15 00:00:00 | 2011-01-25 00:00:00 | 0 | 0 | 0 | 0 | 34000 | 0 | 0 | 0 | 0 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Should be in row 18 |  |  | 0 | 0 | 0 | 0 | 34000 | 0 | 34000 | 0 | 0 | 34000 | 0 | 34000 | 34000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 15 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 25
 |  |  |  |  |  |  |  |  |  | 1 | 31 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 25
Spreadsheet: 143396d1330401036-how-to-transpose-a-column-based-on-similar-values-sample
Sheet: Sheet1

1272 | 885657035694 | 885657035694 | 885657035816 | 885657035878 | 885657036462 | 885657036615 | 885657036790 | 885657200818 | 885657200962
1272 | 885657035816
1272 | 885657035878
1272 | 885657036462
1272 | 885657036615
1272 | 885657036790
1272 | 885657200818
1272 | 885657200962
1381 | 885657152681 | 885657152681 | 885657152704 | 885657152728 | 885657152742 | 885657152766
1381 | 885657152704
1381 | 885657152728
1381 | 885657152742
1381 | 885657152766
 |  |  | So find similar values from column A and then transpose the adjacent values from [NAME]
Spreadsheet: 722476d1615290711-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum-gk-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | M | 3-may-148 |  |  |  |  |  |  | P | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 9 | 9 | 9 | 9 |  | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friends |  |  |  | Non Fiendly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 | 5 | 2 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 5 | 3 |  | 8
 |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 5 | 3 |  | 6
 |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Missing Numbers |  |  |  |  | 4 | 3 | 8 |  |  |  |  |  | 4 | 7 | 1 | 5 |  | 2 | 9
 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 | 2 | 3
 |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1 | 5 | 7 |  | 3
 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | P | 7 |  |  | Lucky Numbers |  |  |  |  | 1 |  |  |  |  |  |  |  | 7 | 4 | 6 | 1
 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  | L | 3 |  |  | [NAME] |  |  |  |  | 5 | 3 | 6 | 4 |  |  |  |  | 8 | 5 | 3 | 6 |  | 1 | 2
 |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Netral Numbers |  |  |  |  | 2 | 7 | 8 | 9 |  |  |  |  | 9 | 1 | 5 | 3 |  | 4 | 2
 |  |  |  |  | 1
 |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 repeats only enter once
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need a formula that will check the  values in R22:R23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and S22:S23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | need to check the numbers that are common from the friendly table and record
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the common numbers into AA22:AG22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | second step all numbers not common between the two under friendly will be recorded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | under the unfriendly and paste into AA23:Ag23 as well as the number from the unfriendly table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | not repeating
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finally third from AA22 to AG 23 checl all numbers and what not there in AA22 to:AG23 , they wiil be recorde into neutral number from AA24:Ag24