tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_cash__26475__Crane WBS
Sheet: Sheet1

 | C.005440.02 |  | Project Crane - Deferred
 |  | C.005440.02.01 |  |  | Pulp & Paper Origination
 |  | C.005440.02.04 |  |  | Legal
 |  | C.005440.02.05 |  |  | Finance
 |  | C.005440.02.06 |  |  | Asset Management
 |  | C.005440.02.07 |  |  | Environmental/Permitting
 |  | C.005440.02.08 |  |  | Governmental Affairs
WBS |  | C.005440.02.09 |  |  | Executive
Element |  | C.005440.02.10 |  |  | Operations/Mid Office
 |  | C.005440.02.11 |  |  | Tax
 |  | C.005440.02.12 |  |  | Human Resources
 |  | C.005440.02.13 |  |  | Planning & Reporting
 |  | C.005440.02.14 |  |  | Transaction Development
 |  | C.005440.02.15 |  |  | Pulic Relations
 |  | C.005440.02.16 |  |  | Information Technology
 |  | C.005440.02.17 |  |  | TD - Associates & Analyst
 |  | C.005440.02.18 |  |  | Fundamental Analysis
 |  | C.005440.02.19 |  |  | Logistics
 |  | Company Code = 1206
Spreadsheet: 793249d1661363787-creating-a-results-list-of-multiple-races-finn-resultaten-2022-hd
Sheet: 5 aug

 |  | Place | Wedstrijd 1 | Wedstrijd 2 | Wedstrijd 3 | Wedstrijd 4 |  |  | place | sailnumber | points | points overall | count
 |  | 1 | 147 | 222 | 147 | 147 |  |  | 1 |  | 5 | 17
 |  | 2 | 200 | 147 | 14 | 13 |  |  | 2 | 14 | 17 | 16
 |  | 3 | 108 | 14 | 13 | 14 |  |  | 3 | 13 | 18 | 15
 |  | 4 | 63 | 250 | 113 | 113 |  |  | 4 | 222 | 19 | 14
 |  | 5 | 222 | 13 | 108 | 222 |  |  | 5 | 113 | 23 | 13
 |  | 6 | 113 | 20 | 1015 | 108 |  |  | 6 | 108 | 25 | 12
 |  | 7 | 1015 | 1015 | 63 | 199 |  |  | 7 | 63 | 30 | 11
 |  | 8 | 13 | 199 | 222 | 960 |  |  | 8 | 199 | 36 | 10
 |  | 9 | 14 | 113 | 199 | 63 |  |  | 9 | 1015 | 37 | 9
 |  | 10 | 20 | 63 | 960 | 131 |  |  | 10 | 960 | 41 | 8
 |  | 11 | 960 | 108 | 20 | 145 |  |  | 11 | 20 | 44 | 7
 |  | 12 | 199 | 960 | 57 | 57 |  |  | 12 | 131 | 51 | 6
 |  | 13 | 131 | 145 | 131 | 150 |  |  | 13 | 145 | 52 | 5
 |  | 14 | 145 | 57 | 145 |  |  |  | 14 | 57 | 53 | 4
 |  | 15 | 57 | 131 | 150 |  |  |  | 15 | 200 | 53 | 3
 |  | 16 | 150 | 150 |  |  |  |  | 16 | 250 | 55 | 2
 |  | 17 | 250 | 200 | 250 | 1015 |  |  | 17 | 150 | 60 | 1
 |  | 17 |  |  | 200 | 250 |  |  |  | 0 | 197
 |  | 17 |  |  |  | 200
 |  | 17 |  |  |  | 20
Spreadsheet: 831202d1685497716-is-there-a-max-number-of-characters-in-the-criteria-in-vlookup-sos
Sheet: Sheet1

 |  | 256
match / vlookup
 | >> look for
aggregate
Spreadsheet: 842659d1694685169-attendance-problem-and-working-across-multiple-worksheets-problem
Sheet: Group 2

Participant | [NAME] | School | 1/02/2023 (Mod 1) | Move1 | 2/02/2023 (Mod 2) | Move2
A2 | [EMAIL] | A2 School | y
B2 | [EMAIL] | B2 School | y
C2 | [EMAIL] | C2 School | y
D2 | [EMAIL] | D2 School | y
E2 | [EMAIL] | E2 School | n
[NAME]
 | [EMAIL] | C1 School
E1 | [EMAIL] | E1 School
F1 | [EMAIL] | F1 School
Spreadsheet: 746716d1630969341-how-to-calculate-double-time-hours-between-12-am-and-6-am-calculate-regular-time-ot-and-double-time-dwhite11-4-
Sheet: 1

 | [NAME] (Last, First) | Social Security # | Department | Rate | In | Out | In | Out | In | Out | In | Out | Hours Worked | ST | OT | DT | 2.25 | 3x | 4x | Day / Show Rate |  | SubTotal | 0.02 | Gross Wages | Parking | COMMENTS
1 |  |  |  |  | 03:00:00 | 06:00:00 | 07:00:00 | 17:00:00
2 |  |  |  |  | 22:00:00 | 03:00:00
3
4
5
6
7
 |  |  |  | Total Time |  |  |  |  |  |  |  |  |  | 6 |  | 5
 |  |  |  | Total Time |  |  |  |  |  |  |  |  |  | 2 |  | 3
 |  |  |  | Total Time
 |  |  |  | Total Time
 |  |  |  | Total Time
 |  |  |  | Total Time
 |  |  |  | Total Time
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | ST
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
 |  |  |  | DT
Spreadsheet: 47084d1245984113-date-and-day-problem-book8
Sheet: Sheet4

 | Employee : |  |  |  |  |  | Employee SSN# :
 | Address : |  |  |  |  |  | Supervisor :
 |  |  |  |  |  |  | Week Starting : |  | 2009-06-25 00:00:00
 |  |  |  |  |  |  | Week Ending : |  | 2009-07-02 00:00:00
 | Phone :
 | Day of Week | Time In | Time Out |  | Time In | Time Out | Total Hrs | Regular Hrs | [NAME] | [NAME] | Vacation Hrs
 | 1989-06-02 00:00:00
 | 2009-06-26 00:00:00
 | 1989-06-03 00:00:00
 | 2009-06-27 00:00:00
 | 1989-06-04 00:00:00
 | 2009-06-28 00:00:00
 | 1989-06-05 00:00:00
 | 2009-06-29 00:00:00
 | 1989-06-06 00:00:00
 | 2009-06-30 00:00:00
 | 1989-06-07 00:00:00
 | 2009-07-01 00:00:00
 | 1989-06-08 00:00:00
 | 2009-07-02 00:00:00
Spreadsheet: 158757d1338387745-conditional-formatting-delete-info-in-one-cell-change-the-formating-of-multiple-others-conditional-formating-blanks
Sheet: Main Title Page 

 |  |  |  |  |  |  |  |  | Thales
Title | System 1 Genre | System 3 Genre | System 1 Category | System 2 Category | System 3 | System 1 | System 2 | System 3 | System 2 Filename | System 3 Filanme
[NAME] | Action | Action | Recent Releases | Premiere | New Releases | 1 | 2 | 3 | JohnCarterSystem2 | JohnCarterSystem3
Sherlock [NAME] | Action | Action | Recent Releases | [NAME] | All Time Greats | 1 | 2 | 3 | SherlockSystem2 | [NAME]
Spreadsheet: 795380d1662651797-how-to-sum-multiple-datedifs-example-tracker-2
Sheet: CALC

Discipline | Count | Duration
Spreadsheet: 819033d1677182190-formula-to-calculate-number-of-cars-in-city-example-47-
Sheet: Status

Miasto/Segment | B | B AUT | C | C AUT | D | D AUT | SUV | VAN 7 os. | E | P+ | MINI LCV | LCV | VAN 9 os. | Mazda | Hyundai | Nissan |  |  | Klasa | [NAME]
Białystok |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C AUT | POZNAŃ
Gdańsk |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B | POZNAŃ
Gdynia |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B AUT | WARSZAWA
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B | POZNAŃ
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | WARSZAWA
Katowice |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | GDAŃSK
Kielce |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C AUT | WARSZAWA
Koszalin |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | D | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | D | POZNAŃ
Legnica |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | D AUT | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
Łódź |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C AUT | WARSZAWA
Olsztyn |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B | KATOWICE
Piotrków [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
Płock |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | D | WARSZAWA
Poznań |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | C | POZNAŃ
Rzeszów |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B | BIAŁYSTOK
Siedlce |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | B AUT | WARSZAWA
Szczecin |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Toruń |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Wałbrzych |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Warszawa |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Wrocław |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 826221d1681866997-vlookup-multiple-dates-test-file-v1-ashleytaylor1702-
Sheet: Sheet2

 |  |  |  |  |  | Vlookup multiple dates (excelforum.com)
Monthly |  |  |  | Weekly
Day of month | Service | Amount |  | Day of week | Service | Amount
1 | Car Insurance | 12 |  | Friday | Food Shopping | 90
1
1
2 | Water | 40
2 | broadband | 20
2
3
3
3
4
4
4
5
5
5
6
6
6
7 | Electric | 60
7 | Insurance
7
8
8
8
9
9
9
10
10
10
11
11 | Mortgage | 489
11
12
12
12
13
13
13
14
14
14
15
15
15
16
16
16
17
17
17
18
18
18
19
19
19
20
20
20
21
21
21
22
22
22
23
23
23
24
24
24
25
25
25
26
26
26
27 | Insurance | 23
27
27
28
28
28
29
29
29
30
30
30
31
31
31
Spreadsheet: 51711d1251330341-how-to-check-the-difference-when-given-a-report-with-two-different-format-mingali-example-1
Sheet: Format 1

 | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9
2009-01-01 00:00:00 | 10 | 17 | 24 | 31 | 38 | 45 | 52 | 59 | 66
2009-02-01 00:00:00 | 20 | 27 | 34 | 41 | 48 | 55 | 62 | 69 | 76
2009-03-01 00:00:00 | 30 | 37 | 44 | 51 | 58 | 65 | 72 | 79 | 86
2009-04-01 00:00:00 | 40 | 47 | 54 | 61 | 68 | 75 | 82 | 89 | 96
2009-05-01 00:00:00 | 50 | 57 | 64 | 71 | 78 | 85 | 92 | 99 | 106
2009-06-01 00:00:00 | 60 | 67 | 74 | 81 | 88 | 95 | 102 | 109 | 116
2009-07-01 00:00:00 | 55 | 62 | 69 | 76 | 83 | 90 | 97 | 104 | 111
2009-08-01 00:00:00 | 31 | 38 | 45 | 52 | 59 | 66 | 73 | 80 | 87
2009-09-01 00:00:00 | 65 | 72 | 79 | 86 | 93 | 100 | 107 | 114 | 121
2009-10-01 00:00:00 | 12 | 19 | 26 | 33 | 40 | 47 | 54 | 61 | 68
2009-11-01 00:00:00 | 51 | 58 | 65 | 72 | 79 | 86 | 93 | 100 | 107
2009-12-01 00:00:00 | 66 | 73 | 80 | 87 | 94 | 101 | 108 | 115 | 122
2010-01-01 00:00:00 | 86 | 93 | 100 | 107 | 114 | 121 | 128 | 135 | 142
2010-02-01 00:00:00 | 132 | 139 | 146 | 153 | 160 | 167 | 174 | 181 | 188
2010-03-01 00:00:00 | 152 | 159 | 166 | 173 | 180 | 187 | 194 | 201 | 208
2010-04-01 00:00:00 | 58 | 65 | 72 | 79 | 86 | 93 | 100 | 107 | 114
2010-05-01 00:00:00 | 96 | 103 | 110 | 117 | 124 | 131 | 138 | 145 | 152
Total | 1014 | 1133 | 1252 | 1371 | 1490 | 1609 | 1728 | 1847 | 1966
Spreadsheet: 355963d1414873749-seek-for-suggestions-on-how-to-display-the-data-for-easy-reference-customer-database-excel-forum-edited-
Sheet: Tables

Units |  | Parameters
[NAME] |  | Paramater | Value
B-15 |  | Booking Fee | 10000
D-25 |  | Earthworks | 0.1
I-64 |  | Piling | 0.1
I-65 |  | Sub Struc | 0.15
I-66 |  | Concrete | 0.15
K-75 |  | Walls | 0.1
 |  | Ceiling | 0.05
 |  | Wiring | 0.05
 |  | Plaster | 0.05
 |  | Roof | 0.05
 |  | Road | 0.05
 |  | CPC | 0.05
Spreadsheet: 835402d1688564424-complex-formula-split-text-into-several-chunks-based-on-character-count-test-copy
Sheet: Sheet1

 |  |  |  | Source copy: | Text_Chunk_1 | Text_Chunk_2 | Text_Chunk_3 | Text_Chunk_4 | Text_Chunk_5 | Text_Chunk_6 | Text_Chunk_7 | Text_Chunk_8 | Text_Chunk_9 | Text_Chunk_10 | Text_Chunk_11 | Text_Chunk_12 | Text_Chunk_13 | Text_Chunk_14 | Text_Chunk_15 | Text_Chunk_16 | Text_Chunk_17 | Text_Chunk_18 | Text_Chunk_19 | Text_Chunk_20 | Text_Chunk_21 | Text_Chunk_22 | Text_Chunk_23 | Text_Chunk_24 | Text_Chunk_25 | Text_Chunk_26 | Text_Chunk_27 | Text_Chunk_28 | Text_Chunk_29 | Text_Chunk_30 | Text_Chunk_31 | Text_Chunk_32 | Text_Chunk_33 | Text_Chunk_34 | Text_Chunk_35 | Text_Chunk_36 | Text_Chunk_37 | Text_Chunk_38 | Text_Chunk_39 | Text_Chunk_40 | Text_Chunk_41 | Text_Chunk_42 | Text_Chunk_43 | Text_Chunk_44
 |  |  |  | [NAME] ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Sapien eget mi proin sed libero enim sed faucibus turpis. Donec adipiscing tristique risus nec feugiat in fermentum. [NAME] ut porttitor [NAME] a [NAME] tempor. Eget duis at tellus at. Faucibus et molestie ac feugiat sed. Arcu felis bibendum ut tristique et egestas quis. Dictum varius duis at consectetur lorem donec. Ullamcorper a lacus vestibulum sed arcu. Eget felis eget nunc lobortis mattis. [NAME] eget egestas purus [NAME] in nisl. In hac habitasse platea dictumst quisque sagittis purus sit. [NAME] adipiscing enim [NAME] turpis egestas pretium aenean pharetra. Arcu ac tortor dignissim convallis aenean et tortor at risus. Egestas fringilla phasellus faucibus scelerisque eleifend donec pretium vulputate. [NAME] turpis nunc eget lorem dolor.  [NAME] augue ut lectus arcu bibendum at varius. Tristique risus nec feugiat in fermentum posuere urna nec. Sagittis vitae et leo [NAME] [NAME] porttitor. Eget egestas purus [NAME] in nisl nisi scelerisque eu. Tincidunt eget nullam non nisi est sit amet facilisis magna. [NAME] fringilla urna porttitor rhoncus dolor purus non enim praesent. Ut [NAME] [NAME] justo eget magna. Et malesuada fames ac turpis egestas integer. Mattis molestie a iaculis at erat pellentesque adipiscing. Condimentum vitae sapien pellentesque habitant morbi tristique senectus et. In fermentum posuere urna nec.  [NAME] rhoncus mattis rhoncus urna neque viverra justo nec. [NAME] duis ultricies lacus sed turpis tincidunt id. [NAME] sed vulputate mi sit amet [NAME].
Spreadsheet: 35434869-31d9-4278-a059-21872c0e11b5
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - General Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2012-11-06 00:00:00 | Governor
Summary By Counties | Ovide Lamontagne, r | [NAME], d | [NAME], [NAME] | [NAME]
Belknap | 15702 | 16756 | 821 | 25
Carroll | 12893 | 14339 | 664 | 15
Cheshire | 13490 | 25136 | 1228 | 41
Coos | 6069 | 8929 | 359 | 41
[NAME] | 16476 | 29412 | 1587 | 47
Hillsborough | 90621 | 104547 | 5749 | 193
Merrimack | 31127 | 46037 | 1887 | 85
Rockingham | 77095 | 84287 | 4358 | 144
[NAME] | 23387 | 37120 | 1831 | 52
[NAME] | 8166 | 12371 | 767 | 23
TOTALS | 295026 | 378934 | 19251 | 666
Belknap County | Lamontagne, r | [NAME], d | [NAME], [NAME] | [NAME]
Alton | 1966 | 1320 | 54 | 2
Barnstead | 1120 | 1198 | 72 | 1
Belmont | 1606 | 1888 | 105 | 2
Center Harbor | 342 | 350 | 13
Gilford | 2162 | 2257 | 95 | 8
Gilmanton | 1037 | 1076 | 53
[NAME] | 738 | 645 | 24 | 2
[NAME] | 463 | 605 | 38
[NAME] 3 | 590 | 738 | 27 | 2
[NAME] | 496 | 637 | 15
[NAME] | 414 | 587 | 42
[NAME] 6 | 782 | 831 | 38 | 2
Meredith | 1860 | 1973 | 104 | 2
New Hampton | 563 | 691 | 28 | 1
Sanbornton | 828 | 923 | 39 | 1
[NAME] | 735 | 1037 | 74 | 2
TOTALS | 15702 | 16756 | 821 | 25
Spreadsheet: kim_ward__20765__ISDA (revised)
Sheet: cws

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Tucson Electric Power Company | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX:
Incorporation State |  | S&P Rating | [NAME]
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX
BBB- or above | 4000000 | 15000000
BB & BB+ | 2500000 | 5000000
B+ & BB- | 1500000 | 3000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | [NAME] | [NAME] | Sr. Unsec.
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific | X
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 10
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7712
Spreadsheet: 475428d1471301071-remove-duplicate-rows-based-on-condition-book3
Sheet: Sheet1

10425324201
10425314301
10425265301
10425253201
10425206601
10425206201
10425111001
10425106401
10425096301
10425081501
10425052501 | 2015-01-15 00:00:00
10425052501
10425005901
10424988101
10424967801
10424935801 | 2013-01-12 00:00:00
10424871801 | 2015-01-06 00:00:00
Spreadsheet: 755877d1637160281-retrieve-specific-no-text-date-from-string-of-text-data_file
Sheet: Sheet1

Incorrect
Raw Data | Result (retrieve the numbers and underscore only - omit other characters) | Result (retrieve only 8 digits that are joined together) | Result (retrieve only the first date, if any, shld be in DD/MM/YYYY) | Result (retrieve second date in string, if any, shld be in DD/MM/YYYY)
Raja 20211113_83378- complete his project of 23/10/2021, by 25/10/2021
[NAME] has 81918191, by 21/10/2021 of 26/11/2021-
[NAME] has ABCD-1212-14444-4444 of 8811001 by 24/11/2021,
[NAME] has 2029221_2291A by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021*
Correct
Raw Data | Result (retrieve the numbers and underscore only - omit other characters) | Result (retrieve only 7 or 8 digits that are joined together) | Result (retrieve only the first date, if any, shld be in DD/MM/YYYY) | Result (retrieve second date in string, if any, shld be in DD/MM/YYYY)
Raja 20211113_83378- complete his project of 23/10/2021, by 25/10/2021 | 20211113_83378 | #N/A | 2021-10-23 00:00:00 | 2021-10-25 00:00:00
[NAME] has 81918191 by 21/10/2021 of 26/11/2021- | #N/A | 81918191 | 2021-10-21 00:00:00 | 2021-11-26 00:00:00
[NAME] has ABCD-1212-14444-4444 of 8811001 by 24/11/2021, | #N/A | 88110011 | 2021-11-24 00:00:00 | #N/A
[NAME] has 2029221_2291A by 28/10/2021 | 2029221_2291 | #N/A | 2021-10-28 00:00:00 | #N/A
[NAME] wants ABCD-111-222-991 of 25/10/2021* | #N/A | #N/A | 2021-10-25 00:00:00 | #N/A
Incorrect
Raw Data | Result (retrieve the numbers and underscore only - omit other characters) | Result (retrieve only 8 digits that are joined together) | Result (retrieve only the first date, if any, shld be in DD/MM/YYYY) | Result (retrieve second date in string, if any, shld be in DD/MM/YYYY)
Raja 20211113_83378- complete his project of 23/10/2021, by 25/10/2021
[NAME] has 81918191, by 21/10/2021 of 26/11/2021-
[NAME] has ABCD-1212-14444-4444 of 8811001 by 24/11/2021,
[NAME] has 2029221_2291A by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021*
Spreadsheet: 878676d1725914910-need-formula-to-pull-tasks-when-name-entered-into-table-need-formula-to-pull-tasks-when-name-entered-into-table
Sheet: Sheet1

 | Morning |  |  |  |  | Afternoon |  |  |  |  | Night
Tasks
Task1 | Kenny | Katyla |  |  |  | Kenny | Kayla |  |  |  | George
[NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
Task3 | [NAME] |  |  |  |  | [NAME]
Task4
Task5
Task6
Task7 | Laurence |  |  |  |  | Laurence | [NAME]
Task8 | Ciaran | [NAME] |  |  |  | Scott | [NAME] | Ciaran
Task9 | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
Task10 | Scott | [NAME]
Task11 | [NAME] |  |  |  |  | [NAME]
Task12
Task13 | [NAME] | [NAME] | George | Mark |  | [NAME] | [NAME] | George | Mark |  | [NAME] | [NAME] | [NAME]
 | Morning | AfternoonNight |  |  |  |  | Morning | AfternoonNight
Kenny | Task1 | [NAME] |  |  |  | Kenny
George | Task13 | Task13 | Task1 |  |  | George
Spreadsheet: 157890d1337901192-sort-list-according-to-order-in-master-list-formula-sortbymaster
Sheet: Sheet1

MasterList | Unsorted List | Sorted List
Cat | Cow | Cat
Dog | Dog | Dog
Fish | Fish | Fish
Bird | Cat | Cow
Rat | Horse | Horse
[NAME]
Cow
Horse
Zebra
 | Start with the Unsorted List, and sort entries to Sorted List in same order as shown in Master List
Spreadsheet: 112560d1308668743-excel-2007-multiple-cells-filled-in-based-on-dropdown-list-ddselection1
Sheet: Sheet1

 |  |  |  | Used | 3 | Truck
 |  |  |  | New | 1 | Truck
 |  |  |  | New | 2 | Van
 |  |  |  | Used | 3 | Truck
 |  |  |  | Used | 4 | Van
 |  |  |  | Sold | 5 | Truck
 |  |  |  | Sold | 6 | Van
 |  |  |  | Write Off | 7 | Junk
Spreadsheet: 49940d1249373239-using-variable-array-formulae-array-formulae
Sheet: Sheet1

 |  | Date |  | Events Scheduled
 |  | 2009-08-01 00:00:00 |  | A |  | C | D |  | F
 |  | 2009-08-02 00:00:00 |  |  |  | C
 |  | 2009-08-03 00:00:00 |  | A | B
 |  | 2009-08-04 00:00:00 |  |  | B |  |  |  |  | G
 |  | 2009-08-05 00:00:00 |  | A | B |  |  | E
 |  | 2009-08-06 00:00:00 |  |  |  |  | D
 |  | 2009-08-07 00:00:00 |  | A
 |  | 2009-08-08 00:00:00
 |  | 2009-08-09 00:00:00
 |  | 2009-08-10 00:00:00
 |  | 2009-08-11 00:00:00
 |  | 2009-08-12 00:00:00
 |  | 2009-08-13 00:00:00
 |  | 2009-08-14 00:00:00
 |  | 2009-08-15 00:00:00
 |  |  |  |  | DESIRED RESULTS: |  |  |  |  |  |  |  |  | EXPERIMENTAL RESULTS
 |  | First | Last |  | Second | First | Scheduled | First | Second |  |  |  |  | Second | First | Scheduled | First |  | Second
 |  | in A1:L20 | in A1:L20 |  | Before | Before | Today? | After | After |  |  |  |  | Before | Before | Today? | After |  | After
 |  |  |  |  | Today | Today |  | Today | Today |  |  |  |  | Today | Today |  | Today |  | Today
 |  |  |  |  | (4-Aug-09) | (4-Aug-09) | (4-Aug-09) | (4-Aug-09) | (4-Aug-09) |  |  |  |  | (4-Aug-09) | (4-Aug-09) | (4-Aug-09) | (4-Aug-09) |  | (4-Aug-09)
 | A | 2009-08-01 00:00:00 | 2009-08-07 00:00:00 |  | 2009-08-01 00:00:00 | 2009-08-03 00:00:00 | no | 2009-08-05 00:00:00 | 2009-08-07 00:00:00 |  |  |  |  |  |  | no | no | 2009-08-12 00:00:00
 | B | 2009-08-03 00:00:00 | 2009-08-05 00:00:00 |  | None | 2009-08-03 00:00:00 | yes | 2009-08-05 00:00:00 | None |  |  |  |  |  |  | no | no | 2009-08-03 00:00:00
 | C | 2009-08-01 00:00:00 | 2009-08-02 00:00:00 |  | 2009-08-01 00:00:00 | 2009-08-02 00:00:00 | no | None | None |  |  |  |  |  |  | no | no | 2009-08-01 00:00:00
 | D | 2009-08-01 00:00:00 | 2009-08-06 00:00:00 |  | None | 2009-08-01 00:00:00 | no | 2009-08-06 00:00:00 | None |  |  |  |  |  |  | no | no | 2009-08-01 00:00:00
 | E | 2009-08-05 00:00:00 | 2009-08-05 00:00:00 |  | None | None | no | 2009-08-05 00:00:00 | None |  |  |  |  |  |  | no | 2009-08-05 00:00:00 | 2009-08-05 00:00:00
 | F | 2009-08-01 00:00:00 | 2009-08-01 00:00:00 |  | None | 2009-08-01 00:00:00 | no | None | None |  |  |  |  |  |  | no | no | 2009-08-01 00:00:00
 | G | 2009-08-04 00:00:00 | 2009-08-04 00:00:00 |  | None | None | yes | None | None |  |  |  |  |  |  | yes | no | 2009-08-04 00:00:00
 | H | Is Error | Is Error |  | Is Error | Is Error | Is Error | Is Error | Is Error |  |  |  |  |  |  | Is Error | Is Error | Is Error
 | this array formula builds text string for required array up to and including today
 | $A$1:$L$7 |  | CONCATENATE("$A$1:",ADDRESS(SMALL(IF($A$1:$C$20=TODAY(),ROW($A$1:$L$20)),ROW($1:$1)),12,1,TRUE,))
 | ROW($A$1:$L$7) |  | CONCATENATE("ROW($A$1:",ADDRESS(SMALL(IF($A$1:$C$20=TODAY(),ROW($A$1:$L$20)),ROW($1:$1)),12,1,TRUE,),")")
 | 1 |  | ROW($A$1:$A$7)