tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126074d1319509197-i-need-help-compiling-a-total-in-excel-from-multiple-worksheets-in-the-same-workbook-goodwill
Sheet: 5-14-2011

[NAME] |  |  | 2011-05-14 00:00:00
 | Item | Quan. | Net  Value | Gross Value
 | [NAME] | 1 | 10
 | Leather [NAME] | 2 | 10
 | [NAME] | 1 | 5
 | Caulking Gun | 3 | 8
 | Angle Levels | 2 | 10
 | [NAME] | 1 | 8
 | Belts for Sander | 18 | 6
 | Short Level | 1 | 15
 | Grid Ceiling Punch NEW | 1 | 50
 | Shot Lights | 2 | 20
 | Wallboard Sanding Block | 1 | 15
 | Steel Wool | 3 | 7
 | [NAME] | 1 | 25
 | Bungy Cords | 10 | 3
 | Drawer File Adapters | 8 | 2
 | Hammer | 3 | 5
 | CD Radio | 1 | 25
 | Lincoln Cents Partial Set Old | 1 | 20
 | Specialty Bits for Rosetts | 2 | 50
 | [NAME] | 35 | 4
 | Hole Saw Parts | 7 | 6
 | [NAME] | 2 | 5
 | [NAME] | 1 | 35
 | [NAME] template | 1 | 15
 | [NAME] | 1 | 10
 | Paint Mixer Paddle | 1 | 15
 | Sanding Blocks | 2 | 3
 | Steel Wire | 1 | 3
 | Elastic Auto Net | 1 | 5
 | [NAME] | 1 | 5
 | Caulking Tubes | 16 | 4
 | [NAME] | 2 | 4
 | [NAME] | 1 | 50
 | Blades for 10" | 10 | 5
 | Tool Box Plastic | 1 | 15
 | Paint Mate Painter | 1 | 40
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 16

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 16  - First Game is Saturday @ 9:30 a.m.
 |  | Visitor |  |  |  | Home
Saturday, December 22
 |  | [NAME] |  |  |  | New England Patriots
 |  | Philadelphia Eagles |  |  |  | San Francisco 49er's
 |  | Tennessee Titans |  |  |  | Oakland Raiders
Sunday, December 23
 |  | Buffalo Bills |  |  |  | Atlanta Falcons
 |  | [NAME] |  |  |  | Green Bay Packers
 |  | San Diego Chargers |  |  |  | Kansas City Chiefs
 |  | [NAME] |  |  |  | New York Giants
 |  | Detroit Lions |  |  |  | Pittsburgh Steelers
 |  | New Orleans Saints |  |  |  | Tampa Bay Buccaneers
 |  | Chicago Bears |  |  |  | Washington Redskins
 |  | St. Louis Rams |  |  |  | Carolina Panthers
 |  | Cincinnati Bengals |  |  |  | Baltimore Ravens
 |  | Dallas Cowboys |  |  |  | Arizona Cardinals
 |  | [NAME] |  |  |  | Minnesota Vikings
 |  | New York Jets |  |  |  | Indianapolis Colts
Tiebreaker |  |  |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | Denver Broncos
Spreadsheet: 133029d1324101960-formula-help-not-even-sure-what-to-call-this-min-help-practice-sheet
Sheet: Payroll and Invoices

[NAME] | Client | Service | Rate | Start | Finish | Hours | Wages | Parking | Materials | Total |  | Blacks | Services | Rate | Hours | Total |  | McDowels | Services | Rate | Hours | Total
Day 1 | Blacks | Painting | 16 | 08:00:00 | 16:30:00 |  |  | 6 | 0 |  |  |  | Painting |  |  |  |  |  | Painting
Day 2 | Blacks | Painting | 16 | 08:00:00 | 16:30:00 |  |  | 6 | 0 |  |  |  | Clean Up |  |  |  |  |  | Clean Up
Day 3 | Blacks | Clean up | 13 | 08:00:00 | 12:00:00 |  |  | 6 | 0 |  |  |  | Plumbing |  |  |  |  |  | Plumbing
Day 4 | Meyers | Clean up | 13 | 08:00:00 | 17:30:00 |  |  | 6 | 0 |  |  |  | Finish Carpentry |  |  |  |  |  | Finish Carpentry
 |  |  |  |  |  |  |  |  |  |  |  |  | Parking |  |  |  |  |  | Parking
 |  |  |  |  |  |  |  |  |  |  |  |  | Materials |  |  |  |  |  | Materials
[NAME] | Client | Service | Rate | Start | Finish | Hours | Wages | Parking | Materials | Total
Day 1 | Blacks | Plumbing | 20 | 08:00:00 | 17:00:00 |  |  | 0 | 125
Day 2 | Blacks | Plumbing | 20 | 08:00:00 | 14:00:00 |  |  | 0 | 0
Day 2 | Meyers | Plumbing | 20 | 14:00:00 | 18:00:00 |  |  | 0 | 60
Day 3 | Meyers | Plumbing | 20 | 14:00:00 | 18:00:00 |  |  | 12 | 0 |  |  | Meyers | Services | Rate | Hours | Total
Day 4 | McDowels | Plumbing | 20 | 07:00:00 | 15:00:00 |  |  | 0 | 0 |  |  |  | Painting |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Clean Up
 |  |  |  |  |  |  |  |  |  |  |  |  | Plumbing
[NAME] | Client | Service | Rate | Start | Finish | Hours | Wages | Parking | Materials | Total |  |  | Finish Carpentry
Day 1 | McDowels | Finish Carpentry | 20 | 07:00:00 | 17:00:00 |  |  | 0 | 0 |  |  |  | Parking
Day 2 | McDowels | Finish Carpentry | 20 | 07:00:00 | 15:00:00 |  |  | 0 | 160 |  |  |  | Materials
Day 2 | McDowels | Plumbing | 25 | 15:00:00 | 17:30:00 |  |  | 0 | 0
Day 3 | Meyers | Finish Carpentry | 20 | 07:00:00 | 15:00:00 |  |  | 0 | 0
Day 4 | Blacks | Finish Carpentry | 20 | 07:00:00 | 15:00:00 |  |  | 0 | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Services | Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Painting | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clean Up | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plumbing | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finish Carpentry | 54
Spreadsheet: 798125d1664311699-how-extract-brands-from-text-glenn
Sheet: Sheet1

[NAME]
DB
INTER CARS
PEUGEOT
SOLARIS
IMNASA
[NAME]
OEM
[NAME],
FIAT
[NAME]
MERCEDES
LPR
BOSCH
TEDGUM
SACHS
MICHELIN DOT20,
[NAME]
ELRING
OE CLAAS
K-DIESEL
[NAME]
MAGNUM TECHNOLOGY
IDEAL
SMAT NORD
SASIC
NGK
KORMORAN SUV
PHILIPS
MOTIP
BLIC
PIUSI
KORMORAN
HETMAN
VIP KOMPLET
MICHELIN
MICHELIN E
AKUSAN
STABILUS
ATT NUSSBAUM
WP
CARGOPARTS
QUICK BRAKE
MAHLE 89
PNEUTRON
TLT
MAHLE 89,9
FROGUM
MAHLE
MAHLE 88
MAHLE 88,5
KLEBER
VIGNAL
HATTAT
KOREA
MAHLE 87
KNIPEX
MAHLE 82
MAHLE 83
PNEUMATICS
JC AUTO
ABUS
AJUSA
ATHENA
DEPO
SKODA
FMIC
MAHLE 90,9
HANS PRIES
KROSNO
[NAME]
VICMA
S-TR
THERMOTEC
PACOL
WSM
SERTPLAS
VALEO
MICHELIN [3500]
HALDEX
MICHELIN [3853]
MAHLE 63,5
MAHLE 66,5
WESEM
YAMATO
IDEAL PRZYCISK
SPARCO
MICHELIN [004958]
TRUCKLIGHT
FORTUNE LINE
ARIETE
MAHLE 92,9
SEPAR
[NAME]
DB OE
[NAME]
TEDGUM PODPORA
SPAL
TECNOSEAL
BFGOODRICH
MAMMOOTH
TAURUS
[NAME]
MAHLE 84
KORMORAN DOT16,
MICHELIN [009349]
MAHLE 70
MAHLE 70,8
MAHLE 94,4
MAHLE 94,8
AGCO
SPARCO TEAMWORK
WAS
VAN WEZEL
CMG
CMG CMG
CMG SBP
VOITH
MAHLE 69,6
FEBI
VADEN ORIGINAL
LINEX
OE GERMANY
EBS
HOT RODS
[NAME]
LEMA
ENGITECH
MAHLE 72
BTA
ADRIAUTO
4MAX
BLAU
ASMET
Spreadsheet: 154322d1336383072-sum-formulae-sample-data-2-
Sheet: output

Row Labels | Sum of Rev Trg. Jan 2012 | Sum of Rev Act. Jan 2012 | Sum of Rev. Trg. Feb 2012 | Sum of Rev. Act. Feb 2012 | Sum of Rev. Tar.Mar 2012 | Sum of Rev. Act. Mar 2012
AAA | 16449080 | 17052630 | 16449080 | 10788760 | 17304080 | 16675665
BBB | 18695363.2728 | 19788183.0294 | 20471477.1912 | 23597659.3293 | 22142194.56 | 23762152.44
CCC | 1220410.8 | 1013027.06 | 1222678.8 | 2647425.7575 | 1224720 | 2083077
DDD | 4394686 | 3258334.62 | 4402746 | 3275896.77 | 4410000 | 3331746
EEE | 678006 | 401551.744 | 679266 | 349164.288 | 680400 | 1743163.2
FFF | 1278525.6 | 1122342.075 | 1280901.6 | 1753658.8758 | 1283040 | 1136329.02
GGG | 0 |  | 0 | 0 | 0
HHH | 0 |  | 0 | 0 | 0
III | 0 |  | 0 | 0 | 0
JJJ | 0 |  | 0 | 0 | 0
KKK | 0 |  | 0 | 0 | 0
LLL | 0 |  | 0 | 0 | 0
MMM | 0 |  | 0 | 0 | 0
NNN | 585000 | 279425 | 585000 | 508200 | 585000 | 589800
OOO | 117000 | 134750 | 117000 | 0 | 117000 | 210000
Others | 0 |  | 0 | 0 | 0
Grand Total | 43418071.6728 | 43050243.5284 | 45208149.59119999 | 42920765.02060001 | 47746434.56 | 49531932.66
Customer | [NAME]. Jan 2012 | Rev Act. Jan 2012 | Trg. Feb 2012 | Act. Feb 2012 | Tar.Mar 2012 | Act. Mar 2012
AAA
BBB
CCC
DDD
EEE
FFF
GGG
HHH
III
JJJ
KKK
LLL
MMM
NNN
OOO
Others
Spreadsheet: 890a6a40-dd9b-4123-91be-c37a6f61c985
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38840817 | 2013-12-05 07:40:15 | AXIS | 1 | 10 | 5 | 920519 | robertn1 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 267932d1380296320-need-excel-2010-pivot-table-with-running-totals-that-reset-to-baseline-test2-requisitions
Sheet: PIVOT

 |  | Values
VENDOR NAME | REQUISITION # | Sum of AMOUNT | Running total
BRADLEY | 58930 | 4334.15 | 4334.15
 | 61152 | 178128 | 182462.15
 | 62236 | 3375 | 185837.15
 | 62237 | 78128 | 263965.15 | <-- reset back to zero here
 | 62257 | 4563.74 | 268528.89
BRADLEY Total |  | 268528.89
Cannon | 61164 | 74250 | 74250
Cannon Total |  | 74250
DELTA | 61159 | 6900 | 6900
 | 61161 | 12500 | 19400
DELTA Total |  | 19400
EMERY | 58933 | 100000 | 100000
 | 58934 | 320000 | 420000 | <-- reset back to zero here
 | 61150 | 15821.58 | 435821.58
 | 61151 | 8500 | 444321.58
 | 61156 | 249018 | 693339.5800000001 | <-- reset back to zero here
 | 61654 | 381489 | 1074828.58
 | 62251 | 81120.51 | 1155949.09
 | 62614 | 75000 | 1230949.09
EMERY Total |  | 1230949.09
GREENHOUSE | 58951 | 31048.4 | 31048.4
 | 61154 | 1077 | 32125.4
 | 61653 | 86541.25 | 118666.65
 | 61659 | 1515.2 | 120181.85
 | 62030 | 14323.86 | 134505.71
 | 62250 | 117322.57 | 251828.28 | <-- reset back to zero here
GREENHOUSE Total |  | 251828.28
Keystone | 62613 | 56270 | 56270
Keystone Total |  | 56270
LINDEL | 58938 | 26950 | 26950
 | 59254 | 4454 | 31404
LINDEL Total |  | 31404
Multivista | 62239 | 16303 | 16303
Multivista Total |  | 16303
NANCY | 58935 | 57000 | 57000
NANCY Total |  | 57000
Parson | 61163 | 13997.44 | 13997.44
 | 62248 | 4381.43 | 18378.87
Parson Total |  | 18378.87
WINTER | 58942 | 1581 | 1581
WINTER Total |  | 1581
HARRISON | 58936 | 100000 | 100000
 | 61158 | 100000 | 200000
 | 62615 | 100000 | 300000 | <-- reset back to zero here
 | 62616 | 100000 | 400000
HARRISON Total |  | 400000
Spreadsheet: 96804d1296076837-trend-formula-book2
Sheet: Sheet1

Base Station | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
WB Police | 0 | 0 | 0 | 1.18 | 0 | 0 | 0 | 0 | 0.03 | 0 | 0.03 | 0 | 0 | 0.03 | 0 | 0 | 0 | 0 | 0 | 0.06 | 0 | 0.02 | 0.03
Red Bay | 0.36 | 0.46 | 0.34 | 1.78 | 0.54 | 0.44 | 0.57 | 0.45 | 0.57 | 0.35 | 0.02 | 0.06 | 0 | 0 | 0.03 | 0.05 | 0.11 | 0 | 0.03 | 0.03 | 0.13 | 0.06 | 0.05
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52
WB Police
Red Bay
Spreadsheet: 794640d1662178366-need-more-solutions-for-slow-calculations-solutions-for-faster-calculation-hd
Sheet: Sheet1

 | Return to single specific value according to the specific items
 |  |  |  |  |  |  |  |  | tomatoes | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | fruit | fruit | fruit
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums |  |  |  | Solution 1
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes |  |  |  | ([NAME]: no need array formula CLRL+Shift+Enter)
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit |  |  |  | (Cons: take so long time in calculation if the data is big)
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-numbers
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes
 | 2015-05-10 00:00:00 | 12 | tomatoes | tomatoes | watermelons | tomatoes
Spreadsheet: 81915d1282037633-how-to-add-a-counter-on-a-spreadsheet-goods-transfer
Sheet: Goods transfer

Goods return
Date issued: | [NAME]/dd/yyyy
 |  | Reference code: |  |  | Auto #
Product Description |  | Product Code | Bay Location | QTY | Reference Code
Item condition
New |  | Opened | Used
Transfer type
Inventory for new sale event |  | New sale | Gift |  | Other
Transfer to:
Sale event |  | Customer | Other
Transfer Details
Company Name:
Contact Name:
Sales ID#:
Invoice #:
Item(s) checked by:
Name: |  | Signature: |  | Date:
Stock Inventory adjusted by:
Name: |  | Signature: |  | Date:
Spreadsheet: 833322d1686905831-countifs-within-date-ranges-correctedmeds_visits
Sheet: Sheet1

Sheet 1 Visit Data
Id | START | STOP | PATIENT | PROVIDER | ENCOUNTERCLASS | CODE | [NAME] | COST | REASONCODE | REASONDESCRIPTION | Column that counts the total number of drugs patient had when on visit start date |  | Row in sheet2 | Start (from sheet2)
b48c6a2c-5ad0-45e7-803f-1778c80a1fb5 | 2010-10-04 14:50:32 | 2010-10-10 19:08:02 | 871 | fc63d100-1b79-3246-bb97-d770c4bcf7e4 | emergency | 50849002 | Emergency Room Admission | 105.37 | 55680006 | heart attack | 1
7b4fe71c-f1f6-4072-b3be-87dcde4f4320 | 2000-08-22 06:31:11 | 2000-08-29 11:35:21 | 872 | 22992079-6dff-36ba-8df6-77b90d8ea32f | emergency | 50849002 | Emergency Room Admission | 105.37 | 55680006 | heart attack | 1
993ce68c-5512-4d35-8e3c-9b8d1dde12af | 2000-09-09 10:16:10 | 2000-09-13 08:24:57 | 873 | c379d77c-0781-34a7-a519-ac996bdebf69 | emergency | 50849002 | Emergency Room Admission | 105.37 | 55680006 | heart attack | 1
Sheet 2 Medication Data
STARTED Taking Drug | STOPPED Taking Drug | PATIENT |  | CODE | [NAME] | COST | DISPENSES
2015-08-12 00:00:00 | NA | 871 |  | 746030 | Atenolol 50 MG / Chlorthalidone 25 MG Oral Tablet
1981-08-12 00:00:00 | NA | 871 |  | 1049630 | diphenhydrAMINE Hydrochloride 25 MG Oral Tablet
2010-10-03 00:00:00 | 2010-10-10 00:00:00 | 872 |  | 562251 | Amoxicillin 250 MG / Clavulanate 125 MG Oral Tablet
2012-04-29 00:00:00 | 2012-05-13 00:00:00 | 872 |  | 1043400 | Acetaminophen 21.7 MG/ML / Dextromethorphan Hydrobromide 1 MG/ML / doxylamine succinate 0.417 MG/ML Oral Solution
2000-07-20 00:00:00 | 2000-08-22 00:00:00 | 873 |  | 835900 | cycloSPORINE 50 MG Oral Capsule
2016-07-20 00:00:00 | 2016-08-10 00:00:00 | 871 |  | 106258 | Hydrocortisone 10 MG/ML Topical Cream
2011-04-19 00:00:00 | 2012-04-13 00:00:00 | 871 |  | 748962 | Camila 28 Day Pack
1994-12-10 00:00:00 | 2015-12-05 00:00:00 | 873 |  | 748879 | [NAME]
2000-08-21 00:00:00 | 2000-08-29 00:00:00 | 872 |  | 1605257 | Liletta 52 MG Intrauterine System
Spreadsheet: 59581d1260191462-vlookup-multiple-cells-and-return-the-first-cell-for-excel-forum
Sheet: Sheet1

 |  |  |  | profile class
master tariff type | supplier one tariff | supplier three tariff | supplier two tariff | profile class |  |  |  |  | search for | day/night | in columns B to D
base | single unit | base rate | base | 3 | 4 |  |  |  | and | 6 | in columns E to H
two rate | flexi two | day/night | two rate | 3 | 4
three rate | flexi 3 | 3 rate | three rate | 3 | 4 |  |  |  | returns | md two rate | From column A
[NAME] | [NAME] single | single md price | [NAME] | 5 | 6 | 7 | 8
md two rate | [NAME] two | day/night | md two rate | 5 | 6 | 7 | 8
md three rate | [NAME] | triple md price | md three rate | 5 | 6 | 7 | 8
nightsaver | economy 7 | night user | nightsaver | 3 | 4
RHT | Restricted | rht | RHT | 3 | 4
domestic | one rate domestic | single domestic | domestic | 1
domestic 2 rate | two rate domestic | dual domestic | domestic 2 rate | 2
what I need is a formula that will search B1 to H12 and return the result from column A the profile class is a qualifier for the tariff name in column A ie if the profile is over 4 then the tariff name normally has MD / [NAME] demand in the title. I have more suppliers to add to the list so the formula needs to be expandable.
Spreadsheet: 730709d1619866118-group-countif-formula-with-multiple-conditions-suneesh
Sheet: Sheet1

TABLE-1 |  |  |  |  |  |  | TABLE-2 |  |  |  |  |  |  |  |  | Answer should be
Item | A | B | C | D | E |  | Item | A | B | C | D | E |  |  |  |  | No. of Item | Valid count | Compliance %
AA | M |  |  |  | M |  | AA | 2022-01-15 00:00:00 |  |  | 2022-01-05 00:00:00 | 2022-02-04 00:00:00 |  |  |  | A
AB |  | M |  |  |  |  | AB |  | 2020-12-31 00:00:00 |  |  |  |  |  |  | B
AC |  |  | M |  |  |  | AC | 2023-01-15 00:00:00 |  | 2022-01-15 00:00:00 |  |  |  |  |  | C
AD |  |  |  | M |  |  | AD |  |  |  | 2020-12-31 00:00:00 |  |  |  |  | D
AE | M |  |  |  | M |  | AE | 2022-05-01 00:00:00 |  |  |  | 2022-01-15 00:00:00 |  |  |  | E
AG |  |  | M |  |  |  | AG |  |  | 2022-05-01 00:00:00
AH |  |  |  | M |  |  | AH |  | 2022-06-05 00:00:00 |  | 2022-05-01 00:00:00
BA |  |  | M |  |  |  | BA |  |  | 2020-01-01 00:00:00 |  |  |  |  | Conditions
BB | M |  |  |  |  |  | BB | 2023-04-06 00:00:00 |  |  |  |  |  |  | 1 | I have to count dates based against the Item
BC |  |  |  |  | M |  | BC |  |  |  |  | 2023-04-06 00:00:00 |  |  | 2 | I have to count only the cells which are having dates and is  greater than today
BD |  | M |  |  |  |  | BD |  | 2020-01-01 00:00:00 |  |  |  |  |  | 3 | Count if only if the second table matches with the first table criteria (M)
BE |  | M |  |  |  |  | BE |  | 2022-01-01 00:00:00 | 2023-03-04 00:00:00
BG |  |  |  | M |  |  | BG |  |  |  | 2022-01-01 00:00:00 | 2023-08-17 00:00:00
BH | M |  |  |  |  |  | BH | 2022-01-01 00:00:00
CG |  | M |  |  |  |  | CG |  | 2023-04-06 00:00:00
CF |  |  |  | M | M |  | CF |  |  |  |  | 2023-04-06 00:00:00
CH |  |  | M |  |  |  | CH |  |  | 2022-01-15 00:00:00
CO | M |  |  |  | M |  | CO | 2020-12-31 00:00:00 |  |  |  | 2022-05-01 00:00:00
 | Legend : M - Mandatory
Spreadsheet: 683411d1592722764-return-cells-in-column-that-match-criteria-blank-and-empty-cells
Sheet: Sheet1

 |  |  |  | Current Array - Incorrect Values and Zeros |  |  |  |  | What I Want
 | Text | Test1 |  |  |  |  |  |  | Test1
 | [NAME] of ="" |  |  |  |  |  |  |  | Test2
 | Text | Test2 |  |  |  |  |  |  | Test3
 | Empty cell
 | Text | Test3
Spreadsheet: 219736d1362925351-cross-reference-coumns-that-contain-specific-text-and-count-them-up-count_dthomas-ver1
Sheet: Sheet1

Red | 2 |  |  |  |  | RED | 2
green | 2 |  |  |  |  | RED | 4
green | 4 |  |  |  |  | GREEN | 2
red | 2 |  |  |  |  | GREEN | 4
red | 4
Spreadsheet: 113418d1309339001-refer-to-cell-on-another-sheet-test
Sheet: Sheet2

TEST1 | 33
TEST2 | 32
TEST3 | 13
TEST4 | 14
TEST5 | 73
TEST6 | 80
TEST7 | 65
TEST8 | 73
TEST9 | 33
TEST10 | 48
TEST11 | 24
TEST12 | 10
TEST13 | 35
TEST14 | 66
TEST15 | 78
TEST16 | 21
TEST17 | 37
TEST18 | 40
TEST19 | 81
Spreadsheet: 453317d1459268388-help-with-lookup-or-match-formula-zeszyt1
Sheet: Arkusz2

Sord | Pcode |  | Net
2 | 114 |  | 1
2 | 114 |  | 2
3 | 113 |  | 3
4 | 113 |  | 4
2 | 112 |  | 5
2 | 111 |  | 6
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: bb

Basil. Greg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 742253d1627626036-help-with-vlookup-across-different-sheets-based-on-criteria-sen-pon-help
Sheet: Y

 | Name of children | Year group | Hours of Support | LSA to ffer support | Difficulties
Spreadsheet: 187283d1350398820-how-can-i-filter-information-across-multiple-columns-without-removing-required-data-personnel-test
Sheet: Sheet1

EVENT SCHEDULE
Date | Start | End | Venue | Event | Activity | Personnel | Personnel | Personnel | Personnel | Personnel | Personnel | Supplier | Location - Pick Up
Monday 4th June
2012-07-13 00:00:00 | 07:30:00 |  | Venue 3 | Show 1 | [NAME] | [NAME] |  |  |  |  |  | QMF GT | Brisbane Domestic Airport
2012-07-13 00:00:00 |  |  | Venue 3 | Show 1 | Check In | [NAME] |  |  |  |  |  | Accom 1
2012-07-14 00:00:00 | 08:00:00 | 09:00:00 | Venue 1 | Show 2 | Bump In | [NAME] | [NAME] |  |  |  |  | Norwest
2012-07-14 00:00:00 | 08:00:00 | 09:00:00 | Venue 1 | Show 2 | Tech | [NAME] | [NAME] |  |  |  |  | Norwest
2012-07-15 00:00:00 | 10:00:00 | 11:00:00 | Venue 2 | Show 3 | Performance | [NAME] | [NAME] |  |  |  |  | Southern Cross Soloists
2012-07-15 00:00:00 | 10:00:00 | 11:00:00 | Venue 2 | Show 3 | Performance | [NAME] |  |  |  |  |  | Southern Cross Soloists
2012-07-16 00:00:00 | 11:00:00 | 13:00:00 | Venue 3 | Show 1 | Performance |  |  |  |  |  |  | [NAME]'s Circus
2012-07-16 00:00:00 | 11:00:00 | 13:00:00 | Venue 3 | Show 1 | Performance |  |  |  |  |  |  | [NAME]'s Circus
2012-07-17 00:00:00 | 12:00:00 | 14:00:00 | Venue 4 | Show 4 | Accommodation |  |  |  |  |  |  | Accom 2
2012-07-17 00:00:00 | 12:30:00 |  | Venue 2 | Show 3 | Delivery - Flowers |  |  |  |  |  |  | Flowerman
2012-07-17 00:00:00 | 13:00:00 |  | Venue 2 | Show 3 | Delivery - Catering |  |  |  |  |  |  | Caterman
2012-07-17 00:00:00 | 13:00:00 | 22:00:00 | Venue 1 | Show 2 | Security Commence |  |  |  |  |  |  | CAP
2012-07-17 00:00:00 | 12:00:00 | 14:00:00 | Venue 4 | Show 4 | Accommodation |  |  |  |  |  |  | Accom 1
2012-07-18 00:00:00 | 13:00:00 | 15:00:00 | Venue 5 | Workshop 1 | Travel - Flight | [NAME] | [NAME] | [NAME] |  |  |  | QANTAS | Brisbane Domestic Airport
2012-07-18 00:00:00 | 18:00:00 | 19:00:00 | Venue 5 | Workshop 1 | Travel - Flight | [NAME] |  |  |  |  |  | QANTAS | Cairns Domestic Airport
Spreadsheet: 291563d1390331200-excel-slotting-bin-slotting1
Sheet: Sheet2

 | Model No: | Length | [NAME] | Height | Cubic FT | Range
[NAME] |  | 36 | 11.5 | 18 | 4.3 | 2-20
[NAME] |  | 14.75 | 8.25 | 7 | 0.5 | 0.5-1
Blue Bins 02 |  | 14.75 | 16.5 | 7 | 1 | 0.2-1
Blue Bins 03 |  | 18 | 16.5 | 11 | 2 | 1-2
[NAME] 01 |  | 11.625 | 3.75 | 4.625 | 0.1 | 0.0-0.1
Shelf Bins02 |  | 11.625 | 5.625 | 4.625 | 0.2 | 0.1-0.2