tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729909d1619438359-finding-the-most-popular-popular-sector
Sheet: Sheet1

site | Customer_Firstname | Customer_Surname | Sector | Date_Ref
[NAME] | [NAME] | Boulton | Retail Trade | 2021-01-22 00:00:00
[NAME] | [NAME] | Boulton | Retail Trade | 2021-01-22 00:00:00
[NAME] | [NAME] | [NAME] | IT & Communications | 2021-01-23 00:00:00 |  |  | most popular by month
Fulham | [NAME] | [NAME] | Public Sector | 2021-01-24 00:00:00 |  |  | 2021-01-01 00:00:00 | feb
Fulham | Enesa | Gara | IT & Communications | 2021-01-25 00:00:00 |  | fulham | IT & Communications
Fulham | Enesa | mark | IT & Communications | 2021-01-25 00:00:00 |  | [NAME] | Retail Trade
Fulham | [NAME] | Dunnett | Voluntary, Charity & Social Enterprise | 2021-02-26 00:00:00
Fulham | [NAME] | Dunnett | Voluntary, Charity & Social Enterprise | 2021-02-26 00:00:00
Fulham | Yelena | Aleksic | Arts, Entertainment & Recreation | 2021-02-27 00:00:00
Ealing | [NAME] | [NAME] | Legal, Accountancy & Consultancy Services | 2021-02-28 00:00:00
Uxbridge | Josaphat | Koko | Retail Trade | 2021-03-01 00:00:00
Fulham | Shania | Breedy | Retail Trade | 2021-03-02 00:00:00
Wembley | Duaa | Chleyah | Childcare & Child Social Work | 2021-03-22 00:00:00
Uxbridge | [NAME] | Fox | Healthcare | 2021-03-22 00:00:00
Uxbridge | Jordan | Gallagher | IT & Communications | 2021-03-22 00:00:00
Wandsworth | Mohamed | Abdulaziz | Retail Trade | 2021-03-22 00:00:00
Uxbridge | Jordan | [NAME] | Healthcare | 2021-03-22 00:00:00
[NAME] | [NAME] | Boulton | Retail Trade | 2021-03-22 00:00:00
Wembley | Alina | Dote | Public Sector | 2021-03-22 00:00:00
Wembley | [NAME] | Simpson-Black | Administration (inc Call Centres) | 2021-03-22 00:00:00
Wembley | [NAME] | Simpson-Black | Hospitality | 2021-04-01 00:00:00
Wembley | Alina | Dote | Retail Trade | 2021-04-02 00:00:00
Fulham | Shania | Breedy | Retail Trade | 2021-04-03 00:00:00
[NAME] | Erin | Haggaty | Voluntary, Charity & Social Enterprise | 2021-04-04 00:00:00
[NAME] | Erin | Haggaty | Voluntary, Charity & Social Enterprise | 2021-04-05 00:00:00
[NAME] | Erin | Haggaty | IT & Communications | 2021-04-06 00:00:00
Wandsworth | Mohamed | Abdulaziz | Wholesale Trade | 2021-04-07 00:00:00
HARLESDEN | Jordan | Groves | Childcare & Child Social Work | 2021-04-08 00:00:00
Spreadsheet: 871242d1717620756-spillable-multiplication-formula-use-spill-operator-spill-formulae-example-tms
Sheet: Sheet1

Sheet protected. No password.
Column A unlocked
Everything else unlocked
Add entries in column A
1
2 |  |  |  |  |  | 2 | 2 |  | 4
3 |  |  |  |  |  | 3 | 3 |  | 9
4 |  |  |  |  |  | 4 | 4 |  | 16
5 |  |  |  |  |  | 5 | 5 |  | 25
6 |  |  |  |  |  | 6 | 6 |  | 36
7 |  |  |  |  |  | 7 | 7 |  | 49
8 |  |  |  |  |  | 8 | 8 |  | 64
9 |  |  |  |  |  | 9 | 9 |  | 81
10 |  |  |  |  |  | 10 | 10 |  | 100
11 |  |  |  |  |  | 11 | 11 |  | 121
12 |  |  |  |  |  | 12 | 12 |  | 144
Spreadsheet: 113695d1309528691-update-formula-references-using-id-number-sample-record
Sheet: Pay Calculations

Period | Pay Period Start | Pay Period End | Hours | Pay Rate | Misc. Hours | Pay Rate 2 | Gross Wage | Federal Withholding | Social Security | Medicare | Total Tax | Net Pay | YTD Gross Income | YTD Fed. Withholding | YTD Social Security | YTD Medicare | YTD Total Taxes | YTD Net Pay | Check #
1 |  |  | 40 | 13 |  |  |  | 30 | 7 | 4
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Spreadsheet: 747423d1631494378-obtaining-values-from-pivot-table-using-if-cell-contains-text-return-value-logic-copy-pivot-table-values_if-contains
Sheet: Pivot

Pivot 1 |  |  |  |  |  |  |  |  |  | Pivot 2
Filter1 | Yes |  |  |  |  |  |  |  |  | Filter1 | Yes
 |  |  |  |  |  |  |  |  |  | Day | (Multiple Items)
 | Column Labels
 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total |  |  |  |  | Column Labels
Count of Count | 3 | 2 | 2 | 3 | 4 | 14 |  |  |  |  | 2017 | 2019 | 2021 | Grand Total
 |  |  |  |  |  |  |  |  |  | Count of Count | 1 | 1 | 1 | 3
 |  |  |  |  |  | Status | Column1 | Column2
 |  |  |  |  |  | 2017
 |  |  |  |  |  | 2018
 |  |  |  |  |  | 2019
 |  |  |  |  |  | 2020
 |  |  |  |  |  | 2021
 |  |  |  |  |  | Status | Column1 | Column2
 |  |  |  |  |  | 2017 | 3 | 1
 |  |  |  |  |  | 2018 | 2 | 0
 |  |  |  |  |  | 2019 | 2 | 1
 |  |  |  |  |  | 2020 | 3 | 0
 |  |  |  |  |  | 2021 | 4 | 1
Spreadsheet: 48289d1247523092-transposing-a-table-book10
Sheet: Original

Name: | Field | Original Tbl.
ABC | A
 | B |  | If the names are listed as in A2:A14
 | E |  | I managed to return them in A18:A23
 | C |  | and all only the first field data (B19:B24)
 | D |  | Which formula will take care of B19:F24 ?
DEF | D |  | (I prefer one formula to suit range B19:F24)
 | C |  | No Helper column nor VBA if possible
GHI | B
JKL | F
MNO | A
 | C
 | G
PQR | D
 |  |  | [NAME]. |  |  |  |  | Hand typed Requested Tbl.
Name: | Field | Field | Field | Field | Field |  |  | Name: | Field | Field | Field | Field | Field
ABC | A |  |  |  |  |  |  | ABC | A | B | E | C | D
DEF | D |  |  |  |  |  |  | DEF | D | C
GHI | B |  |  |  |  |  |  | GHI | B
JKL | F |  |  |  |  |  |  | JKL | F
MNO | A |  |  |  |  |  |  | MNO | A | C | G
PQR | D |  |  |  |  |  |  | PQR | D
Spreadsheet: 49967d1249392383-count-and-total-the-unknown-matching-data-occurences-across-multi-worksheets-dummy
Sheet: Oct

rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
rabbit | 501
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
worm | 402
Spreadsheet: 44b51791-fde2-488a-b29c-b52de76e5503
Sheet: Sheet1

Table S1: S. mansoni Infection array data arranged by fold change in expression between germ ball and day 3 schistosomulum | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
# | gene | name | fold inc | Function/location | Sj homologue
1 | Smp_124000 | MEG-14 | 111 |  | Yes
2 | Smp_166340 | Expressed protein | 70 | Predicted transmembrane
3 | Smp_059530 | Tetraspanin | 67 | Not tegument tetraspanin
4 | Smp_171190 | MEG-8.1 | 62 |  | Yes
5 | Smp_032970 | [NAME] | 54 | Ca binding, ubiquitous
6 | Smp_125320 | MEG-9 | 52 |  | Yes
7 | [NAME] | Cathepsin L cysteine protease | 50 | Likely gut
8 | Smp_163630 | MEG-4.1 | 50 | Oesophageal gland | Yes
9 | Smp_070240 | Venom allergen-like (VAL) 7 protein | 47 | Oesophageal gland | Yes
10 | Smp_075800 | [NAME] endopeptidase, Sm32 | 45 | Gut1
11 | Smp_022450 | Expressed protein | 44 | Predicted transmembrane
12 | Smp_152630 | MEG-12 | 43 |  | No
13 | Smp_139160 | Cathepsin L cysteine protease | 42 | Likely gut
14 | Smp_159810 | [NAME] | 42 | Mature egg, secreted2 | No
15 | Smp_194860 | Low molecular weight protein, LMWP | 40 | Tegument, secreted3
16 | Smp_059480 | Thioredoxin peroxidase | 37 | [NAME], gut1
17 | Smp_194910 | Expressed protein | 36 | Peptidase, likely gut
18 | Smp_085840 | MEG-4.2 | 35 |  | Yes
19 | Smp_176020 | MEG-11 | 32 |  | Yes
20 | [NAME] | MEG-3 | 29 | Schistosomulum, head [NAME] | Yes
82 | Smp_172180 | MEG-8.2 | 11 |  | Yes
 | Key
 |  | MEG transcripts
 |  | Exclusively expressed in the oesophageal gland
 |  | Likely to be expressed in the gut
 | 1, Hall et al, 2011, [NAME]. [NAME].
 | 2, [NAME] et al, 2010, Genome Research
 | 3, [NAME]-Borges et al., 2011; PLOS NTD
N.B. These are the statistically significant changes in expression level for 1043 genes; 9 of the top 20 fold increases are MEGs
Spreadsheet: 684775d1593532336-sorting-data-in-1-column-to-rows-column-to-row
Sheet: Preferred

Internal ID | Name | Display Name | Member [NAME], core | Member [NAME] quantity | Member [NAME] units type | Member item 2, Overdoos | Member [NAME] quantity | Member [NAME] units type | Member [NAME], [NAME] label | Member [NAME] quantity | Member [NAME] units type | Member [NAME], Binnendoos | Member [NAME] quantity | Member [NAME] units type | Member [NAME], ribbon quality | Member [NAME] quantity | Member Item 5 units type | Member [NAME], [NAME] | Member [NAME] 6 quantity | Member [NAME] 6 units type | Member [NAME], ET rond | Member [NAME] 7 quantity | Member [NAME] 7 units type
 |  | W4U 100  110mm x 300mm CSO, DualCore | CC110MM | 2 | piece | Productie Overdoos- D214W 380 x 325 x 310mm | 1 | piece | Box Label | 1 | piece | Productie Binnendoos 370 x 155 x 140 | 0.08333 | piece | W4U 100 | 33 | sq meter | Box Label | 1 | piece | ET-ROND | 1 | piece
 |  | W4U 100  110mm x 450mm CSI, DualCore | CC110MM | 2 | piece | Productie Overdoos- D214W 380 x 325 x 310mm | 1 | piece | Box Label | 1 | piece | Productie Binnendoos 370 x 155 x 140 | 0.11111 | piece | W4U 100 | 49.5 | sq meter | Box Label | 1 | piece | ET-ROND | 1 | piece
18396 | 100110450O2 | W4U 100  110mm x 300mm CSO, DualCore | CC110MM | 2 | piece | Productie Overdoos- D214W 380 x 325 x 310mm | 1 | piece | Box Label | 1 | piece | Productie Binnendoos 370 x 155 x 140 | 0.11111 | piece | W4U 100 | 49.5 | sq meter | Box Label | 1 | piece | ET-ROND | 1 | piece
Spreadsheet: eric_saibi__9818__Market briefs
Sheet: Sheet1

Market Brief | Tuesday, September 25
Stocks | Close | Change | % Change
DJIA | 8659.97 | 56.10999999999876 | 0.00652149151659822
DJ 15 Util. | 311.05 | -2.920000000000016 | -0.009300251616396521
NASDAQ | 1501.64 | 2.230000000000018 | 0.00148725165231659
S&P 500 | 1011.55 | 8.829999999999927 | 0.008806047550662126
Market Vols | Close | Change | % Change
AMEX (000) | 171433 | -1501 | -0.008679611875050596
NASDAQ (000) | 2183201 | 136401 | 0.06664109829978503
NYSE (000) | 1605652 | -130661 | -0.07525198509715703
Commodities | Close | Change | % Change
Crude Oil (Nov) | 21.81 | -0.2000000000000028 | -0.009086778736937884
Heating Oil (Oct) | 0.6176 | 0.007000000000000006 | 0.01146413363904357
Nat. Gas (Henry) | 1.93 | 0.02 | 0.01047120418848168
Propane (Oct) | 38.75 | -0.7999999999999972 | -0.02022756005056883
Palo Verde (Oct) | 31.5 | 0 | 0
COB (Oct) | 33 | 0 | 0
PJM (Oct) | 29.7 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 2.025 | -0.01100000000000012 | -0.005402750491159194
Canada $ | 1.571 | 0.002000000000000002 | 0.001274697259400894
Germany Dmark | 2.12 | -0.01799999999999979 | -0.008419083255378762
Euro | 0.923 | 0.006800000000000028 | 0.007421960270683287
Japan ¥en | 117.7 | 0.1000000000000085 | 0.0008503401360544943
Mexico NP | 9.49 | 0.04000000000000092 | 0.004232804232804331
[NAME] | 0.6801 | -0.003799999999999915 | -0.005556367890042279
Foreign Indices | Close | Change | % Change
Arg MerVal | 243.92 | -3.34 | -0.01350804820836368
[NAME]. | 2904.5 | 37.09999999999991 | 0.012938550603334
[NAME] | 10229.05 | -303.7800000000007 | -0.02884125159145269
Can TSE 300 | 6702.01 | 40.01000000000022 | 0.006005703992794989
Germany DAX | 4009.12 | -29.57000000000016 | -0.007321681040139294
[NAME] | 9210.06 | -74.44000000000051 | -0.008017663848349454
Japan Nikkei 225 | 9693.97 | 138.98 | 0.01454527948223908
[NAME] | 5304.38 | -20.72999999999956 | -0.003892877330233472
UK FTSE 100 | 4663.4 | 49.5 | 0.01072845098506686
Source:  Yahoo! & TradingDay.com
Spreadsheet: 153860d1336072691-conditional-formatting-shading-cells-based-on-number-2012-schedule_ir
Sheet: forecast projection

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51
 |  |  |  |  |  |  | Inventory |  | Schedule Information |  |  |  |  |  |  | January
LINE | FAMILY | MAKE | COVER | EAU | CYCLE TIME | PUMPS PER DAY | INV | W.O.H. | CARRY OVER | QTY NEEDED | RUN QTY | SET UP BEGIN | SET UP FINISH | RUN DATE | ENDING DATE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | ENDING INV | ENDING W.O.H. | MIN WEEKS | CREW | RUNS PER YEAR | RUN SIZE
8 | 1030 | 28491 |  | 27720 | 108 | 570 | -2857 |  |  |  |  |  |  | 2 | 9
8 | 1030T | 28492 |  | 3080 | 60 | 3150 | -8465 |  |  |  | 13500 | 10 | 12 | 13 | 23
8 | 4040DA | 27771 |  | 23673 | 15 | 4400 | 12593 |  |  |  | 9509 | 2 | 5 | 6 | 13
8 | 1038 RH | 11126 |  | 21114 | 15 | 4400 | 9544 |  |  |  | 4245 |  |  | 16 | 18
8 | 1038 LH | 30941 |  | 21114 | 15 | 4400 | 17245 |  | 12000
8 | 1260 | 29668 |  | 70241 | 15 | 4400 | 5877 |  | 1400
8 | 3130 | 26967 |  | 31020 | 15 | 4400 | 1095
8 | 330 | 26966 |  | 660 | 14 | 4500 | 500
6 | 6030 | 17620 |  | 2640 | 14 | 4500 | 11757
8 | 1039 RH | 11127 |  | 3120 | 14 | 4500 | 27213
8 | 1039 LH | 30943 |  | 2080 | 14 | 4500 | 7048
8 |  | 10701 |  |  | 14 | 4500 | 43574
8 |  | 10764 |  |  | 14 | 4500 | 39556 |  | 42000
8 |  | 13878 |  |  | 14 | 4500 | 6584 |  | 10000
8 |  | 14076 |  |  | 14 | 4500 | 2356
8 |  | 23098 |  |  | 14 | 4500 | 3845
8 |  | 30063 |  |  | 14 | 4500 | 262
8 |  | 30134 |  |  |  |  | 45708
8 |  | 30162 |  |  |  |  | 22796
8 |  | 30693 |  |  |  |  | 542
8 |  | 33458 |  |  |  |  | 483
8 |  | 27723 |  |  |  |  | 10591
8 |  | 27876 |  |  |  |  | 1452
8 |  | 29320 |  |  |  |  | 63872
 |  |  | 220
 |  |  | running ave | 30 day | 60 day | highest # | annual | annual adjusted
 | 1030 | 28491 | 111 | 105 | 126 | 126 |  | 27720
 | 1030T | 28492 | 10 | 14 | 10 | 14 |  | 3080
 | 4040DA | 27771 | 93 | 94 | 100 | 100 |  | 23673
 | 1038 RH | 11126 | 26 | 27 | 29 | 29 |  | 21114
 | 1038 LH | 30941 | 26 | 27 | 29 | 29 |  | 21114
 | 1260 | 29668 | 275 | 312 | 316 | 316 |  | 70241
 | 3130 | 26967 | 110 | 132 | 141 | 141 |  | 31020
 | 330 | 26966 | 3 | 3 | 2 | 3 |  | 660
 | 6030 | 17620 | 12 | 4 | 10 | 12 |  | 2640
 | 1039 RH | 11127 | 0 | 0 | 0 |  |  | 3120
 | 1039 LH | 30943 | 0 | 0 | 0 |  |  | 2080
 |  | 10701
 |  | 10764
 |  | 13878
 |  | 14076
 |  | 23098
 |  | 30063
 |  | 30134
 |  | 30162
 |  | 30693
 |  | 33458
 |  | 27723
 |  | 27876
 |  | 29320
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 20

कार्यक्रम PROGRAM |  |  | एसडब्ल्यूओ के  तलए [NAME] कार्यक्रम - िृिीर् चरण 3rd PHASE OF INDUCTION TRAINING FOR SWOs | PROGRAM CODE
 |  |  |  | IT 1053
तर्षर् समूह/ SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO IMPART TECHNOLOGY SKILLS, AND JOB KNOWLEDGE TO ENABLE     PARTICIPANTS     TO     PERFORM     THE     DUTIES EFFECTIVELY
लतक्षि समूह/TARGET GROUP |  |  | PROBATIONARY SWOs
अर्तध/DURATION |  |  | 1 WEEK (5 DAYS)
DAY | SESSION | CONTENTS
Day 1 | I | Registration, Inauguration and Ice Breaking
 | II | Motivation & Team Building
 | III & IV | Debriefing – Hindsight view of the work done in the field so far  – Opportunities, Difficulties and Successes (Experience Sharing)
Day 2 | I | Credit  Environment  &  Banks  Concerns  /  Various  types  of  Credit Facilities and Segments & Customer Need Assessment
 | II | Due Diligence of Borrowers / Guarantors / Customers & KYC/ AML with special reference to Credit Facilities
 | III | CICs / Due Diligence/ ROC Charge Valuation of Assets, Compilation of Opinion Reports (through case-study/case lets)
 | IV | Contours of Rating Models
Day 3 | I | Fundamentals of Lending, Overview of Credit Policy and Delegation of Power
 | II | Due Diligence of Borrowers / Guarantors / Customers, KYC/ AML with special reference to Credit Facilities – Reading of Credit Information Reports
 | III | Gold Loan Policy of the Bank – How to do a gold loan
 | IV | Introduction to Retail Lending Schemes of the Bank
Day 4 | I & III | Case  Studies  and  Group  Discussion  with  regard  to  processing  of Housing Loan (Ready built/Construction/Takeover/)
 | III | Education Loan Products of the Bank – Case Study
 | IV | [NAME] and Vehicle Loan – Case Study
Day 5 | I | Introduction to Agriculture Lending / Agri. Lending Policy& KCC and Animal Husbandry Loans
 | II | Motivation and Team Building
 | III | Preventive   Vigilance/Compliance   Culture   &   Official   Language guidelines
 | IV | Exit Test (100 MCQ) & Feedback
Spreadsheet: 827858d1683079756-formula-for-extracting-managers-job-title-example-for-excelforum
Sheet: Example

Employee Name | Job Title | Manager [NAME] | Manager [NAME] | Comment
[NAME] | Janitor | [NAME] | What is the formula here that will show "Building Manager"? | [NAME]'s Manager is [NAME] and [NAME]'s job title is Building Manager
[NAME] | Accountant | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Buyer | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Auditor | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Building Manager | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Secretary | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Office Manager | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | Marketing Manager | [NAME] | Repeat same type of formula to show respective employee's Manager title here
Mark | Sales Manager | [NAME] | Repeat same type of formula to show respective employee's Manager title here
[NAME] | CEO | Not Applicable | No formula needed. Not Applicable as CEO does not report to anyone
Spreadsheet: 791830d1660631147-calculate-how-many-hours-in-a-time-range-falls-within-a-predef-range-spanning-midnight-battery-time-ans-2
Sheet: Sheet1

Time | Start | End | Total Hrs | Battery Hrs | FORMULA |  |  |  |  | From | -> | 17:00:00 | (lower)
 |  |  |  |  |  |  |  |  |  | To | -> | 06:00:00 | (upper)
T1 | 17:00:00 | 23:00:00 | 6 | 6 |  |  |  |  |  | Total_Hrs | = | 13 | hrs.
T2 | 18:00:00 | 05:00:00 | 11 | 11
T4 | 00:00:00 | 23:59:00 | 24 | 13
T5 | 10:00:00 | 14:00:00 | 4 | 0
T6 | 18:00:00 | 07:00:00 | 13 | 12
T7 | 01:00:00 | 07:00:00 | 6 | 5
T8 | 14:00:00 | 20:00:00 | 6 | 3
Spreadsheet: 162488d1339931633-help-get-top-x-values-as-column-names-not-as-values-themselves-file
Sheet: Last 2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Input: | 1 |  | This table shows more than one number on the rows below. I suppose the formula is wrong or something is going wrong. But what exactly ?
 |  |  |  | [NAME] ori iese fiecare numar in ultimile 2 extrageri; practic se repeta dintr-o extragere intr-alta
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  | Nr. 1 | Nr. 2 | Nr. 3 | Nr. 4 | Nr. 5 | Nr. 6 | Nr. 7 | Nr. 8 | Nr. 9 | Nr. 10 | Nr. 11 | Nr. 12 | Nr. 13 | Nr. 14 | Nr. 15 | Nr. 16 | Nr. 17 | Nr. 18 | Nr. 19 | Nr. 20 | Nr. 21 | Nr. 22 | Nr. 23 | Nr. 24 | Nr. 25 | Nr. 26 | Nr. 27 | Nr. 28 | Nr. 29 | Nr. 30 | Nr. 31 | Nr. 32 | Nr. 33 | Nr. 34 | Nr. 35 | Nr. 36 | Nr. 37 | Nr. 38 | Nr. 39 | Nr. 40
Spreadsheet: 684979d1593640922-help-duplicating-rows-with-formulas-in-multiple-places-on-one-tab-in-a-spreadsheet-excelforum-example
Sheet: Sheet1

 | Total Members
Community group | Jun '20 | May '20 | Apr '20
Dog Lovers | 303 | 302 | 292
[NAME] | 19878 | 19878 | 19878
Makeup Enthusiasts | 3777 | 3758 | 3732
[NAME] | 4740 | 4738 | 4735
Sports Fans | 5816 | 5797 | 5753
 | Total New Members Per Month
Community group | Jun '20 | May '20 | Apr '20
Dog Lovers |  |  | -
[NAME] |  |  | -
Makeup Enthusiasts |  |  | -
[NAME] |  |  | -
Sports Fans |  |  | -
Spreadsheet: chris_germany__3017__BillingOverrun1
Sheet: OverRun

 |  |  |  | Overrun
Service Provider | TCO
Overrun Report | GreaterThan |  | 0
AdjustedAllocated | From | 04/01/2000 | To | 04/17/2000
Service Requestor | 001100-001 | Svc Req Contract |  |  | Rate Schedule |  |  | Zone | 10
Service | [NAME] | Rate |  |  |  | Capacity | Capacity
Requester | Contract | Schedule | Zone | Date | MDQ | Release | Recall | Net | Quantity | Overrun
ENRON N A | 64939 | FTS | 10 | 2000-04-16 | 2300 | 0 | 0 | 2300 | 3081 | 781
ENRON N A | 64939 | FTS | 10 | 2000-04-17 | 2300 | 0 | 0 | 2300 | 3081 | 781
 | 64939 |  |  | Total | 4600 | 0 | 0 | 4600 | 6162 | 1562
ENRON N A | 65071 | FTS | 10 | 2000-04-08 | 7429 | 436 | 0 | 6993 | 6994 | 1
ENRON N A | 65071 | FTS | 10 | 2000-04-17 | 7429 | 436 | 0 | 6993 | 6995 | 2
 | 65071 |  |  | Total | 14858 | 872 | 0 | 13986 | 13989 | 3
ENRON N A | 65108 | FTS | 10 | 2000-04-11 | 5000 | 0 | 0 | 5000 | 5062 | 62
ENRON N A | 65108 | FTS | 10 | 2000-04-15 | 5000 | 0 | 0 | 5000 | 5692 | 692
ENRON N A | 65108 | FTS | 10 | 2000-04-16 | 5000 | 0 | 0 | 5000 | 5407 | 407
 | 65108 |  |  | Total | 15000 | 0 | 0 | 15000 | 16161 | 1161
ENRON N A | 65402 | FTS | 10 | 2000-04-05 | 20000 | 0 | 0 | 20000 | 20542 | 542
 | 65402 |  |  | Total | 20000 | 0 | 0 | 20000 | 20542 | 542
ENRON N A | 66965 | SST | 10 | 2000-04-05 | 20000 | 0 | 0 | 20000 | 20697 | 697
 | 66965 |  |  | Total | 20000 | 0 | 0 | 20000 | 20697 | 697
ENRON N A | 67693 | SST | 10 | 2000-04-04 | 54327 | 0 | 0 | 54327 | 59041 | 4714
ENRON N A | 67693 | SST | 10 | 2000-04-08 | 54327 | 0 | 0 | 54327 | 61337 | 7010
ENRON N A | 67693 | SST | 10 | 2000-04-09 | 54327 | 0 | 0 | 54327 | 54593 | 266
ENRON N A | 67693 | SST | 10 | 2000-04-12 | 54327 | 0 | 0 | 54327 | 64881 | 10554
ENRON N A | 67693 | SST | 10 | 2000-04-13 | 54327 | 0 | 0 | 54327 | 54972 | 645
 | 67693 |  |  | Total | 271635 | 0 | 0 | 271635 | 294824 | 23189
ENRON N A | 67776 | FTS | 10 | 2000-04-05 | 7500 | 0 | 0 | 7500 | 7735 | 235
ENRON N A | 67776 | FTS | 10 | 2000-04-10 | 7500 | 0 | 0 | 7500 | 8046 | 546
ENRON N A | 67776 | FTS | 10 | 2000-04-11 | 7500 | 0 | 0 | 7500 | 8138 | 638
 | 67776 |  |  | Total | 22500 | 0 | 0 | 22500 | 23919 | 1419
Spreadsheet: 784447d1655737220-formula-for-2nd-half-points-scored-game-scores
Sheet: Sheet2

Name | [NAME] | How Many games more than 1 second half point scored
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 877924d1724855826-date-formula-world-rating-082824
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Text to Columns-->Next--->Next-->Date-->yyyy.mm.dd-->Finish
 | Rank | Name | Country | Rating | Games | Last Played
 | 1 | [NAME] | New Zealand | 2133 | 4123 | 2024-05-11 00:00:00
 | 2 | [NAME] | Australia | 2109 | 1531 | 2024-06-08 00:00:00
 | 3 | Brett Smitheram | England | 2064 | 594 | 2024-05-06 00:00:00
 | 4 | [NAME] | United States | 2055 | 149 | 2024-07-24 00:00:00
 | 5 | [NAME] | Canada | 2048 | 1127 | 2024-07-07 00:00:00
 | 6 | [NAME] | Nigeria | 2046 | 711 | 2024-08-25 00:00:00
 | 7 | [NAME] | Singapore | 2045 | 1760 | 2024-08-03 00:00:00
 | 8 | Jesse Day | United States | 2037 | 866 | 2024-07-31 00:00:00
 | 9 | [NAME] | Nigeria | 2035 | 264 | 2024-07-19 00:00:00
 | 10 | [NAME] | United States | 2024 | 737 | 2024-07-25 00:00:00
Spreadsheet: 78449d1278810875-using-a-list-box-to-perform-lookups-on-a-table-archery_example-1-
Sheet: Archery HC

 |  |  |  |  |  |  |  |  | Input Range |  | Cell Link
 |  |  |  | Round A | Round B | Round C | Handicap |  | Round A |  | 1
 | Score | Round |  | 507 | 513 | 520 | 33 |  | Round B
 | 520 | Round C |  | 512 | 516 | 528 | 32 |  | Round C
 |  |  |  | 516 | 520 | 536 | 31
 |  |  |  | 519 | 523 | 542 | 30
 |  |  |  | 523 | 526 | 549 | 29
 | Handicap |  |  | Handicaps
 | 33 |  |  | A score of 520 results in a 30 Handicap on Round A (rounded down to the next highest handicap)
 |  |  |  | A score of 520 results in a 31 Handicap on Round B
 |  |  |  | A score of 520 results in a 33 Handicap on Round C