tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839799d1692227784-odd-irr-dates-2-98023e-09-result-irr-sample
Sheet: Sheet1

 |  | XIRR method |  |  |  |  | NPV validation
 |  | Dates | Cash Flow | IRR |  |  | Period | Discounted CF | Check
 |  | 2023-01-31 00:00:00 | 11787.91666666667 |  |  |  | 1
 |  | 2023-02-28 00:00:00 | 11787.91666666667 |  |  |  | 2
 |  | 2023-03-31 00:00:00 | 11787.91666666667 |  |  |  | 3
 |  | 2023-04-30 00:00:00 | 11787.91666666667 |  |  |  | 4
 |  | 2023-05-31 00:00:00 | 11787.91666666667 |  |  |  | 5
 |  | 2023-06-30 00:00:00 | 11787.91666666667 |  |  |  | 6
 |  | 2023-07-31 00:00:00 | 11787.91666666667 |  |  |  | 7
 |  | 2023-08-01 00:00:00 | -130000 |  |  |  | 8
 |  | 2023-08-31 00:00:00 | 11787.91666666667 |  |  |  | 9
 |  | 2023-09-30 00:00:00 | 11787.91666666667 |  |  |  | 10
 |  | 2023-10-15 00:00:00 | -13480.39733684211 |  |  |  | 11
 |  | 2023-10-31 00:00:00 | 11787.91666666667 |  |  |  | 12
 |  | 2023-11-30 00:00:00 | 11787.91666666667 |  |  |  | 13
 |  | 2023-12-31 00:00:00 | 11787.91666666667 |  | <-- IRR thru 12/31/2023 |  | 14 |  |  | <-- close enough for validation thru 12/31/2023
 |  | 2024-01-31 00:00:00 | 9166.784797894737 |  |  |  | 15
 |  | 2025-01-31 00:00:00 | 6064.032440000001 |  |  |  | 16
 |  | 2026-01-31 00:00:00 | 4265.998863157894 |  |  |  | 17
 |  | 2027-01-31 00:00:00 | 4423.998863157894 |  |  |  | 18
 |  | 2028-01-31 00:00:00 | 3123.759431578947 |  | <-- unknown IRR thru 1/31/2028 |  | 19
Spreadsheet: 779910d1652185111-sum-countif-formula-error-in-contiguous-cells-in-rows-sum-countif-formulae
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This formula calculates incorrect total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ‘=SUM(COUNTIF(E6:AG8,{"*O*","*S*"}))
 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Markwell [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Beacon [NAME]
 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Icration [NAME] |  |  |  |  |  |  |  | Markwell Ashley - S2 - GR |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] - GR
 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Icration [NAME] |  |  |  |  |  |  |  |  |  |  | OUTCOME -  should be 17
Spreadsheet: 732734d1621190947-expected-output-based-on-3-dropdowns-sample-workbook-with-multiple-criteria
Sheet: Status

 |  |  |  |  |  |  |  |  |  |  |  |  | AU Filter |  |  | Ownership Filter |  |  | Status Filter
 |  |  |  | [NAME] |  | 1st Drop Down |  |  |  |  |  |  | All |  |  | ALL |  | ALL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | All |  |  | ALL |  | ALL
 |  |  |  | Ownership |  | 2nd Drop Down |  |  |  |  |  |  |  | 0215647 |  |  | ABC |  | RNR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0213189 |  |  | DEF |  | Complete
 |  |  |  | Status |  | 3rd Drop Down |  |  |  |  |  |  |  |  |  |  | GHI |  | WNS
EXPECTED OUTCOME |  | Unique Names | Unique Names | Count | Count
 |  | Ownership | Reconciler | Status | Approved | Grand Total
Spreadsheet: 736158d1623388460-find-nth-largest-vakue-and-return-with-corrsponding-columns-sample
Sheet: yours

UNIVERSITY | Top Commission | Top Comm. EP | SLAB / Remark | Second Top | Second Top EP | SLAB / Remark | A | SLAB / Remark | B | SLAB / Remark | C | SLAB / Remark | D | SLAB / Remark | E | SLAB / Remark | F | SLAB / Remark | G | SLAB / Remark | H | SLAB / Remark
ANNA |  |  | 8+:20 |  |  | 8+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 15 | 8+:20 | 17 | 5+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 15 | 8+:20 | 17 | 5+:20
CLT |  |  | 8+:20 |  |  | 8+:20 | 13 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20 | 13 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20
UK |  |  | 8+:20 |  |  | 8+:20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: 0830 Blockwork

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0830 | Blockwork |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 8000 | 0 | 8000 |  |  |  | 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
 |  |  |  | Contract Works Sub-Total | 8000 | 0 | 8000 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0830 | Blockwork |  |  | NET TOTAL | 8000 | 0 | 8000 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 725490d1616693933-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR4

Monthly Target | 2022-01-01 00:00:00 |  |  |  |  |  | HIDE ME |  | 2022-02-01 00:00:00 |  |  |  |  |  |  | 2022-03-01 00:00:00
31150 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | 2022-01-01 00:00:00 | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  |  | 2553
TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Astro Supersport (Malaysia)

[NAME] (Malaysia)
Date | Channel | Start (Local) | End (Local) | Notes
2010-11-22 00:00:00 | [NAME] | 22:00:00 | 06:00 (23/11) | Round [NAME] (Singles)
2010-11-23 00:00:00 | [NAME] | 22:00:00 | 06:00 (24/11) | Round [NAME] (Singles)
2010-11-24 00:00:00 | [NAME] | 22:00:00 | 06:00 (25/11) | Round [NAME] (Singles)
2010-11-25 00:00:00 | [NAME] | 22:00:00 | 06:00 (26/11) | Round [NAME] (Singles)
2010-11-26 00:00:00 | [NAME] | 22:00:00 | 06:00 (27/11) | Round [NAME] (Singles)
2010-11-27 00:00:00 | [NAME] | 22:00:00 | 02:00 (28/11) | Semi-Finals - Live (Singles)
2010-11-28 00:00:00 | [NAME] | 23:30:00 | 01:30 (29/11) | [NAME]
2010-11-29 00:00:00 | [NAME] | 01:30:00 | 04:00:00 | Singles Final - Live
Spreadsheet: 05bf6076-921b-4f37-8c18-df8413c62a1f
Sheet: Sheet1

REHABILITACJA DZIECI Z ZABURZENIAMI WIEKU ROZWOJOWEGO W OŚRODKU/ODDZIALE DZIENNYM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Nazwa świadczeniodawcy | [NAME] | Ulica | Telefon
NIEPUBLICZNY ZAKŁAD OPIEKI ZDROWOTNEJ "REHABILITACJA" | [NAME] | Norwida 4 | 95 763 81 01  698 760 064
Ośrodek Wczesnej Interwencji | [NAME] | [NAME] | 95 732 03 83
Specjalistyczny Ośrodek Diagnozy       i Rehabilitacji ECHO | [NAME] | Gwiaździsta 4 | 95 720 48 21  725 00 86
"Nadzieja" Specjalistyczny Ośrodek Rehabilitacji Agnieszka Wiśniewska | Nowa Sól | ul. Sienkiewicza 37 | 668189903
[NAME] i Młodzieży Niepełnosprawnej "Promyk" SP ZOZ w [NAME] | [NAME] | Głowackiego 8a | 68 453 62 82
[NAME] i Rehabilitacja "ATOS" | [NAME] | Podgórna 13 | 68 327 15 18
Niepubliczny Zakład [NAME] Ośrodek [NAME] "Elfik" Lachowicz-Wołoszyn Grażyna | [NAME] | ul. [NAME] | 68 323 06 14
Spreadsheet: 116384d1311793371-special-lookup-formula-formula
Sheet: 26072011

LETTER |  |  | Extension |  |  |  | CODE
A | 79 | 0 | 6509 | T010030 | 2011-07-26 00:00:00 | 10:59:00 | 3181
N | 81 | 0 | T010017 | 6603 | 2011-07-26 00:00:00 | 11:00:00 | 00:00:30 | C | [PHONE]
N | 82 | 0 | T010018 | 6308 | 2011-07-26 00:00:00 | 11:00:00 | 00:00:20 | C | [PHONE]
N | 83 | 0 | 6509 | T010030 | 2011-07-26 00:00:00 | 11:00:00 | 00:00:58 | A | 960443222941707
N | 84 | 0 | T010021 | ATTN01 | 2011-07-26 00:00:00 | 11:01:00 | [NAME] | C | [PHONE]
N | 86 | 0 | T010024 | 6214 | 2011-07-26 00:00:00 | 11:01:00 | 00:00:12 | C | [PHONE]
N | 87 | 0 | 6144 | T010030 | 2011-07-26 00:00:00 | 11:01:00 | 00:00:46 | A | 96018008006890
N | 88 | 0 | 6672 | T010029 | 2011-07-26 00:00:00 | 11:01:00 | 00:01:10 | A | 96015510416566
S | 90 | 0 | T010023 | 6307 | 2011-07-26 00:00:00 | 11:01:00 | 00:00:32 | C | [PHONE]
N | 107 | 0 | T010019 | 6672 | 2011-07-26 00:00:00 | 11:01:00 | 00:02:44 | C | [PHONE]
N | 114 | 0 | T010022 | 6594 | 2011-07-26 00:00:00 | 11:01:00 | 00:05:08
N | 91 | 0 | 6185 | T010030 | 2011-07-26 00:00:00 | 11:02:00 | 00:00:06 | A | 96018008006890
N | 92 | 0 | 6144 | T010030 | 2011-07-26 00:00:00 | 11:02:00 | 00:00:16 | A | 96018008006890
N | 97 | 0 | T010027 | 6202 | 2011-07-26 00:00:00 | 11:02:00 | 00:00:56 | C | [PHONE]
A | 93 | 0 | 6602 | T010030 | 2011-07-26 00:00:00 | 11:03:00 | 0119
N | 94 | 0 | T010026 | 6642 | 2011-07-26 00:00:00 | 11:03:00 | 00:00:16 | C | [PHONE]
N | 95 | 0 | 6602 | T010030 | 2011-07-26 00:00:00 | 11:03:00 | 00:00:14 | A | 960443222942087
N | 108 | 0 | 6568 | T010027 | 2011-07-26 00:00:00 | 11:03:00 | 00:00:56 | A | 960443221050951
N | 113 | 0 | T010028 | 6211 | 2011-07-26 00:00:00 | 11:03:00 | 00:02:40 | C | [PHONE]
A | 123 | 0 | 6307 | T010029 | 2011-07-26 00:00:00 | 11:07:00 | 1846
N | 124 | 0 | T010007 | ATTN01 | 2011-07-26 00:00:00 | 11:07:00 | 00:00:04 | C | [PHONE]
N | 8 | 0 | 6307 | T010029 | 2011-07-26 00:00:00 | 11:07:00 | 00:02:44 | A | 962251300
N | 14 | 0 | 6113 | T010030 | 2011-07-26 00:00:00 | 11:07:00 | [NAME] | A | 962263600
.
I |  |  |  | 07/26 | 17:31:00
Spreadsheet: 85730d1285774728-excel-2007-generating-absence-data-747136_lraebies
Sheet: Sheet1

site_id | species | number_present |  |  | Species/Site
1 | a | 2
1 | b | 1
1 | c | 1
2 | x | 2
2 | y | 2
3 | z | 1
Spreadsheet: 740675d1626450243-partial-text-in-a-cell-as-a-lookup_value-when-using-match-test-sheet
Sheet: dados

Team | Sellers | US | CA | GB | IE | AU | NZ | IN | JP | MX | ES | AR | CO | BR | EG | SA | AE
Sales | [NAME] | US | CA | GB | IE | AU | NZ | IN | XX | XX | XX | XX | XX | XX | XX | XX | XX
Sales | [NAME] | US | CA | GB | IE | AU | NZ | IN | XX | XX | XX | XX | XX | XX | XX | XX | XX
Sales | [NAME] | US | CA | GB | IE | AU | NZ | IN | XX | XX | XX | XX | XX | XX | XX | XX | XX
Sales | [NAME] | XX | XX | XX | XX | XX | XX | XX | JP | XX | XX | XX | XX | XX | XX | XX | XX
Sales | [NAME] | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | EG | SA | AE
Sales | [NAME] | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | BR | XX | XX | XX
Sales | [NAME] | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | XX | BR | XX | XX | XX
 | Sellers | US | CA | GB | IE | AU | NZ | IN | JP | MX | ES | AR | CO | BR | EG | SA | AE
 | [NAME]
 | [NAME]
 | [NAME],[NAME]
 | [NAME]
Spreadsheet: 745813d1630247083-asset-allocation-to-a-date-period-excel-forum
Sheet: Company assignment

Code | Asset name | Company | Allocation from | Allocation until | date it should be / not available.
123456 | Big Car | Company 1 | 2020-01-01 00:00:00 |  | 2021-01-31 00:00:00
123456 | Big Car | Company 2 | 2021-02-01 00:00:00
654321 | Small Car | Company 1 | 2020-01-01 00:00:00 |  | 2020-01-31 00:00:00
654321 | Small Car | Company 3 | 2021-07-01 00:00:00
654321 | Small Car | Company 2 | 2020-02-01 00:00:00 |  | 31.06.2021
123456 | Big Car | Company 3 | 2021-04-05 00:00:00 |  | 2021-01-31 00:00:00
123456 | Big Car | Company 4 | 2021-06-06 00:00:00 |  | 2021-01-31 00:00:00
Spreadsheet: 859177d1707650940-detect-repeat-multiple-values-in-a-row-and-highlight-them-based-on-number-of-repeats-review-of-incorrect-answers
Sheet: Sheet1

 | Method
 | Level
 | Paper Code
 |  | Question Number | Correct Answer | Candidates incorrect answer |  |  |  |  |  |  |  |  |  |  | Question Number | Correct Answer | Candidates incorrect answer
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 1 | A | b | b | b | c | b | b | b | a | a | a |  | 21
 |  | 2 | B | a | a | a | a | a | a | a | a | a | a |  | 22
 |  | 3 | c | b | b | b | b | b | b | b | b | b | b |  | 23
 |  | 4 | D |  |  |  |  |  |  |  |  |  |  |  | 24
 |  | 5 | E |  |  |  |  |  |  |  |  |  |  |  | 25
 |  | 6 | A |  |  |  |  |  |  |  |  |  |  |  | 26
 |  | 7 | B |  |  |  |  |  |  |  |  |  |  |  | 27
 |  | 8 | c |  |  |  |  |  |  |  |  |  |  |  | 28
 |  | 9 | D |  |  |  |  |  |  |  |  |  |  |  | 29
 |  | 10 | E |  |  |  |  |  |  |  |  |  |  |  | 30
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  | 40
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T49

الجدول49: نسبة الذكور الى الإناث لوفيات الرضع المسجلة، 2000-2010
Table 49: Sex ratio for registered infant deaths, 2000-2010
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | البلد
Bahrain | 138.7755102040816 | 134 | 104.3478260869565 | 101.8867924528302 | 93.15068493150685 | 116.1290322580645 | 109.0909090909091 | 107.8125 | ... | ... | ... | البحرين
Egypt | 122.3322863815737 | 117.8880170235404 | 110.0410063171894 | 113.8995926456017 | 114.7928361400695 | 119.7191660081454 | 120.1861832435081 | 119.8983481575603 | 115.7012603915259 | 117.1823623640502 | 113.0528296814088 | مصر
Iraq | ... | ... | 134.7161983782764 | 136.4573110893032 | 130.6980656013457 | 135.1830879577199 | 63.79803761242846 | 175.7454430513118 | 99.58711808422791 | ... | ... | العراق
Jordan | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | الأردن
Kuwait | 136.875 | 129.5081967213115 | 116.580310880829 | 113.4715025906736 | 133.1491712707182 | 113.1979695431472 | 116.1137440758294 | 116.9082125603865 | 122.5225225225225 | 117.9856115107914 | ... | الكويت
Lebanon | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | لبنان
Oman | 125.7668711656442 | 139.2857142857143 | 135.4609929078014 | 129.4520547945206 | 131.7241379310345 | 126.6187050359712 | 129.2035398230088 | 115.4545454545455 | 119.4805194805195 | 142.2939068100358 | ... | عمان
Palestine | 107.4656188605108 | 111.5241635687732 | 112.8544423440454 | 104.9910873440285 | 110.4961832061069 | 96.46840148698885 | 123.1527093596059 | 114.9333333333333 | ... | ... | ... | فلسطين
Qatar | 109.5238095238095 | 109.4339622641509 | 143.1818181818182 | 120.9677419354839 | 113.2075471698113 | 120 | 132.6530612244898 | 95 | 123.728813559322 | 124.1379310344828 | 106.25 | قطر
Saudi Arabia | 104.8827441372069 | 106.1664587417573 | 107.4773139745917 | 108.8170055452865 | 110.1844879518072 | 111.3718755962603 | 112.4927255092144 | 114.39650029827 | 115.8367346938775 | 117.9191961482102 | ... | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | السودان
Syrian Arab Republic | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | الجمهورية العربية السورية
United Arab Emirates | 132.2222222222222 | 114.1552511415525 | 136.7875647668394 | ... | ... | 114.5922746781116 | 126.9035532994924 | 131.5789473684211 | 136.8421052631579 | 150.2369668246446 | ... | الإمارات العربية المتحدة
Yemen | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | اليمن
Spreadsheet: 35905d1233623242-excel-07-subordinate-cells-trinakria1282-1-
Sheet: Sheet1

HEADWORD | DEFINITION | PART OF SPEECH
PICCIOTTU | BOY | NOUN
PICCIOTTU | YOUNG MAN | NOUN
PICCIOTTU | YOUNG | ADJECTIVE
CHIANU | FLAT | ADJECTIVE
CHIANU | SLOW | ADVERB
CHIANU | OUTSIDE | PREPOSITION
What I'd like to do is this:
HEADWORD | PART OF SPEECH | DEFINITION
picciottu | masc. [NAME] | boy
 | masc. [NAME] | young man
 | [NAME] adjective | young
chianu | [NAME] adjective | flat
 | adverb | slow
 | preposition | outside
Of course there would be hundreds more words and defintions…
Now I would like to be able to sort column A, so that it lists these things in the current order.
But if I were to hit sort now, it would put "chianu" first, "picciottu" next, then followed by the blanks:
HEADWORD | PART OF SPEECH | DEFINITION
chianu | [NAME] adjective | flat
picciottu | masc. [NAME] | boy
 | masc. [NAME] | young man
 | [NAME] adjective | young
 | adverb | slow
 | preposition | outside
So this doesn't work for me.  And that's why I was wondering whether there was a way to subordinate
the blank rows in column A to the headword to which they correspond.
One way to do this, although more work than I had hoped, is to fill the blanks with the same headword,
as you've done in your example at the top:
HEADWORD | DEFINITION | PART OF SPEECH
PICCIOTTU | BOY | NOUN
PICCIOTTU | YOUNG MAN | NOUN
PICCIOTTU | YOUNG | ADJECTIVE
CHIANU | FLAT | ADJECTIVE
CHIANU | SLOW | ADVERB
CHIANU | OUTSIDE | PREPOSITION
However, doing this doesn't ensure that the definitions and parts of speech will be organized in the
correct way.  Doing this will only make sure the PICCIOTTUs are all together, not that the [NAME] is first,
and that the adjective is second.
This is why I started to do it this way, although I'm still not happy with this.  I wish there were some way,
as I said, to group or subordinate the blank cells to their headword.  But I've tried this:
HEADWORD | PART OF SPEECH | # | DEFINITION
picciottu | masc. [NAME] | 1 | boy
 | masc. [NAME] | 2 | young man
 | [NAME] adjective | 3 | young
chianu | [NAME] adjective | 1 | flat
 | adverb | 2 | slow
 | preposition | 3 | outside
Again, it's not ideal, because I have to number each row.  And if I decided to make additions later,
I have to figure out how to number it so that it will fit where I want it to.  But it's work thus far.
Now that you know a little bit more about what I want to do, what do you think??
THANKS!!
Spreadsheet: 45360d1244110659-same-formula-why-cant-get-the-same-answer-test
Sheet: Order for EMS

WholeSale Order Form
Customer ID: |  |  | Name: |  |  |  | Date:
Shipping Information:
Attention:
Address:
City: |  | State: |  | Zip Code: |  | Country:
Phone Number: |  |  |  | [NAME]:
 | Order No. | Product Name | Weight (kg) | Unit Price | Quantity | Total Price | Total Weight(kg)
 | 1 | iPhone 3G 16GB (BLACK) | 1 | 735.7512953367876 | 1 | 735.7512953367876 | 1
 | 2
 |  |  |  |  | Total Price: | 735.7512953367876 | 1
 | Bank Account Information |  |  |  | Country to Ship |  | Total Weight (kg)
 | Bank Name: |  |  |  | Japan |  | 1
 | Account No: |  |  |  | Price of Weight: | 168
 | Verifiy code: |  |  |  | Sum | 903.7512953367876
 |  |  |  |  | Declare Value:
Our Account Information |  |  |  |  | Type of Content: | [NAME] | Sample
Bank Name: |  | HSBC Hong Kong |  |  |  | Please delete the inapporiated option
Bank Address: |  | 1 Queen's Road Central, Hong Kong
Bank Code: |  | 004
SWIFT Address: |  | HSBCHKHHHKH
Spreadsheet: 232576d1367457415-extracting-data-from-one-worksheet-to-another-with-multiple-fields-to-populate-spreadsheet-tester
Sheet: Sheet2

CODE | NAME | ADDRESS | LOCALITY
ZAMBO | [NAME] | Settlement Rd yards on north side of road aqprox 5km from Chester Pass Rd and 13km from  [NAME]. | Napier
GSRS | Great Southern Regional Saleyard | Heading South through Mt Barker on RHS. | Mt Barker
JAMEBALD | BA & LD James | Hutton Rd | Kalgan
ROSSBEN | [NAME] | Scotsdale Rd Lot # 2436 RHS on top of hill. | Denmark
Spreadsheet: 50367d1249756075-how-to-autosum-with-functions-test-20sheet-1-
Sheet: Sheet1

Order Form
 | Date:
 | Purchase Order Number:
Code | Description | See here | Pack Size |  | Price /Unit | [NAME] | Niel | [NAME] | [NAME] | [NAME] | [NAME] | Total
TCR500 | blue centre feed (perforated) | TUB | 6 x 1 |  | 13.5 | 1 | 1 | 1 | 1 | 1 | 1
SKS03050 | 25 Litre pump |  | 1 |  | 1.48
OPTA12/S | Air  (Automatic) |  | 12 x 1 |  | 45.14
TCR3690 | [NAME] | BOX | 4 x 5 litre | £1.32/kg | 26.4 | 1 | 1 | 3 | 2 | 1 | 1
TCR560 | Aluminium [NAME] |  | 1 |  | 3.81
TCR501 | Aluminium [NAME] |  | 1 |  | 3.81
TCR560 | Aluminium [NAME] |  | 1 |  | 3.81
 |  |  |  | Totals
 |  |  |  | Totals
 | I would like to auto sum F5 times by E5 and the same all the way across
 | i'm trying to get a cost for each person
Spreadsheet: 730052d1619526577-vlookup-from-a-range-that-have-the-same-name-vlookup
Sheet: Sheet1

 | Old List |  |  | New list
 | Customer | Comments |  | Customer | Comments
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] | Shapen up |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
Spreadsheet: 8fbc6bd6-7bb1-444a-927a-4d4c62ba45fd
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Falls mehr in die Verkehrsinfrastruktur investiert wird, wo soll der Schwerpunkt der [NAME] liegen?
 | [NAME]?
Antwort | Ja | [NAME]
[NAME] | 0.59 | 0.59
Strasseninfrastruktur | 0.3 | 0.3
Neutral / Weiss nicht | 0.12 | 0.11
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 64756d1265611973-cursor-needs-in-same-cell-in-recorded-macro-test-opening
Sheet: Daily CASH

 | AIR CARGO DIVISION
 | DAILY CASH REPORT
 | [NAME] |  |  |  |  |  |  | Monday | 2010-02-08 09:15:22
 | SR. | RV/SLIP |  | CONSIBNEE NAME |  |  | AKAC JOB# | DTD PKG# | AMOUNT
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 |  | TOTAL RECEIPTS |  |  |  |  |  |  | 0
 | Denomination of Notes / Coins |  |  | Kuwaiti Dinar / Fils | Sr. | DETAIL OF PAYMENTS |  |  | AMOUNT
 | 20 | x |  | 0 | 1
 | 10 | x |  | 0 | 2
 | 5 | x |  | 0 | 3
 | 1 | x |  | 0 | 4
 | 0.5 | x |  | 0 | 5
 | 0.25 | x |  | 0 | 6
 | 0.1 | x |  | 0 | 7
 | 0.05 | x |  | 0 | 8
 | 0.02 | x |  | 0 | 9
 | 0.01 | x |  | 0 | 10
 | 0.005 | x |  | 0 | 11
 | TOTAL CASH |  |  | 0 | 12
 |  |  |  |  | 13
 | Opeing Balance |  |  | 450 | 14
 | Total Receipts |  |  | 0 | 15
 | Total Payments |  |  | 0 |  | TOTAL PAYMENTS |  |  | 0
 | Closing Balance |  |  | 450 | SHORT CASH |  |  |  | 450
 | PREPARED BY |  |  |  |  |  |  |  | APPROVED BY