tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 722202d1615114633-match-summary-transactions-monthly-balance
Sheet: Sheet2

I'm kindly asking for excel formula that when I select Fiscal Month on cell [NAME], it automatical fills cell D9, D10, D11, D12, with opening [NAME], Credits and [NAME].
 |  |  |  |  |  | 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
 |  |  |  |  | Opening Bal | 165135.46 | 30872.48999999999 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001
 |  |  |  |  | Debits | 93392.6 | 209067.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Currency: | ZWL |  |  |  | Credits | 227655.57 | 199994.37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fiscal Month |  |  | 2021-02-01 00:00:00 |  | [NAME] | 30872.48999999999 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001 | 39945.82000000001
Summary
Opening Balance |  |  | 30872.48999999999
Total Debits |  |  | 209067.7
Total Credits |  |  | 199994.37
Closing Balance
Spreadsheet: 546112d1509880858-formula-for-sorting-in-alphabetical-order-ak-sample-workbook-for-sorting-alphabetically
Sheet: Raw Data

 |  | Customer Name
 | 1 | AA
 | 2 | BB
 | 3 | CC
 | 4 | DD
 | 5 | EE
 | 6 | DEFG
 | 7 | GG
 | 8 | HH
 | 9 | EE
 | 10 | FGH
 | 11 | KK
 | 12 | CC
 | 13 | DD
 | 14 | MOIM
 | 15 | ADFDF
 | 16 | DFLDSK
 | 17 | QQ
 | 18 | RR
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
Spreadsheet: 390998d1429822537-count-w-multiple-criteria-across-multiple-columns-sumproduct-match-example
Sheet: Main

Test Name | Category | Result
HubRadius | Hub | Passed |  | Before
HubRadius | Sizing | Passed
HubRadius | LocCenter | Passed |  | Focus: |  |  | Passed:
HubRadius | HighP | Passed |  | [NAME]: |  |  | Failed:
HubRadius | Layer1 | Passed |  | [NAME]:
HubPrice | Hub | Passed |  | [NAME]:
HubPrice | Pricing | Passed |  | [NAME]:
HubPrice | LocCenter | Passed
HubPrice | HighP | Passed
HubPrice | Layer1 | Passed
HubColor | Hub | Failed
HubColor | Coating | Failed |  | Example |  |  |  |  |  | Example
HubColor | LocRim | Failed
HubColor | LowP | Failed |  | Focus: | Hub |  | Passed: | 0 |  | Focus: | Rail |  | Passed: | 1
HubColor | Layer2 | Failed |  | [NAME]: | Layer2 |  | Failed: | 1 |  | [NAME]: | Layer1 |  | Failed: | 0
RailLength | Rail | Passed |  | [NAME]: |  |  |  |  |  | [NAME]: | HighP
RailLength | Sizing | Passed |  | [NAME]: |  |  |  |  |  | [NAME]:
RailLength | LocRim | Passed |  | [NAME]: |  |  |  |  |  | [NAME]:
RailLength | LowP | Passed
RailLength | Layer1 | Passed
RailPrice | Rail | Failed
RailPrice | Pricing | Failed |  | Example |  |  |  |  |  | Example
RailPrice | LocRim | Failed
RailPrice | LowP | Failed |  | Focus: | Rail |  | Passed: | 2 |  | Focus: | LowP |  | Passed: | 1
RailPrice | Layer1 | Failed |  | [NAME]: | LocRim |  | Failed: | 1 |  | [NAME]: | Layer1 |  | Failed: | 1
RailColor | Rail | Passed |  | [NAME]: |  |  |  |  |  | [NAME]:
RailColor | Coating | Passed |  | [NAME]: |  |  |  |  |  | [NAME]:
RailColor | LocRim | Passed |  | [NAME]: |  |  |  |  |  | [NAME]:
RailColor | HighP | Passed
RailColor | Layer1 | Passed
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Quail Hollow

 |  | WEEK 5 Wells Fargo Championship
 |  | Total Earnings |  |  |  | Rankings Through Week 5 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | [NAME] |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 95920d1295446962-baby-pool-points-calculations-baby-pool
Sheet: Baby

 | [NAME]
Name |  | Baby's Birthday |  | Baby's Weight |  | Baby's Length | First Letter of Baby's Name
First | Last | Month | Day | Pounds | Ounces | Inches | Letter
First name | Last name | March | 3 | 7 | 3 | 19 | R
 |  |  |  |  |  |  |  |  | If one penalty point is given for each day, ounce,
 |  |  |  |  |  |  |  |  | inch or letter (plus or minus) away from the actual
 |  |  |  |  |  |  |  |  | result, what would the score be?
 |  |  |  |  |  |  |  |  | Sample actual result:  Born March 5, weighs 6 lbs
 |  |  |  |  |  |  |  |  | 9 oz, 20 inches and letter is 'C'.
Spreadsheet: dbe340d4-78e9-4ee7-b4a5-e59ea3c6db6a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Neighborhood and Community Services Department
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2006-08-04 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 1000 |  | 575402 |  | B |  | G57HIP06 |  | 43785 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 43785
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2006-08-04 00:00:00 |  | JOURNAL ID:
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 1000 |  | 575402 |  | 619080 |  | G57HIP06 |  | 43785 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 43785
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 43785
 |  | Correct appropriations to the expenditure accounts for HIP06 grant.
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
[NAME] |  |  |  |  |  | 2006-08-04 00:00:00 |  | [NAME] |  |  |  |  |  | 2006-08-04 00:00:00
Spreadsheet: 112282d1308404338-time-average-book1-1-
Sheet: Sheet1

AssignedTo | Created | Resolved |  |  | Name |  | From | To |  | Time AVERAGE
[NAME] [NS] | 2011-01-12 10:30:35 | 2011-04-05 12:15:16 |  |  | [NAME] [NS]
[NAME] [NS] | 2011-01-16 14:34:19 | 2011-01-17 12:35:38
Ayman Dwdar [NS] | 2011-01-16 15:03:15 | 2011-01-17 15:04:00
Ayman Dwdar [NS] | 2011-01-16 17:49:12 | 2011-01-17 12:35:36
Ayman Dwdar [NS] | 2011-01-16 18:44:35 | 2011-01-17 12:35:00
[NAME] [NS] | 2011-01-16 19:32:52 | 2011-01-24 11:39:00
[NAME] [NS] | 2011-01-17 08:16:03 | 2011-01-17 12:35:30
[NAME] [NS] | 2011-01-17 08:31:33 | 2011-03-13 12:24:46
Tamer Anwar[NS] | 2011-01-17 09:30:18 | 2011-01-18 16:25:00
[NAME] [NS] | 2011-01-17 13:53:46 | 2011-01-17 14:35:24
[NAME] [NS] | 2011-01-17 13:56:09 | 2011-01-19 11:18:00
[NAME] [NS] | 2011-01-18 09:26:08 | 2011-01-18 09:52:00
[NAME] [NS] | 2011-01-18 09:49:01 | 2011-01-24 11:43:00
[NAME] [NS] | 2011-01-18 10:23:05 | 2011-01-18 10:24:00
[NAME] [NS] | 2011-01-19 07:06:06 | 2011-01-20 06:41:00
[NAME] [NS] | 2011-01-19 07:37:40 | 2011-01-20 06:40:00
Tamer Anwar[NS] | 2011-01-19 08:56:44 | 2011-01-19 08:56:00
Spreadsheet: daren_farmer__5081__Tenaska IV 2001
Sheet: January 2001 Act.

Enron North America Corp
Summary of Gas Activity for Tenaska IV Partners, Ltd.
January 2001
January Sales
 | Counterparty | Volume | Dollars
 | Tenaska IV Partners | 1429510 | 3782014
 | Total Sales |  |  | Actual
January Expenses
 | Apache Marketing | -620000 | -1488620
 | [NAME] | -767444 | -2208877.21
 | TXU [NAME] |  | -144390.9
 | Total Expenses |  |  | Actual
 |  |  | UA4
January Netout
 | Total Expenses
 | Amount paid by Plant | 1429510 | 3687860.65 | paid
 | Agency Fee Est (1,407,000 x $0.04) |  | 56280 | paid
 | Agency Fee Act (1,429,510 x $0.04) |  | -57180.4
 | Payable to Tenaska IV Partners/(ENA):
Spreadsheet: 742218d1627585561-multi-criteria-table-lookup-invoice-template
Sheet: Invoice

COMPANY NAME Company Address
BILL TO: |  |  | INVOICE
ACME Widgets |  |  | INVOICE No.:
 |  |  | DATE:
 |  |  | P.O. Number:
 |  |  | TERMS:
QTY | [NAME] |  | UNIT | TOTAL
250 | Product 1
100 | Product 2
 |  |  | TOTAL
Spreadsheet: 806996d1669710079-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: RACHEL

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 | _ |  | _ |  | _ |  | _ |  | _ |  | 1st Grade |  |  |  | 4th Grade
 | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN |  | ADMIN
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | . |  |  |  | .
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q2FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations  - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended September 30, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3946 |  | 0 |  | 368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4314
Cost of revenue | 2188 |  | -13 |  | 0 |  | 0 |  | -36 |  | 0 |  | 0 |  | -2 |  | 0 |  | 2137
Gross profit | 1758 |  | 13 |  | 368 |  | 0 |  | 36 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2177
Operating expenses:
Marketing and sales | 717 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 699
General and administrative | 313 |  | 0 |  | 0 |  | -14 |  | 0 |  | 0 |  | 0 |  | -39 |  | 0 |  | 260
Research and development | 1259 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -118 |  | 0 |  | 1141
Acquired in-process technology | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 51 |  | -51 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Goodwill impairment | 368 |  | -368 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 77 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -77 |  | 0 |  | 0 |  | 0
Total operating expenses | 2786 |  | -420 |  | 0 |  | -14 |  | 0 |  | 0 |  | -77 |  | -175 |  | 0 |  | 2100
Operating income (loss) | -1028 |  | 433 |  | 368 |  | 14 |  | 36 |  | 0 |  | 77 |  | 177 |  | 0 |  | 77
Loss on strategic investments | -46 |  | 0 |  | 0 |  | 0 |  | 0 |  | 46 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 22 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 22
Income (loss) before provison for income taxes | -1052 |  | 433 |  | 368 |  | 14 |  | 36 |  | 46 |  | 77 |  | 177 |  | 0 |  | 99
Provision for income taxes | 256 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -229 |  | 27
Net income (loss) | -1308 |  | 433 |  | 368 |  | 14 |  | 36 |  | 46 |  | 77 |  | 177 |  | 229 |  | 72
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -4.06 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.23
Spreadsheet: a401270f-3a75-41e8-b422-5bdfefcb1a11
Sheet: NV

CC ID | Type | Plant | City | State | ID | CBI | Status | Desig | Handles CCW? | Electric Utility? | Special Waste Addition? | Latitude | Longitude | Lined* | Is Leachate Collected? | Distance from Nearest Surface Waterbody (Ft.) | Year Initially Brought Online Or Planned to be Brought Online | Inactive | Representative | Party | Congressional District ID
North Valmy.LANDFILL-1 | Landfill | North Valmy | Valmy | NV | LANDFILL-1 | 0 | Active/Inactive/Open Landfills | U1, U2 & U3 Ash Landfill | YES | YES | NO | 40.891453 | -117.150428 | No | No | 6917 | 1981 | No | [NAME] | Republican | 3202
[NAME].LANDFILL-1 | Landfill | [NAME] | Moapa | NV | LANDFILL-1 | 0 | Active/Inactive/Open Landfills | Landfill | YES | YES | NO | 0 | 0 | No | No | 3960 | 1994 | Yes
[NAME].[NAME] | Pond | [NAME] | Moapa | NV | [NAME] | 0 | Active/Inactive/Open Pond/Impoundment Units | 4B-1 | YES | YES | NO | 0 | 0 | Yes | Yes | 88 | 1992 | No
[NAME].SPD-2 | Pond | [NAME] | Moapa | NV | SPD-2 | 0 | Active/Inactive/Open Pond/Impoundment Units | 4B-2 | YES | YES | NO | 0 | 0 | Yes | Yes | 729 | 1992 | No
[NAME].SPD-3 | Pond | [NAME] | Moapa | NV | SPD-3 | 0 | Active/Inactive/Open Pond/Impoundment Units | 4B-3 | YES | YES | NO | 0 | 0 | Yes | Yes | 1335 | 1992 | No
[NAME].SPD-4 | Pond | [NAME] | Moapa | NV | SPD-4 | 0 | Active/Inactive/Open Pond/Impoundment Units | 4C-1 | YES | YES | NO | 0 | 0 | Yes | Yes | 85 | 1992 | Yes
[NAME].SPD-5 | Pond | [NAME] | Moapa | NV | SPD-5 | 0 | Active/Inactive/Open Pond/Impoundment Units | 4C-2 | YES | YES | NO | 0 | 0 | Yes | Yes | 346 | 2001 | Yes
[NAME].SPD-6 | Pond | [NAME] | Moapa | NV | SPD-6 | 0 | Active/Inactive/Open Pond/Impoundment Units | E-1 | YES | YES | NO | 0 | 0 | Yes | Yes | 514 | 2003 | No
[NAME].SPD-7 | Pond | [NAME] | Moapa | NV | SPD-7 | 0 | Active/Inactive/Open Pond/Impoundment Units | E-2 | YES | YES | NO | 0 | 0 | Yes | Yes | 60 | 2003 | No
[NAME].SPD-8 | Pond | [NAME] | Moapa | NV | SPD-8 | 0 | Active/Inactive/Open Pond/Impoundment Units | F | YES | YES | NO | 36.653931 | -114.637369 | Yes | Yes | 73 | 1986 | No | [NAME] | Republican | 3203
[NAME].SPD-A | Pond | [NAME] | Moapa | NV | SPD-A | 0 | Planned Pond/Impoundment Units | M-1 | YES | YES | NO | 0 | 0 | Yes | Yes | 3600 | 2014 | NA
[NAME].SPD-B | Pond | [NAME] | Moapa | NV | SPD-B | 0 | Planned Pond/Impoundment Units | M-3 | YES | YES | NO | 0 | 0 | Yes | Yes | 3593 | 2013 | NA
[NAME].SPD-C | Pond | [NAME] | Moapa | NV | SPD-C | 0 | Planned Pond/Impoundment Units | M-5 | YES | YES | NO | 0 | 0 | Yes | Yes | 3287 | 2010 | NA
[NAME].SPD-D | Pond | [NAME] | Moapa | NV | SPD-D | 0 | Planned Pond/Impoundment Units | M-7 | YES | YES | NO | 0 | 0 | Yes | Yes | 3124 | 2011 | NA
*Does not necessarily mean a composite liner
Spreadsheet: 790809d1660001183-multiple-lookup-to-return-a-result-helpexcel1
Sheet: HOLIDAYS

STATE | DATE | HOLIDAY | code
ACT | 2022-08-15 00:00:00 | Queens Birthday | PH
NSW | 2022-08-15 00:00:00 | Queens Birthday | PH
VIC | 2022-08-18 00:00:00 | Picnic day | PH
QLD | 2022-08-22 00:00:00 | Labour day | PH
QLD | 2022-08-26 00:00:00 | show day | PH
Spreadsheet: 60682d1261182588-group-rows-together-group-rows-together-laurenr-vp-sdg11
Sheet: Instructions

----------------------- | ----------------------------- | -------------------- |  |  | Today, 02:20 PM
10401C       7/5/2001 | 109 1 FAIRWAY DR BLDG #2 | ROCKFORD HOMES INC |  |  | LaurenR |  | Group rows together - [NAME]
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY |  |  | Registered User   Join Date: 17 Sep 2009
 | N/A | SUITE 200 |  |  | Location: Columbus, Ohio
 | NEW 4 UNIT CONDO BLD | COLUMBUS, OH 43240 |  |  | MS Office Version:Excel 2003
 | LICKING COUNTY | 4/ 1.00/ |  |  | Posts: 5
 | ETNA TOWNSHIP | 5B |  |  | Group rows together
----------------------- | ----------------------------- | -------------------- |  |  | http://www.excelforum.com/excel-general/711364-group-rows-together.html
10403C       7/5/2001 | 109 1 NICKLAUS LN BLDG #7 | ROCKFORD HOMES INC |  |  | Hello!
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY |  |  | This is my second time posting- thank you always for all of your help! Here is what I'm trying to do.
 | N/A | SUITE 200 |  |  | I have a 2000 page Word document that I need to sort through.
 | NEW 4 UNIT CONDO | COLUMBUS, OH 43240 |  |  | My initial solution was to copy and paste it into Excel (see attached "before" file for a section of the copied results).
 | LICKING COUNTY | 4/ 1.00/ |  |  | As you can see, it copies all of the info into Column A.
 | ETNA TOWNSHIP | 5B
----------------------- | ----------------------------- | -------------------- |  |  | I then separated the data into separate columns, and deleted those that were not important to me.
10407C       8/14/2001 | 109 1 PLAYER WAY BLDG #16 | ROCKFORD HOMES INC |  |  | This is where I get stuck. I only need the groups of information that correspond to the "Z- New Constr."
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY |  |  | entry in the new Column A (See the attached "during" file for an example of where I get stuck).
 | N/A | SUITE 200 |  |  | The groups are between dashed lines- that comes with the copy from Word.
 | NEW 4 UNIT CONDO BLD | COLUMBUS, OH 43240
 | LICKING COUNTY | 4/ 1.00/ |  |  | Is there any way to get to my "after" file without going through and manually deleting all non-New Construction entries?
 | ETNA TOWNSHIP | 5B |  |  | I tried to sort by Column A and it obviously doesn't move all of the corresponding rows.
 |  |  |  |  | This file only starts with 6 entries- my real file has many more than that! Any help you can provide would be really appreciated!
 |  |  |  |  | Thanks so much!
 |  |  |  |  | Lauren
Spreadsheet: jay_reitmeyer__13532__ENRON2001
Sheet: 11-01 #7010

 | MPC November 2001 Gas Transportation Invoice
Enron Gas Marketing, Inc
1200 17th Street - Suite 2750
Denver, CO  80202
Attention: [NAME]
Customer ID # 7010
Account # | 100737-6
Interruptible Transportation Charges
 |  | Quantity | Rate | Charge
Commodity Charge |  | 108424 | 0.2
Interruptible Storage Charges
Commodity Charges |  | Quantity | Rate | Charge
Injection Charge |  | 108424 | 0.019
Withdrawal Charge |  | 15000 | 0.019
Capacity Charge |  | 1121702 | 0.019
Canadian Montana Pipeline Charge
 |  | Quantity | Rate | Charge
 |  | 0 | 0.008
Total Transportation Invoice
Entered:______________ |  |  | Approved:_______________
Spreadsheet: fffaa1cb-4d58-4788-9a54-e16fdaa5233f
Sheet: Sheet1

LUXEMBURG AREA CODE DECODER | Unnamed: 1
Last update: December 18, 1998
Area Code | Area Code Name
2 | Luxembourg (city)
3 | Area surrounding Luxembourg (city)
4 | Luxembourg (city)
5 | Southwest
6 | Southeast and West
7 | East
8 | North Central
9 | Far North
Spreadsheet: 103437d1301167250-working-with-sheets-rds-estimates-2
Sheet: Sheet1

DETAIL | QUANTITY | UNIT PRICE |  | MATERIAL COST | UNIT PRICE | LABOR COST |  |  | TOTALS
101 SUPERINTENDENT - 16 WEEKS |  |  |  |  | 2000 | 32000 |  |  | 32000
102 LAYOUT - 8 WEEKS |  |  |  |  | 1400 | 11200 |  |  | 11200
105 OFFICE - 4 MONTHS |  | 250 |  | 1000 |  |  |  |  | 1000
106 TELEPHONE - 4 MONTHS |  | 300 |  | 1200 |  |  |  |  | 1200
108 WATER | LS |  |  | 400 |  |  |  |  | 400
112 TOOLS | LS |  |  | 5000 |  |  |  |  | 5000
113 MOVE IN AND OUT | LS |  |  |  |  | 1000 |  |  | 1000
115 GAS | LS |  |  | 2000 |  |  |  |  | 2000
116 PROJECT CLEANUP | LS |  |  |  |  | 3000 |  |  | 3000
120 SAFETY | LS |  |  | 1000 |  | 1000 |  |  | 2000
131 DUMPSTER | LS |  |  | 2500 |  |  |  |  | 2500
135 JOB DURATION EQUIPMENT | LS |  |  | 9600 |  |  |  |  | 9600
 |  |  |  | 22700 |  | 48200 |  |  | 70900
Spreadsheet: 51070d1250637390-find-unique-cell-then-copy-to-other-sheets-missing
Sheet: MISSING

Missing Equipment
221027617 | *221027617*
221028165 | *221028165*
221028235 | *221028235*
00460147402025 | *00460147402025*
[PHONE] | *[PHONE]*
[PHONE] | *[PHONE]*
00730836502902 | *00730836502902*
00730839605199 | *00730839605199*
00874738205926 | *00874738205926*
00874803205168 | *00874803205168*
00938841703755 | *00938841703755*
00938902500339 | *00938902500339*
00938902500353 | *00938902500353*
05ZVN39CGL71 | *05ZVN39CGL71*
06J9H6BRRT66 | *06J9H6BRRT66*
Take each individual cell from Missing Sheet under columm Missing Equipment and look them up on the Inventory Scan Sheet under all columms & rows, if Result is a match and they are found on any cell then copy and paste the found cells contents to the Result Sheet under columm Match and Found, if not found then copy paste the remaining not found cells contents from the Missing Sheet to the Result Sheet under columm Missing Not Found                                                          !!!!!!!!!HOPE I AM MAKING SENCE HERE!!!!!!!!!!!!!!!!
Spreadsheet: 685116d1593740307-look-up-formula-from-table-with-uneven-format-look-up-when-source-and-look-upvalues-are-different-format-copy
Sheet: Sheet1

Site No | PD Number |  | Apply  look up formula in  column "C"  referencing variables in A and B and drag down to arrive at desired values per table below
01009 | 3534768
03003 | 3534740
3004 (M) | 4534768
2T11 | 13534768
Lookup table
Site No | PD Number | Desired Values
1009 | 3534768 | 200
1009 | 3555555 | 500
03003 (M) | 3534740 | 100
3004 (M) | 4534768 | 275
02T11 | 13534768 | 389
Spreadsheet: 9ba9d7e9-4092-41a4-b985-abcd21425362
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43141614 | 2014-09-13 16:21:45 | ALLIES | 1 | 4 | 1 | 1602000 | Stipo | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
43141793 | 2014-09-13 16:32:24 | AXIS | 1 | 4 | 2 | 1602000 | Stipo | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
Spreadsheet: 857024d1706118188-need-help-with-table-functions-book2
Sheet: Sheet1

Number | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 1 | 2 | 3 | 4 | 5
Set 1 | d | d | a | d | a | x | a | d | a | d | d | a
Set 2 | a | x | a | d | z | x | x | a | d | a | x | a
Set 3 | a | x | a | d | z | x | x | a | d | a | x | a
 |  | x | a | d | z | x | x | a | d | a | x | a