tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842382d1694480832-conditional-formatting-based-upon-dates-quibilty-dates-reocurring
Sheet: Sheet1

2024-01-19 00:00:00
2024-02-02 00:00:00
2024-02-16 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-03-29 00:00:00
2024-04-12 00:00:00
2024-04-26 00:00:00
2024-05-10 00:00:00
2024-05-24 00:00:00
2024-06-07 00:00:00
2024-06-21 00:00:00
2024-07-05 00:00:00
2024-07-19 00:00:00
2024-08-02 00:00:00
2024-08-16 00:00:00
2024-08-30 00:00:00
2024-09-13 00:00:00
2024-09-27 00:00:00
2024-10-11 00:00:00
2024-10-25 00:00:00
2024-11-08 00:00:00
2024-11-22 00:00:00
2024-12-06 00:00:00
2024-12-20 00:00:00
2025-01-03 00:00:00
2025-01-17 00:00:00
2025-01-31 00:00:00
2025-02-14 00:00:00
2025-02-28 00:00:00
2025-03-14 00:00:00
2025-03-28 00:00:00
2025-04-11 00:00:00
2025-04-25 00:00:00
2025-05-09 00:00:00
2025-05-23 00:00:00
2025-06-06 00:00:00
2025-06-20 00:00:00
2025-07-04 00:00:00
2025-07-18 00:00:00
2025-08-01 00:00:00
2025-08-15 00:00:00
2025-08-29 00:00:00
2025-09-12 00:00:00
2025-09-26 00:00:00
2025-10-10 00:00:00
2025-10-24 00:00:00
2025-11-07 00:00:00
2025-11-21 00:00:00
2025-12-05 00:00:00
2025-12-19 00:00:00
2026-01-02 00:00:00
Spreadsheet: 204281d1357422848-sorting-and-counting-letters-letter-counter
Sheet: Sheet1

I LOVE YOU DAD XXX |  |  |  |  | A | 10
HAPPY BIRTHDAY SARAH X |  |  |  |  | B | 1
Congratulations |  |  |  |  | C | 1
So long and thanks for all the fish |  |  |  |  | D | 4
 |  |  |  |  | E | 2
 |  |  |  |  | F | 2
 |  |  |  |  | G | 2
 |  |  |  |  | H | 6
 |  |  |  |  | I | 4
 |  |  |  |  | J | 0
 |  |  |  |  | K | 1
 |  |  |  |  | L | 5
 |  |  |  |  | M | 0
 |  |  |  |  | N | 5
 |  |  |  |  | O | 7
 |  |  |  |  | P | 2
 |  |  |  |  | Q | 0
 |  |  |  |  | R | 4
 |  |  |  |  | S | 5
 |  |  |  |  | T | 5
 |  |  |  |  | U | 2
 |  |  |  |  | V | 1
 |  |  |  |  | W | 0
 |  |  |  |  | X | 4
 |  |  |  |  | Y | 3
 |  |  |  |  | Z | 0
Spreadsheet: 146406d1332171062-pricing-grid-for-t-shirt-pricing-screen-printing-prices
Sheet: Sheet2

 |  | Qty | Price
 | Item | 5 | 60
 | Quantity | 12
 | Front Color(s) | 3
 | Back Color(s)
 | [NAME])
 | [NAME])
 | Film Front |  | 30
 | Film Back |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | Screen(s) Front |  | 60
 | [NAME]) Back |  | 0
 | [NAME]) [NAME] |  | 0
 | [NAME]) [NAME] |  | 0
 | Print Front |  | 5.15
 | Print Back
 | [NAME]
 | [NAME]
 | Other |  | 0
 | Other |  | 0
 | Other |  | 0
 | Subtotal
 | Tax
 | Total
 | Deposit
Spreadsheet: 177159d1346210396-separate-text-from-alphanumeric-cells-to-columns-copy-of-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Material Name | Materials Needed | Materials On Hand | Remaining
 |  |  |  |  |  |  |  | Isogen |  | 120294
 |  |  |  |  |  |  |  | Megacyte |  | 17600
 |  |  |  |  |  |  |  | Mexallon |  | 442305
Rorqual  Materials |  | Total Needed |  |  |  |  |  | Nocxium |  | 32113
 |  |  |  |  |  |  |  | Pyerite |  | 1649086
Material Name | Materials Needed | For This Part | Materials On Hand | Remaining |  |  |  | Tritanium |  | 9027335
Capital Armor Plates | 8 |  |  | Processing |  |  |  | Zydrine |  | 5713
Isogen | 8637 |  |  | Processing
Megacyte | 185 |  |  | Processing
Mexallon | 52639 |  |  | Processing
Nocxium | 2601 |  |  | Processing
Pyerite | 135008 |  |  | Processing
Tritanium | 574866 |  |  | Processing
Zydrine | 414 |  |  | Processing
Capital Capacitor Battery | 14 |  |  | Processing
Isogen | 7825 |  |  | Processing
Megacyte | 170 |  |  | Processing
Mexallon | 48049 |  |  | Processing
Nocxium | 2237 |  |  | Processing
Pyerite | 131028 |  |  | Processing
Tritanium | 397273 |  |  | Processing
Zydrine | 401 |  |  | Processing
Capital Cargo Bay | 27 |  |  | Processing
Isogen | 4258 |  |  | Processing
Megacyte | 39 |  |  | Processing
Mexallon | 29908 |  |  | Processing
Nocxium | 1212 |  |  | Processing
Pyerite | 87668 |  |  | Processing
Tritanium | 1063006 |  |  | Processing
Zydrine | 174 |  |  | Processing
Capital Clone Vat Bay | 41
Isogen | 10799
Megacyte | 270
Mexallon | 58892
Nocxium | 3174
Pyerite | 169603
Tritanium | 778078
Zydrine | 657
Capital Computer System | 41
Isogen | 7996
Megacyte | 180
Mexallon | 53594
Nocxium | 2257
Pyerite | 134999
Tritanium | 519665
Zydrine | 394
Capital Construction Parts | 54
Isogen | 6202
Megacyte | 128
Mexallon | 45841
Nocxium | 1859
Pyerite | 113939
Tritanium | 471672
Zydrine | 327
Capital Corporate Hangar Bay | 20
Isogen | 11325
Megacyte | 265
Mexallon | 62325
Nocxium | 3254
Pyerite | 176982
Tritanium | 70882
Zydrine | 570
Capital Drone Bay | 7
Isogen | 5466
Megacyte | 104
Mexallon | 40499
Nocxium | 1528
Pyerite | 101146
Tritanium | 421803
Zydrine | 296
Capital [NAME] | 14
Isogen | 10469
Megacyte | 270
Mexallon | 60645
Nocxium | 2732
Pyerite | 173393
Tritanium | 911147
Zydrine | 552
Capital Power Generator | 14
Isogen | 9102
Megacyte | 203
Mexallon | 55430
Nocxium | 2662
Pyerite | 134152
Tritanium | 619831
Zydrine | 443
Capital Propulsion Engine | 11
Isogen | 8429
Megacyte | 184
Mexallon | 51023
Nocxium | 2564
Pyerite | 134155
Tritanium | 555316
Zydrine | 367
Capital Sensor Cluster | 11
Isogen | 8091
Megacyte | 181
Mexallon | 49665
Nocxium | 2192
Pyerite | 122746
Tritanium | 538963
Zydrine | 405
Capital Shield Emitter | 11
Isogen | 8832
Megacyte | 201
Mexallon | 52481
Nocxium | 2471
Pyerite | 127522
Tritanium | 606139
Zydrine | 423
Capital Ship Maintenance Bay | 41
Isogen | 10947
Megacyte | 252
Mexallon | 64774
Nocxium | 2990
Pyerite | 230780
Tritanium | 700762
Zydrine | 555
Spreadsheet: 65870d1266510915-transferring-and-looking-up-name-checker
Sheet: Sheet1

 |  | quote |  | sales members
 | quote number | r/q52 |  | dd | [NAME] duck | 111
 | quote number | [NAME]/q52 |  | [NAME] | [NAME] | 222
 |  |  |  | btm | batman | 333
 |  |  |  | r | [NAME] | 444
 |  |  |  | s | spiderman | 555
 |  |  |  | return name
 |  |  |  | and number
 |  |  |  | in red cell
Spreadsheet: 711356d1609638753-multiple-ifs-multiple-conditions-multiple-choices-big-excel-problem-1-
Sheet: Sheet1

ORIGINAL |  |  |  |  |  |  |  |  |  |  | SOLUTION
Fiscal year | Fiscal year/period | Order | D1 | D2 | Type | BU | INSTRUCTIONS :)  1. GREEN GETS CARRIED DOWN TO BOTTOM OF TABLE  2. ALL BLUE IS FILLED OUT TO MATCH THE ABOVE ORDER NUMBER IF THEY ARE THE SAME   I.E ROW 21 WILL = ROW 20 SINCE ALL BLANK I.E ROW 29 WILL = ROW 28 SINCE ORDER NUMBER IS THE SAME  3. HARDEST THING! FOR EACH ORDER NUMBER THERE CAN ONLY BE ONE TYPE OF "ORDER TYPE"  I. ROW 7 HAS THE SAME ORDER TYPE AS ROW 6 THEREFORE "NOT ASSIGNED" WILL HAVE TO BECOME "helo" - SIMILIAR TO 23 AND 24 |  |  |  | Fiscal year | Fiscal year/period | Order | D1 | D2 | Type | BU
1990 | 1 | [PHONE] | a | 4673 | Not assigned | ZS24 |  |  |  |  | 1990 | 1
 |  | [PHONE] | b | 4673 | Not assigned
 |  | [PHONE] | c | 4823 | Not assigned | ZS24
 |  | [PHONE] | d | 4489 | [NAME] | ZS24
 |  | [PHONE] |  |  | Not assigned | ZS24
 |  | [PHONE] | b | 4917 | Not assigned | ZS24
 |  | [PHONE] | d | NGIO | Not assigned | ZS54
 |  | [PHONE] | a | 5000 | Not assigned | ZS54
 |  | [PHONE] | b | 6181 | Not assigned | ZS24
 |  | [PHONE] | c | 500 | Not assigned | ZS54
 |  | [PHONE] | d | ORUM | Not assigned | ZS54
 |  | [PHONE] | a | III | Not assigned | ZS54
 |  | [PHONE] | b | ULTI | Not assigned | ZS54
 |  |  |  | ULTI | Not assigned
 |  | [PHONE] | d | 6497 | Not assigned | ZS24
 |  | [PHONE] | a | R Z1 | Not assigned | ZS24
 |  | [PHONE] | b | ULTI | Not assigned | ZS54
 |  | [PHONE] | d | 700 | Not assigned | ZS54
 |  | [PHONE] | a | 740 | Not assigned | ZS54
 |  | [PHONE] | b |  | new years | ZS54
 |  | [PHONE] | c | 5000 | Not assigned | ZS54
 |  | [PHONE] | d | ORUM | Not assigned | ZS54
 |  | [PHONE] | a | ORUM | Not assigned | ZS54
 |  | [PHONE] | c | X 5 | Not assigned | ZS24
 |  | [PHONE] | b | 600 | Not assigned | ZS54
Spreadsheet: 57a24a5c-7920-4a3b-b987-fa248bc34a7a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Name___________________________________________ |  |  | I.D.#____________________
 | BA Chinese Studies
Area of Concentration Requirements | The Chinese Studies major consists of 30 hours, of which at least 21 hours must be at the 3000 or 4000-level; these will normally include a minimum of 12 hours in advanced Chinese. Courses must be taken from at least three disciplines. In addition, a 3-hour senior project on a China-related topic must be completed through one of the participating departments. Students of the major will be encourged to complete a study abroad program in China for at least one semester. All courses taken through affiliated programs will be evaluated for transfer credit toward the major on a case by case basis by the Director.
1.  You must have a minimum GPA of 2.2 in your area of
concentration and a minimum of 2.0 TU GPA in order
to graduate.
2.  No Pass/D/F or CLEP credit may be applied toward
your Area of Concentration.
 | The following required courses form the 9-credit core of the major:
3.  Courses applied to meet Core and General Curriculum |  |  |  | HR | GR | SM
requirements cannot also apply in your Area of | 1.)  CHIN 3113 Chinese through Literature I |  |  | _____ | _____ | _____
Concentration.
 | 2.)  HIST 2613 China and Japan from Antiquity to 1800 (or) |  |  | _____ | _____ | _____
4.  Two thirds of the course work in your Major [NAME] | HIST 2623 China and Japan since 1800 |  |  | _____ | _____ | _____
must be at the 3000 or 4000 level.
 | 3.)  POL 2043 Politics and Culture of China |  |  | _____ | _____ | _____
5.    Subjects in your Minor Field must be selected in
conjunction with your [NAME].
 | The remaining 21 credits should be taken in at least three different disciplines with no
6.  No more than 55 hours may be earned in the Area of | fewer  than 18 credits at the 3000 or 4000-level:
Concentration, and no more than 39 of these may be | ___________________________________________ |  |  | _____ | _____ | _____
earned in the major subject. These totals may be | ___________________________________________ |  |  | _____ | _____ | _____
exceeded only by the number of hours beyond the | ___________________________________________ |  |  | _____ | _____ | _____
124 required for graduation. | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
 | Minor - 12 hours with at least 6 hours at the 3000 or 4000-level:
 | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
 | ___________________________________________ |  |  | _____ | _____ | _____
Spreadsheet: 264624d1378923219-populate-required-fields-with-data-from-various-worksheets-based-on-drop-down-list-employee-review
Sheet: August

Employee | Performance 1 | Performance 2 | Performance 3 | Performance 4 | Team
Mr Black | 33 | 34 | 35 | 36 | A Team
Mr Green | 37 | 38 | 39 | 40 | B Team
Ms. [NAME] | 41 | 42 | 43 | 44 | C Team
Mrs. [NAME] | 45 | 46 | 47 | 48 | D Team
Spreadsheet: 486799d1477665985-formula-for-counting-of-times-2-sets-of-data-shows-up-table
Sheet: 2016DietLog

Month | Date | Day | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal | Meal
January | 2016-01-01 00:00:00 | Fri | Egg | PBJ | [NAME] | [NAME] | Rehab | Apple | No Junk
January | 2016-01-02 00:00:00 | Sat | Salad | PBJ | Cheese Ravioli | Rehab
January | 2016-01-03 00:00:00 | Sun | PBJ | Salad | PBJ | Rehab | Apple
January | 2016-01-04 00:00:00 | Mon | Egg | PBJ | Salad | PBJ | Rehab | Rehab | Apple
January | 2016-01-05 00:00:00 | Tue | Egg | PBJ | Chicken | Sweet Potato | PBJ | Rehab | Rehab
January | 2016-01-06 00:00:00 | Wed | Egg | PBJ | Baked Ziti | [NAME] | [NAME] | Rehab
January | 2016-01-07 00:00:00 | Thu | PBJ | Qdoba | Rehab | Rehab
February | 2016-01-08 00:00:00 | Fri | Egg | PBJ | [NAME] | PBJ | Rehab | Rehab
February | 2016-01-09 00:00:00 | Sat | Salad | Salad | [NAME] | Rehab | Rehab | Apple
February | 2016-01-10 00:00:00 | Sun | PBJ | Quesadilla | Quesadilla | Rehab | Apple
February | 2016-01-11 00:00:00 | Mon | Egg | Salad | Cheese Ravioli | [NAME] | Rehab | Apple
February | 2016-01-12 00:00:00 | Tue | Egg | Salad | Chicken | Brocoli | Sweet Potato | Rehab | Rehab | Apple
February | 2016-01-13 00:00:00 | Wed | Egg | Salad | Salad | PBJ | Rehab | Rehab
Spreadsheet: 859186d1707653943-detect-repeat-multiple-values-in-a-row-and-highlight-them-based-on-number-of-repeats-book1-1-
Sheet: Sheet1

 | CARR | BOWEN | ATKINS | WILSON | BRADY
1 | 1 | 12 | 22 | 11 | 17
2 | 15 | 18 | 20 | 20 | 18
3 | 12 | 21 | 15 | 9 | 19
4 | 11 | 22 | 9 | 15 | 16
5 | 2 | 23 | 6 | 13 | 13
6 | 8 | 17 | 3 | 7 | 15
7 | 8 | 18 | 3 | 6 | 19
8 | 6 | 14 | 2 | 11 | 18
9 | 1 | 17 | 1 | 10 | 17
10 | 3 | 18 | 2 | 9 | 16
11 | 1 | 19 | 2 | 9 | 17
12 | 1 | 19 | 2 | 9 | 19
13 | 1 | 17 | 2 | 7 | 19
14 | 5 | 14 | 2 | 7 | 20
15 | 3 | 16 | 3 | 6 | 20
16 | 3 | 12 | 3 | 6 | 19
17 | 3 | 11 | 4 | 7 | 15
18 | 4 | 9 | 3 | 9 | 13
19 | 3 | 11 | 4 | 9 | 13
20 | 4 | 8 | 5 | 11 | 12
21 | 6 | 6 | 5 | 9 | 12
22 | 6 | 9 | 6 | 8 | 10
23 | 8 | 8 | 4 | 8 | 11
24 | 8 | 8 | 4 | 8 | 10
25 | 8 | 5 | 3 | 8 | 9
26 | 8 | 7 | 5 | 8 | 9
27 | 7 | 8 | 4 | 8 | 9
28 | 6 | 9 | 4 | 8 | 9
29 | 6 | 9 | 5 | 8 | 11
30 | 6 | 10 | 7 | 9 | 11
31 | 6 | 10 | 4 | 9
32 | 6 | 7 | 3 | 9
33 | 6 | 8 | 3 | 9
34 | 6 | 9 | 5 | 8
35 | 6 | 8 | 3 | 9
36 | 5 | 8 | 4 | 9
37 | 5 | 8 | 4 | 8
38 | 5 | 7 | 4 | 9
39 | 5 | 7 | 5 | 11
40 | 5 | 7 | 4 | 11
41 | 5 | 7 | 6 | 11
42 | 4 | 7 | 7 | 15
43 | 6 | 6 | 7 | 12
44 | 5 | 7 | 5 | 14
45 | 5 | 7 | 5 | 15
46 | 5 | 7 | 4 | 18
End | 6 | 8 | 4 | 18
Spreadsheet: 03a47e25-e8f7-4c3d-8fb8-a89f4283ec7a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8898 | 46519 | Viktor | Kuznetsov | RUS | 23 | [NAME] | 00:00:29 | 00:37:27 | 00:00:33 | 00:27:52 | 1 | 01:31:28
8898 | 28254 | Pavel | Yakimov | RUS | 21 | [NAME] | 00:00:30 | 00:38:01 | 00:00:27 | [NAME] | 2 | 01:31:52
8898 | 68548 | Dmitry | Koltsov | RUS | 26 | 00:26:13 | 00:00:27 | 00:38:55 | [NAME] | 00:29:08 | 3 | 01:35:20
8898 | 55605 | Sander | Linnus | EST | 22 | 00:27:46 | [NAME] | 00:37:53 | 00:00:44 | 00:30:29 | 4 | 01:37:18
8898 | 39192 | Evgeny | Bayguzov | RUS | 27 | 00:27:46 | 00:00:25 | 00:39:47 | [NAME] | 00:28:54 | 5 | 01:37:29
8898 | 28394 | Martin | Husek | CZE | 24 | 00:28:00 | 00:00:40 | 00:38:41 | 00:01:12 | 00:30:46 | 6 | 01:39:19
Spreadsheet: 215337d1361351708-need-to-sum-the-number-of-records-when-a-value-is-greater-than-0-data-test
Sheet: sheet 1

2012 - 2013 EPL | Profit | Stake | ROI
Market | P&L | Stake | ROI
Half Time Draw
Total Goals
Accumalator
Draw
Away Team Lay
Half Time Home Win
[NAME]
Home Win
Clean Sheet
Highest Scoring Half
BTTS No
1st Goal
Under 2.5
Under 3.5
Win to 0
Half Time Home Win Lay
[NAME]
Winning Margin
Win Both 1/2's
DNB
Over 3.5
1st half Over 1.5
Team Goals
Over 2.5
HT/FT
Home Team Lay
TOFG
BTTS
Spreadsheet: 128924d1321356500-separating-text-query-excel-help
Sheet: Sheet1

No. | Data | What I need
1 | 111 | 1 | 1 | 1
2 | 6X9 | 6 | X | 9
3 | 08X | 0 | 8 | X
4 | X72 | X | 7 | 2
5 | 7X4 | 7 | X | 4
6 | 101 | 1 | 0 | 1
7 | LX0 | L | X | 0
8 | 88 |  | 8 | 8
9 | 142 | 1 | 4 | 2
10 | 2X1 | 2 | X | 1
11 | 14X | 1 | 4 | X
12 | 20X | 2 | 0 | X
13
14 | 2X |  | 2 | X
15 | 54X | 5 | 4 | X
16 | 5X |  | 5 | X
17
18
19 | 9 |  |  | 9
20 | 89X | 8 | 9 | X
Spreadsheet: 1b365a89-1c94-4736-9e10-51c803b007b5
Sheet: Sheet1

Communication Studies @ Southwestern | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Worksheet for the Major
In order to complete a BA in Communication Studies, students must complete all general education requirements and 10 courses (40 credits) in the major--6 required COM courses and 4 COM electives (refer to the SU Catalog for detailed requirements).  To facilitate your learning, courses central to the major include a prerequisite structure that must be followed sequentially, which means you may not concurrently enroll in the prerequisite and the course requiring the prerequisite. It will take students a minimum of 4 semesters to sequence through and complete the major.
[NAME] (2):  Both courses are required for the major and should be taken as early as possible.  These courses are prerequisites for the Core, Writing Intensive, and Capstone.   (see [NAME] for specific requirements).
Course # | Course Name | Prerequisites | Semester Taken
75-134 | Critical/Cultural CommStudies (formerly Intro)
75-154 | Narrative/Image/Self/Audience (formerly PubSpeaking)
II. Core Courses (2):  These 2 courses are required of all majors and cover the two main theoretical areas that comprise the major.  Each Core Course requires the completion of 133/134 and 153/154.  Furthermore, each Core Course serves as a prerequisite for at least one writing intensive course.
Course # | Course Name | Prerequisites | Semester Taken
75-204 | Rhetorical Theory (formerly Rhetorical Traditions) | 75-134, 154
75-604 | Media and Culture | 75-134, 154
III. Writing Intensive Courses (1):  Select 1 of the courses listed below.  Each course requires the completion of 133/134, 153/154, and the associated Core Course.  Writing Intensive courses also teach students research methods.
Course # | Course Name | Prerequisites | Semester Taken
75-214 | Rhetorical Criticism | 75-134, 154, & 204
75-744 | Sonic Communication (75-304 sp13) | 75-134, 154, & 604
75-414 | Writing Culture | 75-134, 154, & 204, 404, or 604
75-784 | Visual Communication | 75-134, 154, & 604
IV. Capstone Research Seminar (1):  After completing the Foundational Courses, Core Courses, and Writing Intensive Course, students may enroll in Capstone.
Course # | Course Name | Prerequisites | Semester Taken
75-964 | Capstone Research Seminar | 75-134, 154, 204, 604 and 1 writing intensive
[NAME] (4):  In addition to the required courses listed above, students must complete four 4-credit elective courses in the major.  Many of these courses have no pre-reqs and can thus be taken at any time.  See the Catalog for specific requirements.
Course # | Course Name | Prerequisites | Semester Taken
75- |  | varies
75- |  | varies
75- |  | varies
75- |  | varies
 |  |  | revised 3/19/2013
Spreadsheet: 157778d1337870780-combining-rows-with-similar-data-not-exact-example
Sheet: Sheet1

GIVEN
EMPLOYEE NUMBER | PERSON ID | ASSIGNMENT NUMBER | FULL NAME | START DATE | POSITION | JOB | [NAME] | ORGANIZATION | ASSIGNMENT START DATE START DATE | ASSIGNMENT END DATE
123456 | 6565 | 72763 | Doe, [NAME] | 2009-09-03 00:00:00 | Workstudy Student.2562 | WS | MN | Games | 2009-11-01 00:00:00 | 2010-08-15 00:00:00
123456 | 6565 | 72763-2 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.4366 | Student Worker | MN | Games | 2010-08-16 00:00:00 | 2010-11-15 00:00:00
123456 | 6565 | 72763-2 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.4366 | Student Worker | MN | Games | 2010-11-16 00:00:00 | 2011-03-05 00:00:00
123456 | 6565 | 72763-2 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.12200 | Student Worker | MN | OtherOrg | 2011-03-06 00:00:00 | 2012-12-31 00:00:00
123456 | 6565 | 72763-3 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.12254 | Student Worker | MN | Facilities Team | 2011-04-03 00:00:00 | 2012-02-19 00:00:00
Want
EMPLOYEE NUMBER | PERSON ID | ASSIGNMENT NUMBER | FULL NAME | START DATE | POSITION | JOB | [NAME] | ORGANIZATION | ASSIGNMENT START DATE START DATE | ASSIGNMENT END DATE
123456 | 6565 | 72763 | Doe, [NAME] | 2009-09-03 00:00:00 | Workstudy Student.2562 | WS | MN | Games | 2009-11-01 00:00:00 | 2010-08-15 00:00:00
123456 | 6565 | 72763-2 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.4366 | Student Worker | MN | Games | 2010-08-16 00:00:00 | 2011-03-05 00:00:00
123456 | 6565 | 72763-2 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.12200 | Student Worker | MN | GamesArea | 2011-03-06 00:00:00 | 2012-12-31 00:00:00
123456 | 6565 | 72763-3 | Doe, [NAME] | 2009-09-03 00:00:00 | Student Worker.12254 | Student Worker | MN | Facilities Team | 2011-04-03 00:00:00 | 2012-02-19 00:00:00
Spreadsheet: 95236d1294867547-conditional-formatting-within-a-table-excel-forum-help
Sheet: Sheet1

Sample Table
Table based on Dates and US Number
Today's Date:
Supplier Number | [NAME] | Active | U.S. Number | Country | Date Signed | Expiration Date
1 | Sample 1 | Y | 12-3456789 | Canada | 2008-12-12 00:00:00
2 | Sample 2 | Y | 23-4567264 | Canada | 2009-09-30 00:00:00
3 | Sample 3 | N |  | Nigeria | 2007-05-22 00:00:00
4 | Sample4 | Y | 35-4565454 | England | 2003-11-13 00:00:00
5 | Sample 5 | Y |  | Canada | 2010-01-22 00:00:00
6 | Sample 6 | Y |  | [NAME] | 2010-04-16 00:00:00
Spreadsheet: 0bb2f61f-df78-4095-9f1c-4552d153071a
Sheet: Sheet1

Ref # | Part # | Description | Notes
AG2 | 026607-Z | HANDLEBAR ASSEMBLY | Includes HPS and N63
AN3 | 018100-AA | FRAME CONSOLE ASSEMLBY
CNS | 071872 | CNS PD7
COS | 062362-ZUP | OVERLAY CONSOLE ASSEMBLY PLATFORM DELUXE | Includes plate and overlay, and N13 only
HPS | 026768-Z | GRIP HEART RATE | Includes G09,G10,and [NAME]
[NAME] | 007806-D | PLATE CONTACT HR
G10 | 004339-00 | [NAME] [NAME]
G11 | 004880-00 | NUT M3
G52 | 004706-A | [NAME]
N01 | 062917-AAX | COVER CONSOLE UPPER PLATFORM
N02 | 062918-AAX | COVER CONSOLE LOWER PLATFORM
N11 | 001485-BA | REED SWITCH BRACKET
N12 | 001961-D2 | REED SWITCH
N13 | 000890-AA | RACK READING INSERTS
[NAME] | 000799-BA | HOLDER BOTTLE
N15 | 004351-00 | [NAME]
N16 | 004612-00 | BOLT BH M3X8 TAPPING
N17 | 004612-AB | SCREW BH M3X8
N18 | 005091-Z | WASHER FT 4X10X1.2
N23 | 004860-AB | SCREW BH M4X0.7X8L OVERSIZE
N24 | 004369-00 | SCREW BH M5X15
N28 | 004612-AB | SCREW BH M3X8
N60 | 057765-AAX | UPPER BOARD DELUXE TCD7
N62 | 056525-A | KEYPAD MEMBRANE 19 KEY
N63 | 002337-A | WIRE HRT CONNECTING TCPD6
N65 | 038132-BBX | BOARD RECEIVER HR CONTACT
[NAME] | 024272-BX | RECEIVER HRT DELUXE/PREMIER
V01 | 064225-AX | DECAL VF MOTOR COVER
V10 | 006130-AX | DECAL SAFETY KEY TCPD6
NOT SHOWN | 013860-B | SAFETY KEY ASSEMBLY
NOT SHOWN | [NAME] | TRANSMITTER W/ STRAP KIT
NOT SHOWN | 062947-BX | MANUAL ASSEMBLY PLATFORM  CONSOLE
NOT SHOWN | 056835-AX | MANUAL OWNER SIMPLE/DELUXE
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 14b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 3 | 0 | 1 | 4
Index | 2274 | 2217 | 3991 | 8482
Other | 0 | 0 | 31 | 31
TOTAL | 2277 | 2217 | 4023 | 8517
Spreadsheet: 884602d1733834982-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User2

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-11-19 00:00:00 |  |  |  | 2024-12-02 00:00:00
 | Pliers | Knipex Five Holes | 32.04 | y | Screwdriver | Wera Slotted Screwdriver Bit, SL4 Tip | 3.63 | N
Total