tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744975d1629627668-min-and-max-max-and-min-2-ansaggregate
Sheet: Sheet1

Before :- |  |  |  |  |  |  |  | After :-
Country | Ref |  |  |  |  |  |  | Country | Start | End
India | A12
Israel | B11
Hong Kong | C10
India | A2
Israel | B2
Hong Kong | C2
India | A3
Israel | B3
Hong Kong | [NAME]
India | A4
Israel | B4
Hong Kong | C440
India | A5
Israel | B99
Hong Kong | C5
Spreadsheet: 879868d1727448530-compare-several-columns-ignore-blanks-cf_duplicates-eba
Sheet: Planilha1

I need to compare B3 to H18 if any number is equal. Both in lines or columns. Any repeted number should be flagged. [NAME] blanks.
 | Home Phone | Home Phone 2 | Business Phone | Business Phone 2 | [NAME] | Other Phone | [NAME] | Business Fax
 |  |  |  |  |  |  | (034) 3314 0400
 |  |  |  |  |  |  | (034) 992 222 115
 |  |  |  |  |  |  | (016) 981 028 901
 | (034) 991 146 709
 | (034) 992 678 000 |  | (034) 3334 8070 |  |  |  | (034) 998 787 081
 |  |  |  |  |  |  | (034) 992 807 189
 |  |  | (034) 997 670 022 |  |  |  | (034) 3314 7445
 |  |  |  |  |  |  | (031) 998 264 985
 |  |  |  |  |  |  | (012) 997 665 360
 | (034) 996 986 341
 |  |  | (034) 999 720 945 |  |  |  | (034) 3322 2478
 | (034) 3319 8032
 |  |  | (034) 988 150 973 |  |  |  | (034) 3333 2201
Spreadsheet: 778005d1650773530-pull-dynamic-info-from-two-separate-cells-book1a
Sheet: Sheet1

Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  |  | Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
Dates and Names are dynamic |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dates and Names are dynamic |  | 2022-04-22 00:00:00
 |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time |  |  |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 08:00:00 | 15:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 09:00:00 | 18:00:00
Spreadsheet: 862353d1710109356-exclude-holidays-in-total-holiday-sample
Sheet: Mar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2024-03-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 51879d1251468980-locking-cell-data-from-different-sheets-linking-test
Sheet: Sheet2

Date | Week
2009-09-07 00:00:00 | 36
2009-08-24 00:00:00 | 35 |  |  |  | Overtime
2009-08-31 00:00:00 | 36 |  |  |  | 8
2009-09-07 00:00:00 | 37
2009-09-14 00:00:00 | 38
2009-09-21 00:00:00 | 39
2009-09-28 00:00:00 | 40
2009-10-05 00:00:00 | 41
2009-10-12 00:00:00 | 42
2009-10-19 00:00:00 | 43
Spreadsheet: 728403d1618431696-get-interest-rate-via-formula-not-goal-seek-from-the-total-earning-interest-rate
Sheet: Sheet1

Year | Total   OOP | Out of Pocket per Year | Net Cumulative Cash  Value | Rate |  | 0.02105430230687219
1 | 51472.86504 |  | 17825.67200000002
2 | 88440.84907 |  | 36989.679
3 | 120725.5442850001 |  | 57000.49950000015
4 | 156566.1486850001 |  | 77437.27000000002
5 | 189584.5407750001 |  | 98659.2370000002
6 | 237923.5451450001 |  | 108941.1780000001
7 | 282898.1070825001 |  | 119779.5375000001
8 | 324188.7113775001 |  | 131211.923
9 | 362274.1395999999 |  | 143233.7664999999
10 | 396844.7650425006 |  | 155883.3345000003
11 | 426986.9034974999 |  | 169233.227
12 | 453236.4388025003 |  | 183279.6170000001
13 | 475549.23068 |  | 198050.1735
14 | 493646.1398700005 |  | 213586.3860000004
15 | 507244.9523425 |  | 229931.4165000003
16 | 507244.9523425 |  | 426260.8045275006
17 | 507244.9523425 |  | 640142.3588359635
18 | 507244.9523425 |  | 871947.8715452235
19 | 507244.9523425 |  | 1122356.738999306
20 | 507244.9523425 |  | 1392441.772314282
21 | 507244.9523425 |  | 1689650.629895283
22 | 507244.9523425 |  | 2004120.551641618
23 | 507244.9523425 |  | 2336680.204549075
24 | 507244.9523425 |  | 2687341.879408292
25 | 507244.9523425 |  | 3056294.058287583
26 | 507244.9523425 |  | 3445201.27247765
27 | 507244.9523425 |  | 3854382.880564367
28 | 507244.9523425 |  | 4284672.136284121
29 | 507244.9523425 |  | 4737069.995804066
30 | 507244.9523425 |  | 5211829.244057208
31 | 507244.9523425 |  | 5707586.479749211
32 | 507244.9523425 |  | 6223532.448640435
33 | 507244.9523425 |  | 6759324.60469285
34 | 507244.9523425 |  | 7313986.488657102
35 | 507244.9523425 |  | 7887198.013660101
36 | 507244.9523425 |  | 8478528.427338207
37 | 507244.9523425 |  | 9088078.640045043
38 | 507244.9523425 |  | 9715588.118646622
39 | 507244.9523425 |  | 10361009.56539925
40 | 507244.9523425 |  | 11022723.11138823
41 | 507244.9523425 |  | 11691166.44398682
42 | 507244.9523425 |  | 12374523.96777636
43 | 507244.9523425 |  | 13072020.47834853
44 | 507244.9523425 |  | 13783029.77839073
45 | 507244.9523425 |  | 14505610.73543441
46 | 507244.9523425 |  | 15029376.36062461
47 | 507244.9523425 |  | 15544539.61784647
48 | 507244.9523425 |  | 16045809.7025211
49 | 507244.9523425 |  | 16527890.36935934
50 | 507244.9523425 |  | 16988604.45833692
51 | 507244.9523425 |  | 17426128.10812871
52 | 507244.9523425 |  | 17846036.64621321
53 | 507244.9523425 |  | 18253178.54483068
54 | 507244.9523425 |  | 18656085.39194975
55 | 507244.9523425 |  | 19071794.726368
56 | 507244.9523425 |  | 19527541.33604088
57 | 507244.9523425 |  | 20040029.63870232
58 | 507244.9523425 |  | 20656651.9638069
59 | 507244.9523425 |  | 21460318.32479014
60 | 507244.9523425 |  | 22607463.33060779
Spreadsheet: 877672d1724487885-formula-to-create-alert-based-on-a-key-word-telford-forklift-truck-pre-shift-inspection-checklist-1-
Sheet: Inspections

Id | Start time | Completion time | [NAME] | Name | Date of Inspection | Inspectors Name | [NAME] | Comments | Picture (If Required) | Hydraulic [NAME] | Comments1 | Picture (If Required)1 | Hydraulic Fluid Levels1 | Comments2 | Picture (If Required)2 | Chains & Fixing Bolts | Comments3 | Picture (If Required)3 | Forks / Attachments | Comments4 | Picture (If Required)4 | Backrest / Extension | Comments5 | Picture (If Required)5 | Tyres / Wheels / Nuts | Comments6 | Picture (If Required)6 | Steering / Seat & Seat Belt | Comments7 | Picture (If Required)7 | Brakes | Comments8 | Picture (If Required)8 | Operating Controls | Comments9 | Picture (If Required)9 | Warning Lights | Comments10 | Picture (If Required)10 | Gauges / Instruments | Comments11 | Picture (If [NAME] | Lights / Beacon | Comments12 | Picture (If Required)12 | Horn / Alarms | Comments13 | Picture (If [NAME] | Safety Guards / Covers | Comments14 | Picture (If [NAME] | Bodywork / Cleanliness | Comments15 | Picture (If [NAME] | Cable Connections | Comments16 | Picture (If [NAME] | Battery Security | Comments17 | Picture (If Required)17
1 | 2024-08-23 14:54:40 | 2024-08-23 14:55:14 | anonymous |  | 2024-08-19 00:00:00 | [NAME] | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK
2 | 2024-08-23 15:04:09 | 2024-08-23 15:05:10 | anonymous |  | 2024-08-20 00:00:00 | [NAME] | OK |  |  | OK |  |  | Repair | Requires top up |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK |  |  | OK
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -81095 | -50716
9238 | -10455 | -23000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2289378 | -2268349
58710 | -143515 | -154908
60921 | -1026582 | -1055085
78026
500084 | -53677 | -69000
500085 | -8664
500097 | -75539 | -92000
INDEX
2001-12-31 00:00:00 |  |  | 766914.32
2002-01-23 00:00:00
CBS Volume
 |  |  | 307322
Spreadsheet: 174329d1345024952-when-i-enter-the-searching-name-some-columns-of-data-wont-be-showing-example
Sheet: Search

Search the Item Name  ê
Press
Item Name | Item Code | Opening Stock | Unit | Reorder Level | Tray No | Rack No
Spreadsheet: 734838d1622539634-matching-name-to-location-book5
Sheet: System

Full Name | First Name | Middle Name | Last Name | Site | Subject | Maths | Technical drawing | accounts | IT | Art | Geography | [NAME] | [NAME]
Abdul
Ceasar
[NAME]
Moomba
[NAME]
Lilato
Mwansa
Ndanji
[NAME]
Mwamba
Kekzo
Matiya
Spreadsheet: 1bed5650-b006-44d4-9c02-4a6b475c860e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TARR | Test | TARR | Tarragon, IgE | Tarragon, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
TARR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TARR | Result | TARR | Tarragon, IgE | Tarragon, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11202-9 | Artemisia dracunculus Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ACCT

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Accounting Certificate | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
2 | ACCT 105 | 1 | X | 1 | X | 1 | 1 | 1
3 | ACCT 198 | 1 | X | 1
2 | ACCT 208 | 1 | X | 1 | X | 1 | 1 | 1
1 | ACCT 209 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | ACCT 226 | 1
5 | ACCT 230 -- Delete? | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 166299d1341523891-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-example2
Sheet: Overview

Item # | 1 | 2 | 3
Week | Weekly | Weekly | Daily
1 | 800 | 600 | 50
2 | 400 | 300 | 50
3 | 400 | 300 | 50
Spreadsheet: 272433d1382384509-transfer-multiple-row-entries-to-single-row-grouping
Sheet: Sheet1

Date | Rising | Morning | Afternoon | Evening | Helper Column to extract unique  date |  | Rising | Morning | Afternoon | Evening
2013-08-20 00:00:00 |  |  | 151
2013-08-20 00:00:00 |  |  |  | 171
2013-08-21 00:00:00 | 133
2013-08-21 00:00:00 |  |  | 180
2013-08-22 00:00:00 | 156
2013-08-23 00:00:00 | 144
2013-08-23 00:00:00 |  |  | 92
2013-08-23 00:00:00 |  |  |  | 215
2013-08-23 00:00:00 |  |  |  | 207
2013-08-24 00:00:00 | 156
2013-08-24 00:00:00 |  |  |  | 188
2013-08-25 00:00:00 | 141
2013-08-25 00:00:00 |  |  |  | 185
2013-08-25 00:00:00 |  |  |  | 187
2013-08-26 00:00:00 | 166
2013-08-26 00:00:00 |  |  | 82
2013-08-26 00:00:00 |  |  | 120
2013-08-26 00:00:00 |  |  |  | 187
Spreadsheet: 127300d1320273173-help-using-match-and-index-i-think-sample-worksheets
Sheet: Salary Breakdown

Employee BREAKDOWN
NAME | WAGE |  | 0.1 | k-4 | 6600 | 5300 | 5100 | 7100 | 2100 | 2400 | 5500 | 6500 | 5400 | 5204 | 9700 | 3100 | Total
[NAME], [NAME] | 49538 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
Allcott, [NAME] | 43091 |  |  |  |  |  | 0.68 |  | 0.16 |  |  | 0.16
Birdman, [NAME] | 45749 |  |  |  |  |  | 1
Caroline, [NAME] | 48784 |  |  |  |  |  | 0.34 |  |  |  |  | 0.66
[NAME], Jon | 61207 |  |  |  |  |  |  |  | 1
Spreadsheet: 214462d1360922963-adjusting-time-12hr-to-24hr-asimbig-sample
Sheet: Sheet1

ID | Downloaded | Downloaded Date | Downloaded Time | Downloaded Day of the Week
1915 | 2012-06-01T04:44:47Z | 2012-06-01 | 04:44:47 | Friday
1916 | 2012-06-01T04:46:36Z | 2012-06-01 | 04:46:36 | Friday
1917 | 2012-06-01T04:49:13Z | 2012-06-01 | 04:49:13 | Friday
1920 | 2012-06-01T06:17:33Z | 2012-06-01 | 06:17:33 | Friday
1921 | 2012-06-01T06:19:47Z | 2012-06-01 | 06:19:47 | Friday
1928 | 2012-06-01T06:30:21Z | 2012-06-01 | [NAME] | Friday
1958 | 2012-06-01T08:41:22Z | 2012-06-01 | 08:41:22 | Friday
1962 | 2012-06-01T09:06:22Z | 2012-06-01 | 09:06:22 | Friday
1963 | 2012-06-01T09:11:57Z | 2012-06-01 | 09:11:57 | Friday
1964 | 2012-06-01T09:13:53Z | 2012-06-01 | 09:13:53 | Friday
1966 | 2012-06-01T09:19:15Z | 2012-06-01 | 09:19:15 | Friday
1971 | 2012-06-01T09:48:06Z | 2012-06-01 | [NAME] | Friday
1972 | 2012-06-01T09:56:40Z | 2012-06-01 | [NAME] | Friday
1973 | 2012-06-01T10:18:12Z | 2012-06-01 | 10:18:12 | Friday
1974 | 2012-06-01T10:44:18Z | 2012-06-01 | 10:44:18 | Friday
1975 | 2012-06-01T10:45:41Z | 2012-06-01 | 10:45:41 | Friday
1976 | 2012-06-01T11:04:59Z | 2012-06-01 | 11:04:59 | Friday
1977 | 2012-06-01T11:23:03Z | 2012-06-01 | 11:23:03 | Friday
1978 | 2012-06-01T11:32:53Z | 2012-06-01 | 11:32:53 | Friday
1985 | 2012-06-01T12:49:15Z | 2012-06-01 | 12:49:15 | Friday
1987 | 2012-06-01T12:54:46Z | 2012-06-01 | 12:54:46 | Friday
1990 | 2012-06-01T12:59:49Z | 2012-06-01 | 12:59:49 | Friday
1992 | 2012-06-01T01:22:21Z | 2012-06-01 | 01:22:21 | Friday
1993 | 2012-06-01T01:36:13Z | 2012-06-01 | 01:36:13 | Friday
1994 | 2012-06-01T01:48:29Z | 2012-06-01 | 01:48:29 | Friday
1995 | 2012-06-01T03:01:15Z | 2012-06-01 | 03:01:15 | Friday
2001 | 2012-06-01T04:08:03Z | 2012-06-01 | 04:08:03 | Friday
2002 | 2012-06-01T04:25:16Z | 2012-06-01 | 04:25:16 | Friday
2003 | 2012-06-01T04:27:24Z | 2012-06-01 | 04:27:24 | Friday
2004 | 2012-06-01T04:28:41Z | 2012-06-01 | 04:28:41 | Friday
2006 | 2012-06-01T06:22:28Z | 2012-06-01 | 06:22:28 | Friday
2007 | 2012-06-01T07:05:51Z | 2012-06-01 | [NAME] | Friday
2008 | 2012-06-01T07:06:55Z | 2012-06-01 | 07:06:55 | Friday
2009 | 2012-06-01T07:07:38Z | 2012-06-01 | 07:07:38 | Friday
2010 | 2012-06-01T07:08:00Z | 2012-06-01 00:00:00 | 07:08:00 | Friday
Spreadsheet: robert_badeer__33104__WestTot
Sheet: PosnChg

Term | LT
Portfolio | TRANSM
Year | (All)
Season | (All)
Quarter | (All)
RefDt | (All)
Month | 12
[NAME] | PWR
TotalChng | AggBasis | Name | DealType
 | NP15 | Grand Total
 | NP15
Monthly | Physical
2000-12-01 00:00:00 | -1.209273290452984 | -1.209273290452984
Grand Total | -1.209273290452984 | -1.209273290452984
Spreadsheet: 0a4b8b31-2e63-49a7-935f-341f2e987469
Sheet: Sheet1

American Osteopathic Association | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Division of Continuing Medical Education
HEALTHCARE FACILITY EDUCATION ACTIVITIES
D.O.'s AOA Membership # |  |  |  |  | D.O.'s Name
Healthcare Facility |  |  |  |  | City, ST & Zip
 |  |  | Month/Year
 |  |  |  |  |  |  |  |  |  | Each block = 1 hour
Tumor Board
Mortality Review
Clinical Pathological Conference
Utilization Review
Medical Records Audit
OTHER IN-HOSPITAL CME ACTIVITIES
 |  |  |  |  |  |  |  |  | Total Hours:
Mail this form to: PACE Office, 3500 Camp Bowie Blvd, Fort Worth, TX 76107
For Office Use Only
Cat_______   Credits_______
Date:____________________
Program #________________ |  |  |  |  |  |  | [NAME], Executive Director
 |  |  |  |  |  |  | Professional & Continuing Education
Spreadsheet: 860239d1708421167-if-formula-to-read-if-dropdown-matches-table-brings-it-into-another-table-at-top-sample
Sheet: Sheet1

Field One |  | Lookup & Return Table |  | Table I want formula to rad
NSW |  | Jurisdiction |  | Read formula
 |  | ACT |  |  |  |  |  |  | Where ever the text is in Column C, I need it to star here in column E
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | ACT |  |  |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 02 Feb 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-02-02 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver |  |  | EFS | Annual
Soud Sharar | 2097 | [NAME] Officer |  |  | [NAME] | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 629103d1561063990-countif-and-index-match-with-indirect-sample
Sheet: AAA10

AAA | BBB | CCC | DDD | EEE | FFF | GGG | HHH | III | JJJ | KKK | LLL | MMM | OOO | PPP | QQQ | RRR | SSS | TTT
 |  |  |  |  |  |  |  |  |  |  |  | XX
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | XX
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | XX
 |  |  |  |  |  |  |  |  |  |  |  | XX
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | OO
 |  |  |  |  |  |  |  |  |  |  |  | XX
 |  |  |  |  |  |  |  |  |  |  |  | XX
Spreadsheet: 679382d1590382296-same-cust-number-within-2-or-more-groups-unique-group-updated
Sheet: Sheet1

GROUP NUM | CUST NUM | ACC NO | Flag | Flag | Flag I want
8 | NSRN67L100800X | 13400310 |  | 1
8 | NSRN67L100800X | 13491858
8 | NSRN67L100800X | 13487635
10 | NSRN67L100800X | 13008840
10 | NSRN67L100800X | 13393888
27 | NSRN67L100800X | 14693886
27 | NSRN67L100800X | 13293807
8 | MXXN67L100800X | 13400314
8 | MXXN67L100800X | 13400324
8 | MXXN67L100800X | 13400378
Spreadsheet: 490576d1479925095-combining-cells-across-random-ranges-example
Sheet: Sheet1

Given
Purchase |  | 1/13/2015 | Electrolux |  | 7740 |  |  | 1022959.08 | DT
Purchase |  | 1/14/2015 | PURCHASE - |  | 1200 |  |  | 1024159.08 | DT
 |  |  | Colonial Spring
 |  |  | Company
Purchase |  | 1/14/2015 | PURCHASE - |  | 1641.86 |  |  | 1025800.94 | DT
 |  |  | BarcodesInc
Purchase |  | 1/14/2015 | PURCHASE - Sea |  | 970 |  |  | 1026770.94 | DT
 |  |  | Transfer
Desired
Purchase |  | 1/13/2015 | Electrolux |  | 7740 |  |  | 1022959.08 | DT
Purchase |  | 1/14/2015 | PURCHASE - Colonial Spring Company |  | 1200 |  |  | 1024159.08 | DT
Purchase |  | 1/14/2015 | PURCHASE - BarcodesInc |  | 1641.86 |  |  | 1025800.94 | DT
Purchase |  | 1/14/2015 | PURCHASE - Sea Transfer |  | 970 |  |  | 1026770.94 | DT
Spreadsheet: 870266d1716809432-search-for-value-within-range-and-return-a-list-book1-312-aligw
Sheet: Sheet2

#5 |  | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8
 |  | WK02: 02/12-02/16 | WK03: 02/19-02/23 | WK04: 02/26-03/01 | WK05: 03/04-03/08 | WK06: 03/11-03/15 | WK07: 03/18-03/22 | WK08: 03/25-03/29 | WK09: 04/01-04/05
[NAME] |  | [NAME] | [NAME] |  |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] | [NAME] |  |  | [NAME] |  | K1Yuna
[NAME] |  | KHenry |  |  |  | [NAME] |  | [NAME]
 |  | [NAME] |  |  |  |  |  | KAudry
 |  | KElina
 |  | [NAME] | [NAME] |  |  | [NAME] |  | K1Yuna
 |  | KHenry |  |  |  | [NAME] |  | [NAME]
 |  | [NAME] |  |  |  |  |  | KAudry
 |  | KElina
Spreadsheet: 810483d1671802026-autonumber-with-concatenate-issue-with-filter-ef_examp-1-
Sheet: DATA

Status |  | Mode |  | Cargo |  | Cargo2 |  | Inco |  | FF |  |  |  |  |  |  |  |  | POD
New |  | Air |  | Pallet |  | DV |  | EXW |  | [NAME] |  |  |  |  | New |  |  |  | ANTW
Quote |  | Sea |  | LCL |  | HC |  | FCA |  | Nippon |  |  |  |  | Quote |  |  |  | RTM
Booked |  | Road |  | 20' FCL |  |  |  | FOB |  | FedEx |  |  |  |  | Booked |  |  |  | NA
On Route |  |  |  | 40' FCL |  |  |  | DAP |  | UPS |  |  |  |  | On Route
Deliverd |  |  |  | FTL |  |  |  |  |  | DSV |  |  |  |  | Deliverd
Delayed |  |  |  | LTL |  |  |  |  |  | TO DECIDE |  |  |  |  | Delayed
Delayed by SUP |  |  |  |  |  |  |  |  |  | N/A |  |  |  |  | Delayed by SUP
Cancelled |  |  |  |  |  |  |  |  |  | Dachser
Spreadsheet: 88022d1287923651-excel-2007-help-with-daily-entry-for-currency-exchange-accounts-testing-mc-1
Sheet: Rate Reference

 |  | RINGGIT MALAYSIA |  | U.S DOLLAR |  | INDONESIAN RUPIAH |  | EURO BUYING |  | HONG KONG DOLLAR |  | BRITISH POUND |  | AUSTRALIAN DOLLAR |  | JAPANESE YEN |  | CANADIAN DOLLAR |  | THAI BAHT |  | NEW ZEALAND DOLLAR |  | PHILLIPINE PESO
DATE |  | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING | BUYING | SELLING
24/10/2010 |  | 2.45 | 2.35 | 1.22 | 1.32 | 7200 | 6300 | 1.65 | 1.8 | 6.25 | 5.6 | 1.95 | 2.12 | 1.18 | 1.29 | 0.0135 | 0.0155 | 1.19 | 1.3 | 27 | 22.5 | 0.92 | 1 | 35 | 30
25/10/2010 |  | 2.45 | 2.35 | 1.22 | 1.32 | 7200 | 6300 | 1.65 | 1.8 | 6.25 | 5.6 | 1.95 | 2.12 | 1.18 | 1.29 | 0.0135 | 0.0155 | 1.19 | 1.3 | 27 | 22.5 | 0.92 | 1 | 35 | 30
26/10/2010 |  | 2.45 | 2.35 | 1.22 | 1.32 | 7200 | 6300 | 1.65 | 1.8 | 6.25 | 5.6 | 1.95 | 2.12 | 1.18 | 1.29 | 0.0135 | 0.0155 | 1.19 | 1.3 | 27 | 22.5 | 0.92 | 1 | 35 | 30
27/10/2010 |  | 2.45 | 2.35 | 1.22 | 1.32 | 7200 | 6300 | 1.65 | 1.8 | 6.25 | 5.6 | 1.95 | 2.12 | 1.18 | 1.29 | 0.0135 | 0.0155 | 1.19 | 1.3 | 27 | 22.5 | 0.92 | 1 | 35 | 30
28/10/2010 |  | 2.45 | 2.35 | 1.22 | 1.32 | 7200 | 6300 | 1.65 | 1.8 | 6.25 | 5.6 | 1.95 | 2.12 | 1.18 | 1.29 | 0.0135 | 0.0155 | 1.19 | 1.3 | 27 | 22.5 | 0.92 | 1 | 35 | 30
29/10/2010
Spreadsheet: 741127d1626850794-countifs-and-dates-countifs-and-dates-stats-wip
Sheet: josephteh

Current Open Tickets |  |  |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1354967
Closed Calls
Total Calls
Calls Per SVD for June |  | OPEN | CLOSED
HUBBLE | HUBBLE BI TEAM
SEAS AP & VENDOR | SEAS AP C & VEN
SEAS DEVELOPMENT | SEAS DEVELOPMENT
SEAS ASSESSMENT | SEAS SYS SUPDEV
SEAS Helpdesk | SEAS Helpdesk
SEAS Interfaces | SEAS Interfaces
SEAS SME Escalation | SEAS SME Escalation
SEAS sys admin | SEAS sys admin
SEAS T & B | SEAS T & B
Totals
Weekly totals Open |  | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00
HUBBLE | HUBBLE BI TEAM
SEAS AP & VENDOR | SEAS AP C & VEN
SEAS DEVELOPMENT | SEAS DEVELOPMENT
SEAS ASSESSMENT | SEAS SYS SUPDEV
SEAS Helpdesk | SEAS Helpdesk
SEAS Interfaces | SEAS Interfaces
SEAS SME Escalation | SEAS SME Escalation
SEAS sys admin | SEAS sys admin
SEAS T & B | SEAS T & B
Weekly totals closed
HUBBLE | HUBBLE BI TEAM
SEAS AP & VENDOR | SEAS AP C & VEN
SEAS DEVELOPMENT | SEAS DEVELOPMENT
SEAS ASSESSMENT | SEAS SYS SUPDEV
SEAS Helpdesk | SEAS Helpdesk
SEAS Interfaces | SEAS Interfaces
SEAS SME Escalation | SEAS SME Escalation
SEAS sys admin | SEAS sys admin
SEAS T & B | SEAS T & B