tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121036d1315786639-converting-column-info-to-row-info-equipmentinventory
Sheet: Sheet1

Customer # | Equipment 1 | Equipment 2 | Equipment 3 | Equipment 4 |  |  | Customer Number | Equipment Type
AM100 |  |  |  |  |  |  | AM100 | Computer
[NAME] |  |  |  |  |  |  | AM100 | Cell Phone
AM102 |  |  |  |  |  |  | AM100 | [NAME]
AM103 |  |  |  |  |  |  | [NAME] | Computer
AM104 |  |  |  |  |  |  | AM102 | [NAME]
 |  |  |  |  |  |  | AM102 | Cup
 |  |  |  |  |  |  | AM102 | Computer
 |  |  |  |  |  |  | AM102 | Remote
 |  |  |  |  |  |  | AM103 | [NAME]
 |  |  |  |  |  |  | AM103 | Cell Phone
 |  |  |  |  |  |  | AM104 | Cup
Result I need |  |  |  |  |  | Basically I have a bunch of equipment in one column and I need to match it with a customer number and cascade it in a row. Is this possible?
Customer # | Equipment 1 | Equipment 2 | Equipment 3 | Equipment 4
AM100 | Computer | Cell Phone | [NAME]
[NAME] | Computer
AM102 | [NAME] | Cup | Computer | Remote
AM103 | [NAME] | Cell Phone
AM104 | Cup
Count of Equipment Type | Column Labels
Row Labels | Cell Phone | Computer | Cup | [NAME] | Remote | Grand Total
AM100 | 1 | 1 |  | 1 |  | 3
[NAME] |  | 1 |  |  |  | 1
AM102 |  | 1 | 1 | 1 | 1 | 4
AM103 | 1 |  |  | 1 |  | 2
AM104 |  |  | 1 |  |  | 1
Grand Total | 2 | 3 | 2 | 3 | 1 | 11
Spreadsheet: 796090d1663092687-delete-rows-from-sheet1-with-same-email-field-in-sheet2-germany
Sheet: Sheet3

Contact Name | Contact Email | Contact Title | Contact Company | Contact Source | Search [NAME] | Date Extracted
[NAME]ESMT Berlin | [EMAIL] |  |  | https://de.linkedin.com/in/ian-wainaina-6bb540110 | Digital Marketing | 2022-09-06 11:52:59
[NAME]  Peritus Partners | [EMAIL] |  |  | https://de.linkedin.com/in/eden-whitcomb | Digital Marketing | 2022-09-06 11:52:59
[NAME] and Healthcare Copywriting | [EMAIL] |  |  | https://de.linkedin.com/in/mariana-rickmann/en | Digital Marketing | 2022-09-06 11:52:59
Jakub | [EMAIL] | [NAME] (MSc) â€“ Product Marketing Manager |  | https://de.linkedin.com/in/jakub-james-boote | Digital Marketing | 2022-09-06 11:52:59
[NAME] [NAME]  CareerFoundry | [EMAIL] |  |  | https://de.linkedin.com/in/ashley-sigmon | Digital Marketing | 2022-09-06 11:52:59
[NAME]  Head of Growth  Business Development | [EMAIL] |  |  | https://de.linkedin.com/in/giuseppekolucci | Digital Marketing | 2022-09-06 11:52:59
[NAME] | [EMAIL] | CEO   OMB Vertriebsmanagement GmbH |  | https://de.linkedin.com/in/michael-eckardt-6a8a9b5/en | Digital Marketing | 2022-09-06 11:52:59
[NAME] of Global HL | [EMAIL] | class [NAME] |  | https://de.linkedin.com/in/harald-fruhstorfer-42406950%3Ftrk%3Dpub-pbmap | Digital Marketing | 2022-09-06 11:52:59
[NAME]  Humboldt | [EMAIL] | [NAME] |  | https://de.linkedin.com/in/will-lyon | Digital Marketing | 2022-09-06 11:52:59
[NAME] | [EMAIL] |  |  | https://de.linkedin.com/in/jennmchoi | Digital Marketing | 2022-09-06 11:52:59
Krish Kumar  HarvardX  [NAME] | [EMAIL] |  |  | [NAME] | Digital Marketing | 2022-09-06 11:52:59
Prof Dr [NAME] | [EMAIL] | Founder & CEO, Hybrid Work Advisor |  | https://de.linkedin.com/in/prof-dr-johanna-bath-14745983/en | Digital Marketing | 2022-09-06 11:52:59
[NAME] and Acquisitions  Berlin Brands Group | [EMAIL] |  |  | https://de.linkedin.com/in/bobbyodumjones | Digital Marketing | 2022-09-06 11:52:59
[NAME]Talent [NAME]  On | [EMAIL] |  |  | https://de.linkedin.com/in/gavingerhardi | Digital Marketing | 2022-09-06 11:52:59
Spreadsheet: 90988d1290671066-excel-2007-payroll-insert-values-by-rank-wages
Sheet: ANNA

Foreign Crew
RANKS | Basic Wages | G.O.T | EXCESS OT/EXTRA WORK PAY | Supplementary Wage | LEAVE PAY | TOTAL
AB | 530 | 334 | 480 | 110 | 106 | 1560 | Rate | 1.4
BOSUN | 700 | 442 | 818 | 110 | 140 | 2210
COOK | 820 | 518 | 592 | 50 | 170 | 2150
MESSMAN | 394 | 248 | 328 | 155 | 80 | 1205
OILER | 530 | 334 | 480 | 110 | 106 | 1560
OS | 452 | 285 | 323 | 130 | 90 | 1280
WIPER | 452 | 285 | 323 | 130 | 90 | 1280
Greek Crew
RANKS | Basic Wages | G.O.T | EXCESS OT/EXTRA WORK PAY | Supplementary Wage | LEAVE PAY | TOTAL
Α ΜΗΧΑΝΙΚΟΣ | 3791.96 | 0 | 0 |  | 1275.68 | 5067.64
ΑΝΘΥΠΟΠΛΟΙΑΡΧΟΣ | 1497.43 | 2627.13 | 0 |  | 645.44 | 4770
Β ΜΗΧΑΝΙΚΟΣ (ΔΙΠΛ/ΧΟΣ) | 1718.86 | 2740 | 0 |  | 725.92 | 5184.78
Β ΜΗΧΑΝΙΚΟΣ (ΜΗ ΔΙΠΛ/ΧΟΣ) | 1718.86 | 2740 | 0 |  | 725.92 | 5184.78
Γ ΜΗΧΑΝΙΚΟΣ | 1497.43 | 2627.13 | 0 |  | 645.44 | 4770
ΔΟΚ. ΠΛΟΙΑΡΧΟΣ ΜΗΧΑΝΙΚΟΣ | 1137.93 | 0 | 0 |  | 483.6 | 1621.53
ΕΚΠ ΣΠΟΥΔΑΣΤΗΣ | 880 | 0 | 0 |  | 0 | 880
ΜΑΓΕΙΡΟΚ/ΤΟΣ | 1565.05 | 1626.11 | 0 |  | 595.12 | 3786.28
ΝΑΥΚΛΗΡΟΣ | 1460.48 | 1620.52 | 0 |  | 574.8 | 3655.8
ΝΑΥΤΗΣ | 1307.15 | 0 | 0 |  | 545.12 | 1852.27
ΠΛΟΙΑΡΧΟΣ | 3990.46 | 0 | 0 |  | 1290.8 | 5281.26
ΥΠΟΠΛΟΙΑΡΧΟΣ | 1718.86 | 2740 | 0 |  | 725.92 | 5184.78
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: STANDS & Wall Mount Brackets

S.No | [NAME] | MODEL | SERIAL NO | QTY
1 | Liberty Projector Ceiling Mount
2 | Imported Projector Ceiling mounts |  |  | 4
3 | Projector Ceiling Mount 4FT |  |  | 37
4 | Genelec 402 Wall Brackets |  |  | 6
5 | Wharfdale Movie star 70 Spkr Stands |  |  | 2
6 | Wharfdale Movie star 60 Spkr Stands |  |  | 2
7 | B & W M1 Spkr Stands |  |  | 4
8 | Pioneer PDK TS 29 Table stand |  |  | 1
9 | Pioneer PDK TS 12 Table stand |  |  | 1
10 | Pioneer PDK TS 29 Table stand |  |  | 1
11 | Pioneer PDK TS 29 Table Top stand |  |  | 1
12 | Pioneer PDK TS 29A Table stand |  |  | 1
13 | Pioneer PDK TS 27 Table stand |  |  | 1
14 | Pioneer PDK TS 30A Table stand |  |  | 1
15 | Vangaurd VM 531 wall mount |  |  | 1
16 | Vangaurd VM 231 wall mount |  |  | 5
17 | Vangaurd VM 111 wall mount |  |  | 2
18 | [NAME] 1415 Wall mount |  |  | 1
19 | 40-50"TV Wall Mounts |  |  | 15
20 | 32" Universal Wall mount bracket |  |  | 7
21 | Wall rack |  |  | 1
22 | TV Table Tops |  |  | 8
23 | Projector Lift |  |  | 3
24 | Swivetelli TV Wall Mount 26"
25 | [NAME] Wall Mount 32" |  |  | 6
26 | Swivetelli PDP Wall Mount 40" |  |  | 1
27 | Swivetelli PDP Wall Mount 50" |  |  | 2
28 | PDP 42" Wall mount brackets |  |  | 3
29 | Panasonic 26" TV Wall mounts |  |  | 1
30 | [NAME] |  |  | 1
31 | Projector Ceiling Mount |  |  | 1
32 | Samsung LED TV Wall mount bracket |  | WMN1000BXXL | 2
33 | Samsung LED TV Wall mount |  |  | 3
34 | Samsung LED TV Table top |  |  | 11
35 | Radrish 42" TV Wall mounts |  |  | 4
37 | Radrish 1001 Wall mounts |  |  | 2
38 | Beyer Dynamics Stands |  |  | 10
 | Ceiling mount |  |  | 1
 | BACK
Spreadsheet: 6d6d5532-0306-4452-9fab-e5618d3ca92c
Sheet: CF

ADVANCED MICRO DEVICES, INC.
CONSOLIDATED STATEMENT OF CASH FLOWS
(Millions)
 | Quarter Ended | Nine Months Ended
 | Sept. 25, | Sept. 25,
 | 2010 | 2010
Cash flows from operating activities:
Net income (loss) | -118 | 96
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Equity in net income (loss) of investee | 186 | 489
Gain on deconsolidation of GLOBALFOUNDRIES | 0 | -325
Depreciation and amortization | 95 | 294
Compensation recognized under employee stock plans | 22 | 65
Non-cash interest expense | 8 | 25
Loss on debt redemption | 24 | 24
Provision (benefit) for deferred income taxes | 9 | -2
Amortization of foreign grant | -5 | -9
Net (gain) on sale of marketable securities | 0 | -8
Other | 0 | -2
Changes in operating assets and liabilities (excludes the effects of deconsolidation): | 0
Accounts receivable | -285 | -673
Inventories | -41 | -134
Prepaid expenses and other current assets | -5 | 14
Other assets | -1 | 13
Accounts payable to GLOBALFOUNDRIES | 3 | 66
Income taxes payable | -2 | 3
Accounts payable, accrued liabilities and other | -14 | -135
Net cash provided by (used in) operating activities | -124 | -199
Cash flows from investing activities:
Purchases of property, plant and equipment | -31 | -110
Purchases of available-for-sale securities | -647 | -1315
Net cash impact of change in status of GLOBALFOUNDRIES from consolidated entity to unconsolidated investee | 0 | -904
Proceeds from sale of property, plant and equipment | 0 | 1
Proceeds from sale and maturity of available-for-sale securities | 315 | 1224
Proceeds from sale of trading securities | 36 | 61
Other | 6 | 23
Net cash provided by (used in) investing activities | -321 | -1020
Cash flows from financing activities:
Proceeds from borrowings, net of issuance cost | 800 | 1223
Net proceeds from foreign grants | 0 | 11
Proceeds from issuance of AMD common stock | 2 | 9
Repayments of debt and capital lease obligations | -818 | -1058
Other | -3 | -3
Net cash provided by (used in) financing activities | -19 | 182
Net increase (decrease) in cash and cash equivalents | -464 | -1037
Cash and cash equivalents at beginning of period | 1084 | 1657
Cash and cash equivalents at end of period | 620 | 620
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, November 16 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 752106d1634582793-excel-365-how-to-put-a-max-function-into-an-array-max_array
Sheet: Sheet1

x
 | Randarray, #-referenced |  |  |  |  | Randarray, normal reference
 | [NAME] | Col 1 | Col 2 | Check |  | [NAME] | Col 1 | Col 2 | Check
Spreadsheet: 202949d1356828483-accrued-time-for-employees-overtime_pivot_table_12-29-2012
Sheet: Overtime

Name | Overtime Hours | Date | Job # |  | Row Labels | Sum of Overtime Hours
[NAME] | 5 | 2012-12-15 00:00:00 | 1 |  | [NAME] | 11
[NAME] | 2 | 2012-12-16 00:00:00 | 2 |  | 2012-12-16 00:00:00 | 2
[NAME] | 1 | 2012-12-17 00:00:00 | 3 |  | 2012-12-19 00:00:00 | 6
[NAME] | 3 | 2012-12-18 00:00:00 | 4 |  | 2012-12-22 00:00:00 | 3
[NAME] | 6 | 2012-12-19 00:00:00 | 5 |  | [NAME] | 11
[NAME] | 8 | 2012-12-20 00:00:00 | 6 |  | 2012-12-17 00:00:00 | 1
[NAME] | 1 | 2012-12-21 00:00:00 | 7 |  | 2012-12-20 00:00:00 | 8
[NAME] | 3 | 2012-12-22 00:00:00 | 8 |  | 2012-12-21 00:00:00 | 1
[NAME] | 1 | 2012-12-23 00:00:00 | 9 |  | 2012-12-23 00:00:00 | 1
[NAME] | 4 | 2012-12-24 00:00:00 | 10 |  | [NAME] | 15
[NAME] | 3 | 2012-12-25 00:00:00 | 11 |  | 2012-12-15 00:00:00 | 5
 |  |  |  |  | 2012-12-18 00:00:00 | 3
 |  |  |  |  | 2012-12-24 00:00:00 | 4
 |  |  |  |  | 2012-12-25 00:00:00 | 3
 |  |  |  |  | Grand Total | 37
Spreadsheet: 36593d1234461913-subsititute-help-namecorrect
Sheet: Sheet1

[NAME] | [NAME] |  |  | PatelN | [NAME]
[NAME] | Smith |  |  | SmithJ | [NAME]
[NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME] | Samsonite |  |  | SamsoniteB | [NAME]
 |  |  |  | MouseM | #N/A | Leaves errors visible
 |  |  |  | DuckD | **New Name** | gives a message instead
Spreadsheet: 139928d1328549258-excel-as-a-data-base-using-macros-vba-sample-database
Sheet: Sheet1

Facility/WB | ST | SO# | Submit to ACC | Contract Start | Contract End | SRV | Parts? | NO | YES | Part Disc | Vendor | CHT PO | Parts Order Date | CHT PO Date | Parts Received Date | Client PO | Client PO date and notes only for contract work | APROX SRV MNTH | SRV SCH Date | Tech | COMPLE     DATE | Billed Date | Gross Margin | REV | TY REV | NEXT SERVICE | RENEW | Sales | % | Sales 2 | % | Report | Scanned | Mailed | Tracking | Emailed
Facility | IL | 4544 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | MPGI |  |  | Yes | Couplier | Amico | 4123 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-06 00:00:00 | 6532 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-26 00:00:00 | [NAME]
 |  |  |  |  |  |  |  | Is there a way to make it so that there is a dropdown list under parts.  If you click
 |  |  |  |  |  |  |  | No that it skips all the pink rows?
Spreadsheet: 43955d1242640912-excel-2007-seperate-shees-and-summary-example-sheets-summary
Sheet: Summary

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] | 18 | 9 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 13 | 42 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fred | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 798616d1664585972-time-calculation-error-workshop-calendar-template
Sheet: Workshops

 | Notes: Enter details in the yellow cells only.  Enter duration in 30-minute increments only. Use the drop-down menu to select a start time.
 | Workshop description and time will auto-populate in the calendar view accordingly.
 | Workshop Description | Duration (hrs) | Workshop Date | Start Time | End Time | Current Date & Time | Last Date & Time | Notes | Workshop Description & Time | Month | Day | Year | Mos-Yr | YrMin | MosMin |  | vlookup Start | vlookup End
 | Workshop Test 1 | 1 | 2022-10-24 00:00:00 | 8:00:00
 | Workshop Test 2 | 1 | 2022-10-25 00:00:00 | 9:00:00
 | Workshop Test 3 | 0.5 | 2022-10-26 00:00:00 | 14:30:00
 | Workshop Test 4 | 0.5 | 2022-10-26 00:00:00 | 14:30:00
 | Workshop Test 5 | 1 | 2022-10-27 00:00:00 | 15:00:00
 | Workshop Test 6 | 0.5 | 2022-10-28 00:00:00 | 15:30:00
 | Workshop Test 7 | 0.5 | 2022-11-02 00:00:00 | 8:00:00
 | Workshop Test 8 | 0.5 | 2023-01-05 00:00:00 | 8:00:00
Spreadsheet: 799323d1665045342-extract-information-from-different-sheets-in-a-workbook-s666-pq-sample-file
Sheet: Required Output

GroupName | Userid |  |  | Group Members | UserID
ADGroup100 | test1 |  |  | Group100 | test4
ADGroup100 | test2 |  |  | Group100 | test5
ADGroup100 | test3 |  |  | Group100 | test3
ADGroup100 | test4 |  |  | Group100 | test1
ADGroup100 | test5 |  |  | Group100 | test2
ADGroup200 | test1 |  |  | Group300 | test14
ADGroup200 | test2 |  |  | Group300 | test15
ADGroup200 | test3 |  |  | Group300 | test13
ADGroup200 | test4 |  |  | Group300 | test11
ADGroup200 | test5 |  |  | Group300 | test12
ADGroup300 | test11 |  |  | Groupb200 | test4
ADGroup300 | test12 |  |  | Groupb200 | test5
ADGroup300 | test13 |  |  | Groupb200 | test3
ADGroup300 | test14 |  |  | Groupb200 | test1
ADGroup300 | test15 |  |  | Groupb200 | test2
Spreadsheet: 812135d1672991663-autofill-with-if-formula-if-formula-1-
Sheet: Sheet1

 |  |  | [NAME] | Grade | BC | Ket |  |  | SOURCE  IF | TEXT
THE RESULT I WANT (AUTO FILL) |  |  |  |  |  | FARM 2 |  |  | FARM 1 | MPS FARM 1
 |  |  |  |  |  |  |  |  | FARM 2 | MPS FARM 2
 |  |  |  |  |  |  |  |  | BOTH | MIX MPS FARM 1 AND FARM 2
 |  |  |  |  |  |  |  | I ENTER THE TEXT HERE FROM D4:D12
 |  |  | [NAME] | Grade | BC | Ket |  |  | [NAME] | Grade | BC | Ket
THE RESULT I WANT |  |  |  |  |  | FARM 1 |  | THE RESULT I WANT |  |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 1
Spreadsheet: 133363d1324361751-excel-2007-changing-the-month-daily-schedule-bvj-
Sheet: Sheet1

 |  | WKDY | Time | Task | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  | Mon | 08:30 - 09:00 | Approaching target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
 |  |  | 09:00 - 09:30 | Quality Closure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  |  | 16:30 - 17:00 | Chasing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  | Tue | 08:30 - 09:00 | Approaching target
 |  |  | 09:00 - 09:30 | Quality Closure
WE | 2012-02-01 00:00:00 |  | 16:30 - 17:00 | Chasing
Holiday |  | Wed | 08:30 - 09:00 | Approaching target
PL |  |  | 09:00 - 09:30 | Quality Closure
HLF |  |  | 09:00 - 09:30 | Weekly Inputs
LWP |  |  | 10:30 - 10:45 | Prudential Call
UPL |  |  | 16:30 - 17:00 | Chasing
 |  | Thu | 08:30 - 09:00 | Approaching target
 |  |  | 09:00 - 09:30 | Quality Closure
 |  |  | 15:30 - 16:00 | Biweekly Call
 |  |  | 16:30 - 17:00 | Chasing
 |  | Fri | 08:30 - 09:00 | Approaching target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  |  | 09:00 - 09:30 | Quality Closure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  |  | 09:00 - 09:30 | Pru weekly cust report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  |  | 09:00 - 09:30 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
 |  |  | 16:30 - 17:00 | Chasing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
 |  |  | 17:00 - 17:30 | Weekly Trackers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
Spreadsheet: 145929d1331818898-setting-rules-for-conditional-formating-example_conditional-formating
Sheet: Sheet1

Test 1 |  |  |  | 100 | 100 | 100 | 100 | 100 | 60 | 0 | 100 | 100 | 100 | 100 | 100
Test 1 Target % |  |  |  | 100 | 100 | 100 | 100 | 90 | 70 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 708297d1607707372-sum-formula-with-multiple-cases-filters-sum-formula-example
Sheet: Summatory

 | First Example |  |  |  |  |  |  | Second Example |  |  |  |  |  |  |  | Third Example
Filters | Owner → | [NAME] | Open Position → | no | Trading Month → |  |  | Filters | Owner → |  | Open Position → | yes | Trading Month → |  |  | Filters | Owner → | [NAME] | Open Position → | no | Trading Month → | 1
Symbol | Bought QTY | Bought Amount | Sold QTY | [NAME] |  |  |  | Symbol | Bought QTY | Bought Amount | Sold QTY | [NAME] |  |  |  | Symbol | Bought QTY | Bought Amount | Sold QTY | [NAME]
ETHE |  |  | 0 | 0 |  |  |  | ETHE |  |  | 295 | 15112.85 |  |  |  | ETHE |  |  | 0 | 0
GBTC |  |  | 100 | 7843 |  |  |  | GBTC |  |  | 0 | 0 |  |  |  | GBTC |  |  | 0 | 7843
RKT |  |  | 0 | 0 |  |  |  | RKT |  |  | 75 | 1689.75 |  |  |  | RKT |  |  | 0 | 0
APPS |  |  | 80 | 2080 |  |  |  | APPS |  |  | 0 | 0 |  |  |  | APPS |  |  | 50 | 1117
Spreadsheet: 143841d1330595465-populating-data-in-one-sheet-from-another-project-tracking
Sheet: Full Detail

 |  | JUMP TO | ACCOUNT MANAGEMENT | PURCHASING | PRODUCTION PLANNING
ENGINEERING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCOUNT MANAGMENT |  |  |  |  |  |  |  | PURCHASING |  |  | PRODUCTION PLANNING
Part Link Code | Part Number | Issue Level | Description | Model | Drawing Received | Estimated BOM Date | Actual BOM Date | Initial Drawing Issue Date | ISIR Revision Level | ISIR Date Internal | ISIR Customer Approved | Production Drawing Issue Date | No of Circuits | Labour Time | Similar To | Replaces Harness | ISIR Required Date | ISIR Promised Date | Prototype Qty Required | Prototype Date Required | Prototype Price | Production Price GB | Production Price Oversea's | Number of Critical Shortages | Longest Date of Shortages | Purchasing Notes | [NAME] | Internal Works Order Number | ISIR Despatch Date | Prototype Despatch Date | Production Despatch Date | 28 | 29 | 30 | 31
Spreadsheet: 57300d1257416976-league-table-score-predictions
Sheet: Sheet1

# | Fixture |  | Nick |  |  |  |  | [NAME] |  |  |  |  | Result |  |  |  | POS | Name | Points
 |  |  | Home | Away | Result | Points |  | Home | Away |  | Points |  | Home | Away |  |  | 1
1 | Man Utd vs CSKA |  | 3 | 1 |  |  |  | 1 | 0 |  |  |  | 3 | 3 |  |  | 2
2 | Chelsea vs Man Utd |  | 1 | 1 |  |  |  | 1 | 0
3 | Man Utd vs Everton
4 | Man Utd vs Beshiktas
5 | Portsmouth vs Man Utd
6 | West Ham vs Man Utd
7 | Wolfsburg vs Man Utd
8 | Man Utd vs [NAME]
9 | Man Utd vs Wolves
10 | Fulham vs Man Utd
11 | Hull vs Man Utd
12 | Man Utd vs [NAME]
 | Total Points
Spreadsheet: 156252d1337242591-excel-2007-meeting-criteria-in-a-range-example
Sheet: Sheet1

Column A | Column B
1 | A
4 | J
7 | A
4 | B
5 | A
6 | E
5 | E
8 | C
9 | F
8 | F
Does 5 and A or 8 and D appear on same row within the range |  |  |  |  |  |  |  |  | Yes or No to appear here
Spreadsheet: 169437d1342833482-help-with-sorting-and-counting-pivot-table-ansewr-for-co-name-color
Sheet: Sheet1

Co Name | Color
Company A | blue
Company A | blue
Company A | red
Company B | red
Company B | red
Count of Color | Column Labels
Row Labels | red | blue | Grand Total
Company A | 1 | 2 | 3
Company B | 2 |  | 2
Grand Total | 3 | 2 | 5
Spreadsheet: 147587d1332869999-intersection-of-two-sets-of-values-intersection-of-two-sets-example
Sheet: Sheet1

 | Input data | Input data | Desired output
 | Set 1 | Set 2 | Intersection of Set 1 and Set 2
 | apple | orange | apple
 | orange | grape | orange
 | apple | grape | grape
 | grape | mango
 | pear | apple
 | pear | banana
 | kiwi | orange
 |  | grape
Spreadsheet: 690437d1597100997-sumifs-with-mulitple-criteria-sample1
Sheet: Sheet1

Data Set |  |  | What I have |  |  |  | What I need
Product | Fruit | Total | Find_Items | Fruit | SUMIFS | SUMPRODUCT |  | Apples
Milk | Apples | 100 | Milk | Apples |  |  | Milk | Oranges
Milk | Oranges | 100 | Milk | Oranges |  |  |  | Pears
Milk | Pears | 100 | Milk | Pears |  |  |  | Apples
Cookies | Apples | 100 | Cookies | Apples |  |  | Cookies | Oranges
Cookies | Oranges | 100 | Cookies | Oranges |  |  |  | Pears
Produce | Oranges | 100 | Cookies | Pears |  |  |  | Apples
Produce | Pears | 100 | Produce | Apples |  |  | Produce | Oranges
Milk | Apples | 100 | Produce | Oranges |  |  |  | Pears
Milk | Pears | 100 | Produce | Pears
Milk | N/A | 100
Cookies | Apples | 100
Cookies | N/A | 100
Produce | Apples | 100
Produce | Oranges | 100
Cookies | Pears | 100
Produce | Pears | 100
Produce | Pears | 100
Spreadsheet: 453828d1459457255-data-validation-listing-based-on-certain-condition-sample1
Sheet: Weeks

 |  |  |  | HIDE ME
2016-04-02 00:00:00 | 2016-04-08 00:00:00
2016-04-09 00:00:00 | 2016-04-15 00:00:00
2016-04-16 00:00:00 | 2016-04-22 00:00:00
2016-04-23 00:00:00 | 2016-04-29 00:00:00
2016-04-30 00:00:00 | 2016-05-06 00:00:00
2016-05-07 00:00:00 | 2016-05-13 00:00:00
2016-05-14 00:00:00 | 2016-05-20 00:00:00
2016-05-21 00:00:00 | 2016-05-27 00:00:00
2016-05-28 00:00:00 | 2016-06-03 00:00:00
2016-06-04 00:00:00 | 2016-06-10 00:00:00
2016-06-11 00:00:00 | 2016-06-17 00:00:00
2016-06-18 00:00:00 | 2016-06-24 00:00:00
2016-06-25 00:00:00 | 2016-07-01 00:00:00
2016-07-02 00:00:00 | 2016-07-08 00:00:00
2016-07-09 00:00:00 | 2016-07-15 00:00:00
2016-07-16 00:00:00 | 2016-07-22 00:00:00
2016-07-23 00:00:00 | 2016-07-29 00:00:00
2016-07-30 00:00:00 | 2016-08-05 00:00:00
2016-08-06 00:00:00 | 2016-08-12 00:00:00
2016-08-13 00:00:00 | 2016-08-19 00:00:00
2016-08-20 00:00:00 | 2016-08-26 00:00:00
2016-08-27 00:00:00 | 2016-09-02 00:00:00
2016-09-03 00:00:00 | 2016-09-09 00:00:00
2016-09-10 00:00:00 | 2016-09-16 00:00:00
2016-09-17 00:00:00 | 2016-09-23 00:00:00
2016-09-24 00:00:00 | 2016-09-30 00:00:00
Spreadsheet: 49752d1249067037-v-lookup-return-multiple-occurances-and-columns-multiple-value-vlookup
Sheet: Sheet1

List
aaa
bbb
[NAME]
 | Table
 | aaaa | 666 | 777 | 888 | 999
 | aaaa | 111 | 222 | 333 | 444
 | bbbb | 1212 | 2323 | 4545 | 5656
 | eeee
 | cccc | 333 | 333 | 6666 | 66666
 | cccc | 222 | 555 | 555 | 4545
 | cccc | 888 | 1111 | 343 | 56
Spreadsheet: 152950d1335633736-excel-2007-sumif-and-dynamic-names-teng-master-summer-jr-
Sheet: FRI

DAILY MOVEMENTS
DAY | Fri |  | DATE | 2010-01-15 00:00:00 |  |  | fri |  |  |  |  | frimov | frd
REG | FLT | NO | STA | ATA | TYPE | DEST | FLT | NO | STD | ATD | OIL | MOVE | DLY | BALM | COMMENTS | codes | Dscription |  | BA02
 |  |  |  |  |  |  |  |  | FRI TOTAL |  | 0 | 0 | 0
Spreadsheet: 820626d1678205385-formula-to-return-last-posted-balance-from-table-based-on-todays-date-sample18
Sheet: Sheet1

 |  | Today's Date
 |  | Last Posted Balance
 |  | Month | Balance
 |  | Jan | 25000
 |  | Feb | 30000
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Jul
 |  | Aug
 |  | Sep
 |  | Oct
 |  | Nov
 |  | Dec