tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25636__31S
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 31S
COMPANY NAME  Limbach Company
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -229595.6
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -20984667
RE - Beg Bal |  | 0920 |  | -9113000 |  | -4550663 |  |  |  |  |  |  |  |  |  | C&E Entries
RE - Net Income |  | 0930
RE - Net Income (Fair Value Adjustment) |  | 0931 |  | 51426 |  |  |  | 51427
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 855109d1704804537-help-with-let-function-digital-operator-production-log-v3-3-
Sheet: Daily Totals

Client | Job # | Lettercode/ Part | Remake # | Printer | Speed | Today's Date | Scheduled  Time | Start Time | Stop Time | Actual Time | [NAME] | Sheets Printed | Material | [NAME] | Height | # Up | Column1 | Column2 | Square Feet | Sq. Feet / Hr | MS UPDATE
 | 243695 | 1 | y | Tauro-2 | 4 Pass | 2024-01-08 00:00:00 | 05:16:48 | 06:23:00 | 0.2673611111111111 | -0.03333333333333321 | -0.2993055555555554 | 2 | pap-so-0061 | 69 | 42 | 1 | 20.125 | 0 | 40.25 | -1207.500000000004 | Yes
calares | 242973 | 10, 12 | y | Tauro-2 | 4 Pass | 2024-01-09 00:00:00 | 12:00:00 | 06:26:00 | 0.2847222222222222 | -0.4499999999999998 | -0.7180555555555553 | 8 | pap-so-1374 | 28 | 47 | 3 | 9.13888888888889 | 0 | 73.11111111111111 | -162.4691358024692 | 0
ggpm | 20307 | 122.1 | n | Tauro-2 | 4 Pass | 2024-01-10 00:00:00 | 1900-01-01 13:12:00 | 06:52:00 | 0.6458333333333334 | -9.116666666666667 | -9.402777777777779 | 420 | pap-so-0017 | 22 | 28 | 4 | 4.277777777777778 | 0 | 1796.666666666667 | -197.0749542961609 | Yes
HH GLOBAL TMOBILE | 243775 | 1,2 | 0 | 3R-2 | 6 Pass | 2024-01-09 00:00:00 | 12:00:00 | 07:00:00 | 0.6458333333333334 | 8.5 | 8 | 650 | [NAME] | 48 | 41 | 2 | 13.66666666666667 | 0 | 8883.333333333332 | 1045.098039215686 | 0
[NAME] | 243684 | 2 | 0 | 3R-1 | 5 Pass | 2024-01-10 00:00:00 | 1900-01-01 06:00:00 | 08:00:00 | 0.3472222222222223 | 0.3333333333333348 | -0.9166666666666652 | 3 | ART-4393 | 27 | 23 | 1 | 4.3125 | 0 | 12.9375 | 38.81249999999983 | Yes
GGPM | 20307 | 403.1 | 143961 | Big HP | 5 Pass | 2024-01-11 00:00:00 | 18:00:00 | 08:30:00 | 0.3611111111111111 | 0.1666666666666661 | -0.5833333333333339 | 30 | ART-4388 | 50 | 6 | 9 | 2.083333333333333 | 0 | 62.50000000000001 | 375.0000000000014 | 0
GGPM | 20314 | 384.3 | 0 | 3R-1 | 5 Pass | 2024-01-12 00:00:00 | 13:12:00 | 09:30:00 | 0.6458333333333334 | 6.000000000000001 | 5.450000000000001 | 1388 | ART-4388 | 50 | 8 | 3 | 2.777777777777778 | 0 | 3855.555555555555 | 642.5925925925924 | 0
AD TRENDS ADVERTISING INC. | 243741 | 1 | 0 | 3R-1 | 5 Pass | 2024-01-13 00:00:00 | 08:24:00 | 11:00:00 | 0.4722222222222223 | 0.3333333333333348 | -0.01666666666666516 | 2 | ART-2150 | 22 | 13 | 2 | 1.986111111111111 | 0 | 3.972222222222222 | 11.91666666666661 | 0
Spreadsheet: 538d3352-527a-4f81-a517-a36e0e1e0036
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Category | Full description | Short name
1 | Motor Cars | Motor Cars
2 | Light commercial vehicles (carrying capacity up to and including 3.5 tons) | Light CV
3 | Heavy commercial vehicles (carrying capacity over 3.5 tons) | Heavy CV
4 | Buses, minibuses and coaches i.e. vehicles with a seating capacity greater than 9 (incl. the driver) | Buses, coaches etc
5 | Taxis, private and public hire vehicles | Taxis etc
6 | Self-drive hire vehicles | SDH
7 | Tankers/Petrol Tankers/Vehicles carrying hazardous goods | Tankers, hazardous
8 | Motor cycles | Motor cycles
9 | Motor Trade Road Risks | Motor Trade
10 | All others | All others
Spreadsheet: 62865d1263867395-array-lookup-return-sum-multiple-values-test
Sheet: Sheet1

Task | Resource1 | Resource2 | Resource3 | Resource4 | Resource5 | Resource6 | Days |  |  | Resource# | Days
Demo | 2 | 3 | 7 |  |  |  | 4 |  |  | 1 | 2
Framing | 2 | 5 | 6 | 8 |  |  | 1 |  |  | 2 | 7
Mechanical | 4 | 5 | 7 | 8 |  |  | 5 |  |  | 3 | 6
Windows | 1 | 2 | 3 | 5 | 6 | 8 | 2 |  |  | 4 | 5
 |  |  |  |  |  |  |  |  |  | 5 | 8
 |  |  |  |  |  |  |  |  |  | 6 | 3
 |  |  |  |  |  |  |  |  |  | 7 | 9
 |  |  |  |  |  |  |  |  |  | 8 | 8
Here's what I'm trying to accomplish... it seems so simple but pulling my hair out. I want to look up values from table (A1:H5) and then for each occurrence of a particular number, return the value in the same row in column H, and sum when there are multiple values (see green shaded area for desired output. The numbers are references from a drop-down list on anopther sheet. For example, the number 8 occurs in E3, E4, and G5. I want to return the sum of the corresponding values in column H (1,5, and 2). I've spent hours trying to work this one out, I'm sure this is an array formula, but I can't manage to make it work. Any help would be appreciated.
Spreadsheet: 744112d1628960457-sum-by-date-range-and-name-sum-by-date-and-name
Sheet: Sheet1

 |  | Date | Wages | Person |  |  |  | Q1 (1/1/21 - 3/31/21) | Q2 | Q3 | Q4
 |  | 2021-01-15 00:00:00 | 1000 | [NAME] |  |  | [NAME]
 |  | 2021-01-15 00:00:00 | 1000 | [NAME] |  |  | [NAME]
 |  | 2021-01-15 00:00:00 | 1000 | Pam |  |  | Pam
 |  | 2021-01-31 00:00:00 | 2000 | [NAME]
 |  | 2021-01-31 00:00:00 | 2000 | [NAME]
 |  | 2021-01-31 00:00:00 | 2000 | Pam
 |  | 2021-02-15 00:00:00 | 3000 | [NAME]
 |  | 2021-02-15 00:00:00 | 3000 | [NAME]
 |  | 2021-02-15 00:00:00 | 3000 | Pam
 |  | 2021-02-28 00:00:00 | 1000 | [NAME]
 |  | 2021-02-28 00:00:00 | 1000 | [NAME]
 |  | 2021-02-28 00:00:00 | 1000 | Pam
 |  | 2021-03-15 00:00:00 | 2000 | [NAME]
 |  | 2021-03-15 00:00:00 | 2000 | [NAME]
 |  | 2021-03-15 00:00:00 | 2000 | Pam
 |  | 2021-03-31 00:00:00 | 3000 | [NAME]
 |  | 2021-03-31 00:00:00 | 3000 | [NAME]
 |  | 2021-03-31 00:00:00 | 3000 | Pam
Spreadsheet: 862961d1710515836-display-rows-from-matching-data-sorting
Sheet: Sheet2

 | Mod | Elog | [NAME] | Hardness | Tear | #N/A
AP-50388 | 10.982 | 2.932 | 402.956 | 1.42 | 69 | 42.628
AP-50406 | 10.568 | 3.052 | 384.582 | 1.37 | 69 | 41.89
[NAME] | 11.62 | 3.412 | 363.658 | 1.38 | 69 | 44.304
AN-51117 | 11.21 | 3.606 | 439.374 | 1.44 | 65 | 59.644
AO-50421 | 11.746 | 2.226 | 486.476 | 1.45 | 126 | 57.128
AO-50430 | 11.98 | 2.234 | 503.002 | 1.45 | 65 | 55.89
AO-50435 | 11.668 | 2.41 | 555.353 | 1.54 | 68 | 54.72
AO-50642 | 10.854 | 2.054 | 504.234 | 1.41 | 69 | 50.01
AO-50647 | 11.242 | 2.084 | 502.346 | 1.46 | 66 | 57.412
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Winsloe

[NAME] To: | [NAME]
Alberton, PE | 76
Amherst, NS | 80
Borden, PE | 35
Chatham, NB | 162
[NAME], NB | 262
Dartmouth, NS | 198
Debert, NS | 140
Edmundston, NB | 377
Foxley River, PE | 62
Fredericton, NB | 213
[NAME], NB | 337
Kensington, PE | 26
Kentville, NS | 253
Lennox Island, PE | 73
Miminegash, PE | 79
[NAME], NB | 108
Montague, PE | 33
Morell, PE | 27
Mount Pleasant, PE | 52
Mt [NAME], PE | 18
[NAME], PE | 48
Murray River, PE | 44
New Annan, PE | 30
New Glasgow, NS | 180
North Sydney, NS | 336
[NAME], NB | 157
[NAME], NB | 197
[NAME], PE | 35
Scoudouc, NB | 94
[NAME], PE | 53
St Louis, PE | 78
Summerside, PE | 35
Sussex, NB | 153
Sydport-Term, NS | 347
Tignish, PE | 84
Truro, NS | 148
Wellington, PE | 44
Wood Islands, PE | 42
Spreadsheet: 513271bc-97be-4e2e-9ac5-16c0a4c00996
Sheet: OneClick Audiobooks

OneClickdigital Audiobooks 2014
 | Collection Size |  | Patrons |  | Circulations |  | Top Book
 | Total Titles | Total Copies | Total | New | Total | Daily Average | By Checkout | By Holds
January | 4791 | 10152 | 20554 | 399 | 12992 | 419 | Fifty Shades of Grey | Takedown Twenty
February | 4851 | 10594 |  | 290 | 11909 |  | Fifty Shades of Grey | Takedown Twenty
March |  | 10831 |  | 368 | 13068 |  | Takedown Twenty | The Chase
April |  | 11318 |  | 254 | 12932 |  | Takedown Twenty | Divergent
May | 5162 | 11632 |  | 273 | 13137 |  | Takedown Twenty | Divergent
June | 5550 | 11946 |  | 299 | 13721 |  | The Target (baldacci) | Divergent
July |  |  |  | 294 | 14342 |  | Gone Girl | Top Secret Twenty-One
August * | 5599 | 12769 |  | 218 | 14054 |  | Fifty Shades of Grey | Top Secret Twenty-One
September | 5626 | 12812 |  | 216 | 13550 |  | The Chase (Evanovich & Goldberg) | Personal (Child)
October
November
December
Year to date
Notes
*Collection includes multiuse titles.  These have unlimited simultaneous checkouts per title, but are reflected as 1 in the copies tally as of August 2014.
 | Type of multiuse book: |  |  |  | Titles #
 | Titles on one year lease/subscription |  |  |  | 400
 | Modern Scholar series (multiuse, no expiration) |  |  |  | 67
Collection Size blanks -- OCD has had a number of issues with this report recently, and completely rebuilt the report in September.
Spreadsheet: 203e7f4a-6a03-434d-8b4e-e619d00baa08
Sheet: Sheet1

Chromosome | r | SE | CI %
1 | -0.72 | 0.097 | (-0.86, -0.47)
2 | -0.605 | 0.132 | (-0.81, -0.30)
3 | -0.738 | 0.081 | (-0.87, -0.56)
4 | -0.852 | 0.051 | (-0.94, -0.73)
5 | -0.574 | 0.158 | (-0.79, -0.22)
6 | -0.58 | 0.163 | (-0.86, -0.25)
7 | -0.733 | 0.124 | (-0.92, -0.44)
8 | -0.733 | 0.126 | (-0.92, -0.44)
9 | -0.706 | 0.132 | (-0.92, -0.45)
10 | -0.581 | 0.261 | (-0.86, 0.12)
Table S3. The re-sampled correlation coefficients describing the relationship between % LTR retrotransposon
abundance and family richness for each chromosome.
Spreadsheet: 110214d1306943628-3d-vlookup-test-results-for-forum-v5
Sheet: Audit

BoundWidth | =MATCH(REPT("Z",255),'KS3 Boundaries'!$1:$1) |  |  | this counts the columns in KS3 Boundaries
TierPosition | =MATCH(Results!$C11,'KS3 Boundaries'!$A:$A,0) |  |  | this counts how many rows down the $[NAME] (tier) is in the KS3 Boundaries sheet.  The $C reference changes on every row because this is a function
 | MAKE AN ARRAY OF THE TIER TABLE BEING USED
CurrData | =OFFSET(INDEX('KS3 Boundaries'!$A:$A,TierPosition),,1,5,BoundWidth) |  |  | this MAKES AN ARRAY by pointing to the reference cell given by TierPosition (eg Tier 6 - 8) and makes/offsets the array "CurrData" to be 1 column right, 5 high and "Boundwidth" wide
 | =INDEX('KS3 Boundaries'!$A:$A,TierPosition) |  |  | this returns the contents of [NAME] column A at row <TierPosition>
Result | =IFERROR(VLOOKUP(SUM(Results!E2:G2),OFFSET(INDEX(CurrData,1,MATCH(Results!D2,INDEX(CurrData,1,),0)),1,,4,BoundWidth),BoundWidth+1-MATCH(Results!D2,INDEX(CurrData,1,))),"")
 | =MATCH(Results!D2,INDEX(CurrData,1,)) |  |  | This returns the column number that matches the year in the CurrData Index row 1. I think the +0 just makes it a value instead of text
 | =[NAME],) |  |  | this returns the contents of CurrData in Row 1 (0,1995,0,1996 etc)
 | =INDEX(CurrData,1,MATCH(Results!D2,INDEX(CurrData,1,),0)) |  |  | this returns the contents of CurrData in row 1, column <MATCH ….>
 | =OFFSET(INDEX(CurrData,1,MATCH(Results!D2,INDEX(CurrData,1,),0)),1,,4,BoundWidth) |  |  | this MAKES AN ARRAY within CurrData by pointing to the reference cell given by <[NAME] ….> (eg 2008) and makes/offsets the array to be 1 row down, 4 high and BoundWidth wide
 |  | =IFERROR(1,2) |  | Returns 2 if there is an error
Spreadsheet: 142218d1329741486-looking-up-dates-with-if-problem-sample-project-overview-sheet
Sheet: AFTER

 |  |  | FEB |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL
Date | w/c |  | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00
Project 1 |  |  |  |  |  |  |  |  |  | etc
 | Event Type 1 |  |  | x
 | Event Type 2 |  |  |  |  |  | x
Project 2 |  |  |  |  |  |  |  |  |  | etc
 | Event Type 1 |  |  |  |  | x
 | Event Type 2
Spreadsheet: 759887d1639778739-help-with-reducing-length-of-formula-example-uploaded-mlbtsta-example
Sheet: Dashboard

Plate Appearances |  |  |  |  |  |  |  |  |  |  |  |  |  | Plate Appearances |  |  | Total Bases |  |  | Strikeouts |  |  | Select Division: | AL Central |  | PA Entry Codes |  | Counts For This Game
BO | Player | POS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total |  | Start: | 14 |  | Start: | 10 |  | Start: | 13 |  |  |  |  | 0 | Out
1 | Minnie Minoso | CF |  |  |  |  |  |  |  |  |  |  |  | In Game: |  |  | In Game: |  |  | In Game: |  |  | Current Points: | 210 |  | 1 | Single
2 | [NAME] | LF |  |  |  |  |  |  |  |  |  |  |  | Total: |  |  | Total: |  |  | Total: |  |  |  |  |  | 2 | Double
3 | [NAME] | SS |  |  |  |  |  |  |  |  |  |  |  | Goal: | 100 |  | Goal: | 20 |  | Goal: | 15 |  | TEAMS |  |  | 3 | Triple
4 | [NAME] | 1B |  |  |  |  |  |  |  |  |  |  |  | Left: |  |  | Left: |  |  | Left: |  |  |  |  |  | 4 | HR
5 | [NAME] | RF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | Walk
6 | [NAME] | 2B | f | p | 1 | 2 | 3 | 4 | 0 | w | 1 |  |  | Game Point Calculator |  |  |  |  |  |  |  |  |  |  |  | F | Fielder's Choice
7 | Yoan Moncada | 3B | w | x | 1 | 2 | 3 | 4 | 0 | p | f |  |  | Goal |  |  | Amount | Points | Earned |  |  |  |  |  |  | E | Error
8 | [NAME] | C |  |  |  |  |  |  |  |  |  |  |  | Plate Appearances |  |  |  | 10 |  |  |  |  |  |  |  | D | Double Play
9 | Pitcher / Pinch Hitter | P |  |  |  |  |  |  |  |  |  |  |  | Total Bases |  |  |  | 5 |  |  |  |  |  |  |  | X | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 5 |  |  |  |  | Win / Loss: |  |  | P | K with Wild Pitch
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Defeat Division Rival |  |  | 1 | 5 |  |  |  |  |  |  |  | H | Hit by Pitch
 | Pitcher | POS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total |  | Total Game Points Earned:
 | [NAME] | SP |  |  |  |  |  |  |  |  |  |  |  | Player Task Points Earned:
 | [NAME] | RP |  |  |  |  |  |  |  |  |  |  |  | Total Points Earned:
 | [NAME] | RP
 | [NAME] | CP
 | Players with Tasks | POS | Task |  | Have |  | Game |  | Goal |  | Need
 | Yoan Moncada | 3B | 12 TB |  | 11
 | [NAME] | CP | 8 K |  | 0
 | [NAME] | 3B | 12 TB |  | 9
 | [NAME] | C | 3 HR |  | 0
 | [NAME] | 2B | 5 XBH |  | 2
 | [NAME] | OVR |  | POS |  | 2nd POS
Spreadsheet: 8634b582-b38a-4c21-9ec0-bda5c8a599dd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3539 | 6171 | Armin | Beyrich | GER | 91 | [NAME] | 00:01:10 | 00:25:44 | 00:01:27 | 00:27:23 | 1 | 01:18:21
3539 | 21546 | [NAME] | Grutsch | AUT | 92 | 00:21:54 | [NAME] | 00:27:00 | 00:01:56 | 00:30:31 | 2 | 01:22:14
Spreadsheet: 74846d1275398801-get-header-for-the-topsheet-no-bd-ack
Sheet: Sheet2

INDUS TOWERS LTD., KERALA CIRCLE
Acknowledgement to [NAME] for receipt / return of invoices
 |  | L0-Rate Verification |  |  | L1-First Approver |  |  | L2-SCM(Sajith) |  |  | L3-Statcom |  |  | L4-WCT |  |  | L5-SCM(Unni) |  |  | L6-Scanning |  |  | L7-Finance |  |  | [NAME] |  |  | Current Status
TS No. | Category | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date | Count | In Date | Out Date
50001
50002
50003
50004
50005
50006
50007
50008
50009
50010
50011
50012
50013
50014
50015
50016
50017
50018
50019
50020
50021
50022
50023
50024
50025
50026
50027
50028
50029
50030
50031
50032
50033
50034
50035
Spreadsheet: 884672d1733920016-lookup-text-and-match-by-searching-in-range-ekac-partial-text-spill-2024-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected Required Result |  | Main Data to Lookup
 |  |  |  |  |  |  |  | Lookup from M column | Result1 | Result2
 |  |  |  |  |  |  |  | Private Limited |  | 32146 Private Limited | 19 | 3426 Apex Court
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 20 | 26364 High Court
 |  |  |  |  |  |  |  | Government Institution | 22 | 14421 Government Institution | 22 | 14421 Government Institution
 |  |  |  |  |  |  |  | Public Limited | 23 | 11122 Public Limited | 23 | 11122 Public Limited
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 24 | 32146 Private Limited
 |  |  |  |  |  |  |  |  |  |  | 25 | 91424 Other Entities
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited
 |  |  |  |  |  |  |  | Government Institution | 22 | 14421 Government Institution
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited
Spreadsheet: 91874d1291574311-offset-function-error-with-asteresk-copy-of-inventory
Sheet: SHEET1

Generated Report
Inventory with Bar Codes
Inventory | Inventory | InvBarCode
PartNo | Description | Barcode
3001099 | GLOVE, HYFLEX, CR, SIZE 10 | AAABA000393
3001100 | GLOVE, HYFLEX, CR, SIZE 9 | AAABA000390
3000590 | GLOVE, IMPACT, SM, GANDER - BLK | AAABA000398
3000569 | GLOVE, LINER, GREEN | [NAME]
3000563 | GLOVE, LINER, KNIT | AAABA000428
3001088 | GLOVE, MECH, BLK, L | AAABA000254
3000665 | GLOVE, MECHANIC, FAST FIT, L | AAABA000455
3000874 | GLOVE, MECHANIC, FAST FIT, M | AAABA000536
3000717 | GLOVE, MECHANIC, FAST FIT, XL | AAABA000456
3000565 | GLOVE, NITRIL, SM | AAABA000426
3000567 | GLOVE, NITRIL, XL | AAABA000425
3001032 | GLOVE, WELDING, LG, BGE - YLW/BLUE | AAABA000122
3000575 | GLOVE, WELDING, LG, GANDER - 1 FNGR LINED | AAABA000413
3000589 | GLOVE, WELDING, LG, GANDER - LINED | AAABA000399
3001334 | GLOVE, WELDING, LG, GANDER - WHITE | AAABA001218
3000568 | GLOVE, WELDING, LG, RANPRO - WHITE | AAABA000423
Spreadsheet: 154857d1336582333-identify-values-in-a-specific-column-and-list-them-on-another-column-please-help-book1
Sheet: Sheet1

Product | Release | MCD Version | MAS Version | MBG Version | ME Version | NPM Version | AWC Version | UCA Version
MBG | 7.0.12.0 | NOT_INSTALLED | NOT_INSTALLED | 7.0.12.0 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED
UCA | 5.0.22.0 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | 5.0.22.0
 |  | 10.2 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED
 |  | NOT_INSTALLED | NOT_INSTALLED | 7.0.12.0 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED
 |  | NOT_INSTALLED | NOT_INSTALLED | 7.1.16.0 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED
 |  | NOT_INSTALLED | NOT_INSTALLED | 6.0.11.0 | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED
 |  | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | NOT_INSTALLED | 3.2.15.0
*The example shown is what I need; for the search to overlook the 'NOT_INSTALLED' until it finds a number and copy paste that number in the 'Release' column (B) and then the heading of that column into column 'Product' (A).
Spreadsheet: 88416d1288248351-excel-2007-pivot-table-help-test
Sheet: Sheet1

Date | Product | Region | Movement | Quantity |  |  | Sum of Quantity |  | Movement
2010-12-12 00:00:00 | A | North | Receipt | 100 |  |  | Region | Product | Receipt | Issue | Balance
2010-12-06 00:00:00 | B | West | Receipt | 10 |  |  | East | A | 50 |  | 50
2010-12-06 00:00:00 | C | North | Receipt | 100 |  |  |  | B |  |  | 0
2010-12-03 00:00:00 | D | North | Receipt | 20 |  |  |  | C |  |  | 0
2010-12-20 00:00:00 | D | West | Receipt | 30 |  |  |  | D |  |  | 0
2010-12-15 00:00:00 | E | East | Receipt | 30 |  |  |  | E | 30 |  | 30
2010-12-15 00:00:00 | A | East | Receipt | 50 |  |  |  | F |  |  | 0
2010-11-02 00:00:00 | B | North | Receipt |  |  |  |  | G |  |  | 0
2010-11-02 00:00:00 | C | South | Receipt | 10 |  |  | East Total |  | 80 |  | 80
2010-12-04 00:00:00 | D | South | Receipt | 200 |  |  | North | A | 100 |  | 100
2010-12-04 00:00:00 | A | South | Receipt | 30 |  |  |  | B |  |  | 0
2010-12-04 00:00:00 | B | South | Receipt |  |  |  |  | C | 100 | 20 | 80
2010-12-16 00:00:00 | C | North | Issue | 20 |  |  |  | D | 20 |  | 20
2010-12-16 00:00:00 | D | South | Issue | 50 |  |  |  | E |  |  | 0
2010-11-02 00:00:00 | A | South | Issue | 10 |  |  |  | F | 60 |  | 60
2010-12-18 00:00:00 | D | South | Issue | 20 |  |  |  | G |  |  | 0
2010-11-24 00:00:00 | F | North | Receipt | 60 |  |  | North Total |  | 280 | 20 | 260
2010-11-21 00:00:00 | G | South | Receipt | 10 |  |  | South | A | 30 | 10 | 20
 |  |  |  |  |  |  |  | B |  |  | 0
 |  |  |  |  |  |  |  | C | 10 |  | 10
 |  |  |  |  |  |  |  | D | 200 | 70 | 130
 |  |  |  |  |  |  |  | E |  |  | 0
 |  |  |  |  |  |  |  | F |  |  | 0
 |  |  |  |  |  |  |  | G | 10 |  | 10
 |  |  |  |  |  |  | South Total |  | 250 | 80 | 170
 |  |  |  |  |  |  | West | A |  |  | 0
 |  |  |  |  |  |  |  | B | 10 |  | 10
 |  |  |  |  |  |  |  | C |  |  | 0
 |  |  |  |  |  |  |  | D | 30 |  | 30
 |  |  |  |  |  |  |  | E |  |  | 0
 |  |  |  |  |  |  |  | F |  |  | 0
 |  |  |  |  |  |  |  | G |  |  | 0
 |  |  |  |  |  |  | West Total |  | 40 |  | 40
 |  |  |  |  |  |  | Grand Total |  | 650 | 100 | 550
Spreadsheet: 91147a1d-07fa-49d0-8095-31e6d79443ef
Sheet: Fall 2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
School of Business
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Lead Instructor | Lead Instructor ID | Percentage | 2nd Instructor | 2nd Instructor ID | Percentage | Contract Code | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C