tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145339d1331542306-need-help-regarding-graph-bidyut_review-format_chart
Sheet: MONTH 1 (2)

[NAME] : |  |  | BIDYUT GANGULY
MONTH : |  |  | 2012-03-01 00:00:00
 |  | DOJ | NAME | HQ | PRI SALES | SEC SALES | DR. CALL
BE | 1 | 2011-10-01 00:00:00 | [NAME] | Sonarpur | 20000 | 15000 | 250
BE | 2 | 2012-01-04 00:00:00 | [NAME] | D Harbor | 18000 | 12000 | 300
BE | 3 | 2011-10-01 00:00:00 | S.S.Roy | Midnapur | 25000 | 10000 | 270
BE | 4 | 2011-10-01 00:00:00 | Sumit Mahapatra | Contai | 15000 | 9000 | 280
EMPLOYEE STRENGTH |  |  |  | TOTAL SALE :
VACCANT HQ |  |  |  | PCPM :
Spreadsheet: 125918d1319383667-multiple-matching-and-indexing-with-null-logic-797818-multiple-matching-and-indexing-test
Sheet: 1

part Number |  |  |  | combined | 2 | 3 | 4
90-4523
90-6544
33-778
34-5432
90-3344
90-7754
54-7886
12-3456
Spreadsheet: 130b6a3b-aa40-49b1-866e-ade7c341d714
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-08-06 09:34:40.270000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.542 | 101.417 | 101.292 | 100.917
3.75 | 101.393 | 101.268 | 101.143 | 100.768 |  | Note: | Refer To Price [NAME]
3.625 | 100.981 | 100.856 | 100.731 | 100.356 |  |  | For all Price Adjs
3.5 | 100.332 | 100.207 | 100.082 | 99.457
3.375 | 99.44 | 99.315 | 99.19 | 98.565
3.25 | 98.477 | 98.352 | 98.227 | 97.602
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.027 | 101.902 | 101.777 | 101.402
3.25 | 101.6 | 101.475 | 101.35 | 100.975
3.125 | 101.3 | 101.175 | 101.05 | 100.675
3 | 100.95 | 100.825 | 100.7 | 100.325
2.875 | 100.339 | 100.214 | 100.089 | 99.464
2.75 | 99.68 | 99.555 | 99.43 | 98.805
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-20 09:34:40.270000
30 DAY | 2012-09-04 09:34:40.270000
45 DAY | 2012-09-19 09:34:40.270000
60 DAY | 2012-10-04 09:34:40.270000
90 DAY | 2012-11-03 09:34:40.270000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 678073d1589702860-need-assistance-with-vlook-up-formula-vlook-up-problem
Sheet: Sheet1

StudentNo | Status | PercentGrade | LetterGrade |  | Status |  |  | UNCL/UGRD Grading Scale |  |  | GRAD Grading Scale
103599 |  | 88 |  |  | Threshold | Status |  | Threshold | LetterGrade |  | Threshold | LetterGrade
222412 |  | 76 |  |  |  |  |  | 0 | F |  | 0 | F
234205 |  | 90 |  |  |  |  |  | 50 | D |  | 60 | C-
234989 |  | 76 |  |  |  |  |  | 55 | C- |  | 64 | C
243123 |  | 85 |  |  |  |  |  | 60 | C- |  | 67 | C+
331231 |  | 92 |  |  | UGRD Class Perormance |  |  | 64 | C+ |  | 70 | B-
418243 |  | 72 |  |  | Min_Prop_of_As | Level |  | 68 | B- |  | 74 | B
493852 |  | 90 |  |  | 0 | Poor |  | 72 | B- |  | 77 | [NAME]
555213 |  | 83 |  |  | 0.15 | Satisfactory |  | 76 | [NAME] |  | 80 | A-
568523 |  | 89 |  |  | 0.3 | Good |  | 80 | A- |  | 85 | A
619324 |  | 97 |  |  | 0.45 | Excellent |  | 85 | A- |  | 90 | A+
791298 |  | 72 |  |  |  |  |  | 90 | A+
888812 |  | 98 |  |  | UGRD Cl-Perf-LVL:
921221 |  | 81
Spreadsheet: 742903d1628103726-creating-a-search-function-that-returns-information-from-each-found-result-sku-search
Sheet: Sheet1

SKU [ONLY ] | NWB & NWOB Sizes & PRE OWNED | NWB No Lid Sizes | eBay | POSH | MERCARI | GOAT | Stock X |  |  |  | Desired Function
501524-106 | 10 | NA | DONE | DONE | NA | DONE | DONE |  |  |  | Search Term | SKU from A. This would be manually entered
501524-106 | 10 | NA | DONE | DONE | NA | DONE | DONE |  |  |  | Example | CZ2636-687
501524-106 | 10 | NA | DONE | DONE | NA | DONE | DONE |  |  |  | Results
CZ2635-354 | S | NA | DONE | DONE | DONE | NA | NA |  |  |  | [NAME] | Ebay | Posh | Mercari | Goat | Sx
CZ2635-354 | M | NA | DONE | DONE | DONE | NA | NA
CZ2635-354 | M | NA | DONE | DONE | DONE | NA | NA
CZ2635-354 | M | NA | DONE | DONE | DONE | NA | NA
CZ2636-687 | M | NA | DONE | DONE | DONE | NA | NA
CZ2636-687 | M | NA | DONE | DONE | DONE | NA | NA
CZ2636-687 | L | NA | DONE | DONE | DONE | NA | NA
CZ2636-687 | L | NA | DONE | DONE | DONE | NA | NA |  |  |  | Note: The words "DONE" and NA" could easily be replaced with values that make this easier like "1" and "0"
597761-01 | XL | NA | DONE | DONE | DONE | NA | NA
940172-687 | XXL | NA | DONE | DONE | DONE | NA | NA
AR2246-484 | XL | NA | DONE | DONE | DONE | NA | NA
CU1508-010 | S | NA | DONE | DONE | DONE | NA | NA
939438-011 | XS | NA | DONE | DONE | DONE | NA | NA
939438-011 | S | NA | DONE | DONE | DONE | NA | NA
CU5094-478 | S | NA | DONE | DONE | DONE | NA | NA
CU5094-478 | M | NA | DONE | DONE | DONE | NA | NA
595760-01 | S | NA | DONE | DONE | DONE | NA | NA
710814766001 | M | NA | DONE | DONE | DONE | NA | NA
1272344-497 | 4 | NA | DONE | DONE | DONE | NA | NA
756476-01 | LARGE | NA | DONE | DONE | DONE | NA | NA
757264-05 | LARGE | NA | DONE | DONE | DONE | NA | NA
Spreadsheet: 810665d1671943911-sum-all-identical-merged-columns-s666-pq-sum-all-identical-merged-rows
Sheet: Sheet1

Category | Type | price |  | expected end result |  |  | Category | Sum
pencil | A | 100 |  | pencil | 480 |  | pencil | 480
 | B | 60 |  | ink | 220 |  | ink | 220
ink | A | 80 |  | ruler | 80 |  | ruler | 80
 | C | 30 |  | rubber stamp | 60 |  | rubber stamp | 60
ruler | D | 40
rubber stamp | E | 10
 | F | 20
pencil | A | 100
 | B | 60
ink | A | 80
 | C | 30
ruler | D | 40
rubber stamp | E | 10
 | F | 20
pencil | A | 100
 | B | 60
Total
Spreadsheet: 269417d1381156119-dynamic-range-in-columnb-that-starts-and-ends-depending-on-a-value-in-either-columna-or-b-workbook2
Sheet: Sheet1

Issue1 | NEST | True | Range starts at B2 triggerred by "Issue" in A1.  [NAME] stops at B8 triggerred by blank in B9.  Returns TRUE as "Ticket" found in range.
Date | Notes
Date | Ticket
Date | Notes
Date | Notes
Date | Notes
Date | Ticket
Date | Notes
Date
Issue2 | DATA | True | Range starts at B10 triggerred by "Issue" in A10.  [NAME] stops at B16 triggerred by "Issue" in A17.  Returns TRUE as "Ticket" found in range.
Date | Notes
Date | Notes
Date | Notes
Date | Notes
Date | Notes
Date | Ticket
Issue3 | NEST | False | Range starts at B17 triggerred by "Issue" in A17.  [NAME] stops at [NAME] triggerred by blank in B21.  Returns FALSE as "Ticket" not found in range.
Date | Notes
Date | Notes
Date | Notes
Spreadsheet: 31781d1227724404-use-dropdown-to-copy-cell-groups-trip-budget-calculator
Sheet: Sheet1

Trip Budget Calculator
 |  |  |  | Boat
 | TO |  |  | Bus
Mode of Travel |  |  |  | Car
 | 0 |  |  | Plane
Number of Travelers | 0 |  |  | Train
Meals per Day | 0 |  |  | 0
Price per Meal | 0 |  |  | 1
 | 0 |  |  | 2
 | 0 |  |  | 3
 | 0 |  |  | 4
 | 0 |  |  | 5
 | 0 |  |  | 6
 |  |  |  | 7
 | 0 |  |  | 8
 | 0 |  |  | 9
 | 0 |  |  | 10
 | 0 |  |  | 11
 | 0 |  |  | 12
 | 0 |  |  | 13
 | 0 |  |  | 14
 | 0 |  |  | 15
 | 0 |  |  | 16
Total (Travel) | 0 |  |  | 17
 |  |  |  | 18
Days At Destination | 0 |  |  | 19
Hotel Cost Per Night Per Room | 0 |  |  | 20
# of Rooms | 0 |  |  | 21
Meals Per Day | 0 |  |  | 22
Cost Per Meal | 0 |  |  | 23
Misc | 0 |  |  | 24
Misc | 0 |  |  | 25
Misc | 0 |  |  | 26
Misc | 0 |  |  | 27
Misc | 0 |  |  | 28
Misc | 0 |  |  | 29
Misc | 0 |  |  | 30
Misc | 0 |  |  | 31
Misc | 0 |  |  | 32
Misc | 0 |  |  | 33
 | 0 |  |  | 34
Total At Destination | 0 |  |  | 35
 |  |  |  | 36
Plans |  | Add Another Destination |  | 37
 |  |  |  | 38
 |  |  |  | 39
 |  |  |  | 40
 |  |  |  | Same Route Back
 |  |  |  | New Route Back
 |  |  |  | Add Another Destination
 |  |  |  | Total Trip | 0
 |  |  |  |  | TO
 |  |  |  | Mode of Travel | Car
 |  |  |  | MPG | 12
 |  |  |  | Number of Travelers | 0
 |  |  |  | Meals per Day | 0
 |  |  |  | Price per Meal | 0
 |  |  |  | Days Driving | 5
 |  |  |  |  | 0
 |  |  |  | Distance Day 1 | 0
 |  |  |  | Hotel Price Day | 0
 |  |  |  | Gas Price | 0
 |  |  |  | Distance Day 2
 |  |  |  | Hotel Price Day 2 | 0
 |  |  |  | Gas Price | 0
 |  |  |  | Distance Day 2 | 0
 |  |  |  | Hotel Price Day 3 | 0
 |  |  |  | Gas Price | 0
 |  |  |  | Distance Day 4 | 0
 |  |  |  | Hotel Price Day 4 | 0
 |  |  |  | Gas Price | 0
 |  |  |  | Distance Day 5 | 0
 |  |  |  | Total (Travel) | 0
 |  |  |  | Days At Destination | 40
 |  |  |  | Hotel Cost Per Night Per Room | 0
 |  |  |  | # of Rooms | 0
 |  |  |  | Meals Per Day | 5
 |  |  |  | Cost Per Meal | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  | Misc | 0
 |  |  |  |  | 0
 |  |  |  | Total At Destination | 0
 |  |  |  | Plans
Spreadsheet: 761475d1640937594-best-of-three-best-3-selection-aligw
Sheet: Sheet1

MUSHTAK ESMAIL | 1 | 1 | 1 | 5 |  | 1
TOYO KITUA | 2 | 3 | 2 | 4 |  | 2.333333333333333
SHAHNAZ HIRJI | 3 | 2 | 0 | 3 |  | 2.666666666666667
MAKBUL MANJI | 0 | 4 | 3 | 2 |  | 3
HAMISI [NAME] | 4 | 6 | 4 | 1 |  | 3
[NAME] | 0 | 5 | 0 | 1 |  | dis
Spreadsheet: 146863d1332389019-count-if-help-countif
Sheet: HCM

 | Product and Code | Price
 | Bike
 | HCMB01 | 3000
 | HCMB02 | 5000
 | HCMB03 | 6000
 | HondaHCM | 8000
 | YamahaHCM | 2000
 | Car
 | HCMC01 | 10000
 | HCMC02 | 20000
 | HCMC03 | 50000
 | House
 | HCMH01 | 200000
 | HCMH02 | 1000000
 | HCMH03 | 6000000
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 37159 | 36100
2 | 38086 | 36100
3 | 38653 | 36100
4 | 36813 | 36100
5 | 39325 | 36100
6 | 38358 | 36100
7 | 39935 | 36100
8 | 34841 | 30900
9 | 27867 | 30900
10 | 28719 | 30572
11 | 31635 | 30845
12 | 31880 | 30845
13 | 30922 | 30900
14 | 40859 | 38732
15 | 29724 | 39491
16 | 23279 | 30900
17 | 30232 | 30900
18 | 31762 | 30900
19 | 31987 | 30900
20 | 30776 | 30900
21 | 31304 | 30900
22 | 29202 | 30900
23 | 31556 | 30900
24 | 30206 | 30900
25 | 29602 | 30900
26 | 30775 | 30900
27 | 30258 | 35900
28 | 33247 | 35900
29 | 23913 | 35900
30 | 29914 | 35900
31
2001-10-31 00:00:00 |  |  | 22711.97
2001-11-30 00:00:00
CBS Volume
 |  |  | 25624
Spreadsheet: lindy_donoho__22161__Prices for Lindy
Sheet: MO IND DATA

 |  | Beginning of Month Index Prices
DATE | NGI-SOCAL | IF-ELPO/SJ | IF-ELPO/PERMIAN
2001-01-01 00:00:00 | 16.32 | 8.8 | 9.81
2001-02-01 00:00:00 | 12.63 | 6.24 | 6.65
2001-03-01 00:00:00 | 12.58 | 4.83 | 5.12
2001-04-01 00:00:00 | 12.56 | 4.65 | 5.31
2001-05-01 00:00:00 | 14.94 | 4.23 | 4.91
2001-06-01 00:00:00 | 11.7 | 3.14 | 3.82
2001-07-01 00:00:00 | 4.7 | 2.34 | 3.21
2001-08-01 00:00:00 | 3.74 | 2.46 | 3.09
2001-09-01 00:00:00 | 2.65 | 2.18 | 2.33
2001-10-01 00:00:00 | 1.76 | 1.34 | 1.63
Spreadsheet: 142897d1330080258-index-match-problem-book1_dean81
Sheet: Sheet1

dogs | 2012 | jan | 4 |  |  |  |  | dogs | cats | fish
 |  | feb | 5 |  |  |  | jan | 4 | 7 | 9
 |  | [NAME] | 6 |  |  |  | feb | 5 | 1 | 8
cats | 2012 | jan | 7 |  |  |  | [NAME] | 6 | 3 | 7
 |  | feb | 1
 |  | [NAME] | 3
fish | 2012 | jan | 9
 |  | feb | 8
 |  | [NAME] | 7
Spreadsheet: 808404d1670440328-formula-to-look-in-a-number-column-and-find-a-certain-type-of-number-op-sample-9-
Sheet: Sheet1

Column1 | Column2
360 Appraisal Group | 14
AAA-AMC | 18
Accurate Group | 1789
Act Appraisal, Inc | 12431
Allstate Appraisal, LP | 3036
AMC Settlement Services | 236
American Valuation Corp | 996
AMSA | 285
[NAME] Services | 82
Appraisal House USA | 667
[NAME] | 6
Appraisal Management Solutions | 169
Appraisal MC | 34
Appraisal Nation | 3980
Appraisal Unlimited Management Group | 972
Appraisals 2U | 1308
AppraisalTek | 493
AppraiserVendor.com LLC | 2053
[NAME] | 721
[NAME] | 9
AssetVal Valuation Solutions | 112
Assurant Valuations | 4346
Spreadsheet: 01c8e005-5e7b-4ff0-8ecd-298bdee6c06a
Sheet: Sheet1

Spring 2013 | MKT 382 |  | Professor [NAME]
Class | Day | Date | Topic
1 | Monday | 2013-01-14 00:00:00 | Lecture: Overview of Course/Marketing Metrics
 | Wednesday | 2013-01-16 00:00:00 | [NAME]: (HBS 9-502-030)
 | Wednesday | 2013-01-23 00:00:00 | Lecture: Market Management
 | Monday | 2013-01-28 00:00:00 | Classic Knitwear - Case (HBS 4217): Submission 1
 | Wednesday | 2013-01-30 00:00:00 | Lecture: Market Share Performance Metrics and Share Growth
 | Monday | 2013-02-04 00:00:00 | Harrington Collection - Case (HBS 3258): Submission 2
 | Wednesday | 2013-02-06 00:00:00 | Lecture: High Technology Marketing (Product Performance)
 | Monday | 2013-02-11 00:00:00 | Synthes (Case) (9-502-008): Submission 3
 | Wednesday | 2013-02-13 00:00:00 | Lecture: Pricing Metrics
 | Monday | 2013-02-18 00:00:00 | Clean Edge: (HBS 4249): Submission 4
 | Wednesday | 2013-02-20 00:00:00 | Lecture :Product Management
 | Monday | 2013-02-25 00:00:00 | Mountain Man Brewing (Case) (2069): Submission 5
 | Wednesday | 2013-02-27 00:00:00 | Midterm Exam Review
 | Monday | 2013-03-04 00:00:00 | Flexible class: Global
 | Wednesday | 2013-03-06 00:00:00 | Flexible class: Global
 |  |  | SPRING BREAK
 | Monday | 2013-03-18 00:00:00 | Lecture: Emerging Markets: Strategies that Fit Emerging Markets
 | Wednesday | 2013-03-20 00:00:00 | Overflow Class -
 | Monday | 2013-03-25 00:00:00 | Lecture: Advertising & Promotions Management
 | Wednesday | 2013-03-27 00:00:00 | Mednet: HBS 2066: Submission 6
 | Monday | 2013-04-01 00:00:00 | Lecture: Customer Relationship Management
 | Wednesday | 2013-04-03 00:00:00 | [NAME] and Resorts: CRM (HBS: 2087): Submission 7
 | Monday | 2013-04-08 00:00:00 | Lecture: BusinesstoBusinessMarketing
 | Wednesday | 2013-04-10 00:00:00 | Perelson Weiner LLP: (HBS 9-506-006): Submission 8
 | Monday | 2013-04-15 00:00:00 | Lecture: Social Media
 | Wednesday | 2013-04-17 00:00:00 | Pepsi Lipton Brisk:  (HBS - 9-512-011): Submission 9
 | Monday | 2013-04-22 00:00:00 | Marketing-Finance Interface I ((SSF Journal of Marketing 1998)/Student Group Presentations
 | Wednesday | 2013-04-24 00:00:00 | Student Group  Presentations
 | Monday | 2013-04-29 00:00:00 | Student Group  Presentations
 | Wednesday | 2013-05-01 00:00:00 | Course Wrap-up
Spreadsheet: 100896d1299105353-excel-2007-conditional-formatting-multiple-conditions-demo-customer-leads-template
Sheet: Agent 7

Lead Id | Lead Type Id | First Name | Last Name | Address | City | State | Zip | [NAME] | Phone | Inquiry Type Id | DateTimeCreated | DateTimeUpdated | Inquiry Type Name
210624 | 2 | Customer | Last Name | 123 main st | selma | AL | 36701 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210545 | 2 | Customer | Last Name | 141 main st | Green Cove Springs | FL | 32043 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210606 | 2 | Customer | Last Name | 142 main st | [NAME] | FL | 34614 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210601 | 2 | Customer | Last Name | 143 main st | Warrenton | GA | 30828 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
Spreadsheet: 804290d1667988566-large-nested-if-statements-how-to-improve-test1-1-
Sheet: Orders

OrderNo | OrderType | ProcCode | Qty | ProcFee
321 | B2B | 3 | 7
654 | B2C | 5 | 3
987 | B2B | 1 | 1
741 | B2C | 8 | 7
Spreadsheet: 82232d1282238091-populating-info-from-one-row-in-a-sheet-to-another-according-to-a-number-sample-budget
Sheet: Transactions

sub account | date | description | amount
255-06 | 2010-08-12 00:00:00 | office supplies | 250
256-01 | 2010-08-12 00:00:00 | Washington Conference | 78
256-03 | 2010-08-13 00:00:00 | team dinner | 263
257-01 | 2010-08-14 00:00:00 | magazine ad | 350
258-02 | 2010-08-14 00:00:00 | [NAME] | 582
255-04 | 2010-08-14 00:00:00 | Event Banners | 1700
Spreadsheet: 791111d1660158146-return-date-in-cell-based-columns-a-c-2022-08-10-oeldere-ajaxs87-find-the-date
Sheet: Start Stop

EOS Report |  |  |  |  | Search Information |  |  | yes
Build Date | Start # | Stop # | criteria | check | Shipping Date | Number |  | Return Date
2022-08-01 00:00:00 | 291 | 621 |  |  |  | 412
2022-08-01 00:00:00 | 622 | 853
2022-08-02 00:00:00 | 854 | 7
2022-08-02 00:00:00 | 8 | 353
2022-08-03 00:00:00 | 354 | 701
2022-08-03 00:00:00 | 702 | 100 |  |  | I have a list with dates and sequence numbers from 000-999 in columns A and B:C. The numbers reset back to 000 after 999. What I am seeking is:
2022-08-04 00:00:00 | 101 | 369
2022-08-04 00:00:00 | 370 | 748 |  |  | 1. User - Puts the Shipping Date into F3 and the Sequence # into G3.
2022-08-05 00:00:00 | 749 | 10 |  |  | 2. [NAME] that uses the most recent date (that is older that cell F3) in Column A and a within the ranges between Column B:C.
2022-08-05 00:00:00 | 11 | 301 |  |  | 3. It returns the Date in Column A in cell I3
2022-08-08 00:00:00 | 302 | 599
2022-08-08 00:00:00 | 600 | 999 |  |  | Thank you for anyone taking the time to read this or give input on how to make this work. Attachment added.
 |  |  |  |  | Attached Files Attached Files
 |  |  |  |  | I have figured out part of the formula. To figure out if the number falls within a start and stop number, I used the formula below in [NAME] (I3).
 |  |  |  |  | =AND(G3>=MIN(B3,"999"),G3<=MAX("0",C3))
 |  |  |  |  | The part I am seeking help with is, making it so that.
 |  |  |  |  | I want cell, I3 to return the date in Column A.
 |  |  |  |  | - Based on the Date in Column A & the Sequence Number entered in Column C.
 |  |  |  |  | - Column A Date must be equal to or less than the date entered into cell (F3)
 |  |  |  |  | - Cell (G3) value must also fall between the numbers in Column B:C, using the formula mentioned above *or if you have something better*.
 |  |  |  |  | I hope this is a bit more clear compared to my explanation yesterday. And look forward to hearing with any advice or help.
 |  |  |  |  | Thank you
Spreadsheet: 807723d1670009772-bank-account-balance-for-each-account-in-one-table-sample-10-
Sheet: List1

 |  | Name | income | outcome | saldo | commment
 |  | Nina | 50
 |  | [NAME] | 42
 |  | [NAME] | 61
 |  | [NAME] | 61
 |  | [NAME] | 36
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11
 |  | [NAME] | 11 | 8
 |  | [NAME] |  | 9
 |  | [NAME] |  | 23
 |  | [NAME] | 21
 |  | [NAME] |  | 20
 |  | [NAME] | 10
 |  | [NAME] |  | 5
 |  | [NAME] | 22
 |  | Nina | 10
 |  | Nina |  | 8
Spreadsheet: 587032d1534797059-find-search-cell-from-another-column-jtakwformula-find-search-match-up
Sheet: Sheet1

 | Sample BOM List (from another file) |  | From list below - Looking Up, Finding, Searching or Matching up list below to verify it's in descriptive BOM list in Colum B
 |  |  |  |  | [NAME] Found | = If Found
 |  |  |  |  | Not Found | = If Not Found
 |  |  | =IF(ISNUMBER(SEARCH($B$16:$B$40,D16)), "Match Found", "No Match Found")
 |  |  | -- Function kind of works but not 100% reliable
 | DRC0363D |  | Part number |  | Verification Column
 | [NAME] |  | 0121L02699SB
 | M0221817 SCREW-SM |  | 0121L01971
 | 0121L01634 OD COIL BLOCKOFF |  | 0121L02036
 | 0272L00964 ASSY., CONTROL BOX-101.85 |  | 0121L02047
 | 0121L02202 BOX-CONTROL, BOTTOM |  | 0121L02159
 | 0121L02047 CONTROL BOX BACK |  | 0121L02202 |  |  |  | Function should've found but it's not
 | 0121L02159 MTG PLATE-CONTROL, 3-6 TON |  | 0121L02227
 |  |  | 0121L02260
 | 20520901 STRAP-CAPACITOR |  | 0121L02584
 | 802007090 TERM BOARD |  | 0121L02878
 | 0130L00005 GROUND-LUG |  | 0121L02935
 | 0130M00038 TERMINAL BOARD
 | B1141654 TRANSFORMER,208-240,75VA,RESET
 | 0121L01622 OUTDOOR BASEPAN
 | 0270L00931 ASSY., INSUL. PARTITION PANEL
 | 0121L01730 PARTITION PANEL
 | 0160L00207 PARTITION PANEL INSULATION
 | 0153M00007 INSULATION ADHESIVE
 | 0163M00039 WELD PIN
 | 0121L01728SB PAINTED CORNER POST
 | 0141L00003X BOARD-FORK
 | 0121L00055 BRACKET-FORK BOARD
 | 0121L02697SB PAINTED SIDE POST
 | 0121L02202 BOX-CONTROL, BOTTOM
Spreadsheet: 09a0f32d-3e92-469b-8855-3d52e9dc3bd7
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42946513 | 2014-08-30 17:49:54 | AXIS | 0 | 4 | 6 | 1562400 | player1562400 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42946740 | 2014-08-30 18:09:08 | ALLIES | 1 | 6 | 3 | 1562400 | player1562400 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42947001 | 2014-08-30 18:19:55 | AXIS | 1 | 4 | 1 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42947139 | 2014-08-30 18:39:02 | ALLIES | 0 | 2 | 4 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42947624 | 2014-08-30 19:15:55 | ALLIES | 0 | 4 | 6 | 1601827 | [NAME] | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
42947819 | 2014-08-30 19:25:24 | AXIS | 1 | 6 | 2 | 1601827 | [NAME] | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Business

BUSINESS
Associate in Applied Science
Student Name:  _________________________________________
Student ID:  ___________________________
General Education | Semester | Grade
___ ENG 101 (3) Writing I
___ COM 191 (3) Basic Public Speaking
OR ___ COM 252 (3) Introduction to Interpersonal Communication
___ ECO 101 (3) Contemporary Economic Issues
OR ___ ECO 201 (3) Principles of Microeconomics
OR ___ ECO 202 (3) Principles of Macroeconomics
___ MAT 105 (3) Business Mathematics
OR ___ MAT 110 (3) Applied Mathematics OR ___ Higher Quantitive Reasoning
___ Heritage/Humanities (3)
___ Natural Science (3-4)
Technical Courses
___ CIT 105 (3) Introduction to Computers
OR ___ OST 105 Introduction to Information Systems
___ ENG 102 (3) Writing II
OR ___ OST 235 (3) Business Communicatiosn Technology
___ CIT 130 (3) Productivity Software
OR ___OST 240 (3) Software Integrations
___ [NAME] (3) Introduction to Business
___ [NAME] (1) Business Employability Seminar
___ [NAME] (3) Introduction to Business Law
___ [NAME] (3) Principles of Marketing
___ [NAME] (3) Principles of Management
___ ACC 201 (3) Financial Accounting
OR ___ ACT 101 (3) Fundamentals of Accounting I
AND ___ ACT 102 (3) Fundamentals of Accounting II
___ ACC 202 (3) Managerial Accounting
Southeast Kentucky Community & Technical College | Updated Spring 2013