tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855958d1705395931-looking-to-find-the-correct-formulas-open-to-ideas-copy-panel-builder
Sheet: WESCO SIM #'S 

INTERIOR PART # | WESCO SIM |  | BOX PART # | WESCO SIM |  | TRIM PART # | WESCO SIM
P1AL4A118I | 1 |  | [NAME] | 6745 |  | EZT2030F | 63546456
P1AL4A124I | 2 |  | [NAME] | 3456 |  | EZT2036F | 43255
P1AL4A130I | 3 |  | EZB2042RC | 4536 |  | EZT2042F | 63456754
P1AL4A142I | 4 |  | EZB2048RC | 4256 |  | [NAME] | 4536756437
P1AL4A218I | 5 |  | EZB2054RC | 2456 |  | EZT2054F | 435345432
P1AL4A224I | 6 |  | [NAME] | 2656 |  | EZT2060F | 345345
P1AL4A230I | 7 |  | EZB2072RC | 4235 |  | EZT2072F | 4354326
P1AL4A242I | 8 |  | EZB2090RC | 3255 |  | EZT2090F | 432563246
P1AL4A260I | 9 |  |  |  |  | EZT2030S | 3465645
P1AL4A272I | 10 |  |  |  |  | EZT2036S | 436245675
P1AL4A284I | 11 |  |  |  |  | EZT2042S | 4231534
P1AL4A424I | 12 |  |  |  |  | EZT2048S | 341534256
P1AL4A430I | 13 |  |  |  |  | EZT2054S | 3415134
P1AL4A442I | 14 |  |  |  |  | EZT2060S | 143251435
P1AL4A460I | 15 |  |  |  |  | EZT2072S | 12351324
P1AL4A472I | 16 |  |  |  |  | EZT2090S | 14325342165
P1AL4A484I | 17
P1AL4C118I | 18
P1AL4C124I | 19
P1AL4C130I | 20
P1AL4C142I | 21
P1AL4C218I | 22
P1AL4C224I | 23
P1AL4C230I | 24
P1AL4C242I | 25
P1AL4C260I | 26
P1AL4C272I | 27
P1AL4C284I | 28
P1AL4C424I | 29
P1AL4C430I | 30
P1AL4C442I | 31
P1AL4C460I | 32
P1AL4C472I | 33
P1AL4C484I | 34
P1AL1A118I
P1AL1A124I
P1AL1A130I
P1AL1A218I
P1AL1A224I
P1AL1A230I
P1AL1A242I
P1AL1A260I
P1AL1A272I
P1AL1A424I
P1AL1A430I
P1AL1A442I
P1AL1A460I
P1AL1A472I
P1AL1C118I
P1AL1C124I
P1AL1C130I
P1AL1C218I
P1AL1C224I
P1AL1C230I
P1AL1C242I
P1AL1C260I
P1AL1C272I
P1AL1C424I
P1AL1C430I
P1AL1C442I
P1AL1C460I
P1AL1C472I
P1AT4A242ED200I
P2AL4A118I
P2AL4A124I
P2AL4A130I
P2AL4A224I
P2AL4A230I
P2AL4A242I
P2AL4A260I
P2AL4A272I
P2AL4A424I
P2AL4A430I
P2AL4A442I
P2AL4A460I
P2AL4A472I
P2AL4C118I
P2AL4C124I
P2AL4C130I
P2AL4C224I
P2AL4C230I
P2AL4C242I
P2AL4C260I
P2AL4C272I
P2AL4C424I
P2AL4C430I
P2AL4C442I
P2AL4C460I
P2AL4C472I
Spreadsheet: 80626d1280849521-vba-dropdowns-from-named-ranges-dropdowntesting
Sheet: Sheet2

Wclass/Wattribute | Cvalues
11 | a
11 | b
11 | c
11 | d
12 | e
12 | f
12 | g
13 | h
14 | i
14 | j
14 | k
15 | l
15 | m
15 | n
15 | o
Spreadsheet: 4fbbd270-6630-4622-8c6d-bb210d065fb1
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2010/11 | 54.233 | 1163 | 0 | 1217.233 |  | 1079.705 | 92.528 | 1172.233 | 45
2011/121 | 45 | 1090 | 0 | 1135 |  | 982.058 | 102.942 | 1085 | 50
2012/132 | 50 | 1125 | 0.2 | 1175.2 |  | 1000.2 | 125 | 1125.2 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-04-12 11:57:10.490000
Spreadsheet: 197337d1354299032-calculating-overtime-hours-on-a-timesheet-weekly-timesheet-b
Sheet: Time Sheet 1st & 2nd Shift

Kenco Fleet Services
Fax:  [PHONE]
[EMAIL]
Time Period | 2012-11-26 00:00:00
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 18:00:00
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Employee Name: |  |  |  |  | Location:
Date | Day | In | Out | In | Out | Regular Hrs. | [NAME]. | PTO | Total
 |  |  |  |  | Total Hrs.
Spreadsheet: 95120d1294790992-sum-value-based-on-2-ranges-banking
Sheet: Summary

SPENDING BY MONTH & CATEGORY
Category | ALL 2011 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Fast Food
Groceries
Home Improvement
Movie Entertainment
Tools
[NAME]. - Cigarettes, Lottery
Spreadsheet: 80303d1280480532-convert-first-3-letters-into-desired-one-in-the-formula-cell-book1
Sheet: Sheet1

 |  |  | Expected Result
 | CNDDRSSCRRBK
 | CNDKDRKCCRBRD
 | CNSKDRKSCRRBK
 | PAPDRKCCRFBK
 | PAPDRKCCRPMR
 | PPOHDRKCCRSRD |  |  | Pl.put the formula in C8 cell sothat PPO convert into PAP automatically in cell C8
 | PPRHDRKSCRFBK |  |  | Pl.put the formula in C9 cell sothat PPR convert into PAP automatically in cell C9
 | SPSJDRSCCRBRD
 | SPSJDRSCCRSBK
Spreadsheet: 275279d1383430361-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-1-
Sheet: Week45

2013-11-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour
1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 | 10 | 1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 |  | 1111 | Name1 | task1
2222 | [NAME] | [NAME] | 10 | 2222 | [NAME] | [NAME] | 5 | 2222 | [NAME] | [NAME] | 7 | 2222 | [NAME] | [NAME] | 10 | 2222 | [NAME] | [NAME] |  | 2222 | [NAME] | [NAME]
3333 | Namde3 | [NAME] | 15 | 3333 | Namde3 | task1 | 15 | 3333 | Namde3 | [NAME] | 6 | 3333 | Namde3 | [NAME] | 25 | 3333 | Namde3 | task1 |  | 3333 | Namde3 | task1
Spreadsheet: 781224d1653066253-data-table-to-work-with-reference-to-pivot-table-pivot-table-and-data-table
Sheet: Sheet1

Source data |  |  |  |  | Pivot Table |  |  |  | Data table
CSO | bw backlog
H5806A14 | 50
H5806A199 | 10
[NAME]
H5806A24 | 30 |  |  | bw backlog | CSO | bw | 20.May | 21.May | 22.May | 23.May | 24.May
H5806A299 |  |  |  | 10 | H5806A199 | 10 | 5 |  | 5
H5815A11 | 20 |  |  | 20 | H5815A11 | 20 |  | 10 |  | 10
H5815A12 |  |  |  |  | H5856A117 | 20 | 5 | 5 | 5 | 5
[NAME] |  |  |  | 30 | H5806A24 | 30
H5856A117 | 20 |  |  | 50 | H5806A14 | 50 | 15 | 15 | 15
H5856A118 |  |  |  | 60 | H5856A153 | 60 | 12 | 12 | 12 | 12 | 12
H5856A153 | 60
 |  |  |  | Requirement:
 |  |  |  | My source data is huge and rows increases day by day.  For better visibility of only BALANCE rows, a pivot table is made and distributed into days.
 |  |  |  | Above Data table should change with reference to the Pivot Table (i.e. when the [NAME] table increases or decreases, data table also should change .
 |  |  |  | Is there a way out.
Spreadsheet: 688075d1595559301-conditional-lookup-free-space-hdd-comp-free-disk-space
Sheet:  Free Disk Juli

[NAME] | Drive | Label | Free Space ( MB ) | Free Space ( MB )
Comp-1 | C |  | 73317 | 121344
Comp-2 | C |  | 62558 | 121345
Comp-3 | C | System | 101159 | 135368
Comp-4 | C | System | 16982 | 135368
Comp-5 | C | System | 15231 | 135469
Comp-6 | C | System | 103271 | 135469
Comp-7 | C | System | 103276 | 135368
Comp-8 | C | System | 12456 | 135368
Comp-9 | C |  | 72243 | 121344
Comp-10 | C | System | 102777 | 135368
Comp-11 | C |  | 72902 | 121344
Comp-12 | C | System | 104092 | 135368
Comp-13 | C | System | 18323 | 135368
Comp-14 | C | System | 101498 | 135368
Comp-15 | C | System | 103702 | 135469
Spreadsheet: 239903d1370061364-using-conditional-formatting-to-highlight-cells-based-on-days-of-the-month-test_month
Sheet: JUNE

Month | 6 | 2013-05-01 00:00:00
Year | 2013
Names | 2013-06-01 00:00:00 | 2013-06-02 00:00:00 | 2013-06-03 00:00:00 | 2013-06-04 00:00:00 | 2013-06-05 00:00:00 | 2013-06-06 00:00:00 | 2013-06-07 00:00:00 | 2013-06-08 00:00:00 | 2013-06-09 00:00:00 | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 2013-06-12 00:00:00 | 2013-06-13 00:00:00 | 2013-06-14 00:00:00 | 2013-06-15 00:00:00 | 2013-06-16 00:00:00 | 2013-06-17 00:00:00 | 2013-06-18 00:00:00 | 2013-06-19 00:00:00 | 2013-06-20 00:00:00 | 2013-06-21 00:00:00 | 2013-06-22 00:00:00 | 2013-06-23 00:00:00 | 2013-06-24 00:00:00 | 2013-06-25 00:00:00 | 2013-06-26 00:00:00 | 2013-06-27 00:00:00 | 2013-06-28 00:00:00 | 2013-06-29 00:00:00 | 2013-06-30 00:00:00
 | 1
Spreadsheet: 158438d1338240024-lookup-in-split-ranges-as-in-one-copy
Sheet: Sheet1

Category 1 |  |  |  | Category 2
ProductA | ProductB | ProductC | TOTAL | ProductD | ProductE | ProductG | ProductH | TOTAL | etc.
10 | 40 | 20 |  | 5 | 15 | 25 | 30
 |  |  |  |  |  |  |  |  |  | Need to find Top 5 products EXCLUDING the total columns
 |  |  |  |  |  |  |  |  |  | Number of columns before each total varies, meaning for one category it could be a sum of 3 values, for another 4, etc.
Spreadsheet: louise_kitchen__22772__NETCO1
Sheet: LEGAL

Lawyers
Houston
Cash, [NAME]
[NAME], Mary
[NAME], [NAME]
[NAME], Leslie
Koehler, [NAME]
[NAME], [NAME]
Nettelton, Marcus
[NAME], [NAME]
Portz, [NAME]
Sager, [NAME]
St. Clair, Carol
[NAME], [NAME]
Hodge, [NAME]
Nemec, [NAME]
Hendry, Brent
[NAME], [NAME]
Sanders, [NAME]
Schuler, Lance
Canada
Flaman, [NAME]
Keohane, [NAME]
Johnston, Greg
Portland
Hall, [NAME]
Yoder, Christian
[NAME], [NAME]
Legal Specialists
Fitzgerald, Genia
Heard, [NAME]
Jones, [NAME]
Korkmas, Deb
Panus, [NAME]
Spreadsheet: 017447e7-0862-4cf4-a5b2-8cbdfd765c4e
Sheet: Holds

2012-11-01 00:00:00 |  | Mental Holds (I.C. 66-326) by Ordering County
 |  |  |  |  |  |  |  | [NAME] -YTD
 |  | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total
Region 1 | Benewah |  | 2 |  |  |  |  |  | 3
 | [NAME] |  | 5 |  |  |  |  | 1 | 23 |  | 1
 | Boundary
 | Kootenai | 8 | 26 |  | 6 |  |  | 51 | 122 | 1 | 35
 | Shoshone |  | 3 |  |  |  |  | 2 | 6 |  | 1
Region 2 | Clearwater |  |  |  |  |  |  | 2 |  | 1 | 1
 | Idaho |  |  |  |  |  |  |  |  | 3
 | Latah | 5 | 4 |  |  |  |  | 11 | 9 | 3 | 2
 | Lewis |  |  |  |  |  |  |  |  | 2
 | Nez Perce | 4 | 4 |  |  |  |  | 30 | 23 |  | 2
Region 3 | Adams |  |  |  |  |  |  | 2 | 1 |  | 3
 | Canyon | 21 | 32 |  | 2 |  |  | 149 | 192 |  | 9
 | Gem | 1 | 2 |  |  |  |  | 10 | 9
 | Owyhee | 1 |  |  |  |  |  | 8 | 5 |  | 1
 | Payette | 1 | 3 |  |  |  |  | 6 | 13
 | Washington | 1 |  |  |  |  |  | 10 | 6
Region 4 | [NAME] | 83 | 50 | 7 |  |  |  | 447 | 274 | 49 | 2
 | Boise |  |  |  |  |  |  |  | 2
 | Elmore | 2 | 2 |  |  |  |  | 9 | 17 | 2
 | Valley | 2 |  |  |  |  |  | 3 | 2
Region 5 | Blaine | 2 |  |  |  |  |  | 14 | 1
 | [NAME] |  |  |  |  |  |  |  | 1
 | Cassia | 5 | 2 |  |  |  |  | 12 | 5 |  | 1
 | Gooding | 3 |  |  |  |  |  | 8 | 4
 | [NAME] | 3 |  |  |  |  |  | 8 | 4
 | Lincoln | 2 |  |  |  |  |  | 6 | 1
 | Minidoka | 6 | 2 |  |  |  |  | 10 | 4
 | [NAME] | 23 | 7 |  |  |  |  | 117 | 31 |  | 1
Region 6 | Bannock | 10 | 1 |  |  |  |  | 82 | 8 |  | 11
 | Bear Lake
 | [NAME]
 | Franklin |  |  |  |  |  |  | 1 | 4 |  | 1
 | Oneida |  |  |  |  |  |  |  | 1
 | Power | 1 |  |  |  |  |  | 3 |  |  | 1
Region 7 | Bingham | 4 |  |  | 6 |  |  | 8 | 1 |  | 33
 | [NAME] |  | 3 |  | 9 |  |  | 6 | 12 |  | 73
 | [NAME]
 | [NAME]
 | Custer |  |  |  |  |  |  |  |  |  | 1
 | Fremont |  | 1 |  |  |  |  |  | 2 |  | 3
 | [NAME] |  | 1 |  | 1 |  |  | 3 | 1 |  | 8
 | Lemhi |  |  |  |  |  |  | 1 | 2 |  | 5
 | [NAME] |  |  |  | 2 |  |  | 3 |  |  | 13
 | Teton |  | 1 |  |  |  |  |  | 1 |  | 2
Out of State and Other |  |  |  |  |  |  |  | 5
Statewide
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 1881 | - | 303
Cross-Currency Fixed-Fixed | - | 21 | - | 23
Cross-Currency Fixed-Float | - | 453 | - | 283
TOTAL | - | 2355 | - | 609
Spreadsheet: 744718d1629392402-combine-hlookup-and-countif-or-anything-similar-sample
Sheet: Raw

Shift | Sat | Sun | Mon
Day | Day OT - 06:00 - 15:00 | Off | Day 07:00 - 16:00
Day | Day OT - 06:00 - 15:00 | Off | Day 07:00 - 16:00
Day | Day OT - 06:00 - 15:00 | Off | Day 07:00 - 16:00
Day | Day OT - 06:00 - 15:00 | Off | Day 07:00 - 16:00
Day | Off | Off | Day 07:00 - 16:00
Day | Off | Off | Day 07:00 - 16:00
Day | Off | Off | Day 07:00 - 16:00
Day | Day OT - 06:00 - 15:00 | Off | Day 07:00 - 16:00
Night | Night OT 17:30 - 02:30 | Off | Night 17:30 - 02:30
Night | Off | Night 17:30 - 02:30 | Night 17:30 - 02:30
Night | Night 17:30 - 02:30 | Night 17:30 - 02:30 | Off
Night | Off | Night 17:30 - 02:30 | Night 17:30 - 02:30
Night | Off | Night 17:30 - 02:30 | Night 19:30 - 04:30
Night | Leave | Night 17:30 - 02:30 | Off
Night | Mat | Mat | Mat
Night | Night OT 17:30 - 02:30 | Off | Night 17:30 - 02:30
Night | Night OT 17:30 - 02:30 | Off | Night 19:30 - 04:30
Night | Night OT 17:30 - 02:30 | Off | Night 19:30 - 04:30
Night | Off | Night OT 17:30 - 02:30 | Night 19:30 - 04:30
Night | Off | Off | Night 19:30 - 04:30
Night | Night OT 17:30 - 02:30 | Off | Night 19:30 - 04:30
Night | Off | Off | Night 19:30 - 04:30
Day Shift | 0
Day Shift OT | 5
Leave | 2
Night Shift | 1
Night Shift OT | 5
OFF | 9
Spreadsheet: d2217eb0-edea-4de2-b2cf-447a51cf220b
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
FPGD2 | Test | FPGD2 | [NAME] (PGD2), Serum or [NAME] | [NAME] (PGD2), S/P | Radioimmunoassay (RIA) Following Extraction of Specimens | EDTA (lavender-top) tube: EDTA OR Serum Gel Tube: SGT OR |  |  | 3 | mL | Patient should not be on aspirin, indomethacin, or anti-inflammatory medications, if possible, for at least 48 hours prior to collection of specimen.  Submit only 1 of the following specimens:   Specimen Type: Serum Collection Container/Tube: Red top or serum gel Submission Container/Tube: Plastic vial [NAME]: 3 mL Collection Instructions:  1. Separate immediately 2. Label specimen appropriately (serum).   [NAME]: Lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 3 mL Collection Instructions:  1. Separate immediately. 2. Label specimen appropriately (plasma). | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | 35-115 pg/mL    No pediatric reference ranges available for this test.   This test was performed using a kit that has not been cleared or approved by the FDA and is designated as research use only. The analytic performance characteristics of this test have been determined by Inter Science Institute. This test is not intended for diagnosis or patient management decisions without confirmation by other medically established means.   Test Performed By:  Interscience Institute                                         944 West Hyde Park Blvd                                         Inglewood, CA  90302 | Monday through Friday | 5-7 days | 7-9 days | 1 | 84150 |  |  |  |  | Inter Science Institute
FPGD2 | [NAME] | VARIES | Varies |  |  |  | Frozen | 180 days
FPGD2 | Result | Z0921 | [NAME] (PGD2), S/P | [NAME] (PGD2), S/P | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 52625d1252485524-impossible-with-pivot-table-test_enquete_results
Sheet: pivot

Taal | (Alles)
Einde bereikt | (Alles)
Browser | (Alles)
Besturingssysteem | (Alles)
 | q2_1 | q2_2 | Data
 | 2 |  | 3
 | 4 |  | 1
q1_1 | Aantal van q2_1 | Aantal van q2_2 | Aantal van q2_1 | Aantal van q2_2
1 | 0.5 | 0.5 | 0 | 0
2 | 0 | 0 | 0.5 | 0.5
Eindtotaal | 0.5 | 0.5 | 0.5 | 0.5
Spreadsheet: c4ce0641-caa2-424a-89d7-751e073ad6ae
Sheet: Table 8.4

8.4 Short-term interest rates
 |  |  |  |  |  | Months (c)
 | Annual average (a) (b) |  |  |  |  | 2014
Country | 2010 | 2011 | 2012 | 2013 |  | Jun | Jul | Aug | Sep
Australia |  | 4.399 | 3.553 | 2.616 |  | 2.39 | 2.469 | 2.483 | 2.422
Canada | 0.5700000000000001 | 0.916 | 0.9470000000000001 | 0.966 |  | 0.935 | 0.9430000000000001 | 0.9470000000000001 | 0.93
China | 1.782 | 3.193 | 2.959 | 3.411 |  | 3.243 | 3.495 | 3.238 | 3.64
France | 0.392 | 0.713 | 0.065 | 0.063 |  | 0.053 | 0.018 | 0.017 | -0.02
Germany | 0.321 | 0.544 | 0.011 | 0.032 |  | -0.006 | -0.02 | -0.005 | -0.073
India | 5.412 | 8.247 | 8.679 | 8.901 |  | 8.82 | 8.848 | 8.918000000000001 | 8.905
Italy | 0.707 | 2.027 | 1.053 | 0.454 |  | 0.24 | 0.158 | 0.08700000000000001 | 0.107
Japan | 0.114 | 0.111 | 0.11 | 0.089 |  | 0.043 | 0.035 | 0.031 | 0.032
New Zealand | 3.036 | 2.826 | 2.698 | 2.686 |  | 3.548 | 3.697 | 3.717 | 3.721
Philippines | 3.791 | 2.03 | 1.747 | 0.797 |  | 1.292 | 1.362 | 1.542 | 1.542
Singapore | 0.337 | 0.274 | 0.269 | 0.245 |  | 0.33 | 0.301 | 0.305 | 0.311
United Kingdom | 0.547 | 0.58 | 0.468 | 0.376 |  | 0.381 | 0.42 | 0.406 | 0.427
United States | 0.135 | 0.049 | 0.084 | 0.055 |  | 0.03 | 0.023 | 0.027 | 0.022
Comparable data for Australia not available prior to August 2011
(a) 3 month Treasury [NAME].
(b) Years shown are calendar years.
(c)  Monthly average
Source: Datastream
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | 2014-10-01 00:00:00
Spreadsheet: 277789d1384435219-sumproduct-from-a-table-not-calculating-test
Sheet: Sheet1

Date Worked | Handler |  | reference | Resolved | Handed | Where | Closed | other | Date Received | Time to Hand off
2013-11-14 00:00:00 | Doreen |  | 1 | Yes | Yes | Simple Recoveries | Yes | Yes | 09/10/2013 | 36
2013-11-14 00:00:00 | [NAME] |  | 2 | No | No | N/A | Yes | Yes | 13/11/2013 | 1
2013-11-14 00:00:00 | [NAME] |  | 3 | Yes | Yes | Closed | Yes | No | 13/11/2013 | 1
2013-11-14 00:00:00 | [NAME] |  | 4 | Yes | No | N/A | Yes | No | 15/10/2013 | 30
2013-11-14 00:00:00 | [NAME] |  | 212010210 | No | No | N/A | Yes | Yes | 2013-11-14 00:00:00 | 0
 | 2013-10-09 00:00:00 | 2013-11-15 00:00:00
 |  | COUNTIF | SUMPRODUCT
 | [NAME] | 3 | 0
 | [NAME] | 1 | 0
 | Doreen | 0 | 0
Spreadsheet: 733725d1621763407-monthly-rental-revenue-calculation-with-rcd-and-red-date-and-different-escalation-rates-monthly-rent-calculation-template
Sheet: Sheet1

Start Year | 2020-01-01 00:00:00
Unit | Area | RCD | RED | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
1 | 5000 | 2021-04-11 00:00:00 |  | 100 | 100 | 105 | 110
Spreadsheet: mary_hain__25839__trani_1999_2000
Sheet: Sheet1

Counterparty |  | 1999 | 2000
Benton County PUD |  | 112131.5 | 217593.25
[NAME] |  | 11350 | 5786753.1
Richland PUD |  | 10632.5 | 3500
Franklin PUD |  | 14490 | 6126.25
Montana |  | 6444.14 | 33382.66
Pacificorp |  | 0 | 94712.65
Gray Harbor PUD |  | 9065 | 81133
Snohomish PUD |  | 201392.92 | 50000.06
Seattle City Light |  | 134004.55 | 5264
Spreadsheet: 68092d1268660790-excel-2007-looking-for-excel-function-that-displays-first-occurrence-of-data-in-a-range-of-data-first-occurances
Sheet: Sheet1

Range | <- must be something in first row…
Apple | <- data must start in 2nd row |  |  |  |  | Apple
Apple |  |  |  |  |  | Orange
Apple |  |  |  |  |  | Tomato
Apple |  |  |  |  |  | Plum
Orange
Orange
Orange
Apple
Tomato
Plum
Plum
Plum
Tomato
Orange
Spreadsheet: 739597d1625811247-fuzzy-match-without-fuzzy-lookup-add-in-power-query-and-vba-sample-data
Sheet: Sheet1

Samsung | Samsung
The Samsung | The | Samsung
LG | LG
LG Inc | LG | Inc
General | General |  |  |  |  | Likewise I need other matching results below Samsung Co. | [NAME] works only in cell F1, To get the results for other words like LG, Philips etc., I have to manually change cell reference every time in search function in F1
Sony | Sony
Philips | Philips
Philips Co. | Philips | Co.
Acer | Acer
Samsung Inc | Samsung | Inc
Samsung Co. | Samsung | Co.
[NAME] | [NAME] | Philps
The LG | The | LG
LG Co. | LG | Co.
General & Co. | General | & | Co.
General Co. | General | Co.
Sony Inc | Sony | Inc
Sony Corp. | Sony | Corp.
Philips Inc. | Philips | Inc.
The Philips | The | Philips
Acer Co. | Acer | Co.
Spreadsheet: 91628d1291305635-report-using-vlook-up-excel-rep-sheet
Sheet: RAW DATA

Store Nbr | [NAME] | TSM NAME | UPC | Item Desc 1 | [NAME] | Store Type [NAME] | Street Address | City | State | Latest 4 Weeks POS Sales | Latest 4 Weeks Avg Price
1000 | 123 | BOB | 5587203518 | PRODUCT A | A | LARGE | 123 EXAMPLE | [NAME] | CALIFORNIA | 38.16 | 4.77 |  | 3
1000 | 354 | BOB | 5587203519 | PRODUCT B | I | LARGE | 124 EXAMPLE | SMITHVILLE | NEW YORK | 50 | 4.77
1000 | 456 | BOB | 5587203520 | PRODUCT C | A | SMALL | 125 EXAMPLE | WALLVILLE | NEW YORK | 90 | 4.77
1000 | 126 | BOB | 5587203521 | PRODUCT D | D | SMALL | 126 EXAMPLE | TIMIVILLE | MICHIGAN | 45 | 4.77
1001 | 1236 | BOB | [PHONE] | PRODUCT E | A | LARGE | 127 EXAMPLE | BOWMANVILLE | MICHIGAN | 4.77 | 4.77 | 1
1001 | 456 | PATRICIA | 5587203518 | PRODUCT A | A | LARGE | 128 EXAMPLE | TENVILLE | DC | 4.77 | 4.77 | 2
1001 | 1236 | PATRICIA | 5587203520 | PRODUCT C | D | LARGE | 129 EXAMPLE | SMALLVILLE | DC | 4.77 | 4.77 | 3
Spreadsheet: 55652d1255763620-copying-rows-to-new-sheet-based-on-condition-sample-workbook
Sheet: Phosphate Schedule

Recv'd Date | WO # | Customers | Items | Finish / Color | Phosphate | Chem-Film | Blast | Mask | Powder | Paint | DUE DATE | STATUS
2009-10-15 00:00:00 | 64591 | Plating | Frames | Gloss | Y |  |  | Y | Y |  | asap
Spreadsheet: 267693d1380138808-remove-duplicates-help-25-09-2013_excelforum_removing_duplicates-ok
Sheet: ORIGINAL DATA

Batch # | Document # | Amount | Debit | Credit |  |  |  | 10
AUX | 1111 | 800 | 800 | 0 |  | [NAME] | 1
AUX | 1111 | 800 | 0 | 250 |  | AUX11118000250 | 2
AUX | 1111 | 800 | 0 | 550 |  | AUX11118000550 | 3
AUX | 2222 | 400 | 250 | 0 |  | AUX22224002500 | 4
AUX | 2222 | 400 | 150 | 0 |  | AUX22224001500 | 5
AUX | 2222 | 400 | 0 | 400 |  | [NAME] | 6
AUX | 2222 | 400 | 250 | 0 |  | AUX22224002500
AUX | 2222 | 400 | 150 | 0 |  | AUX22224001500
AUX | 2222 | 400 | 0 | 400 |  | [NAME]
AUX | 3333 | 1000 | 500 | 0 |  | AUX333310005000 | 7
AUX | 3333 | 1000 | 300 | 0 |  | AUX333310003000 | 8
AUX | 3333 | 1000 | 200 | 0 |  | [NAME] | 9
AUX | 3333 | 1000 | 0 | 1000 |  | [NAME] | 10
AUX | 3333 | 1000 | 500 | 0 |  | AUX333310005000
AUX | 3333 | 1000 | 300 | 0 |  | AUX333310003000
AUX | 3333 | 1000 | 200 | 0 |  | [NAME]
AUX | 3333 | 1000 | 0 | 1000 |  | [NAME]
AUX | 3333 | 1000 | 500 | 0 |  | AUX333310005000
AUX | 3333 | 1000 | 300 | 0 |  | AUX333310003000
AUX | 3333 | 1000 | 200 | 0 |  | [NAME]
AUX | 3333 | 1000 | 0 | 1000 |  | [NAME]
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index/Index Tranche | 30169 | 88656 | 79983 | 198808
OTHER* | 0 | 0 | 12817 | 12817
TOTAL | 30169 | 88656 | 92800 | 211625
*OTHER variable includes exotic credit products, swaptions, and total return swaps.