tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 737527d1624456671-formula-to-change-cell-data-depending-upon-other-cell-value-change
Sheet: Sheet1

Plan | Time | Keyword
1 | 5 | 1
 | 3 | 1
 | 4 | 1
 | 55 | 1
 | 34 | 1
1 | 3 | 2
 | 34 | 2
 | 2 | 2
 | 23 | 2
 | 5 | 2
1 | 2 | 3
 | 4 | 3
 | 3 | 3
 | 4 | 3
 | 3 | 3
 | 66 | 3
 | 6 | 3
 | 6 | 3
 | 3 | 3
1 | 43 | 4
 | 4 | 4
 | 3 | 4
 | 3 | 4
 | 4 | 4
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 5. HCV

 |  | HCV test results |  |  |  |  | HCV test results | 0
 |  |  |  |  |  |  | Number of donations tested serologically during the indicated year
 |  | HCV test results |  |  |  |  | Donations from first time tested donors**, number | 0
 |  |  |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Number of donations tested serologically during the indicated year |  |  |  |  | Number of donations tested by NAT during the indicated year
 |  |  |  |  |  |  | Donations from first time tested donors**, number | 0
 |  | Donations from first time tested donors**, number |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Donations from repeat tested donors***, number |  |  |  |  | Number of invalid NAT test results during the indicated year (%) | 0
 |  | Number of donations tested by NAT during the indicated year
 |  | Donations from first time tested donors**, number
 |  | Donations from repeat tested donors***, number
 |  | Number of invalid NAT test results during the indicated year (%)
 |  | **         Donations from first time tested donors: From a person who was tested for the first time
 |  | without report of prior serological testing in the blood establishment.
 |  | ***       Donations from repeat tested donors:
 |  | From a donor who has been subjected to previous serological testing in a given blood establishment.
 |  |  |  | Page 18 of 34
Spreadsheet: vkaminski__40839__HenryHub
Sheet: _Wizard

xIGASS00 Low HenryHub!$C$1 | x | xIGASS00 | xLow | [NAME] | [NAME] | x4 | x1 | xHenryHub | x$C$1 | x|False|year(s)|day(s)|1|1|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|True|False|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | x | xFalse | xFalse | xTrue | xFalse | xTrue | xLow of IGASS00 | xFalse | x-1 | [NAME] | xExpiration Day | x | x | x | x | xFalse
xIGASS00 High HenryHub!$A$1 | x | xIGASS00 | xHigh | [NAME] | [NAME] | x4 | x1 | xHenryHub | [NAME] | x|False|year(s)|day(s)|1|1|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|True|False|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | x | xFalse | xFalse | xTrue | xFalse | xTrue | xHigh of IGASS00 | xFalse | x-1 | [NAME] | xExpiration Day | x | x | x | x | xFalse
xIGASS00 Index HenryHub!$A$1 | x | xIGASS00 | xIndex | [NAME] | [NAME] | x4 | x1 | xHenryHub | [NAME] | x|False|year(s)|day(s)|1|1|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|True|False|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | x | xFalse | xFalse | xTrue | xFalse | xTrue | xIndex of IGASS00 | xFalse | x-1 | [NAME] | xExpiration Day | x | [NAME] | [NAME] | xUSD | xFalse
Spreadsheet: 886018d1735957529-pull-number-from-column-with-other-text-sats-1
Sheet: Sheet1

1d ago
+ 2 sats |  |  |  |  |  |  |  |  | Sats
1d ago
+ 4 sats
1d ago
+ 4 sats
2d ago
- 385 sats'
2d ago
+ 4 sats
2d ago
+ 4 sats
2d ago
+ 15 sats
Spreadsheet: 693715d1599112684-finding-mismatches-via-conditional-formatting-checking-differences-via-conditional-formating
Sheet: Sheet1

Month Clearance | Clearance in System | Ideally, in the "Month Clearance" column (Col.A), if data starts with 0 or 1 or 2 the data in "Clearance in System" column (Col. B) should be shown as "Cleared". Similarly, if the data starts with 3 or 4 or 5 or 6, the data in "Clearance in System" column should be shown as " Yet to Clear".  But in table A13:E20, the logic is not matching two places. The requirement is: I want to figure out the mismatches via conditional formating.  Need a formula for it.  Wherever there is any mismatch between Col. D and Col.E (as per the logic against Table A3:B10), the same are to be highlighted in Yellow (as shown in below table).
0 Closed | Cleared
1 Cleared for Shipment | Cleared
2 Inspection cleared | Cleared
3 Inspection to be Cleared | Yet to clear
4 To Be Cleared | Yet to clear
5 Production Clearance Awtd | Yet to clear
6 Site Clearance Awtd. | Yet to clear
PHASE WBS | JOB | Customer | Month clearance | Clearance in System
HY-05633.01.21 | HY-05633 | GAS POINT | 4 To be Cleared | Cleared
HY-05633.01.22 | HY-05633 | GAS POINT | 4 To be Cleared | Yet to clear
HY-05633.01.23 | HY-05633 | GAS POINT | 1 Cleared for Shipment | Yet to clear
HY-05674.01.03 | HY-05674 | ITC LTD, HOSKOTE | 1 Cleared for Shipment | Cleared
HY-05674.01.05 | HY-05674 | ITC LTD, HOSKOTE | 5 Prodn Clearance Awtd | Yet to clear
HY-05674.01.06 | HY-05674 | ITC LTD, HOSKOTE | 5 Prodn Clearance Awtd | Yet to clear
HY-05674.01.04 | HY-05674 | ITC LTD, HOSKOTE | 5 Prodn Clearance Awtd | Yet to clear
Spreadsheet: 828554d1683606934-summing-the-number-portion-of-cells-with-numbers-and-text-book1-test
Sheet: Sheet1

 | 4 | W | W | 4.
 |  |  | 1 | W | 1 | W | 2.
 |  | 64 | W | 2 | 2 | W | 68.
 |  | 1 | 2 | 4 | 6. | 1 | 1.
 | 1 | 2 | W | W | W | 3.
 |  |  |  |  | 2 | 1 | 3.
SUB
SUB "." | 0 | 0 | 0 | 4 | 6 | 3 | 74 | <[NAME] to calculate this row?
Spreadsheet: kate_symes__18685__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
Spreadsheet: 113064d1309009191-countif-for-two-criteria-countif-for-two-criteria
Sheet: Credit Card Unknowns

 |  |  |  |  | Desired data range : D6 to z9999
 |  | pd_cls_iii | Product id number | Bank_code | emp_num | cust_name | week_start | account name | Remark | Team | account reprsentative | monitor | date of complete
 |  | bbe | sav | 11333 | unk | [NAME] | 01-Jan-11 | 6060000000405466 | sales complete | PCT | [NAME] | y | 20110131
 |  | bbe | sav | 11333 | unk | Ella wong | 05-Jan-11 | 6460000000405466 | customer decline | PCT | [NAME] | y | 20110230
 |  | bba | sav | 11222 | unk | [NAME] | 05-Jan-11 | 6060100000405443 | customer decline | PCT | [NAME] | y | 20110111
 |  | bba | sav | 11222 | unk | [NAME] | 03-feb-11 | 6060000000405443 | no lead, may be rm | PCT | [NAME] |  | 20110111
 |  | bbd | sav | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 | product no useful | PCT | June |  | 20110421
 |  | bbe | sav | 11333 | unk | Ella wong | 05-Jan-11 | 6460000000405466 | not sure, may be RM | PCT | [NAME] | y | 20110230
 |  | bba | sav | 11222 | unk | [NAME] | 05-Jan-11 | 6060100000405443 | customer decline | act | [NAME] | y | 20110111
 |  | bba | sav | 11222 | unk | [NAME] | 03-feb-11 | 6060000000405443 | customer decline | act | [NAME] |  | 20110111
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 | product no useful | pct | June |  | 20110421
 |  | bbe | INK | 11333 | unk | Ella wong | 05-Jan-11 | 6460000000405466 | customer decline | act | [NAME] | y | 20110230
 |  | bba | CRI | 11222 | unk | [NAME] | 05-Jan-11 | 6060100000405443 | customer decline | act | [NAME] | y | 20110111
 |  | bba | TTL | 11222 | unk | [NAME] | 03-feb-11 | 6060000000405443 | nn o lead, may be RM | act | [NAME] |  | 20110111
 |  | bbd | ppe | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 | product no useful | act | June |  | 20110421
 |  | bbe | PPE | 11333 | unk | Ella wong | 05-Jan-11 | 6460000000405466 | customer decline | act | [NAME] | y | 20110230
 |  | bba | PPE | 11222 | unk | [NAME] | 05-Jan-11 | 6060100000405443 | customer decline | act | [NAME] | y | 20110111
 |  | bba | ppe | 11222 | unk | [NAME] | 03-feb-11 | 6060000000405443 | customer decline | act | [NAME] |  | 20110111
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 | product no useful | act | June |  | 20110421
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
 |  | bbd | CRI | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
 |  | bbd | CRI | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
 |  | bbd | SAV | 11444 | unk | [NAME] | 04-may-11 | 6060000434405466 |  | act | June |  | 20110421
Spreadsheet: 696451d1600829079-amortization-restructure-amortization-restructure-2
Sheet: restruct

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESTRUCTURED
 |  | Loan | 5000000 |  |  |  |  |  |  |  |  | Loan |  |  |  |  |  |  | Rem Loan
 |  | Interest | 0.1100000769361779 |  |  |  |  |  |  |  |  | Interest
 |  | Months | 12 |  |  |  |  |  |  |  |  | Months
 |  | Adv/Arr | 0 |  |  |  |  |  |  |  |  | Adv/Arr
 |  | Installment |  |  |  |  |  |  |  |  |  | Installment
 |  | Interest |  |  |  |  |  |  |  |  |  | Interest
 |  |  |  |  |  |  |  | IRR |  |  |  |  |  |  |  |  |  | IRR |  |  |  |  |  | IRR
 | No | Installment | Paid Interest | Paid Principal | Outstanding Principal | Outstanding Interest |  |  |  |  | No | Installment | Paid Interest | Paid Principal | Outstanding Principal | Outstanding Interest |  |  | Installmt | [NAME] | [NAME] | [NAME] | [NAME]
 | 1 |  |  |  |  |  |  |  |  | PAST | 1
 | 2 |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 0
 | 6 |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | 0
 | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  | 0
 | 8 |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 33513d1229966101-referencing-every-nth-row-from-another-worksheet-666253
Sheet: Finding Sub by Skill

 |  | Row | 2 | 2 | 4 | 3 | 6 | 7 | 8 | 9
 |  | Col | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Today | Tomorrow | Long Term | Last | First | Cell # | Phone # | Computer | Baking | Early Mornings | Notes | Row Ofst
 |  |  | Doe | [NAME] |  | 555-1234 |  |  |  |  | 0
 |  |  | [NAME] | King | 876-1234 | 987-7456 |  |  |  |  | 17
 |  |  | Witch | Evil | 123-9876 | 555-1234 |  |  |  |  | 34
 |  |  | [NAME] | Glenda | [NAME] | None |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  | 85
Spreadsheet: 545540d1509539128-find-the-max-value-and-adjacent-cells-date-book1
Sheet: Sheet1

2017-01-01 00:00:00 | 595
2017-01-02 00:00:00 | 175
2017-01-03 00:00:00 | 107
2017-01-04 00:00:00 | 685
2017-01-05 00:00:00 | 621
2017-01-06 00:00:00 | 199
2017-01-07 00:00:00 | 448
2017-01-08 00:00:00 | 433
2017-01-09 00:00:00 | 558
2017-01-10 00:00:00 | 985
2017-01-11 00:00:00 | 521
2017-01-12 00:00:00 | 106
2017-01-13 00:00:00 | 257
2017-01-14 00:00:00 | 820
2017-01-15 00:00:00 | 905
2017-01-16 00:00:00 | 409
2017-01-17 00:00:00 | 902
2017-01-18 00:00:00 | 283
2017-01-19 00:00:00 | 711
Spreadsheet: 839620d1692114274-how-to-concatenate-and-show-ranking-formulas-ranking-example-aligw
Sheet: Sheet1

Name 1 | [NAME] | Address | Phone No | Visits | Ranking
Elvis | Presley | 2 West Street | 55987 | 23
[NAME] | [NAME] | 15 West Street | 16579 | 18 | Rank 3 = [NAME] 18
Clint | Eastwood | 2 North Row | 78945 | 4 | Rank 4 = [NAME]
[NAME] | Wayne | 54 East Avenue | 22265 | 66 | Rank 1 = [NAME]
 | How to rank and show Full name and amount of visits:
 | Rank 1 = [NAME] 66
 | Rank 2 = [NAME] 23
 | Rank 3 = [NAME] 18
 | Rank 4 = [NAME]
 | Name have been concatenated also
 | Rank 2 = Elvis  Presley 23
 | Rank 3 = [NAME] 18
 | Rank 4 = [NAME]
Spreadsheet: fe0270c8-b8da-42a8-a0d0-6ea7becce601
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PAMYB | Test | PAMYB | Amylase, Pancreatic, Body Fluid | Amylase, Pancreatic, BF | Monoclonal Antibody Technique | Plastic vial: PlV |  |  | 0.5 | mL | Container/Tube: Body fluid container [NAME]: 0.5 mL Additional Information: Indicate specimen source. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Note on Line 21 Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Not applicable | Monday through Friday | 1 day (not reported on Saturday or Sunday) | 5 days | 1 | 82150 |  |  |  |  | Rochester
PAMYB | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 30 days
PAMYB | Result | PAMBF | Amylase, Pancreatic, BF | Amylase, Pancreatic, BF | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 48996-3
PAMYB | Result | FLD | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6
Spreadsheet: 860277d1708436406-flow-data-through-tabs-based-on-what-is-entered-in-a-cell-pricing-example-ef
Sheet: Products

Budget Waney Lap
2ft Budget Waney lap |  |  |  |  | 3' Budget Waney lap |  |  |  |  | 4' Budget Waney lap |  |  |  |  | 5' Budget Waney lap |  |  |  |  | 6' Budget Waney lap
Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost
 | 5 |  |  |  | 3' [NAME] | 5 |  |  |  | 4' [NAME] | 5 |  |  |  | 5' [NAME] | 5 |  |  |  | 6' [NAME] | 7
 | 5 |  |  |  | 3' Thin Batten | 5 |  |  |  | 4' Thin Batten | 5 |  |  |  | 5' Thin Batten | 5 |  |  |  | 6' Thin Batten | 5
 | 6 |  |  |  | 5mm Waney Boards | 9 |  |  |  | 5mm Waney Boards | 11 |  |  |  | 5mm Waney Boards | 13 |  |  |  | 5mm Waney Boards | 15
 | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' Top Rail | 1
 | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | Badge | 1
 | 1 |  |  |  | Badge | 1 |  |  |  | Badge | 1 |  |  |  | Badge | 1 |  |  |  | 38[NAME] nails | 1
 | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | Individual Dip Price | 1
 | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Piecework | 1
 | 1 |  |  |  | Piecework | 1 |  |  |  | Piecework | 1 |  |  |  | Piecework | 1
 |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost
In columns A, F, K etc with components in, I will have them linked
to the components in the Components tab, as per A5 to A13
What I need is the pricing from the Components tab to link through
and into columns C, H, M etc, the price columns, based on the component
in columns A, F, K etc.
Spreadsheet: 330939d1404909242-difference-between-price-volume-variance-at-summary-total-level-variance-2
Sheet: Sheet1 (2)

 |  |  | Current volume | Mix | Prior volume | Mix | current price | last year price | total current | total prior | price variance | volume variance | mix variance
 |  | Product A | 5 |  | 8 |  | 1300 | 1300 |  |  |  |  |  | =SUMPRODUCT(D4*H4-F4*I4)
 |  | Product B | 968 |  | 1273 |  | 425 | 428 |  |  |  |  |  | =SUMPRODUCT(D5*H5-F5*I5)
 |  | Product C | 1800 |  | 2154 |  | 300 | 207 |  |  |  |  |  | =SUMPRODUCT(D6*H6-F6*I6)
 |  | Total |  |  |  |  |  |  | 957900
 |  |  |  |  |  |  |  |  |  | Summary Level
 |  |  |  |  |  |  |  |  | Total Variance
 |  |  |  |  |  |  |  |  |  | Total Level
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: T@C

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 269783d1381279042-subtotal-filter-not-working-excel4m_910
Sheet: Sheet1

q1.1 | q1.2 | q1.3 | q1.4 | q1.5 | q1.6 | q1.7 | q1.8 | q1.9 | q2 | q3 | q4 | q5 | q6 | Entry Id | Entry Date | #[NAME]
Conservative | Balanced | Growth | Target Return | Australian Shares | International Shares | Diversified Fixed Interest | Cash |  | More than twice | No | Yes | Income Focused | 25 to 40 years | 13025 | 2013-10-01 15:05:21
 | Balanced | Growth |  | Australian Shares |  | Diversified Fixed Interest | Cash |  | More than twice | No | No |  | 41 to 60 years | 11740 | 2013-09-27 18:02:28
Conservative | Balanced | Growth |  | Australian Shares |  |  | Cash |  | Once | No | No |  | 60 plus | 11840 | 2013-09-27 18:59:13
 | Balanced | Growth |  | Australian Shares | International Shares | Diversified Fixed Interest |  |  | More than twice | No | No |  | 41 to 60 years | 12045 | 2013-09-27 21:51:11
 | Balanced |  |  | Australian Shares | International Shares | Diversified Fixed Interest | Cash |  | Twice | No | Yes | Income Focused | 60 plus | 11911 | 2013-09-27 19:51:06
 | Balanced |  | Target Return | Australian Shares | International Shares | Diversified Fixed Interest |  |  | More than twice | No | Yes | Income Focused | 60 plus | 12324 | 2013-09-28 13:13:44
Conservative |  | Growth |  | Australian Shares | International Shares |  | Cash |  | More than twice | No | Yes | Traditional | 41 to 60 years | 11419 | 2013-09-27 16:23:59
Conservative | Balanced | Growth |  |  |  | Diversified Fixed Interest |  |  | More than twice | No | No |  | 41 to 60 years | 11435 | 2013-09-27 16:26:02
Spreadsheet: 119025d1314141074-extract-last-word-from-a-cell-to-another-cell-seimens_site_for_forum
Sheet: Address Format

Street_number | street_name | street_extension | city | zip | [NAME]
301 | TYSON AVE |  | PARIS | 38242 | 4544
1 | TERMINAL DR |  | NASHVILLE | 37214 | 0000
465 | OPRY MILLS MALL DRIVE |  | NASHVILLE | 37214 | 0000
1025 | AIRSIDE DR STE 2101 |  | MORRISVILLE | 27560 | 6216
2055 | ALCOA HWY |  | ALCOA | 37701 | 3179
2491 | WINCHESTER RD CARGO 2 |  | MEMPHIS | 38116 | 3851
5501 | JOSH BIRMINGHAM PWY |  | CHARLOTTE | 28208 | 5746
482 | MCBRIEN RD |  | EAST RIDGE | 37412 | 3224
3700 | WAKE FOREST RD |  | RALEIGH | 27609 | 6833
3700 | WAKE FOREST RD |  | RALEIGH | 27609 | 6833
1525 | W WT HARRIS BLVD |  | CHARLOTTE | 28262 | 8522
3501-3553 | DUNN RD |  | FLORISSANT | 63033 | 6726
5500 | 44TH ST SE |  | GRAND RAPIDS | 49512 | 4093
Spreadsheet: 675393d1588266362-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-demo
Sheet: APersaud

Dalton, Marcuse Oriliouse | 2
El [NAME], [NAME] | 2
Espinoza, [NAME] | 3
Flores, [NAME] | 0
[NAME], [NAME] | 1
Harker, Hailey Nichole | 0
[NAME], Sophia Valentina | 1
[NAME], [NAME] | 2
[NAME], Emily Guadalupe | 3
[NAME], [NAME] | 3
Maldonado, [NAME] | 0
MCGAUGHY, [NAME] | 1
Nieves Vizcarrondo, Victorya Essined | 0
Pacheco, [NAME] | 3
Ramos, [NAME] | 0
Rivera, [NAME] | 1
[NAME], [NAME] | 0
Vendeuvre-Briceno, [NAME] | 1
Villalobos-Oyola, Yulianna [NAME] | 2
Ye, [NAME] Xin | 3
Spreadsheet: 850443d1700767146-counting-consecutives-identical-cells-book1
Sheet: Sheet1

 |  |  | Comp | VENUE | GF | GA |  | consecutives |  | GOALS SCORED | [NAME]
 |  |  | League | H | 2 | 4 |  |  |  | TOTAL | TOTAL
 |  |  | League | A | 1 | 3 |  | ALL COMPS | ALL | 7 | 10
 |  |  | League | H | 2 | 2 |  |  | HOME | 10 | 14
 |  |  | League | A | 3 | 1 |  |  | AWAY | 3 | 7
 |  |  | League | H | 3 | 0 |  | LEAGUE ONLY | ALL
 |  |  | League | A | 2 | 1 |  |  | HOME
 |  |  | League | H | 1 | 2 |  |  | AWAY
 |  |  | League | A | 0 | 3 |  | LONGEST RUNS |  | WITHOUT CONCEDING | WITHOUT SCORING
 |  |  | League | H | 4 | 4 |  |  |  | TOTAL | TOTAL
 |  |  | League | A | 0 | 3 |  | ALL COMPS | ALL | 3
 |  |  | League | H | 3 | 2 |  |  | HOME
 |  |  | Cup | A | 2 | 5 |  |  | AWAY
 |  |  | League | H | 5 | 1 |  | LEAGUE ONLY | ALL | 2
 |  |  | League | A | 1 | 2 |  |  | HOME
 |  |  | League | H | 2 | 1 |  |  | AWAY
 |  |  | League | A | 0 | 0
 |  |  | League | H | 4 | 1
 |  |  | League | A | 1 | 2
 |  |  | League | H | 1 | 3
 |  |  | League | A | 2 | 4
 |  |  | League | H | 0 | 3
 |  |  | Cup | A | 0 | 0
 |  |  | League | H | 1 | 0
 |  |  | League | A | 2 | 0
 |  |  | League | H | 3 | 1
 |  |  | League | A | 2 | 2
 |  |  | League | H | 0 | 3
 |  |  | League | A | 0 | 0
 |  |  | League | H | 1 | 4
 |  |  | League | A | 0 | 0
 |  |  | League | H | 2 | 1
 |  |  | League | A | 3 | 2
Spreadsheet: 843274d1695168075-unifying-fields-with-varied-hh-mm-ss-formatting-fix-time-format
Sheet: Sheet1

sample | bvj | tms1 | tms2 |  | HD1 | HD2
01h:01m
01m:01s
01h:55m
02h:03m
01h:38m
02h:26m
01h:01m
01h:53m
23m:16s
03m:02s
34m:47s
08h:00m
51m:46s
01h:16m
09m:38s
04h:44m
Spreadsheet: 177525d1346338436-novice-trying-to-work-how-assign-value-in-a-cell-based-on-another-cell-vlookup-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | 12 | 6A
 |  |  |  |  |  |  |  | 6 | 4A
 |  |  |  |  |  |  |  | 6 | 4A
 |  |  |  |  |  |  |  | 15 | 7A
 |  |  |  |  |  |  |  | 12 | 6A
 |  |  |  |  |  |  |  | 1 | 3C
 |  |  |  |  |  |  |  | 7 | 5C
 |  |  |  |  |  |  |  | 16 | 8C
 |  |  |  |  |  |  |  | 10 | 6C
 |  |  |  |  |  |  |  | 13 | 7C
 |  |  |  |  |  |  |  | 10 | 6C
 |  |  |  |  |  |  |  | 14 | 7B
 |  |  |  |  |  |  |  | 6 | 4A
 |  |  |  |  |  |  |  | 5 | 4B
 |  |  |  |  |  |  |  | 2 | 3B
 |  |  |  |  |  |  |  | 14 | 7B
 |  |  |  |  |  |  |  | 2 | 3B
 |  |  |  |  |  |  |  | 14 | 7B
 |  |  |  |  |  |  |  | 6 | 4A
 |  |  |  |  |  |  |  | 12 | 6A
 |  |  |  |  |  |  |  | 10 | 6C
 |  |  |  |  |  |  |  | 7 | 5C
 |  |  |  |  |  |  |  | 11 | 6B
 |  |  |  |  |  |  |  | 15 | 7A
 |  |  |  |  |  |  |  | 3 | 3A
 |  |  |  |  |  |  |  | 9 | 5A
 |  |  |  |  |  |  |  | 12 | 6A
 |  |  |  |  |  |  |  | 7 | 5C
 |  |  |  |  |  |  |  | 6 | 4A
 |  |  |  |  |  |  |  | 12 | 6A
 |  |  |  |  |  |  |  | 1 | 3C
 |  |  |  |  |  |  |  | 10 | 6C
 |  |  |  |  |  |  |  | 15 | 7A
 |  |  |  |  |  |  |  | 18 | 8A
 |  |  |  |  |  |  |  | 4 | 4C