tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 546410d1510042227-if-a-column-contains-a-duplicate-then-fill-another-column-with-the-value-546305d1509984197-if-a-column-contains-a-duplicate-then-fill-another-column-with-the-value-auto
Sheet: Master List

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | - | - | -
Product Information |  |  |  |  |  | Testing |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Figures
PCP | Project | Syspro Code | Drawing No. | Material | Drawing | Req. | Customer (OEM) | Application (Location) | Risk Category | Test Reports |  |  |  |  |  | OOS |  | Verification Audits |  | Total 12 Months | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 0 | 12345 |  |  |  |  |  |  | Low Risk |  |  |  |  |  |  |  |  |  |  |  | 0 | 54 | 0 | 0 | 0 | 36 | 0 | 36 | 72
 | 0 | 12346 |  |  |  |  |  |  | Low Risk |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | 1 | 12347 |  |  |  |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  | 94 | 170 | 120 | 70 | 0 | 130 | 90 | 80 | 60 | 70
 | 1 | 12347 |  |  | !If this cell and the cell above are the same |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | #Then this value moves up
 | 2 | 12348 |  |  |  |  |  |  | Low Risk |  |  |  |  |  |  |  |  |  |  |  | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | 12349 |  |  |  |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  | 166 | 159 | 210 | 140 | 220 | 190 | 140 | 220 | 210 | 200
 | 3 | 12349 |  |  | !If this cell and the cell above are the same |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | #Then this value moves up
 | 4 | 12350 |  |  |  |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 5 | 12351 |  |  |  |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  | 99 | 180 | 120 | 60 | 100 | 130 | 90 | 80 | 60 | 70
 | 5 | 12351 |  |  | !If this cell and the cell above are the same |  |  |  | High Risk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | #Then this value moves up
Spreadsheet: 217558d1362102341-need-help-with-if-statement-formula-example
Sheet: Sheet2

102 | data | data | data
104 | data | data | data
106 | data | data | data
108 | data | data | data
109 | data | data | data
112 | data | data | data
114 | data | data | data
Spreadsheet: 835976d1689006756-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: Roster

First Name | Last Name | Concat
[NAME] | Suiter
Easton | [NAME]
Cade | Bradley
[NAME] | Feltes
[NAME] | [NAME]
Cooper | Mabel
Eamon | Leahy
[NAME] | Welch
[NAME] | Shere
Bo | [NAME]
[NAME] | Triggiani
Nathan | Gohring
Troy | Atwell
Spreadsheet: 774426d1648472430-highlight-column-a-if-column-e-has-data-condition-format-etaf
Sheet: Sheet1

A | B | C | D | E | F | G | H
TANADAR | DRT | AAA | N |  | s | 11970 | AAADNRT |  | Highlight column A if Column E has data
GRADATE | DRT | AAE | G |  | ds | 2848 | AADEGRT
LATERAD | DRT | AAE | L |  |  | 1668 | AADELRT
ADAPTER | DRT | AAE | P |  | s | 4817 | AADEPRT
READAPT | DRT | AAE | P | p | s | 4818 | AADEPRT
ADRATES | DRT | AAE | S |  |  | 1670 | AADERST
Spreadsheet: 48664d1247881284-excel-template-possible-for-this-jloyzaga-final-cl8-grades-dev
Sheet: Gradebook

Last Name | First Name | ENGLISH | MATH | SCIENCE | HSIE HISTORY | HSIE GEOGRAPHY | LOTE LANGUAGE | DESIGN & TECH | VISUAL ARTS | PDHPE | MUSIC
Baines | Kelsey | B | S | S | S | S | S | S | S | B | B
Barta | Bence | S | S | T | T | S | S | S | S | T | S
Cah | Aden | S | S | S | S | S | S | S | B | T | T
Cincotta | Emily | B | S | S | S | S | T | S | T | S | S
[NAME] | [NAME] | T | S | T | E | T | T | S | T | T | T
Dacey | [NAME] | S | S | T | B | S | B | T | S | S | S
Dacey | [NAME] | T | S | T | S | S | S | S | T | T | T
[NAME] | Tess | E | S | T | T | T | T | S | T | S | E
[NAME] | Callum | L | S | S | B | B | B | B | S | B | B
[NAME] | Martin | S | S | S | B | S | S | S | S | S | T
Hall | Emily | B | S | T | NEW | S | B | S | S | S | S
Jones-Hughes | Delwyn | S | S | S | B | B | B | S | B | B/S | B
Jost | [NAME] | T | S | T | E | S | E | S | T | T | B
Kamper | Olivia | T | S | T | T | S | S | S | T | T | S
Kelly | Siobhan | B | S | T | E | S | B | S | T | T | E
Lodhia | Sheena | B | B | S | L | S | B | S | S | L | S
[NAME] | [NAME] | B | S | S | S | S | S | S | T | B | S
[NAME] | [NAME] | S | S | T | S | S | S | S | S | S | S
[NAME] | [NAME] | L | S | S | B | B | B | B | B | B/S | B
O'Doherty | Alexandra | S | S | S | S | S | S | S | T | S | T
[NAME] | Hilary | T | S | T | E | S | S | S | T | T | S
Roose | [NAME] | S | S | T | S | S | B | S | S | S | S
Strijakova | Vara | E | S | S | E | S | T | E | T | S | S
[NAME] | [NAME] | T | S | T | T | S | T | S | T | S | S
Towers | Jessica | S | S | T | S | S | S | E | T | S | T
Ulich | Kristina | S | S | B | B | S | B | S | S | S | B
Walters | [NAME] | L | B | B | B | S | L | S | B | T | B
Wilde | [NAME] | B | S | S | B | S | L | S | B | S | B
[NAME] | [NAME] | S | S | NEW | NEW | S | L | S | S | S | B
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Derivatives w-o  AA

 | Derivatives Marketing
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 1222275 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 67500
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 225000 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 45000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 531 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 67500 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 90000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 1.8 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 13500 | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  | 9 | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  | 0 | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 7266cec7-752f-44ea-a403-38e0c11f9fde
Sheet: Sheet1

Supplementary Table 3: Intron conservation in the T. hominis and N. ceranae orthologues of experimentally-confirmed E. cuniculi intron-containing proteins. A dashed line means no homologue could be detected, accession numbers on white indicate the presence of a homologue but not an intron, accession numbers on grey background indicate that this homologue also contains an intron. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Gene | T. hominis | [NAME] | E. cuniculi*
L6 | orf_162 | C4V6L1 | Q8SR91
L19 | - | C4V7A7 | Q8SRP5
L27A | orf_2277 | C4V9S6 | O62581
S8 | orf_459 | C4V8F5 | Q8SWC9
S17 | orf_629 | C4VBM0 | Q8SSF9
S26 | orf_1595 | C4V966 | Q8SRN2
L39 | orf_3301 | - | [NAME]
adenylate kinase | orf_2554 | C4VB94 | Q8SVC2
Unknown3 | orf_150 | - | Q8SUP5
Unknown4 | - | C4V8X9 | Q8SU40
L11 | orf_1535 | C4VAT3 | Q8SSG9
Ubiquitin activator | orf_2535 | - | Q8STS6
pgs-a | [NAME] | C4VB87 | Q8SQW8
Vacuolar sorter | orf_1186 | C4VA14 | Q8SUV0
L5 | orf_282 | C4V9T8 | Q8SRQ3
S24 | - | C4VBK4 | Q8SR06
S6 | orf_2573 | C4V8S6 | Q8SRY0
L37 | orf_1107 | - | Q8SRH5
Sec61a | orf_2529 | - | Q8SQQ4
S3A | orf_96 | C4VBI8 | Q8SS05
s10 UTR | orf_394 | - | Q8SS17
s30 | orf_523 | - | Q8SR05
L37a | orf_1577 | C4V7T9 | [NAME]
polyA-binder | orf_860 | - | Q8STN7
*This list includes all annotated E. cuniculi intron-containing proteins, but not the 8 unannotated hypothetical proteins recently identified by [NAME], [NAME], [NAME] and Fast (2010), for which protein sequences and genomic coordinates were unavailable.
T. hominis-specific putative intron-containing ribosomal proteins: S23, [NAME], L24, L44 (see Table S2)
Spreadsheet: 17dc191f-f7e4-461f-a5ce-9391ede2df3b
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. RWM, AGRO, FSCI, ASCI) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. RWM, AGRO, FSCI, ASCI) and Number | PSY
Discipline codes:  AGEC = 0101 , AG = 0200 , AGSC = 0200 ,                 ASCI = 0202 , FSCI= 0203 , RWM = 0300   (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for AGEC 1351, ASCI 1351 = 0200                             AGEC 1331 = 0800      Honors = 0801               (4 digits)
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 83896d1283934972-excel-2007-table-summary-sample
Sheet: Summary

BILL | MARK1 | MARK2 | [NAME] | MARK4 | MARK5 | TOTAL
A
B
C
Spreadsheet: 159913d1338902128-vertical-scroll-not-working-excel-scrollnotworking
Sheet: Sheet1

 |  | SO # | Customer | Part  # | Description | Fulfillment Date | Needed | On Hand | Short | Days Till | Days Late | Priority | NCMR | Remarks
Spreadsheet: 673496d1587407903-help-with-sumifs-calculating-between-a-date-range-and-another-argument-ledger-project
Sheet: Monthly Report 

2019-10-21 00:00:00
Summery of Accounts
Name | Type | Amount
Business Account | Checking | 6604.77
Licence Plate Account | Checking | 7440
Money Market | Savings | 3001.71
Total
Income Category |  | Amount | Remarks
[NAME] by Member
Fundraising Revenue |  | 0
Product Donations |  | 0
Donations - All Others |  | 0
Motorcycle Raffle Money In |  | 0
Patch Deposit paid by Member |  | 0
[NAME] from National |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Total
Expense Category |  | Amount | Remarks | Paid
Post Office Box |  | 106 | Annual | 2019-10-15 00:00:00
Bingo |  | 60 |  | 2019-10-01 00:00:00
Checks |  | 157.91 |  | 2019-10-09 00:00:00
Total
Hoka Hey Challenge |  | Amount
[NAME] | 2 | 125
Spreadsheet: ff9da19b-35ad-4890-a894-960110793d80
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 | Enter KPI Name Here
 | Step 1:  Enter Setup Information and Budget |  |  |  |  | Step 2: Enter YTD Results |  |  |  |  |  | Step 3: Enter Goals; Press Compute Button Above ---^ |  |  |  |  |  | Non-Printing Calculations
 | Enter Budget Hurdle for this KPI |  |  |  |  |  |  |  |  |  |  | Enter [NAME] for this KPI |  |  |  |  |  |  | Calc'd Baseline --> | 0
 | Enter [NAME] (000s) |  |  |  |  |  |  |  |  |  |  | Enter Annual Runoff Rate for this KPI |  |  |  |  |  |  | Calc'd Target --> | 0
 | Budget (000s) |  |  |  |  | Actual Performance (000s) |  |  |  |  |  | Hurdle Tactical Plan (000s)
 | Month | Month End | Month Avg | [NAME] |  | Month | Month End | Month Avg | [NAME] | [NAME] |  | Month | End Bal | [NAME] | Growth | Orig |  | On/Off | Count | End | YTD/Fcst | Days/Mo
 | Begin |  |  |  |  | Begin |  |  |  |  |  | Begin
 | Jan |  |  | 0 |  | Jan |  |  |  |  |  | Jan |  | 0 | 0 | 0 |  | 1 | 1 | On | 0 | 31
 | Feb |  |  | 0 |  | Feb |  |  |  |  |  | Feb |  | 0 | 0 | 0 |  | 1 | 2 | Fcst | 0 | 29
 | Mar |  |  | 0 |  | Mar |  |  |  |  |  | Mar |  | 0 | 0 | 0 |  | 1 | 3 | Fcst | 0 | 31
 | Apr |  |  | 0 |  | Apr |  |  |  |  |  | Apr |  | 0 | 0 | 0 |  | 1 | 4 | Fcst | 0 | 30
 | May |  |  | 0 |  | May |  |  |  |  |  | May |  | 0 | 0 | 0 |  | 1 | 5 | Fcst | 0 | 31
 | Jun |  |  | 0 |  | Jun |  |  |  |  |  | Jun |  | 0 | 0 | 0 |  | 1 | 6 | Fcst | 0 | 30
 | Jul |  |  | 0 |  | Jul |  |  |  |  |  | Jul |  | 0 | 0 | 0 |  | 1 | 7 | Fcst | 0 | 31
 | Aug |  |  | 0 |  | Aug |  |  |  |  |  | Aug |  | 0 | 0 | 0 |  | 1 | 8 | Fcst | 0 | 31
 | Sep |  |  | 0 |  | Sep |  |  |  |  |  | Sep |  | 0 | 0 | 0 |  | 1 | 9 | Fcst | 0 | 30
 | Oct |  |  | 0 |  | Oct |  |  |  |  |  | Oct |  | 0 | 0 | 0 |  | 1 | 10 | Fcst | 0 | 31
 | Nov |  |  | 0 |  | Nov |  |  |  |  |  | Nov |  | 0 | 0 | 0 |  | 1 | 11 | Fcst | 0 | 30
 | Dec |  |  | 0 |  | Dec |  |  |  |  |  | Dec |  | 0 | 0 | 0 |  | 1 | 12 | Fcst | 0 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 366
 |  |  |  |  |  |  |  |  |  |  |  | Totals to Reach Goal --> |  |  | 0 | 0 |  |  | Solver Change --> | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solver Set Zero --> | 0
 |  |  |  |  |  |  |  |  |  |  |  | Monthly Activity to Reach Hurdle 0 |  |  |  |  |  |  | Calc'd [NAME] --> | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ChartMin --> | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg Originations per Month | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | # Accts/Mo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Enter [NAME] --> | 1000 | 5000 | 10000
Spreadsheet: 55049d1255117100-sumif-returning-value-when-referenced-workbook-is-closed-test
Sheet: Test

PCGPO | LOB | Product | Accounts | Consoldiated Products | WGT | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00
H1920 | BMO CAPITAL MARKETS | No Product | No Account | ADP | 1 | 78382.02297296122 | 63451.37806682851 | 70936 | 81203 | 88117 | 78888 | 89632 | 84981 | 72710 | 76530 | 61867 | 76928 | 81564 | 66612 | 86276 | 68603 | 74702 | 69186 | 73517 | 73555 | 78592 | 76258 | 93434 | 114255 | 84694 | 96184 | 70249 | 68637 | 84415 | 66878 | 71769 | 72333 | 66308 | 65620 | 76035
H1920 | BMO NESBITT BURNS | No Product | No Account | ADP | 1 | 465836 | 392294 | 533276 | 429040 | 440264 | 457890 | 459519 | 445404 | 459044 | 392967 | 340810 | 611442 | 542102 | 472984 | 597815 | 445208 | 510696 | 611283 | 546029 | 777586 | 585195 | 412634 | 558329 | 637657 | 575428 | 452146 | 600969 | 365042 | 549537 | 529609 | 464953 | 643824 | 449391 | 396671 | 370176
H1920 | BMO INVESTORLINE | No Product | No Account | ADP | 1 | 230521 | 183587 | 223290 | 231595 | 218790 | 214163 | 221774 | 191467 | 212644 | 226271 | 174321 | 255575 | 258787 | 197933 | 294554 | 224606 | 250163 | 271327 | 275662 | 284706 | 274045 | 213845 | 337604 | 413316 | 306813 | 285316 | 294557 | 281670 | 387983 | 388117 | 428432 | 406272 | 348827 | 369561 | 411426
H1920 | [NAME] PRIVATE BANKING | No Product | No Account | ADP | 1 | 13963 | 10270 | 16128 | 13366 | 11470 | 10773 | 12344 | 18928 | 21168 | 18483 | 22267 | 17315 | 19890 | 17382 | 18259 | 17329 | 14964 | 18706 | 13810 | 27314 | 18727 | 16894 | 22043 | 26595 | 25338 | 24963 | 14507 | 18136 | 16869 | 13647 | 25365 | 16174 | 16696 | 17598 | 24350
H1920 | BMO NBSL | No Product | No Account | ADP | 1 | 24 | 32 | 29 | 37 | 19 | 18 | 56 | 36 | 35 | 31 | 26 | 37 | 54 | 19 | 32 | 19 | 19 | 71 | 40 | 48 | 64 | 15 | 26 | 42 | 14 | 9 | 0 | 0 | 7 | 14 | 0 | 0 | 35 | 25 | 17
Spreadsheet: 105696d1302971371-running-totals-example
Sheet: Balance Sheet

 |  |  |  | Balance Sheet for February 2008
 |  | ASSETS |  | LIABILITIES |  |  | Members | Subs | S.O. | Cen. | Date | Dining | Guests | Gifts
 |  | Current Assets |  | Current Liabilities
 |  | Bank Account |  | Beesley's Catering |  |  | [NAME].[NAME]. [NAME]
 |  | L.O.I. Collection |  | [NAME] |  |  | Bro. [NAME]
 |  | Dining |  | Members [NAME] 2007 |  |  | Bro.[NAME]
 |  | Subs |  |  |  |  | [NAME].[NAME]
 |  | Donations |  |  |  |  | [NAME]. Derek Davies
 |  | Centenary Fund |  |  |  |  | [NAME]. [NAME]
 |  |  |  |  |  |  | [NAME]. [NAME]
 |  |  |  |  |  |  | Bro. [NAME]
 |  |  |  |  |  |  | [NAME]. [NAME]
 |  |  |  |  |  |  | Bro. [NAME]
 |  |  |  |  |  |  | Bro. [NAME]
 |  |  |  |  |  |  | Bro.[NAME]
 |  |  |  |  |  |  | [NAME].[NAME]
 |  |  |  |  |  |  | [NAME].[NAME]
 |  |  |  |  |  |  | [NAME]. [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]. [NAME]
 |  | TOTAL ASSETS |  | TOTAL LIABILITIES
 |  | Assets Over Liabilities = |  | Charity Collection= |  |  | Totals This Month
 |  | L.O.I. Total to Date |  | Charity To Date |  |  | Totals To Date
Spreadsheet: 546458d1510062144-cascading-drop-down-data-validation-lists-with-only-unique-items-remove-duplicates-breakdown-and-max-with-index
Sheet: Remove Duplicates Breakdown

 |  |  |  |  | Match No | [NAME] For Array | Frequency | [NAME] | Small | Index | Error | Remove Duplicates In One
 |  |  | Fred |  | 2 | 2 | 1 | 2
 |  |  | [NAME] |  | 3 | 3 | 2 | 3
 |  |  | [NAME] |  | 4 | 4 | 1 | 4
 |  |  | [NAME] |  | 1 | 5 | 0
 |  |  | [NAME] |  | 6 | 6 | 1 | 6
 |  |  | [NAME] |  | 3 | 7 | 0
 |  |  | [NAME] |  | 8 | 8 | 1 | 8
 |  |  | FULLY DYNAMIC
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  | <<-- First
 |  | 2 | Fred |  | 2 | 2 | 2 | 2
 |  | 3 | [NAME] |  | 3 | 3 | 3 | 3
 |  | 4 | [NAME] |  | 4 | 4 | 1 | 4 |  |  |  |  |  |  |  | <<-- Last
 |  | 5 | [NAME] |  | 1 | 5 | 0
 |  | 6 | [NAME] |  | 6 | 6 | 1 | 6
 |  | 7 | [NAME] |  | 3 | 7 | 0 |  |  |  |  |  |  |  |  | <<-- Full List
 |  | 8 | [NAME] |  | 8 | 8 | 1 | 8
 |  | 9 | [NAME] |  | 9 | 9 | 2 | 9
 |  | 10 | [NAME] |  | 1 | 10 | 0
 |  | 11 | [NAME] |  | 11 | 11 | 1 | 11
 |  | 12 | Huw |  | 12 | 12 | 1 | 12
 |  | 13 | [NAME] |  | 1 | 13 | 0
 |  | 14 | Fred |  | 2 | 14 | 0
 |  | 15 | [NAME] |  | 3 | 15 | 0
 |  | 16 | [NAME] |  | 9 | 16 | 0
 |  | 17 | [NAME] |  | 17 | 17 | 1 | 17
 |  | 18 | [NAME] |  | 1 | 18 | 0
 |  | 19 | [NAME] |  | 19 | 19 | 1 | 19
 |  | 20 | [NAME] |  | 1 | 20 | 0
 |  | 21 |  |  | #N/A | #N/A | 0
 |  | 22 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 23 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 24 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 25 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 26 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 27 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 28 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 29 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 30 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 31 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 32 |  |  | #N/A | #N/A | #N/A | #N/A
 |  | 33 |  |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 8cdd0284-21fe-4641-be38-14313ba54478
Sheet: Japan

EXPORT SALES | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Japan | this year | last year | this year | last year | this year | last year
Spreadsheet: 757877d1638483822-counting-cell-after-a-reference-point-and-restart-when-the-reference-point-is-meet-count-after-a-landmark-is-meet2
Sheet: Sheet1

 | results
 |  |  |  |  |  |  |  | Counting cell after a reference point and restart when the refference point is meet.
 |  |  |  |  |  |  |  | RF = refference point
RF | 3 |  |  |  |  |  |  | B = cells to count
 | 2
7 | 5
B | 1
B
D
B
F
RF
G
B
23
B
N
25
RF
B
R
B
10
B
B
M
B
RF
B
15
Spreadsheet: 30235d1225673276-conditional-formatting-question-match
Sheet: Sheet1

 |  | Selected Numbers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winner
 |  | 12 | 14 | 49 | 34 | 25 | 18 | 16 | 86 | 123 | 160 | 15 | 37 |  |  |  |  |  |  |  | Player1
Player1 |  | 12 | 49 | 86 | 123 | 160 | 14
Player2 |  | 23 | 38 | 53 | 68 | 83 | 98
Player3 |  | 21 | 37 | 53 | 69 | 85 | 101
Player4 |  | 49 | 25 | 28 | 31 | 34 | 37
Player5 |  | 1 | 48 | 95 | 142 | 189 | 236
Player6 |  | 4 | 47 | 90 | 133 | 176 | 219
Player7 |  | 2 | 25 | 48 | 71 | 94 | 117
Player8 |  | 5 | 26 | 47 | 68 | 89 | 110
Player9 |  | 2 | 14 | 26 | 38 | 50 | 62
Player10 |  | 4 | 13 | 22 | 31 | 40 | 49
Player11 |  | 5 | 11 | 17 | 23 | 29 | 35
Player12 |  | 12 | 15 | 18 | 21 | 24 | 27
Player13 |  | 13 | 14 | 15 | 16 | 17 | 18
Player14 |  | 14 | 22 | 30 | 38 | 46 | 54
Player15 |  | 15 | 17 | 19 | 21 | 23 | 25
Player16 |  | 16 | 19 | 22 | 25 | 28 | 31
Player17 |  | 1 | 5 | 9 | 13 | 17 | 21
Player18 |  | 4 | 9 | 14 | 19 | 24 | 29
Player19 |  | 9 | 14 | 19 | 24 | 29 | 34
Player20 |  | 21 | 36 | 51 | 66 | 81 | 96
Player21 |  | 22 | 25 | 28 | 31 | 34 | 37
Player22 |  | 23 | 55 | 87 | 119 | 151 | 183
Player23 |  | 24 | 47 | 70 | 93 | 116 | 139
Player24 |  | 25 | 29 | 33 | 37 | 41 | 45
Player25 |  | 26 | 23 | 20 | 17 | 14 | 11
Player26 |  | 36 | 55 | 74 | 93 | 112 | 131
Spreadsheet: 125977d1319453436-excel-2007-pulling-across-names-phone-numbers-addresses-sample_customer_list
Sheet: Sheet1

name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | address | pcode | telephone |  |  |  |  |  |  |  |  | contact_email
Bobbert |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bluh bluh Huge Road | 133 73R | 2222222222 |  |  |  |  |  |  |  |  | [EMAIL]
Bobbar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 y u hatin road | 133 7ER | 1110000000 |  |  |  |  |  |  |  |  | [EMAIL]
Billar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 Amazing Avenue | L33 7ER | 1111111111 |  |  |  |  |  |  |  |  | [EMAIL]