tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813105d1673551144-how-return-substring-of-count-for-override-for-found-december-etc-examplereport
Sheet: Sheet1

result1 | [NAME] | result3 | [NAME] | result5 | overall [NAME] | Feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | 2023-01-01 00:00:00 | override [NAME] | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | 2023-01-01 00:00:00
overallCount 2023/01 11 | overallCount 2022/12 35 | overallCount  2022/01 12 | overrideCount 2022/01 5 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 11 | 5
overallCount 2023/02 1 | overallCount 2022/11 34 | overrideCount 2022/02 9 | overrideCount 2022/01 5 |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  | 5
----- | (3 rows) | OverrideYearOrders | overrideCount 2022/10 2 | overallCount 2023/01 6 | 6
Spreadsheet: 810587d1671870523-filtering-data-s666-pq-filtering-data
Sheet: Sheet1

 | Student | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 | Subject 9 | Subject 10 | Subject 11 | Subject A | Subject B | Subject C |  | Result | Student
 | Student 1 |  |  | 40 | 47 |  | 43 | 50 | 53 |  |  |  |  |  |  |  | student 1 | Student 1
 | Student 2 |  |  | 30 |  |  | 22 |  | 28 |  |  |  |  |  |  |  | student 2 | Student 2
 | Student 3 |  |  | 46 |  |  | 65 |  |  |  |  |  |  |  |  |  | student 3 | Student 3
 | Student 4 |  |  | 39 |  |  | 43 |  |  |  |  |  |  |  |  |  | student 4 | Student 4
 | Student 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | student 11 | Student 11
 | Student 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 12 | Student 12
 | Student 7 |  |  |  |  | 50 | 60 |  |  |  |  |  |  |  |  |  | student 13 | Student 13
 | Student 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 14 | Student 14
 | Student 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 15 | Student 15
 | Student 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 16 | Student 16
 | Student 11 |  |  | 41 |  |  | 67 | 40 | 50 |  |  |  |  |  |  |  | student 22 | Student 22
 | Student 12 |  |  | 17 |  | 22 | 25 |  | 28 |  |  |  |  |  |  |  | student 30 | Student 30
 | Student 13 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  | student 34 | Student 34
 | Student 14 | 13 | 20 | 10 | 19 | 0 | 15 | 21 | 25 |  |  |  |  |  |  |  | student 35 | Student 35
 | Student 15 |  | 71 | 55 |  | 52 | 43 |  |  |  |  |  |  |  |  |  | student 37 | Student 37
 | Student 16 |  |  | 50 |  |  |  |  | 41 |  |  |  |  |  |  |  | student 40 | Student 40
 | Student 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 42 | Student 42
 | Student 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 43 | Student 43
 | Student 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | student 45 | Student 45
 | Student 20 |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  | student 46 | Student 46
 | Student 21 |  |  |  |  |  |  | 55 | 51 |  |  |  |  |  |  |  | student 47 | Student 47
 | Student 22 |  |  | 51 |  |  | 39 |  | 51 |  |  |  |  |  |  |  | student 50 | Student 50
 | Student 23
 | Student 24 |  |  |  |  |  | 50
 | Student 25
 | Student 26 |  |  | 50 |  |  | 59
 | Student 27
 | Student 28
 | Student 29
 | Student 30 |  |  | 40 |  |  | 50
 | Student 31
 | Student 32 |  |  |  |  |  | 50
 | Student 33 |  |  |  |  |  |  |  | 51
 | Student 34 |  |  |  |  |  | 21
 | Student 35 |  |  | 43 |  | 50 | 44
 | Student 36
 | Student 37 |  |  | 10 |  |  | 18 |  | 29
 | Student 38 |  |  |  |  |  | 79 |  | 67
 | Student 39
 | Student 40 |  |  | 43
 | Student 41
 | Student 42 |  |  | 33 |  | 50 | 53 | 48 | 50
 | Student 43 |  |  | 52 |  |  | 43 |  | 50
 | Student 44
 | Student 45 |  |  | 43 |  | 52 | 52 |  | 56
 | Student 46 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Student 47 |  |  | 40 |  |  | 52 |  | 50
 | Student 48
 | Student 49 |  |  |  |  |  | 64
 | Student 50 |  |  | 10 |  |  | 31
Spreadsheet: 542023d1507671188-separating-city-name-from-addresses-without-delimiter-s666-1204206-separating-city-name-from-addresses-without-delimiter
Sheet: Sheet1

How I have | WHAT I WANT
Address | Address | CITY |  | Address | City
One E. Washington Street Ste. 1900 Phoenix | One E. Washington Street Ste. 1900 | Phoenix |  | One E. Washington Street Ste. 1900 | Phoenix
2525 E. Arizona Biltmore Circle Ste. B-218 Phoenix | 2525 E. Arizona Biltmore Circle Ste. B-218 | Phoenix |  | 2525 E. Arizona Biltmore Circle Ste. B-218 | Phoenix
2575 E. Camelback Road Ste. 1100 Phoenix | 2575 E. Camelback Road Ste. 1100 | Phoenix |  | 2575 E. Camelback Road Ste. 1100 | Phoenix
101 Montgomery Street Ste. 2300 San Francisco | 101 Montgomery Street Ste. 2300 | San Francisco |  | 101 Montgomery Street Ste. 2300 | San Francisco
One Market Spear Tower Ste. 2200 San Francisco | One Market Spear Tower Ste. 2200 | San Francisco |  | One Market Spear Tower Ste. 2200 | San Francisco
921 S. 8th Avenue Stop 8410 Pocatello | 921 S. 8th Avenue Stop 8410 | Pocatello |  | 921 S. 8th Avenue Stop 8410 | Pocatello
TCA - Cheri Mattson PO Box 126 [NAME] | TCA - Cheri Mattson PO Box 126 | [NAME] |  | TCA - Cheri Mattson PO Box 126 | [NAME]
151 4th Street West Unit 3359 Ketchum | 151 4th Street West Unit 3359 | Ketchum |  | 151 4th Street West Unit 3359 | Ketchum
2300 [NAME]. [NAME]. 210 Idaho Falls | 2300 [NAME]. [NAME]. 210 | Idaho Falls |  | 2300 [NAME]. [NAME]. 210 | Idaho Falls
2235 E. 25th Street Ste. 250 Idaho Falls | 2235 E. 25th Street Ste. 250 | Idaho Falls |  | 2235 E. 25th Street Ste. 250 | Idaho Falls
3456 E. 17th Street Ste. 280 Idaho Falls | 3456 E. 17th Street Ste. 280 | Idaho Falls |  | 3456 E. 17th Street Ste. 280 | Idaho Falls
339 W. State [NAME]. 205 Eagle | 339 W. State [NAME]. 205 | Eagle |  | 339 W. State [NAME]. 205 | Eagle
291 E. Shore Drive Ste. 200 Eagle | 291 E. Shore Drive Ste. 200 | Eagle |  | 291 E. Shore Drive Ste. 200 | Eagle
291 E. Shore Drive Ste. 200 Eagle | 291 E. Shore Drive Ste. 200 | Eagle |  | 291 E. Shore Drive Ste. 200 | Eagle
2825 S. Meridian Road Ste. 150 Meridian | 2825 S. Meridian Road Ste. 150 | Meridian |  | 2825 S. Meridian Road Ste. 150 | Meridian
524 Third Street South PM Box 142 Nampa | 524 Third Street South PM Box 142 | Nampa |  | 524 Third Street South PM Box 142 | Nampa
5700 E. Franklin Road Ste. 200 Nampa | 5700 E. Franklin Road Ste. 200 | Nampa |  | 5700 E. Franklin Road Ste. 200 | Nampa
608 Northwest Blvd. [NAME]. 300 Coeur d'Alene | 608 Northwest Blvd. [NAME]. 300 | Coeur d'Alene |  | 608 Northwest Blvd. [NAME]. 300 | Coeur d'Alene
Spreadsheet: 842510d1694573502-would-like-to-list-several-cells-from-a-lookup-incl-other-data-vstack-hstack-mosom-6
Sheet: Sheet2

Manager: | Manager 3
Roles: |  |  |  |  |  |  |  |  |  |  | Role 3 | Role 5
 | Role 3 |  | Topic 1 | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 5
 | Role 5 |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 |  | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
Spreadsheet: 219619d1362824764-what-to-enter-in-cell-a7-to-exclude-anything-that-appears-in-cells-a3-a6-linked-to-sumifs-f-to-exc-po-on-summary
Sheet: POSum

Contract  Details | Period | Week #
 |  | 1 | 2 | 3 | 4 | 5 | 6
A | 01/01/13
D
G
<>A |  |  |  |  |  |  |  | Correct - when single NO
<>A,<>D,<>G |  |  |  |  |  |  |  | What to type in Cell A7 to exclude everything in Cell A3:A5
EXPECTED |  | 50 |  |  | 100 | 10
A | 2013-02-01 00:00:00
D
G
<>A |  |  |  |  |  |  |  | Correct - when single NO
<>A,<>D,<>G |  |  |  |  |  |  |  | What to type in Cell A16 to exclude everything in Cell A12:A14
EXPECTED |  | 120 | 50 |  | 10
Spreadsheet: 869463d1716023912-bypass-the-number-of-cells-based-on-the-value-ang-highlight-calender-template
Sheet: Sheet1

Start Date | Frequency | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00
2024-01-01 00:00:00 | 7
2024-01-01 00:00:00 | 14
2024-01-01 00:00:00 | 30
2024-01-01 00:00:00 | 10
2024-01-01 00:00:00 | 5
2024-01-01 00:00:00 | 20
Spreadsheet: 726435d1617233145-complex-transposition-in-a-datalist-ef1518_transpose-data
Sheet: Monthly donor analysis 4 years

ID | GIFT DATE | AMOUNT |  | ID | 2018-01-01 00:00:00
11111 | 2018-01-15 00:00:00 | 24 |  | 11111
11111 | 2018-02-16 00:00:00 | 24 |  | 22222
22222 | 2018-01-15 00:00:00 | 18 |  | 33333
33333 | 2018-03-15 00:00:00 | 10
Spreadsheet: 556e6ce2-39da-4d9f-8a39-f79c8818f36d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 20. Quarter measure of aggregate monthly hours worked by Industry Sector - Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  Agriculture ; |  |  | Seasonally Adjusted | A3539308V | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market excluding Agriculture (Rest of Market) ; |  |  | Seasonally Adjusted | A3539305L | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market ; |  |  | Seasonally Adjusted | A3539309W | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Education ; |  |  | Seasonally Adjusted | A3539306R | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market excluding Education (Rest of Non Market) ; |  |  | Seasonally Adjusted | A3539307T | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market ; |  |  | Seasonally Adjusted | A3539310F | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Total (Industry ANZSIC06) ; |  |  | Seasonally Adjusted | A3539311J | 1984-12-01 00:00:00 | 2010-03-01 00:00:00 | 102 | 000 Hours | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 459157d1462448164-increase-value-until-value-in-another-cell-reaches-target-sample-cost-analysis
Sheet: Sheet1

Product Code | Description | Supplier | Supplier Code | Unit Weight | # [NAME] | Total Weight | Unit Cost (Net) | Total Cost (Net) | Total (Inc VAT) | Shipping Method | Shipping (Net) | Shipping (Inc VAT) | Packaging | [NAME] | EBAY | PAYPAL | INSERTATION | TOTAL COST | Profit | Margin | Sell Price (Net) | Sell Price (Inc VAT)
AF11055 | FRESH - Wild Berry Dry Formulation Air Freshener Aerosol (400ml) | [NAME] | C053LEV | 0.45 | 1 | 0.45 | 1.25 | 1.25 | 1.5 | My Hermes 0-1KG | 2.25 | 2.7 | 0.1 | 0.04 | 0 | 0.2 | 0.05 | 3.89 | -3.89 | -311.2 |  | 0
Spreadsheet: 238402d1369524190-need-a-way-to-search-using-a-date-ef418_date-search-2
Sheet: Sheet1

Employee | Start | End | Hours
A | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 12
A | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 12
A | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 12
b | 2013-08-29 00:00:00 | 2013-08-30 00:00:00 | 12 |  |  | Date | 2012-12-31 00:00:00
c | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 12
c | 2014-02-05 00:00:00 | 2014-02-06 00:00:00 | 12 |  |  | Employee | Start | End | Hours
d | 2014-04-26 00:00:00 | 2014-04-27 00:00:00 | 12
f | 2014-07-15 00:00:00 | 2014-07-16 00:00:00 | 12
g | 2014-10-03 00:00:00 | 2014-10-04 00:00:00 | 12
d | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 12
Spreadsheet: 707930d1607538972-if-a-match-then-enter-corresponding-value-sales-table
Sheet: Customers

Customers Orders | Date | Value
[NAME]
c
a
b
c
a
b
c
a
b
c
a
vv |  | 45
rest |  | 12
Spreadsheet: 812098d1672945824-need-if-statement-to-check-text-sample-if-statement-hd
Sheet: Sheet1

Site 1 | Site 2 | Site 3 | Site 4 | Site 5 | Site 6 | Site 7 | Site 8 | Site 9 | Site 10 | Site 11 | Site 12 | Site 13 | Site 14 | IF Function to check if column A to N does not contain any Yes or Yes.., return 1, otherwise show blank. | If column A to N contains ONLY Yes or Yes... (#N/A excluded), return 1, otherwise show blank | If column A to N contains ONLY Yes or Yes... (#N/A included), return 1, otherwise show blank
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Yes, sometimes | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | No | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | Yes | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Yes
Yes | 0 | #N/A | #N/A | 0 | Yes, trained | #N/A | No | No | Yes | #N/A | Yes | #N/A | Yes
No | #N/A | #N/A | Yes, train at other sites | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Unsure | #N/A | #N/A | #N/A
Spreadsheet: 08098ba7-a213-43fa-8f59-8f2a470fb251
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Bedriftsrådgivning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Råd & Regnskap Akershus AS | Holmav. 20 | 1339 | Vøyenenga | 21 62 70 00 | 850 29 500
Tet | [NAME] g 10 | 3717 | Skien | 35 51 92 30 | 35 51 92 31
Intersoft Management Systems AS | Lysaker torg 45 | 1366 | Lysaker | 22 22 63 00
Beckman Lundevall Revisjon AS | [NAME]. 70 | 0680 | Oslo | 22 78 28 00 | 22 78 28 01
[NAME] | Kabelg. 2 | 0580 | Oslo | 22 86 50 00 | 22 20 18 01
Akselera Norway AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
Akselera AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
[NAME] | Filipstad Brygge 1 | 0252 | Oslo | 23 11 42 00 | 23 11 42 01
Russel Reynolds Associates AS | Universitetsg. 7 | 0164 | Oslo | 22 03 80 10
Akselera AS | Strandv. 37 | 1366 | Lysaker | 952 68 706
BearingPoint Norway AS | Tjuvholmen allé 3 | 0252 | Oslo | 24 06 90 00 | 24 06 90 01
Enova Business Services AS | Astrids v 1 | 1473 | Lørenskog | 67 98 04 20
Akselera Norway AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
TeamWork OU | [NAME] v 12A | 0484 | Oslo | 22 36 56 10
EH Consulting | Sykehusg. 30 | 8613 | Mo i Rana | 906 14 830
CBA Consultans AS | Klinestadmoen 9 | 3241 | Sandefjord | 454 14 600
Astanel AS | Gamlev. 33 | 6065 | Ulsteinvik | 900 27 234
McKinsey & Company Inc Norway | [NAME] g 5 | 0161 | Oslo | 22 86 25 00 | 22 86 26 00
Strategica People and Processes AS | Bogstadv. 30 | 0355 | Oslo | 23 36 60 52
Assessit AS | Kjøpmannsg. 40 | 7011 | Trondheim | 913 75 565
Elverum Regnskapsservice AS | Storg. 17 | 2408 | Elverum | 62 42 26 02 | 62 42 26 49
Tingvoll Næringsforum | Gunnars v 10 | 6630 | Tingvoll | 71 53 31 66
Kvalitet & Sikkerhet Rådgivning AS | Gamlev. 6A | 3550 | Gol | 880 02 020
ISCO Group AS | Oscars g 23 | 0352 | Oslo | 22 06 87 00 | 22 06 87 01
Holte Consulting AS | Drammensv. 147A | 0277 | Oslo | 22 04 95 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 140483d1328773731-excel-2008-drop-down-list-example-1
Sheet: Sheet1

Company 1
Company 2
select company | select name
Company 1
Company 1 | Name | Adress | zipcode | city | country |  |  | Company 2 | Name | Adress | zipcode | city | country
Bik Bok | [NAME] | karlsgatan 2 | 24889 | Stockholm | Sweden |  |  | [NAME] | [NAME] | storgatan 3 | 25689 | Stockholm | Sweden
[NAME] | [NAME] | storgatan 3 | 25689 | Stockholm | Sweden |  |  | H&M | [NAME] | storgatan 14 | 59989 | Stockholm | Sweden
Lindex | [NAME] | södergatan 23 | 26998 | Stockholm | Sweden |  |  | Lindex | [NAME] | södergatan 23 | 26998 | Stockholm | Sweden
Lindex | [NAME] | södergatan 23 | 89956 | Stockholm | Sweden |  |  | Lindex | [NAME] | södergatan 23 | 89956 | Stockholm | Sweden
Lindex | [NAME] | södergatan 23 | 25889 | Stockholm | Sweden |  |  | Lindex | [NAME] | södergatan 23 | 25889 | Stockholm | Sweden
Spreadsheet: 807968d1670199124-dynamic-dependent-dropdown-list-in-excel-categories-tms-v2
Sheet: Sheet1 (TMS)

 | STEP 1
 | Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prep
 | Cat 1 | << 1. Up to 10 but not necessarily 10 (and with blanks) |  |  |  |  | << 2. Categories reorganized to remove blanks
 | Cat 2 |  |  |  |  | Cat 2
 | Cat 3 |  |  |  |  | Cat 3
 | Cat 4 |  |  |  |  | Cat 4 |  |  | Cat 1 | << 3. Dropdown on only available categories, without blanks
 | Cat 5 |  |  |  |  | Cat 5 |  |  | "DV: $G$5#"
 |  |  |  |  |  | Cat 6
 | Cat 6 |  |  |  |  | Cat 7
 | Cat 7
 | STEP 2 | << Up to 16 but not necessarily 16 (and with blanks). Each associated with a Category
 | Sub Categories | Associated Cat
1 | Sub 1 | Cat 1 | << Using categories dropdown previously created to associate category to each sub
 | Sub 2 | Cat 4
 | Sub 3 | Cat 6
 | Sub4 | Cat 4 |  | Cat Dropdown
 | Sub 5 | Cat 2 |  | Cat 2 |  |  | Cat 2 | Cat 3 | Cat 4 | Cat 5 | Cat 6 | Cat 7
 | Sub 6 | Cat 3 |  | "DV: $G$5#"
 |  |  |  | [NAME]?? |  | Sub7 |  | Sub 13 | Sub4 | Sub 12 | Sub 10 | Sub 11
 | Sub7 | Cat 1 |  | Sub 1
 | Sub 8 | Cat 7 |  | "DV: =INDIRECT(SUBSTITUTE($E$24," ","_"))"
 | Sub 9 | Cat 5
 | Sub 10 | Cat 6
 |  |  |  | (copied across)
 | Sub 11 | Cat 7
 | Sub 12 | Cat 5
 | Sub 13 | Cat 3
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 27 March 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-03-27 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation 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 | Annual leave
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | Com off Air Show
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 743457d1628519016-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main
Sheet: March

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 100
 |  |  |  |  | 20
 |  |  |  |  | 1
 |  | This Month | Last Month Total | Annual to date
Total Business Kilometres |  |  |  |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: 56924d1257102788-how-to-filter-data-in-spreadsheets-example-workbook
Sheet: Comparative Data

Kanji |  | WRP_CardID
一 |  | 1
七 |  | 2
万 |  | 3
三 |  | 4
上 |  | 5
下 |  | 6
中 |  | 7
九 |  | 8
二 |  | 9
五 |  | 10
人 |  | 11
八 |  | 12
六 |  | 13
会 |  | 14
何 |  | 15
先 |  | 16
入 |  | 17
円 |  | 20
出 |  | 21
分 |  | 22
前 |  | 23
北 |  | 24
千 |  | 26
午 |  | 27
半 |  | 28
南 |  | 29
友 |  | 30
口 |  | 31
古 |  | 32
名 |  | 34
国 |  | 36
土 |  | 37
外 |  | 38
多 |  | 39
大 |  | 40
天 |  | 41
女 |  | 42
子 |  | 43
学 |  | 44
Spreadsheet: 55026d1255100019-to-if-or-not-to-if-index-and-match
Sheet: Sheet1

9 | 11.25 |  |  |  |  | 1 | 1.25
6 | 7.5 |  |  |  |  | 2 | 2.5
6 | 7.5 |  |  |  |  | 3 | 3.75
8 | 10 |  |  |  |  | 4 | 5
9 | 11.25 |  |  |  |  | 5 | 6.25
4 | 5 |  |  |  |  | 6 | 7.5
9 | 11.25 |  |  |  |  | 7 | 8.75
2 | 2.5 |  |  |  |  | 8 | 10
9 | 11.25 |  |  |  |  | 9 | 11.25
4 | 5
3 | 3.75
5 | 6.25
7 | 8.75
8 | 10
1 | 1.25
9 | 11.25
1 | 1.25
2 | 2.5
4 | 5
4 | 5
8 | 10
6 | 7.5
1 | 1.25
3 | 3.75
4 | 5
8 | 10
6 | 7.5
9 | 11.25
3 | 3.75
7 | 8.75
5 | 6.25
7 | 8.75
8 | 10
6 | 7.5
8 | 10
4 | 5
1 | 1.25