tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 298469d1392815844-some-way-to-alert-me-when-certain-monthly-limits-are-exceeded-mocktarget
Sheet: Sheet1

Here's the type of data I am working with:
Date | Salesperson | Item
2014-01-01 00:00:00 | [NAME] | Apple |  |  | I would like to write either code or formula to
2014-01-02 00:00:00 | [NAME] | Apple |  |  | return some sort of alert when
2014-01-03 00:00:00 | [NAME] | Apple |  |  | these monthly limits are exceeded.
2014-01-04 00:00:00 | [NAME] | Apple |  |  |  | [NAME] sales >35% of total sales (from one salesperson)
2014-01-05 00:00:00 | [NAME] | Apple |  |  |  | >1 carrot sold by one salesperson
2014-01-06 00:00:00 | [NAME] | Apple |  |  |  | >25 apples sold as a company
2014-01-07 00:00:00 | [NAME] | Apple
2014-01-08 00:00:00 | [NAME] | Apple |  |  | My data for each month is on a separate tab in one workbook
2014-01-09 00:00:00 | [NAME] | Apple
2014-01-10 00:00:00 | [NAME] | Apple |  |  | I do not want to backlight the cells, or do any conditional formatting of
2014-01-11 00:00:00 | [NAME] | Apple |  |  | the records, as I am often dealing with 30-50,000 records per month.
2014-01-12 00:00:00 | [NAME] | Apple |  |  | I need the alerts to return a value (or values) to another cell when
2014-01-13 00:00:00 | [NAME] | Apple |  |  | a limit is exceeded.
2014-01-14 00:00:00 | [NAME] | Apple
2014-01-15 00:00:00 | [NAME] | Apple
2014-01-16 00:00:00 | [NAME] | [NAME]
2014-01-17 00:00:00 | [NAME] | [NAME]
2014-01-18 00:00:00 | [NAME] | [NAME]
2014-01-19 00:00:00 | [NAME] | [NAME]
2014-01-20 00:00:00 | [NAME] | [NAME]
2014-01-21 00:00:00 | [NAME] | [NAME]
2014-01-22 00:00:00 | [NAME] | [NAME]
2014-01-23 00:00:00 | [NAME] | [NAME]
2014-01-24 00:00:00 | [NAME] | [NAME]
2014-01-25 00:00:00 | [NAME] | Grape
2014-01-26 00:00:00 | [NAME] | Grape
2014-01-27 00:00:00 | [NAME] | Grape
2014-01-28 00:00:00 | [NAME] | Grape
2014-01-29 00:00:00 | [NAME] | Grape
2014-01-30 00:00:00 | [NAME] | Carrot
2014-01-31 00:00:00 | [NAME] | Carrot
2014-01-01 00:00:00 | [NAME] | Apple
2014-01-02 00:00:00 | [NAME] | Apple
2014-01-03 00:00:00 | [NAME] | Apple
2014-01-04 00:00:00 | [NAME] | Apple
2014-01-05 00:00:00 | [NAME] | Apple
2014-01-06 00:00:00 | [NAME] | Apple
2014-01-07 00:00:00 | [NAME] | Apple
2014-01-08 00:00:00 | [NAME] | Apple
2014-01-09 00:00:00 | [NAME] | Apple
2014-01-10 00:00:00 | [NAME] | Apple
2014-01-11 00:00:00 | [NAME] | Apple
2014-01-12 00:00:00 | [NAME] | Apple
2014-01-13 00:00:00 | [NAME] | Apple
2014-01-14 00:00:00 | [NAME] | [NAME]
2014-01-15 00:00:00 | [NAME] | [NAME]
2014-01-16 00:00:00 | [NAME] | [NAME]
2014-01-17 00:00:00 | [NAME] | [NAME]
2014-01-18 00:00:00 | [NAME] | [NAME]
2014-01-19 00:00:00 | [NAME] | [NAME]
2014-01-20 00:00:00 | [NAME] | [NAME]
2014-01-21 00:00:00 | [NAME] | [NAME]
2014-01-22 00:00:00 | [NAME] | [NAME]
2014-01-23 00:00:00 | [NAME] | [NAME]
2014-01-24 00:00:00 | [NAME] | [NAME]
2014-01-25 00:00:00 | [NAME] | [NAME]
2014-01-26 00:00:00 | [NAME] | [NAME]
2014-01-27 00:00:00 | [NAME] | Grape
2014-01-28 00:00:00 | [NAME] | Grape
2014-01-29 00:00:00 | [NAME] | Grape
2014-01-30 00:00:00 | [NAME] | Grape
2014-01-31 00:00:00 | [NAME] | Carrot
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 9

Fixtures | Week 9 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Bournemouth |  | - |  | Tottenham |  | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0
Arsenal |  | - |  | Middlesbrough |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Burnley |  | - |  | Everton |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
Hull City |  | - |  | Stoke City |  | 0 | 0 | 2 | 0 | 0 | 2 | 5 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 0 | 5 | 2 | 2
Leicester City |  | - |  | Crystal Palace |  | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2 | 2 | 2 | 2 | 0 | 2 | 5 | 0 | 2 | 2 | 0
Swansea City |  | - |  | Watford |  | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0
West Ham |  | - |  | Sunderland |  | 2 | 2 | 2 | 5 | 2 | 5 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 2 | 2 | 5 | 2 | 2 | 2
Liverpool |  | - |  | West Brom |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 5 | 2 | 0 | 5 | 2 | 2 | 2 | 2 | 2
Manchester City |  | - |  | Southampton |  |  |  |  |  |  |  |  | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Chelsea |  | - |  | [NAME] |  |  |  |  |  |  |  |  | 0 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 0 | 0 | 2 | 2
Home Team | Score |  |  | Away Team | Weekly Total
Bournemouth | 0 | - | 0 | Tottenham |  | 1-1 | 1-1 | 2-3 | 1-2 | 2-2 | 1-2 | 1-0 | 1-2 | 1-2 | 1-0 | 2-2 | 0-1 | 2-1 |  | 2-1 | 1-3 | 1-1 | 1-1 | 0-2 | 0-2
Arsenal | 0 | - | 0 | Middlesbrough |  | 3-0 | 3-0 | 3-0 | 2-0 | 4-0 | 3-1 | 2-0 | 2-0 | 3-0 | 3-1 | 4-0 | 3-0 | 2-0 |  | 2-1 | 4-1 | 2-0 | 3-1 | 3-0 | 3-1
Burnley | 2 | - | 1 | Everton |  | 1-2 | 1-2 | 1-2 | 1-3 | 0-1 | 0-1 | 1-3 | 1-2 | 1-2 | 0-1 | 1-2 | 1-2 | 0-2 |  | 2-1 | 1-2 | 0-2 | 1-2 | 1-2 | 0-2
Hull City | 0 | - | 2 | Stoke City |  | 1-1 | 1-1 | 0-1 | 2-2 | 1-1 | 1-2 | 0-2 | 1-1 | 1-1 | 2-1 | 0-1 | 1-1 | 1-2 |  | 2-1 | 1-2 | 1-1 | 0-2 | 1-2 | 1-2
Leicester City | 3 | - | 1 | Crystal Palace |  | 1-2 | 1-0 | 1-1 | 1-0 | 2-1 | 1-1 | 1-1 | 2-1 | 2-2 | 2-1 | 2-1 | 2-1 | 3-0 |  | 2-1 | 3-1 | 1-1 | 1-0 | 1-0 | 1-1
Swansea City | 0 | - | 0 | Watford |  | 1-0 | 2-1 | 2-2 | 1-1 | 2-1 | 2-2 | 2-0 | 2-2 | 2-1 | 2-1 | 2-0 | 2-1 | 2-1 |  | 2-1 | 1-1 | 2-1 | 1-2 | 2-2 | 1-2
West Ham | 1 | - | 0 | Sunderland |  | 2-0 | 2-0 | 2-0 | 1-0 | 2-1 | 1-0 | 1-1 | 1-1 | 1-2 | 2-0 | 1-1 | 2-0 | 3-1 |  | 2-1 | 2-0 | 1-0 | 2-0 | 2-0 | 2-0
Liverpool | 2 | - | 1 | West Brom |  | 3-0 | 4-0 | 3-1 | 2-0 | 3-1 | 3-1 | 4-0 | 2-0 | 2-1 | 4-0 | 3-1 | 2-1 | 4-0 |  | 2-1 | 3-0 | 2-0 | 3-0 | 3-0 | 2-0
Manchester City | 1 | - | 1 | Southampton |  | 2-0 | 2-1 | 2-2 | 3-1 | 2-1 | 3-2 | 2-0 | 2-1 | 1-1 | 3-1 | 3-0 | 2-1 | 3-2 |  | 2-1 | 2-1 | 1-1 | 2-1 | 2-0 | 3-0
Chelsea | 4 | - | 0 | [NAME] |  | 1-2 | 2-2 | 1-1 | 1-1 | 2-1 | 1-1 | 0-1 | 1-1 | 3-2 | 2-1 | 2-1 | 2-1 | 3-1 |  | 2-1 | 2-1 | 1-1 | 2-2 | 2-0 | 2-1
Spreadsheet: 52469d1252221231-problem-concatenating-the-filename-to-the-code-sheet-c
Sheet: Sheet1

Quote S/N | Customer Name | Customer Code | Date Inquiry Received | Date Quotation Sent | Preparer Initials | Region | Quote Value $US | Application | Multiplier used | Quote Ref. | Quote Status | Inquiry Status | Remarks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1 | AJ | [NAME] | [NAME] | Ajman | Fire | Pending
849 | [NAME] | Aika | 2009-08-18 00:00:00 | 2009-09-01 00:00:00 | AJ | R1 | 123980 |  | 0.54 | R1-Aika-00849-010909-AJ | Pending
850 | ADCC | ADCC | 2009-08-24 00:00:00 | 2009-08-31 00:00:00 | AA | R2 |  |  | 0.54 | R2-ADCC-00850-310809-AA | Pending
851 | [NAME] | Ferz | 2009-09-01 00:00:00 | 2009-09-02 00:00:00 | AJ | R1 |  |  | 0.54 | R1-Ferz-00851-020909-AJ
Spreadsheet: 03f581d1-4a9a-4cb9-b695-1c72fe233d8e
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
 |  |  |  |  |  |  | Pronuclear Injection Request Form
 |  |  |  |  |  |  | University of Maryland, Baltimore    School of Medicine Transgenic Core Laboratory   Howard Hall 581    [PHONE]
 |  |  |  |  |  |  |  |  | Non-UMB Investigator Form
 |  |  |  |  |  | Request Date |  |  |  |  | PI Name
 |  |  |  |  |  | Please indicate address where invoices should be sent: |  |  |  |  | Affiliation
 |  |  |  |  |  | Invoice contact person
 |  |  |  |  |  | Street address |  |  |  |  | Street address
 |  |  |  |  |  | City, State, Zip |  |  |  |  | City, State, Zip
 |  |  |  |  |  | Lab Contact |  |  |  |  | phone
 |  |  |  |  |  | phone |  | email |  |  | email
 |  |  |  |  |  | Animal Facility Address: |  |  |  |  |  | ARF# |  | Exp. Date
 |  |  |  |  |  | (Complete Address) |  |  |  |  |  | Please include a copy of your protocol approval letter
 |  |  |  |  |  | Veterinarian contact: |  | Phone |  |  | email |  |  | FAX
 |  |  |  |  |  | Animal Facility Contact: |  | Phone |  |  | email |  |  | FAX
 |  |  |  |  |  | [NAME] strain for injections (indicate): |  |  | B6C3F1 |  | C57BL/6NCr |  | FVB | Other
 |  |  |  |  |  | Please provide 10 ug of plasmid DNA digest for each project with enzymes inactivated or removed
 |  |  |  |  |  | Construct Name:
 |  |  |  |  |  |  |  | Please provide 1) a linear map of your construct 2) gel picture of plasmid digest indicating injection fragment
 |  |  |  |  |  | Vector
 |  |  |  |  |  | Restriction enzyme(s) used to excise injection fragment:
 |  |  |  |  |  | Size of injection frag (kb) |  |  |  |  | Conc & vol of DNA provided (ug/uL, uL)
 |  |  |  |  |  | Tail biopsies will be provided to PI when pups are 1 week of age, PI must take posession of pups at 28 days of age.
 |  |  |  |  |  | Please report assay results promptly to the Transgenic/Knockout Core Facility at  6-0453
 |  |  |  |  |  | Screening Assay: |  | PCR | Southern |  | Provide a gel photo (PCR) of the screening assay indicating 1) positive control,
 |  |  |  |  |  | (circle one) |  |  |  |  | 2) negative control and 3) demonstration of 1-copy gene per genome sensitivity
 |  |  |  |  |  | Do you require the Transgenic Lab to prep DNA from tail biopsies? |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Please provide a project description as it pertains to the use of transgenic animals:
 |  |  |  |  |  | Has this construct been used to generate transgenic animals previously? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  | Are phenotypic problems expected (i.e. [NAME])? |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  |  |  |  |  |  |  | if yes, explain
 |  |  |  |  |  | PI Signature: |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Return this completed form to: Transgenic Core Facility, [NAME] (FAX [PHONE])
 |  |  |  |  |  | This form and all requested information and supporting data must be received prior to project initiation
Spreadsheet: 699720d1602736811-selection-from-a-table-excel-help-v2
Sheet: Condition

 | Data input Field | Data Input Field | Calculated field
Item | Useful Life | Age | Rating |  |  |  |  |  |  | Rating (based on age range)
 |  |  | Based on age range |  |  |  |  |  | Useful life | 1 | 2 | 3 | 4 | 5
aa | 4 | 2.5 |  |  |  |  |  |  | 2 | 0.5 | 1 | 1.5 | 2 | >2
bb | 18 | 2 |  |  |  |  |  |  | 3 | 0.75 | 1.5 | 2.25 | 3 | >3
cc | 25 | 16 |  |  |  |  |  |  | 4 | 1 | 2 | 3 | 4 | >4
dd | 15 | 9 |  |  |  |  |  |  | 5 | 1.25 | 2.5 | 3.75 | 5 | >5
ee | 5 | 2 |  |  |  |  |  |  | 6 | 1.5 | 3 | 4.5 | 6 | >6
ff | 8 | 7 |  |  |  |  |  |  | 7 | 1.75 | 3.5 | 5.25 | 7 | >7
gg | 20 | 11 |  |  |  |  |  |  | 8 | 2 | 4 | 6 | 8 | >8
hh | 25 | 6 |  |  |  |  |  |  | 10 | 2.5 | 5 | 7.5 | 10 | >10
ii | 25 | 8 |  |  |  |  |  |  | 12 | 3 | 6 | 9 | 12 | >12
jj | 40 | 11 |  |  |  |  |  |  | 15 | 3.75 | 7.5 | 11.25 | 15 | >15
 |  |  |  |  |  |  |  |  | 18 | 4.5 | 9 | 13.5 | 18 | >18
 |  |  |  |  |  |  |  |  | 20 | 5 | 10 | 15 | 20 | >20
 |  |  |  |  |  |  |  |  | 25 | 6.25 | 12.5 | 18.75 | 25 | >25
 |  |  |  |  |  |  |  |  | 30 | 7.5 | 15 | 22.5 | 30 | >30
 |  |  |  |  |  |  |  |  | 40 | 10 | 20 | 30 | 40 | >40
 |  |  |  |  |  |  |  |  |  | Age table
 | I am trying to provide a "rating" based actual "age" within an items "useful life".  The age table is a simple proportion of the 1 to 5 rating for each useful life year, against the "rating".  Each "age" falls within a range of each "rating" as is not unique it each useful life.   I would like to be able to generate a "rating" in column D for each item based on the "useful life", corresponding to the "age" range of that row.  The "rating" formula in Column D seems fine for working out the rating based on an "age" range along a row but I am hoping to generate this selection by matching the "useful life" in Column B to Column J in the table.  I am not sure if there is an INDEX / MATCH function I can use or it is just something simple and I cannot see it - appreciate any help
Spreadsheet: 35070d1232573717-conditional-formatting-months-arpspreadsheet-1-
Sheet: Sheet1

Direct | ARP Due
[NAME] | 2009-12-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2010-01-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-03-01 00:00:00
[NAME] | 2009-11-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2008-06-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-08-01 00:00:00
[NAME] | 2009-11-01 00:00:00
[NAME] | 2008-11-01 00:00:00
[NAME] | 2008-09-01 00:00:00
[NAME] | 2009-02-01 00:00:00
[NAME] | 2009-08-01 00:00:00
[NAME] | 2009-05-01 00:00:00
[NAME] | 2009-10-01 00:00:00
Nicola Web | 2008-02-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-09-01 00:00:00
[NAME] | 2009-10-01 00:00:00
[NAME] | 2009-03-01 00:00:00
[NAME] | 2008-06-01 00:00:00
[NAME] | 2009-04-01 00:00:00
 | Overdue by more than 3 months
 | Overdue by between 3 and 1 month
 | Due this month
 | Due next month
 | Due between next month and 3 months time
 | Due in more than 3 months
Spreadsheet: 705370d1606069888-formulas-for-counting-and-adding-rolling-data-excel-forum-question
Sheet: Sheet1

red | Total count of Blue and Red per last/rolling 100 entries: |  |  | 1 | Sum of all numbers for last/rolling 100 entries:
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1 |  |  | This should be 5099
red |  |  |  | 1
red | This should be 94 |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
Red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
green |  |  |  | 5000
green
green
green
green
green
Spreadsheet: 693588d1599048312-how-to-efficiently-manage-trapping-value-and-n-a-errors-level-3-5-state-challenge-13th-september-2020
Sheet: Sheet1

VAULT
Comp Number | First Name | Last Name | Level | Judge 1 | Judge 2 | Average | Score | [NAME]
1111 | [NAME] | Doa | 5 | 0 | 1.2 | 0.6 | 9.4 | Gold
2222 | Mini | [NAME] | 5 | 2.9 | 1.1 | 2 | 8 | Silver
 |  |  |  | 0 | 0 | 0 | 10 | Gold
 |  |  |  | 9 | 10 | 9.5 | 0.5 | [NAME]
 |  |  |  | 10 | 10 | 10 | 0 | [NAME]
 |  |  |  | 1 | 1 | 1 | 9 | Gold
 |  |  |  |  |  | Awaiting Average | #[NAME]! | #N/A
 |  |  |  |  |  | Awaiting Average | #[NAME]! | #N/A
 |  |  |  |  |  | Awaiting Average | #[NAME]! | #N/A
 |  |  |  |  |  | Awaiting Average | #[NAME]! | #N/A
 |  |  |  |  |  | Awaiting Average | #[NAME]! | #N/A
Spreadsheet: 792847d1661185515-extract-value-from-top-row-table
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | LETTER | NUMBER | RESULT
 |  |  | A | B | C | D | E |  |  |  | C | 2 |  | NEED TO BE D
 |  | A | 1 | 2 | 3 | 4 | 5 |  |  |  | D | 5 |  | NEED TO BE C
 |  | B | 5 | 1 | 2 | 3 | 4 |  |  |  | A | 1 |  | NEED TO BE A
 |  | C | 4 | 5 | 1 | 2 | 3
 |  | D | 3 | 4 | 5 | 1 | 2
 |  | E | 2 | 3 | 4 | 5 | 1
Spreadsheet: 694039d1599313389-merge-cells-2020-09-05-oeldere-john_cash-694027d1599308558-merge-cells-merge-cell-05_09
Sheet: Foglio1

 |  |  | new modified |  |  | helpcolumn | result
 | 123456 |  | 12345612345678       ASD ASD ASD
 | AAAA-12345678     ASD ASD ASD
 | 123456 |  | 123456
 | 12345711 |  | 1234571112345678      ASDAS [NAME]
 | AAAA-12345678     ASDAS OEOE KKDK
 | 99978844 |  | 999788441237888      KAKA [NAME]
 | AAAA-1237888     KAKA [NAME]
 | 12347888 |  | 12347888
 | 9997888 |  | [PHONE]      KAKA DQQ ERR
 | AAAA-99888     KAKA DQQ ERR
Spreadsheet: 688243d1595660797-existing-formulas-dont-correctly-show-the-status-of-cells-being-either-blank-or-text-pairs
Sheet: Sheet1

 | No | Village | PairedWith | Status
 | 1 | [NAME]
 | 2
 | 3 | [NAME]
 | 4 | [NAME]
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
Spreadsheet: e2493eac-a1f0-48b8-9c9e-b06e933d2ce8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6147 | 12801 | Fabienne | St Louis | MRI | 21 | 00:18:52 | 00:00:00 | 01:10:37 | 00:00:00 | 00:39:00 | 1 | 02:08:32
6147 | 31943 | Flavia | Fernandes | BRA | 22 | 00:18:07 | 00:00:00 | 01:11:24 | 00:00:00 | 00:42:23 | 2 | 02:11:55
Spreadsheet: 862185d1709926806-find-alfanumeric-values-and-make-a-sum-sum-from-e-xxx-ver-3
Sheet: Blad1

 | qty | value | value
349220243 | 4 | 70 | 10 |  |  |  |  | Sort out the values and net with items
981734143 | 5 | 10 | 10 |  |  |  |  | that start with an "E" to accumulated sum |  |  |  | "TF3" in column C | TF3" in column D | TF07 in "C" | TF07 in "D" | TF2 in "C" | TF2 in "D"
473367462 | 6 | 10 | 10 |  |  |  |  | C-column | D-column | C-column | D-column
756295285 | 5 | 20 | 10 |  |  |  |  | EXXXX item | Exxxx item net | All other items with numbers without E, and TF numbers | All other items with numbers and TF numbers
E1234567 | 9 | 10 | 10 |  | REFERENCE LINE
E2345678 | 2 | 30 | 10
E3219876 | 2 | 100 | 10
E256 | 7 | 30 | 50
TF123 | 3 | 50 | 10
TF3 | 3 | 10 | 10
TF07 | 1 | 7 | 2 |  |  |  |  |  | 80 | 207 | 78 | 10 | 10
TF2 | 1 | 10 | 10
tf07 | 2 | 10 | 1 |  |  |  |  |  | 80 | 207 | 78 | 10 | 10 | 23
tf2 | 3 | 10 | 5
Spreadsheet: 873848d1720432950-look-up-the-data-and-return-multiple-result-sample-data-3-
Sheet: Sheet1

DATAS |  |  | CALCULATED RESULT
Name | Choice |  | No | Name | 1st Choice | 2nd Choice | 3rd Choice
[NAME] | Japan |  | 1
[NAME] | Singapore |  | 2
Hanna | Bali |  | 3
Leanne | Phillipine |  | 4
[NAME] | Holland |  | 5
Hanna | Malaysia |  | 6
[NAME] | Vietnam |  | 7
[NAME] | Korea |  | 8
Leanne | India
[NAME] | Nepal
Hanna | Australia |  | EXPECTED RESULT
Leanne | Canada |  | No | Name | 1st Choice | 2nd Choice | 3rd Choice
[NAME] | Alaska |  | 1 | [NAME] | Japan | Vietnam | Switzerland
[NAME] | Switzerland |  | 2 | [NAME] | Singapore | Korea | England
[NAME] | England |  | 3 | Hanna | Bali | Malaysia | Australia
 |  |  | 4 | Leanne | Phillipine | India | Canada
 |  |  | 5 | [NAME] | Holland | Nepal | Alaska
 |  |  | =IF(D3="","",INDEX($A$3:$A$25,MATCH(0,COUNTIF(E$2:E2,$A$3:$A$25),0))&"")
 |  |  | =IF($E3="","",IFERROR(INDEX($B$3:$B$20,SMALL(IF($A$3:$A$20=$E3,MATCH(ROW($A$3:$A$20),ROW($A$3:$A$20))),COLUMNS($A$1:A1))),"")&"")
Spreadsheet: 230085d1366683976-help-need-to-filter-out-certain-zipcodes-from-leads-example-final
Sheet: Sheet1

first_name | MI | last_name | PREFIX | address | SUITE_APT | city | state | zip | ZIP4 | ADDRESS_TYPE_INDICATOR | TELEPHONE_PRESENT_FLAG | phone_number | gender | NUMBER_OF_SOURCES | HOME_OWNER_SOURCE_FLAG | DATE_OF_BIRTH-YEAR | [NAME] | INFERRED_AGE | INCOME-ESTIMATED_HOUSEHOLD | NET_WORTH | MARITAL_STATUS_IN_THE_HHLD | ownrent | HOME_MARKET_VALUE | MILITARY_MEMORABILIA_WEAPONRY | LIFESTYLES_INTERESTS_AND_PASSIONS_COLLECTIBLES | HOME_IMPROVEMENT-DO-IT-YOURSELFERS | AUTO_WORK | SEWING_KNITTING_NEEDLEWORK | PURCHASE_DATE | PURCHASE_PRICE | LOAN_TO_VALUE | CREDIT_RATING | DO_NOT_CALL_FLAG
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12345 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12347 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12350 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12351 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12352 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | 12353 | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
Spreadsheet: 1fc6cae1-cd39-43df-a066-d4c624819061
Sheet: Sheet1

COUNTY SUMMARY/NAMES ON CHECKLIST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Democratic | Republican | Undeclared | Total |  | #1
Belknap County | 11491 | 15770 | 18030 | 45291 |  | 3220
Carroll County | 8349 | 12337 | 18511 | 39197 |  | 2033
Cheshire County | 18855 | 13716 | 26154 | 58725 |  | 5622
Coos County | 7054 | 5714 | 9341 | 22109 |  | 1443
Grafton County | 20863 | 17209 | 30294 | 68366 |  | 5729
Hillsborough County | 80148 | 83505 | 109206 | 272859 |  | 23125
Merrimack County | 32899 | 33008 | 43599 | 109506 |  | 8963
Rockingham County | 64061 | 69397 | 91775 | 225233 |  | 14600
Strafford County | 29735 | 21733 | 35900 | 87368 |  | 9789
Sullivan County | 8966 | 8118 | 12790 | 29874 |  | 2231
Totals | 282421 | 280507 | 395600 | 958528 |  | 76755
1. Number of persons who registered to vote at the polling place
updated 1/15/09
The numbers are the count of registered voters as reported by city and town clerks after the polls closed at the November 4, 2008 General Election.  Because town supervisors of the checklist and city registrars need to meet in public session to authorize the removal of voters from the checklist, voters who registered on election day who were already registered to vote in another N.H. city or town are counted as registered voters in both places.  Updated numbers will be posted after all the cities and towns have removed those voters who moved and registered on election day in some other town or ward in New Hampshire.
2009-01-15 00:00:00