tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 143288d1330351496-countifs-for-unique-values-based-on-months-while-reading-from-dates-sample_count
Sheet: Sheet1

 |  |  |  |  |  | Result I want to get from the Formula
 |  | NAMEA | 2009-06-03 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-03 00:00:00 | KETPO
 |  | NAMEA | 2009-06-05 00:00:00 | KETPO1 |  |  |  |  |  |  |  |  | RAW DATA --> | NAMEA | 2009-06-03 00:00:00 | KETPO
 |  | NAMEA | 2009-06-10 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-03 00:00:00 | KETPO
 |  | NAMEA | 2009-06-12 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-05 00:00:00 | KETPO1
 |  | NAMEA | 2009-06-15 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-10 00:00:00 | KETPO
 |  | NAMEA | 2009-06-17 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-12 00:00:00 | KETPO
 |  | NAMEA | 2009-06-18 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-15 00:00:00 | KETPO
 |  | NAMEA | 2009-06-19 00:00:00 | KETPO1 |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-15 00:00:00 | KETPO
 |  | NAMEA | 2009-06-20 00:00:00 | KETPOO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-15 00:00:00 | KETPO
 |  | NAMEA | 2009-06-20 00:00:00 | KETPOT1 |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-15 00:00:00 | KETPO
 |  | NAMEA | 2009-06-24 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-17 00:00:00 | [NAME]
 |  | NAMEA | 2009-06-24 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-18 00:00:00 | KETPO
 |  | NAMEA | 2009-06-25 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-19 00:00:00 | KETPO1
 |  | NAMEA | 2009-06-26 00:00:00 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-20 00:00:00 | KETPOO
 |  | NAMEA | 2009-06-26 00:00:00 | KETPOO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-20 00:00:00 | KETPOT1
 |  | NAMEA | 2009-06-27 00:00:00 | KETPOS |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-20 00:00:00 | KETPOT1
 |  | NAMEA | 31/06/2009 | KETPO |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-20 00:00:00 | KETPOT1
 |  | NAMEA | 31/06/2009 | [NAME] |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-20 00:00:00 | KETPOT1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-24 00:00:00 | KETPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-24 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-25 00:00:00 | KETPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-26 00:00:00 | KETPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-26 00:00:00 | KETPOO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 2009-06-27 00:00:00 | KETPOS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 31/06/2009 | KETPO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAMEA | 31/06/2009 | [NAME]
Spreadsheet: 825781d1681505640-forecasting-with-gaps-book1-20-
Sheet: Paid FTEs

 |  |  |  |  |  |  |  |  |  |  |  | FY Months Remaining
 |  | DATA_TYPE | FY_AP
 |  | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE | YTD FTE Total | PROJECTION
Key | DEPTID | 2023_01 | 2023_02 | 2023_03 | 2023_04 | 2023_05 | 2023_06 | 2023_07 | YTD FTE Total | PROJECTION | Average Monthly FTE | Proj Exp Remaining Months | Standard Projection | Adjustment Entry
 | 00AEDAPS | 1 | 0.1 | 0 | 0 | 0 | 0 |  | 1.1 | 0.1 |  |  |  | 96.4
 |  |  |  |  |  |  |  |  |  |  |  |  | sum last 2 months > ,5 then multiply with 1 else multiply with 0,0001
Spreadsheet: louise_kitchen__24063__Non Commercial
Sheet: Sheet1

CANADA - Non-Commercial
 | Risk | Documentation | Volume Mgmt | Logistics | [NAME] | IT | Human Resources | Accounting | Gov Affairs | Legal | [NAME] | Credit | Toronto
1 | [NAME] | Seib | Punja | Prior | Wiebe | [NAME] |  | Scott |  | Keohane | [NAME] |  | Marryott
 | Reeves | [NAME] | [NAME] | Ripley | Koulikov | Martin |  | Dawes |  | Johnston | O'Neil
 | Bardel | Moscoso |  | Langfeldt |  | [NAME] |  | Hanslip |  | Crawford | McCullough
 | Unger | Pernul |  | Tackney |  |  |  | Donlevy-Lee |  | [NAME] | Scott
 | Luc | Liknes |  |  |  |  |  | Quon |  | Flaman
 |  | Machado |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Jessop
2 | [NAME] | [NAME] | Dupuy | Heal |  | Maskwa | Doucet |  | [NAME] | Sietzema | [NAME] |  | Crouch
 | Cooper | Gilkes |  | Webner |  | Rondeau | [NAME] |  | Stubbings |  | [NAME] |  | [NAME]
 | Rothrock | Boulanger |  | Nicholson |  |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Hanley
 |  |  |  |  |  |  |  |  |  |  |  |  | Rojo
3 | Rogers | Dey |  | Herring | Bingham |  | Wells | Lawrick | [NAME] | [NAME] |  | Otto | [NAME]
 | Rennebeerg | [NAME] |  |  | [NAME] |  |  | Vallejo |  |  |  |  | [NAME]
 |  | [NAME] |  |  | McKeel |  |  | Ta |  |  |  |  | Hall
 |  |  |  |  |  |  |  | Morgan
 |  |  |  |  |  |  |  | Panchuk
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 863438d1710933368-creating-lists-with-multiple-criteria-sample-excel
Sheet: List

Name | Limit | Bank 1 | Bank 2 | Bank 3 | Bank 4 | Bank 5
[NAME] | 30000 | 12000 | 35000 | 25000 | 17000 | 50000
George | 55555 | 50000 | 25000 | 30000 | 0 | 30000
[NAME] | 100000 | 90000 | 40000 | 90000 | 30000 | 25000
[NAME] | 123123 | 100000 | 125000 | 105000 | 35000 | 3560
[NAME] | 25000 | 18000 | 26000 | 35000 | 25000 | 30000
Spreadsheet: juan_hernandez__17578__09-11-00
Sheet: Sheet1

Deal # | sitara
392445 | sitara
392222
392096
392036
392000
391939
391925
391574
391565
391209
391207
391206
391059
390876
390681
390566
390517
390464
390367
390362
390346
390325
390184
390040
389924
389910
389826
389759
389346
389342
389192
389130
388912
388557
388330
388195
388188
388148
388128
388100
388075
388050
388041
386867
385249
383620
377126
341680
323403
295980
WR0994
WR409538
M306844
M307416
M307957
M307988
M308514
M309033
M309039
M309055
M309561
M309562
M309563
M309564
389759.01
389759.02
391550.01
400718.01
401392.01
401597.01
401598.01
402208.01
402817.01
402821.01
402848.01
402849.01
403187.01
403374.01
403376.01
403475.01
403564.01
403723.01
403763.01
403767.01
403838.01
403842.01
403847.01
403913.01
403926.01
403929.01
403949.01
404014.01
404028.01
404029.01
404104.01
404128.01
404137.01
404138.01
404155.01
404157.01
404216.01
404255.01
404264.01
404265.01
404340.01
404371.01
404404.01
404415.01
404688.01
404763.01
404768.01
404793.01
404794.01
404892.01
404893.01
404896.01
404898.01
404903.01
404932.01
405567.01
405624.01
405626.01
405672.01
405674.01
405690.01
405691.01
405695.01
405700.01
405710.01
405884.01
405887.01
405963.01
406060.01
406280.01
406488.01
406581.01
406732.01
406745.01
406815.01
406834.01
406937.01
407019.01
407193.01
407202.01
407216.01
407293.01
407443.01
407444.01
407462.01
407609.01
407611.01
407729.01
407749.01
407757.01
407759.01
408550.01
322684.01
341151.01
343053.01
345326.01
352750.01
371336.01
384908.01
393975.01
394135.01
394164.01
394165.01
394229.01
395080.01
399749.01
401805.01
401865.01
402615.01
403083.01
403325.01
403356.01
403615.01
403817.01
403831.01
404420.01
404423.01
404532.01
404897.01
405101.01
405941.01
405946.01
406078.01
406149.01
406161.01
406165.01
406480.01
406572.01
406579.01
406584.01
406591.01
406666.01
406679.01
406693.01
406695.01
406737.01
406915.01
406971.01
407061.01
407237.01
407241.01
407317.01
407319.01
407330.01
407353.01
407445.01
407505.01
407517.01
407522.01
407533.01
407605.01
407693.01
407696.01
407974.01
407978.01
407983.01
408071.01
408081.01
408139.01
408254.01
408855.01
408861.01
408877.01
Spreadsheet: 782978d1654502048-special-transposing-phonebook-to-sim-format-book2
Sheet: Sheet2

[NAME] (LMF) | NUMBER | [NAME] (FML)
SMITHJ/P | +[PHONE] | JSMITH/P
SMITHJ | [PHONE] | JSMITH
SMITHJ/A | 28 | JSMITH/A
MacGilleFhJP/W | 6284567890 | JPMacGilleFh/W
MacGilleFhaoJP | 12 | JPMacGilleFhao
MacGilleFJP/Xz | +[PHONE] | JPMacGilleF/Xz
[NAME] length 14 characters (Truncate last name)
 | Retain only "+", remove all other than numbers
Spreadsheet: chris_germany__2321__2001new02
Sheet: 3rd Party Deals

 | EES |  |  |  | EOG |  |  |  | EES |  |  |  | Dynegy
 | A06 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | F4 - Monclova |  |  |  | Total | Net
 | 597271 | Price | Amount |  | 597290 | Price | Amount |  | 597293 | Price | Amount |  | 597316 | Price | Amount |  | Receipt | Citygate
1 | 3751 |  |  |  | 4100 |  |  |  | 3674 |  |  |  | 6160
 | 3500
 | 4001
 | 3751
Spreadsheet: 101773d1299813190-draft-day-registration-help-team-draft
Sheet: Teams

Team | A | B | C | D | E | F | G | H
Player
1 | 6 | 15
 | 8 | 37
 | 16
 | 37
 |  | Player is picked on more than one team
 |  | Player's partner has not been drafted but other players at a lower rank have been drafted
Spreadsheet: lindy_donoho__21990__CASplog
Sheet: Post Impl Items

Plog# | Function | Description of Problem | Reported By/Date | Assigned To/Date | Priority | Comments | Release Date | Retested | BY
15 | Delete | Need error message for invalid delete process | [NAME] |  |  | [NAME] to post implementation
30 | Display | GISB compliance recommendations | Mary & Ramona 2/26 |  |  | Post - implementation item
53 | Entry | How much data should be retrieved and how much history should be stored | [NAME] 3/2 |  |  | Active/History filter to be placed on [NAME], Date range capability to be put on Operational Capacity view to default to 1st day of month that is current
63 | Display | Scroll down on Relationship view, keep text box in view | Ramona 3/7
74 | Update | Comments truncated | [NAME] | [NAME] |  | Data deleted after single quote detected in Comments
87 | Comments | Create separate view to capture Operational comments |  |  |  | Will redesign with FGT CAS project
Spreadsheet: 762142d1641408362-formula-for-totalling-based-on-a-drop-down-choice-sample-spreadsheet-01
Sheet: Sheet1

 |  |  |  | Sandra | [NAME] | Beryl | [NAME]
 | December |  | Job B | 1 |  |  | 2
 |  |  | Job A | 3 | 3 | 3 | 3
 |  |  | Job C | 4 | 4 | 4 | 4
 |  |  | Job C | 2 | 2 | 2
 |  |  | Total Jobs Overall
 | Totals |  | Job A
 |  |  | Job B
 |  |  | Job C
Spreadsheet: 493678d1481824482-find-and-replace-troubles-problem-ak
Sheet: Sheet1

TYPE | CONTACT NAME | ADDRESS 1 | STREET | POSTAL TOWN | POSTCODE | PHONE 1 | PHONE 2
Farm | Scs Farm | 71 Bon-Accord St, Aberdeen AB11 6EL, UK |  |  |  | 07453 453359 | +44 7453 453359
Farm | Shell UK Exploration & Production | 1 Altens Farm Rd, Aberdeen AB12 3FY, UK |  |  |  | 01224 248570 | +44 1224 248570
Farm | Groat | Bishopston Farm, Aberdeen AB12 4RS, UK |  |  |  | 01224 782476 | +44 1224 782476
Farm | [NAME] | Causeyport Farm, Portlethen, Aberdeen AB12 4RT, UK |  |  |  | 01224 780216 | +44 1224 780216
Spreadsheet: 648616d1573131417-power-bi-get-rate-based-on-category-and-date-excel-forum-rate
Sheet: Sheet1

Date | Category | Amt |  | Date | Category | Rate |  | [NAME] |  |  |  |  |  |  | Want to find group of Alpha/Bravo/Charlie
2018-07-01 00:00:00 | Alpha | 6 |  | 2018-01-01 00:00:00 | Alpha | 0.2 |  | Date | Category | Amt | [NAME] | Multiply | Sum |  | Average | 2018-07-01 00:00:00
2018-07-01 00:00:00 | Bravo | 17 |  | 2018-01-01 00:00:00 | Bravo | 0.1 |  | 2018-07-01 00:00:00 | Alpha | 6 |  |  |  |  | Average | 2019-02-01 00:00:00
2018-07-01 00:00:00 | [NAME] | 8 |  | 2018-01-01 00:00:00 | [NAME] | 0.18 |  | 2018-07-01 00:00:00 | Bravo | 17
2018-07-01 00:00:00 | Delta | 13 |  | 2018-01-01 00:00:00 | Delta | 0.12 |  | 2018-07-01 00:00:00 | [NAME] | 8
2018-07-01 00:00:00 | Echo | 18 |  | 2018-01-01 00:00:00 | Echo | 0.12 |  | 2018-07-01 00:00:00 | Delta | 13
2018-07-02 00:00:00 | Alpha | 4 |  | 2018-12-14 00:00:00 | Alpha | 0.22 |  | 2018-07-01 00:00:00 | Echo | 18
2018-07-02 00:00:00 | Bravo | 15 |  | 2019-02-08 00:00:00 | Delta | 0.1 |  | 2018-07-02 00:00:00 | Alpha | 4
2018-07-02 00:00:00 | [NAME] | 2 |  |  |  |  |  | 2018-07-02 00:00:00 | Bravo | 15
2018-07-02 00:00:00 | Delta | 13 |  |  |  |  |  | 2018-07-02 00:00:00 | [NAME] | 2
2018-07-02 00:00:00 | Echo | 6 |  |  |  |  |  | 2018-07-02 00:00:00 | Delta | 13
2019-02-01 00:00:00 | Alpha | 13 |  |  |  |  |  | 2018-07-02 00:00:00 | Echo | 6
2019-02-01 00:00:00 | Bravo | 3 |  |  |  |  |  | 2019-02-01 00:00:00 | Alpha | 13
2019-02-01 00:00:00 | [NAME] | 16 |  |  |  |  |  | 2019-02-01 00:00:00 | Bravo | 3
2019-02-01 00:00:00 | Delta | 5 |  |  |  |  |  | 2019-02-01 00:00:00 | [NAME] | 16
2019-02-01 00:00:00 | Echo | 13 |  |  |  |  |  | 2019-02-01 00:00:00 | Delta | 5
2019-02-08 00:00:00 | Alpha | 7 |  |  |  |  |  | 2019-02-01 00:00:00 | Echo | 13
2019-02-08 00:00:00 | Bravo | 18 |  |  |  |  |  | 2019-02-08 00:00:00 | Alpha | 7
2019-02-08 00:00:00 | [NAME] | 9 |  |  |  |  |  | 2019-02-08 00:00:00 | Bravo | 18
2019-02-08 00:00:00 | Delta | 17 |  |  |  |  |  | 2019-02-08 00:00:00 | [NAME] | 9
2019-02-08 00:00:00 | Echo | 2 |  |  |  |  |  | 2019-02-08 00:00:00 | Delta | 17
 |  |  |  |  |  |  |  | 2019-02-08 00:00:00 | Echo | 2
Spreadsheet: 676597d1588881204-sum-countifs-with-an-array-if-in-a-date-range-my_example
Sheet: Sheet1

holidays | 2020-01-01 00:00:00 | 2020-01-01 00:00:00
holidays | 2020-01-02 00:00:00
holidays | 2020-01-03 00:00:00
holidays | 2020-01-04 00:00:00
holidays | 2020-01-05 00:00:00
days in lieu | 2020-01-06 00:00:00
days in lieu | 2020-01-07 00:00:00
days in lieu | 2020-01-08 00:00:00
days in lieu | 2020-02-09 00:00:00
days in lieu | 2020-02-10 00:00:00
days in lieu | 2020-02-11 00:00:00
sickness | 2020-02-12 00:00:00
sickness | 2020-02-13 00:00:00
sickness | 2020-02-14 00:00:00
sickness | 2020-02-15 00:00:00
sickness | 2020-02-16 00:00:00
sickness | 2020-02-17 00:00:00
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 7

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
16-15 | 1
 | 2
 | 3
10-9 | 1
 | 2
 | 3
14-13 | 1
 | 2
 | 3
12-11 | 1
 | 2
 | 3
15-16 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 882579d1730975653-if-a-cell-has-a-number-in-with-a-certain-text-for-it-then-to-be-added-in-a-different-cel-molecular-
Sheet: Sheet1

Molecular
Panel 1 |  |  | Mcps | smokes | heat | bases | sounder base | sounder beacon | wall sounder beacon | I/O
Loop 1 |  |  | 36 | 147 | 44
MCP's-3
Opticals-30
Heats-0
Sounder Bases-19
[NAME] Bases-4
Wall Sounder Beacon-2
I/O's-3
Panel 1
[NAME]
MCP's-9
Opticals-3
Heats-37
Multi's-2
Wall Sounder Beacon-9
I/O's-7
Panel 2
Loop 1
MCP's-11
Opticals-49
Heats-3
Multi's-1
Sounder Base-17
[NAME]
Wall Sounder Beacon-5
I/O's-1
Panel 2
[NAME]
MCP's-1
Opticals-1
Sounder Base-1
Panel 3
Loop 1
MCP's-4
Opticals-17
Heats-2
Sounder Bases-6
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-1
Panel 4
Loop 1
MCP's-2
Opticals-9
Wall Sounder Beacons-2
Panel 5
Loop 1
MCP's-5
Opticals-37
Heats-2
Sounder Bases-13
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-4
Panel 6
Loop 1
MCP's-1
Opticals-1
Sounder Base-1
I/O-1
Spreadsheet: sally_beck__36249__East PG&E Deal Sum by Desk
Sheet: _tmp_9844_EPMI-LT-ERCOT_deal_su

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       04/06 | /01
Report Da | te:  04/06/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       18:12 | :48
Post ID: | 9844
Desk: EPM | I-LT-ERCOT
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
403479 | PGEENEPOWLP | 2000-08-30 00:00:00 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | No | ERCOT System | 49615 | 0 | 0 | 0 | 51200 | 0 | 454459 | 0 | 454459 | 447017 |  | -7254 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R6 |  |  |  |  |  | 49615 | 0 | 0 | 0 | 51200 | 0 | 454459 | 0 | 454459 | 447017 |  | -7254 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 49615 | 0 | 0 | 0 | 51200 | 0 | 454459 | 0 | 454459 | 447017 |  | -7254 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 817819d1676460625-need-to-count-how-many-times-a-group-of-numbers-occur-in-a-line-excel-problem-formula-required
Sheet: Sheet1

 | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | 1 | 1 | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | 2 | W | W |  |  | W | W | 2 | 2 | 2 |  |  | W | W | W | W | W |  |  | W | 1 | W | 2 | 2
 | W | W | W | W | W |  |  | W | 1 | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | 2 | W | W |  |  | W | 2 | 2 | W | W |  |  | W | 2 | W | W | W |  |  | W | 2 | 2 | 2 | W
 | 1 | 1 | 1 | 1 | 1 |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 5 | 5 | 5 | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | 2 | 2 | 2 | W |  |  | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | 0.5 | W |  |  | W | W | W | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | 2 | W |  |  | 1 | 1 | W | W | W |  |  | W | W | W | W | W
Problem - Need to know how to write a formula to count how many times 2 occurs  in a group, example line 10  there are 3 groups of 2, line 13 there are 4 groups of 2 etc.
Spreadsheet: 35132d1232644530-copying-hyperlinks-december-2008-excel-forum
Sheet: 1(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | 1(a)
на начало дня 1 Декабря 2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 0 | 0 | 0 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 0 | 0 | 0 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Общий Итог: | 0 | 0 | 0 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
 |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
 |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус минус | A170 | B182 | C182 | F182
на конец дня 1 Декабря 2008 года |  |  |  |  |  | Плюс-минус | A186 | B198 | C198 | F198
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
[NAME] | 5000 | 0 | 5000 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус книги | 6000 | 0 | 6000 |  |  |  |  | B233 | C233 | F233
Вагриус правда | 7000 | 0 | 7000
Вагриус минус | 100 | 0 | 100
Плюс-минус | 300 | 0 | 300
Издательство Вагриус | 4500 | 0 | 4500
Вагриус плюс-минус | 9999 | 0 | 9999
Общий Итог: | 32899 | 0 | 32899
Spreadsheet: 709928d1608630660-generate-list-of-unique-emails-and-sum-data-in-columns-example-data-workbook-tickets
Sheet: Sheet1

From | From [NAME] | Thread Count |  |  |  |  |  |  |  |  |  |  | Unique User Emails |  | Total Thread Count
Person 1 | [EMAIL] | 1
Person 3 | [EMAIL] | 4
Person 4 | [EMAIL] | 6
Person 5 | [EMAIL] | 1
Person 2 | [EMAIL] | 2
Person 1 | [EMAIL] | 1
Person 1 | [EMAIL] | 5
Person 5 | [EMAIL] | 6
Person 4 | [EMAIL] | 13
Person 4 | [EMAIL] | 9
Person 5 | [EMAIL] | 1
Person 1 | [EMAIL] | 8
Person 4 | [EMAIL] | 2
Person 3 | [EMAIL] | 3
Person 3 | [EMAIL] | 5
Person 4 | [EMAIL] | 10
Person 1 | [EMAIL] | 1
Person 5 | [EMAIL] | 4
Person 3 | [EMAIL] | 2
Person 3 | [EMAIL] | 6
Spreadsheet: 462502d1464080217-selecting-data-according-to-text-and-placing-in-graph-peter-renton-bsb-
Sheet: Scunthorpe

Scunthorpes Capital Expense 2016-2017
Improment/Equipment | In-house/ Subcontract | Time Scale | Expense | possible Savings
add some led lights in key area of w/shop 6 | inhouse |  | 2300 | 546
floor scrubber |  |  | 2500
fixed wire repair costs | subcontract |  | 7500
 |  |  |  |  |  | Scunthorpe
 |  |  |  |  |  | expense | Potential Saving
Totals
Spreadsheet: 719838d1613843874-replace-if-specific-position-matches-index-test-2-
Sheet: Sheet1

 |  |  |  |  |  | Sample Test of current formula |  |  |  |  |  |  |  |  |  |  |  | Old text | Replace | <Sample Index
Old Text | Desired output |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 30
20AC326 | 2010326 |  | A | 10 |  | 20AC326 |  |  |  |  |  |  |  |  |  |  |  | D | 40
25Bs99999 | 252099999 |  | B | 20 |  | 25Bs99999 |  |  |  |  |  |  |  |  |  |  |  | E | 50
21OL34gh7 | 21OL34gh7 |  | C | 30 |  | 21OL34gh7 |  |  |  |  |  |  |  |  |  |  |  | F | 60
56GG99234 | 567099234 |  | D | 40 |  | 56GG99234 |  |  |  |  |  |  |  |  |  |  |  | G | 70
53gG10001 | 537010001 |  | E | 50 |  | 53gG10001 |  |  |  |  |  |  |  |  |  |  |  | H | 80
53AD10001 | 531010001 |  | F | 60 |  | 53AD10001 |  |  |  |  |  |  |  |  |  |  |  | J | 90
53AD10002 | 531010002 |  | G | 70 |  | 53AD10002
53AD10003 | 531010003 |  | H | 80 |  | 53AD10003
53AD10004 | 531010004 |  | J | 90 |  | 53AD10004
53DG10005 | 534010005 |  |  |  |  | 53DG10005 | <Want this to cell be highlighted)
53JD10006 | 531010006 |  |  |  |  | 53AD10006
53JD10007 | 531010007 |  |  |  |  | 53AD10007
Spreadsheet: 708536d1607920155-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver-jimmy-
Sheet: Model

Item | Qty | Lbs | Total lbs | [NAME] lbs |  | What I want it to have my formulate produce as the end result
 |  |  |  | 150 |  | Waybill 1 | Waybill 2 | Waybill 3 | Total
Clear ziplock baggies | 1 | 40 |  |  |  | 0 | 1 | 0
baggies tie close | 2 | 40 |  |  |  | 0 | 1 | 1
cans | 2 | 17 |  |  |  | 2 | 0 | 0
Sterile water | 8 | 15 |  |  |  | 7 | 1 | 0
Swabs | 2 | 6 |  |  |  | 0 | 1 | 1
Spoons | 8 | 6 |  |  |  | 0 | 8 | 0
Straps | 3 | 3 |  |  |  | 3 | 0 | 0
dowels | 1 | 2 |  |  |  | 0 | 0 | 1
blister pacsk | 1 | 1 |  |  |  | 1 | 0 | 0
screens | 2 | 1 |  |  |  | 1 | 1 | 0
Straws | 1 | 0.5 |  |  |  | 0 | 0 | 1
 |  |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
 |  | Objective |  |  | Weight | 1000 | 100 | 10