tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 472672d1469702411-vlookup-based-on-a-criteria-account-client-wise
Sheet: Sunil

NO. | IMEI | STATUS | CLIENT | PRICE | PAID BY | AMOUNT | PAID DATE | REMARKS
1 | 355409070322593 |  |  |  | Moneygram | 560
2 | 352069066537068
3 | 358363067170423
4 | 354442060877152
5 | 352030074483786
6 | 353270072104419
7 | 354450067605476
8 | 352025078219129
9 | 358370066492294
10 | 353320076541247
11 | 359254064387590
12 | 355418076663512
13 | 356980065237623
14 | 352020070476868
15 | 352067063704285
16 | 355424073063672
17 | 358762058792659 |  |  |  | - | - | -
18 | 353317071192497
19 | 352061068915517
20 | 355432075070769
21 | 353335070712867
22 | 353314073133827
23 | 358369066913002
24 | 356953061971735
25 | 353318079419841
26 | 352032075033131
27 | 358353064316921
28 | 353336070334827
29 | 352023072409390
30 | 358367068551713
31 | 354449066079691
32 | 352092070849055
33 | 353264071704386
34 | 354445062502645
35 | 354383065672182
36 | 356960065010782
37 | 353270072719331
38 | 354435068766831
39 | 359310069874832
40 | 354435068766831
41 | 359310069874832
42 | 353310070204884
43 | 354451065567445
44 | 353265079511459
45 | 358361068540412
46 | 354381069063572
47 | 359226069276523
48 | 352072061212687
49 | 355432075276838
50 | 355696078242761
51 | 359256061068594
52 | 356980060227611
53 | 356952060995604
54 | 359317064517407
55 | 352075062343294
56 | 353287078205834
57 | 359228063650398
58 | 352070066064301
59 | 359244068323683
60 | 358371063529823
61 | 354381060547425
62 | 355430075637199
 | TOTAL
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT
Spreadsheet: 130750d1322572107-utilising-time-in-a-drop-down-list-to-show-start-and-finish-time-millbook1
Sheet: Lists

6 x 2 | Plate Mill 20 |  | 01:00:00 | :00
2 x 10 | Rail service Center |  | 02:00:00 | :05
10 x 6 | CMB 4 |  | 03:00:00 | :10
 | CMB 13 |  | 04:00:00 | :15
 | CMB 15 |  | 05:00:00 | :20
 | CMB Scale |  | 06:00:00 | :25
 | [NAME] |  | 07:00:00 | :30
 | [NAME] 17 |  | 08:00:00 | :35
 | [NAME] |  | 09:00:00 | :40
 | Sulpher Print |  | 10:00:00 | :45
 | [NAME] (BBM ENT 7) |  | 11:00:00 | :50
 | BBM ENT 3,5,6 |  | 12:00:00 | :55
 | MSM A (Sections) |  | 13:00:00
 | MSM J (Rail) |  | 14:00:00
 | MSM E (Rail) |  | 15:00:00
 | MSM F (Sections) |  | 16:00:00
 | Degasser [NAME] |  | 17:00:00
 | Wobs |  | 18:00:00
 | [NAME] |  | 19:00:00
 | Misc |  | 20:00:00
 | Red Dust |  | 21:00:00
 | AFCO RoRo skip |  | 22:00:00
 | Decant pit inside BOS |  | 23:00:00
 | BBM Blooms
 | Caster 4 clearing
 | In between BBM MSM
 | Plate Mill 20 (Scrap)
 | DLCO
 | Blast
 | OPP
 | Shoe scrap CEW
 | Slab Yard
 | 95a Scale pile
 | Caster 5 & Caster 4 Blooms
 | Billet despatch
Spreadsheet: 7cdf1dbc-b886-4219-a636-47b7144dfe48
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Plassering | [NAME] | Ant. ser. | Score | Hcp | Total score | Navn | Klubb
1 |  |  |  |  | 0
2 |  |  |  |  | 0
3 |  |  |  |  | 0
4 |  |  |  |  | 0
5 |  |  |  |  | 0
6 |  |  |  |  | 0
7 |  |  |  |  | 0
8 |  |  |  |  | 0
9 |  |  |  |  | 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
Spreadsheet: 165653d1341314080-if-formula-when-using-result-from-vlookup-a-and-d
Sheet: Acc&Def

Date | 2012-06-30 00:00:00
GBP | 1
USD | 1.581
EUR | 1.2111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETAINERS ONLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIABILITY | ASSET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (reduces rev) | (increase rev)_
Name | Exch Cost Centre | Other Code | Exch Dept | fx | Currency | Inv fee total | Current monthly fee in invoicing currency | months billed | Date from | Date billed to | Invoice days | Work done | Day rate | Deferred | D. Income |  | D. Income (Consolidated) | Acc Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days | LC |  | GBP
 | 1 | a | FPR | 1 | GBP | 15000 | 15000 | 1 | 01/04/2012 | 30/04/2012 | 29 | 90 | 517.2413793103449 | -61 | -15000 |  | 0 | 15000
 | 2 | b | FPR | 1 | GBP | 15000 | 15000 | 1 | 2012-05-01 00:00:00 | 2012-05-30 00:00:00 | 29 | 60 | 517.2413793103449 | -31 | -16034.48275862069 |  | 0 | 16034.48275862069
 | 4 | c | FPR | 1 | GBP | 15000 | 5000 | 3 | 2012-04-05 00:00:00 | 2012-06-04 00:00:00 | 60 | 86 | 250 | -26 | -6500 |  | 0 | 6500
 | 5 | d | FPR | 1 | GBP | 15000 | 15000 | 1 | 2012-07-02 00:00:00 | 2012-08-01 00:00:00 | 30 | 0 | 500 | 30 | -15000 |  | 0 | 15000
Spreadsheet: 40741d1239135902-use-a-vlookup-to-return-multiple-values-lookupsheet
Sheet: data

name | client | Item-1 | Item-2 | Item-3
[NAME] | abc | 1234 | 987 | 1475
[NAME] | def | 7865 | 1200 | 1890
mary | ghi | 14496 | 1413 | 2305
[NAME] | jkl | 21127 | 1626 | 2720
[NAME] | mno | 27758 | 1839 | 3135
mary | pqr | 34389 | 2052 | 3550
[NAME] | [NAME] | 41020 | 2265 | 3965
[NAME] | vxc | 47651 | 2478 | 4380
[NAME] | dfr | 54282 | 2691 | 4795
mary | tgh | 60913 | 2904 | 5210
[NAME] | jkl | 67544 | 3117 | 5625
[NAME] | poi | 74175 | 3330 | 6040
mary | yyy | 80806 | 3543 | 6455
[NAME] | ttt | 87437 | 3756 | 6870
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: General00Lee

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
General00Lee
offlineGeneral00Lee
Add as a friend Send message Donate
Experience level 27
14,402 / 15,000
Location: PolandPoland, Great Poland Citizenship: CroatiaCroatia
eRepublik birthday
Apr 15, 2011
National rank: 980
No political activity
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(120)
sime1408
[NAME]
Nosghotic
Stakor077
yanbbo
GleNoobaPosleKise
Daria89
[NAME]
Macaklin
view all
Land of General00Lee: 17 buildings
Visit
About me
Wiki page
"We choose only once. We choose either to be warriors or to be ordinary. A second choice does not exist. Not on this earth."
~ [NAME] ~
Achievements
hard worker
5
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
5
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
1,463.00
Super soldier:1,463 / 1,500
Rank
Colonel **Colonel **
Rank points:
453,054 / 540,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 98207317-46d4-4eb7-8c63-d54660db730a
Sheet: Table 5.5

Monthly Statistical Bulletin
5.5 Stock exchange indexes
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
All ordinaries index (a)
July | 4249.5 | 4507.4 | 4500.5 | 4289.400000000001 | 5035.7
August | 4484.1 | 4438.8 | 4369.9 | 4339 | 5125.3
September | 4739.3 | 4636.9 | 4070.7 | 4406.3 | 5217.7
October | 4646.9 | 4733.4 | 4360.5 | 4535.4 | 5420.3
November | 4715.5 | 4676.4 | 4184.7 | 4518 | 5314.3
December | 4882.7 | 4846.9 | 4111 | 4664.6 | 5353.1
January | 4596.9 | 4850 | 4325.7 | 4901 | 5205.1
February | 4651.1 | 4923.6 | 4388.1 | 5120.38 | 5415.4
March | 4893.1 | 4928.6 | 4420 | 4979.9 | 5403
April | 4833.9 | 4899 | 4467.2 | 5168.6 | 5470.8
May | 4453.6 | 4788.9 | 4133.7 | 4914 | 5473.8
June | 4324.8 | 4659.8 | 4135.5 | 4775.4
S&P/ASX 200 index (b)
July | 4244 | 4493.5 | 4424.6 | 4269.1 | 5052
August | 4479.1 | 4404.2 | 4296.5 | 4316.1 | 5135
September | 4743.6 | 4582.9 | 4008.6 | 4387 | 5218.9
October | 4643.2 | 4661.6 | 4298.1 | 4517 | 5425.5
November | 4701.4 | 4584.4 | 4119.8 | 4506 | 5320.1
December | 4870.6 | 4745.2 | 4056.6 | 4648.9 | 5352.2
January | 4569.6 | 4753.9 | 4262.7 | 4878.8 | 5190
February | 4637.7 | 4831.7 | 4298.5 | 5104.08 | 5404.8
March | 4875.5 | 4837.9 | 4335.2 | 4966.5 | 5394.8
April | 4807.4 | 4823.2 | 4396.6 | 5191.2 | 5489.1
May | 4429.7 | 4708.3 | 4076.3 | 4926.6 | 5492.5
June | 4301.5 | 4608 | 4094.6 | 4802.6
(a) Index at the end of the month. Base: December 1979 = 500.0. (In March 2000 the
all ordinaries index was at 3 133.3, and this was the base used for the S&P/ASX200
index.)
(b) Index at the end of the month. Base: March 2000 = 3 133.3.
Source: Australian Financial Review | http://www.afr.com/home/
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-07-01 00:00:00
Spreadsheet: 245c7406-585b-4906-9c9c-a36ec1efb337
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2014-2015 Unit Program Planner
ONLY ENTER DATA IN HIGHLIGHTED SPACES
1. Enter all your activities and costs per Scout under each month. |  |  | Unit Type and Unit # |  | 0
2. Enter your number of Scouts and unit commission %. |  |  | Number of Scouts in Unit |  | 0
3. Fill in the five shaded fields at the bottom of the sheet. |  |  | Unit Commission % |  | 0
September |  | October |  | November
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
December |  | January |  | February
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
March |  | April |  | May
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
June |  | July |  | August
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
0 | Registration & Insurance |  | Unit Total Activity Cost & Expenses |  | 0
0 | Boys' Life |  | Scout Total Activity Cost & Expenses |  | 0
0 | Uniform |  | Other Expenses |  | 0
0 | Advancements |  | Unit [NAME]
0 | Total Expenses |  | Scout Sales Goal
 |  |  | Unit Commission
Spreadsheet: 134219d1325096808-vlookup-formula-lookup-with-indirect
Sheet: FebData

Emp Id | [NAME] | Sales
1001 | [NAME] | 111
1002 | Sarita | 142
1003 | Bhavesh | 145
1004 | Priya | 167
1005 | [NAME] | 98
1006 | Rupak | 300
1007 | [NAME] | 731
1008 | Raman | 431
1009 | Rajat | 666
1010 | Umesh | 678
1011 | Upendra | 552
1012 | Upajit | 586
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet7

Counting the number of differences between two ranges
MyData |  |  | YourData
1 |  |  | 1 | 34 |  |  | False |  | 0
 |  |  | 3 | 35 |  | False | False | 0 | 0
 |  |  | 5 | 36 |  | False | False | 0 | 0
 |  |  | 7 | 37 |  | False | False | 0 | 0
 |  |  | 9 | 38 |  | False | False | 0 | 0
 |  |  | 11 | 39 |  | False | False | 0 | 0
 |  |  | 13 | 40 |  | False | False | 0 | 0
 |  |  | 14 | 41 |  | True | False | 1 | 0
 |  |  | 17 | 42 |  | False | False | 0 | 0
 |  |  | 19 | 43 |  | False | False | 0 | 0
 |  |  | 21 | 44 |  | False | False | 0 | 0
 |  |  | 23 | 43 |  | False | True | 0 | 1
 |  |  | 25 | 46 |  | False | False | 0 | 0
 |  |  | 27 | 47 |  | False | False | 0 | 0
 |  |  | 29 | 48 |  | False | False | 0 | 0
 |  |  | 31 | 49 |  | False | False | 0 | 0
 |  |  | 33 | 50 |  | False | False | 0 | 0
Differences found:
Alternate version:
Spreadsheet: 694729d1599763991-if-formula-help-dschittone-sample
Sheet: 07-08

LIST PROJECT # | DISTRICT SCHOOL - PROPOSED BUILDING PROJECT                                      (List Deficiencies from District Facilities Director and 00-05 District LRFP'S by School and Year)   Note:  Add Rows for Additional Schools | 2007-2008 | Life - Safety  - Priority A | Critical /  Recommended Projects -              Priority B | [NAME]Priority C | Barrier-Free ADA Compliance - Priority H | Energy Efficiency - Priority E | Quantity - Check Total | Unit Cost
 | SCHOOL NAME: [NAME] Complex
2 | Replace Built-Up Roof System | 315000 | 0 |  | 0 | 0 | 0 | 53700 | 15
3 | Paint Interior Walls | 26800 | 0 | 0 |  | 0 | 0 | 243214 | 0.55
4 | Acoustical Treatment in Music Room | 6700 | 0 | 0 |  | 0 | 0 | 680 | 9.75
7 | Regrout Ceramic Tile in Pool | 134500 | 0 | 0 |  | 0 | 0 | 11210 | 12
11 | RTU's |  | 0 | 0 | 0 | 0 |  | 600000 | ls
14 | Replace Toilet Partitions (ADA) - 3 per room (district to buy/install) | 10000 | 0 | 0 |  | 0 | 0 |  | ls
 | SUBTOTAL "A"
 | SCHOOL NAME: [NAME]
1 | [NAME] Room Accessibility, Grab Bars, Mirrors, Dispensers & Hardware | 6300 | 0 | 0 | 0 |  | 0 | 7 qty | 900
2 | Closers to Solid Core Wood Doors | 20700 |  | 0 | 0 | 0 | 0 | 69 qty | 300
4 | Diesel Generator 201kW and Up | 110000 | 0 |  | 0 | 0 | 0 | 250 kw | ls
17 | Replace Carpeting (corr, then 1/2 CRs over 2 years) | 28000 | 0 | 0 |  | 0 | 0 | 15361 | 4.1
18 | Replace Central Video Retrieval | 57000 | 0 | 0 |  | 0 | 0 | 38008 | 1.5
19 | Replace Ceramic Tile (in gang bath rooms) | 16000 | 0 | 0 |  | 0 | 0 | 1085 | 14.75
30 | Replace Service Sink | 3500 | 0 | 0 |  | 0 | 0 | 1 | 3500
 | Replace Single Ply Membrane Roof for BUR (Roofs D) |  | 0 |  | 0 | 0 | 0 | 15816 | 14.25
34 | Replace Solid Core Wood Doors | 33600 |  | 0 | 0 | 0 | 0 | 28 qty
37 | Service Heat and HVAC Systems | 12500 | 0 | 0 | 0 | 0 |  | 8324 | 1.5
38 | Upgrade Stair Enclosure | 25000 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0
 | SUBTOTAL "B"
 | SCHOOL NAME: William Davies Middle School
1 | Paint Interior Walls | 7000 | 0 | 0 |  | 0 | 0 | 63380 | 0.55
2 | Replace [NAME] | 21500 | 0 | 0 |  | 0 | 0 | 15622 | 4.1
 |  |  |  |  |  |  | 0
 | SUBTOTAL "C"
 | SCHOOL NAME:
1 |  | 0 | 0 | 0 | 0 | 0
 | SUBTOTAL "D"
 | SUMMARY SUBTOTALS (Subtotals A-G) :
 | PROJECT SOFT COSTS (A/E Fees, [NAME], Printing x 25%) :
 | PROJECT TOTALS:
Spreadsheet: a54fcff1-c99f-411c-b3bc-ab5b04221130
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6813 | 8061 | Winston | [NAME] | USA | 2054 | 00:40:29 | 00:04:12 | 01:50:20 | 00:02:37 | 01:32:25 | 1 | 04:10:04
Spreadsheet: 837569d1690266157-formula-sumifs-and-index-example
Sheet: Sheet3

 |  |  | Person | Dates
 |  |  | ABC | 2023-04-01 00:00:00 | 2023-04-02 00:00:00 | 2023-04-03 00:00:00 | 2023-04-04 00:00:00 | 2023-04-05 00:00:00 | 2023-04-06 00:00:00 | 2023-04-07 00:00:00 | 2023-04-08 00:00:00 |  | between dates | Person
 |  |  | ABC | 0 | 0 | 500 | 500 | 500 | 390 | 500 | 500 |  | 2023-04-01 00:00:00
 |  |  | ABC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2023-04-03 00:00:00
 |  |  | ABC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DEF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DEF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DEF | 0 | 0 | 25 | 35 | 35 | 35 | 35 | 35
 |  |  | DEF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DEF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | DEF | 0 | 0 | 25 | 35 | 35 | 35 | 35 | 35
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | GHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 845063d1696608413-problem-with-vlookup-test
Sheet: DATA CAPTURE

 |  | Linked |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  | WEEKLY DATA CAPTURE COMPLIANCE
 |  |  |  | ENTER STORE NUMBER | 352 |  |  | WEEK ENDING:
 |  | STORE | EE | STORE NAME | CASHIER ID | TRANS COUNT | [NAME] | [NAME] % WTD | [NAME] MTD | [NAME] % QTD | [NAME] YTD
Spreadsheet: 717862d1612884223-how-to-count-rows-based-on-cell-value-book1
Sheet: Sheet1

 |  |  |  |  |  |  | example | Flag | NewFlag | How Flag should be
 |  |  |  |  |  |  | ABC |  |  | 1
 |  |  |  |  |  |  | ABC |  |  | 2
 |  |  |  |  |  |  | ABC |  |  | 3 |  | 24
 |  |  |  |  |  |  | CBA |  |  | 1
 |  |  |  |  |  |  | ABC |  |  | 4 |  | 3
 |  |  |  |  |  |  | CBA |  |  | 2
 |  |  |  |  |  |  | ABC |  |  | 5
 |  |  |  |  |  |  | ABC |  |  | 6
 |  |  |  |  |  |  | CBA |  |  | 3
 |  |  |  |  |  |  | CBA
 |  |  |  |  |  |  | ABC |  |  | 7
 |  |  |  |  |  |  | ABC |  |  | 8
 |  |  |  |  |  |  | ABC |  |  | 9
 |  |  |  |  |  |  | CBA
 |  |  |  |  |  |  | CBA
 |  |  |  |  |  |  | ABC |  |  | 10
 |  |  |  |  |  |  | ABC |  |  | 11
 |  |  |  |  |  |  | ABC |  |  | 12
 |  |  |  |  |  |  | ABC |  |  | 13
 |  |  |  |  |  |  | ABC |  |  | 14
 |  |  |  |  |  |  | ABC |  |  | 15
 |  |  |  |  |  |  | ABC |  |  | 16
 |  |  |  |  |  |  | ABC |  |  | 17
 |  |  |  |  |  |  | ABC |  |  | 18
 |  |  |  |  |  |  | ABC |  |  | 19
 |  |  |  |  |  |  | ABC |  |  | 20
 |  |  |  |  |  |  | ABC |  |  | 21
 |  |  |  |  |  |  | ABC |  |  | 22
 |  |  |  |  |  |  | ABC |  |  | 23
 |  |  |  |  |  |  | ABC |  |  | 24
Spreadsheet: 164402d1340746395-add-rows-if-referenced-cells-in-another-sheet-contain-data-excel-help
Sheet: Sheet26

Job: | #N/A |  | Description: |  |  |  |  |  |  |  |  |  | Reference
Phase: |  |  | Comment: |  |  |  |  |  |  |  |  |  |  | Type: | Drawing number:
Date: | 2012-06-26 17:24:24 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Exclusions and Qualifications: |  |  |  |  |  |  |  |  |  | 2
Drawing Reference |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF/SF: | Quantities: | Connections: | Material: | Finish:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Other
Spreadsheet: 484903d1476556265-hide-switch-to-hidden-book1
Sheet: Sheet1

1
2
3 |  |  |  |  |  |  |  |  |  | Manually select even 2-20. Format - Row Hide.
4
5
6
7 |  |  |  |  |  |  |  |  |  | Result fig. 1
8
9
10
11
12
13
14
15
16
17
18
19
20
 |  |  |  |  |  |  |  |  |  | Run macro
 |  |  |  |  |  |  |  |  |  | Desired Result fig. 2
 |  |  |  |  |  |  |  |  |  | Running macro again should get fig 1.
Spreadsheet: 55106d1255210971-formula-to-count-occurrences-of-multiple-elements-within-a-string-sample-data-1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R8 | R9 | R9 | R10 | R10
 | Ref | Condition | T / F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AND |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | >0 | 0 | >0 | 0
 | 1 | a |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | OR
 | 2 | b |  | 1 | 2 |  |  |  | 2 |  | 2 |  |  |  | 6 |  |  |  |  |  | 1 | 0
 | 3 | c |  |  | 0 |  |  |  | 3 | 1 |  | 3 |  | 5 |  |  |  |  |  |  | 1 | 0
 | 4 | d |  |  | 0 |  |  |  | 4 |  |  | 3 |  |  |  |  | 8 |  |  |  | 0 | 0
 | 5 | e |  |  | 0 |  |  |  | 5 |  |  |  |  |  | 6 | 7 |  |  |  |  | 0 | 0
 | 6 | f |  | 0 | 0 |  |  |  | 6 |  | 2 |  |  | 5 |  |  |  |  |  |  | 1 | 0
 | 7 | g |  |  | 0 |  |  |  | 7 | 1 | 2 |  |  |  | 6 |  |  |  |  |  | 2 | 2
 | 8 | h |  |  | 0 |  |  |  | 8 | 1 |  | 3 |  |  |  |  |  |  |  |  | 1 | 0
 | 9 | i |  |  | 0 |  |  |  | 9 | 1 | 2 |  | 4 |  |  |  |  |  |  |  | 2 | 2
 | 10 | j |  |  | 0 |  |  |  | 10 |  |  | 3 | 4 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  | 2 |  |  |  | 11 |  |  | 3 |  |  | 6 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 12 |  | 2 |  |  |  |  |  | 8 |  |  |  | 1 | 0
 |  |  |  |  |  |  |  |  | 13 |  |  |  | 4 |  | 6 |  |  |  |  |  | 0 | 0
 |  | Type | AND | 2 |  |  |  |  | 14 |  |  |  |  |  |  |  | 8 | 9 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 15 |  |  |  | 4 |  |  |  |  |  | 10 |  | 0 | 0
 | The check boxes above are ticked and the drop down selected for AND/OR. |  |  |  |  |  |  |  | 16 |  |  | 3 |  |  |  |  |  | 9 |  |  | 0 | 0
 | The problem is finding a formula to match the reference number to the string |  |  |  |  |  |  |  | 17 |  | 2 |  | 4 |  |  |  |  |  |  |  | 1 | 0
 | in thec record list to the right. |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 7 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 19 | 1 |  |  |  |  |  |  |  | 9 |  |  | 1 | 0
 |  |  |  |  |  |  |  |  | 20 |  | 2 |  |  |  |  |  | 8 |  |  |  | 1 | 0