tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788920d1658800070-match-with-two-variables-excel-lookup-example
Sheet: Sheet1

[NAME]
 | Low Range |  | Hi Range |  |  | Origin | A | Lookup a | Origin | B | Lookup b | Origin | C | Lookup c
 | a | 8001 | 8004 | X |  | a | 8001 |  | b | 8001 |  | c | 8001
 | a | 8005 | 8008 | Y |  | a | 8002 |  | b | 8002 |  | c | 8002
 | b | 8001 | 8003 | P |  | a | 8003 |  | b | 8003 |  | c | 8003
 | b | 8004 | 8005 | D |  | a | 8004 |  | b | 8004 |  | c | 8004
 | b | 8006 | 8007 | Q |  | a | 8005 |  | b | 8005 |  | c | 8005
 | c | 8001 | 8001 | T |  | a | 8006 |  | b | 8006 |  | c | 8006
 | c | 8002 | 8002 | W
 | c | 8003 | 8003 | R
 | c | 8004 | 8099 | E
 |  |  |  |  |  | What the answers |  |  |  | hould be
 |  |  |  |  |  | Origin | A | Lookup a | B | Lookup b | C | Lookup c
 |  |  |  |  |  | a | 8001 |  | 8001 |  | 8001
 |  |  |  |  |  | a | 8002 |  | 8002 |  | 8002
 |  |  |  |  |  | a | 8003 |  | 8003 |  | 8003
 |  |  |  |  |  | a | 8004 |  | 8004 |  | 8004
 |  |  |  |  |  | a | 8005 |  | 8005 |  | 8005
 |  |  |  |  |  | a | 8006 |  | 8006 |  | 8006
Spreadsheet: 177e8675-8886-45f6-9857-02d97593e669
Sheet: Sheet1

Employer Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Policy Number:
Current TPA:
 | Claim Data |  |  | Calendar Year 2012 Payroll Segregated by NCCI Class Code
Calendar Accident Year | Total Paid as of  12-31-2012* | Total Reserve as of 12-31-2012* |  | Class Code | Payroll
Prior
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987 |  |  |  | Please attach a loss run for all open/active claims that includes a minimum of the following data fields:
1988
1989
1990 |  |  |  | Claim Number
1991 |  |  |  | Date of Injury/Date of Last Exposure
1992 |  |  |  | Claim Type
1993 |  |  |  | Total Indemnity Paid
1994 |  |  |  | Total Medical Paid
1995 |  |  |  | Total Expense Paid
1996 |  |  |  | Total Indemnity Reserve
1997 |  |  |  | Total Medical Reserve
1998 |  |  |  | Total Expense Reserve
1999
2000
2001
2002 |  |  |  | Please include a list all claims that have closed within the year.
2003
2004 |  |  |  | Claim Number
2005 |  |  |  | Date of Injury/Date of Last Exposure
2006 |  |  |  | Claim Type
2007
2008
2009
2010
2011
2012
Are expenses included in the Paid and Reserve data? |  | Yes
* Total Paid and Total Reserve columns should include aggregate indemnity, medical, and expense. Please inform us if expense data is not fully included in the claims data.
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 1003

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OME 1003 |  | Start Date | 24/07/2011 |  |  |  | [NAME]
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | a
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: Mojave

56696
Day | Scheduled | Measured
1 |  | 71514
2 |  | 74070
3 | 65632 | 66238
4 | 48170 | 48619
5 |  | 46708
6 |  | 53054
7 |  | 40954
8 |  | 32413
9 | 24867 | 26010
10 |  | 25525
11 |  | 24667
12 |  | 38096
13 |  | 18761
14 | 22897 | 23514
15 | 24866 | 24876
16 | 33771 | 32400
17 | 34751 | 34803
18 | 34751 | 31227
19 | 24612 | 23031
20 | 39867 | 38189
21 | 44866 | 40946
22 | 43720 | 42583
23 | 44494 | 43315
24 | 42574 | 43564
25 | 42329 | 41642
26 | 49630 | 48285
27 | 33200 | 31944
28 | 24867 | 22822
29 | 41786 | 42619
30 | 24867 | 23044
31 | 21416 | 22978
2000-11-30 00:00:00 |  |  | 84016
2000-12-31 00:00:00
Spreadsheet: 149096d1333692040-insert-formula-based-on-cell-criteria-formula-criteria
Sheet: Sheet1

Revenue is |  | Gross
Week Ending |  | Liquor Revenue | Food    Revenue | Total       Revenue
Sub Total |  | 0 | 0 | 0
(+) Part Week This
(-) Part Week Last
Grand Total |  | 0 | 0 | 0
Till Read |  | 0 | 0 | 0
Revenue v Till |  | 0 | 0 | 0
Spreadsheet: 170341d1343240055-moving-data-with-index-and-match-for-pricing-sheet-copy-of-revised-pricing
Sheet: Wall Cabinets

WALL CABINETS
Code | [NAME] | DEPTH | HEIGHT | WIDTH | SQ.FT | HINGES | SHEET | WM $ | WHITE MEL. | C. MEL $ | COLORED MEL. | PFB$ | PRE-FINISHED BIRCH PLY | [NAME] | CLEAR VENEER | SV$ | STAINED VENEER | PM$ | PAINTED MDF | PV$ | PAINTED VENEER
W2412 | Wall Cabinet | 12 | 12 | 24 |  | 10 | 0.32 | 150 |  | 165 |  | 195 |  | 238 |  | 350 |  | 350 |  | 410
W2712 | Wall Cabinet |  |  | 27 |  |  | 0.35
W3012 | Wall Cabinet |  |  | 30 |  |  | 0.38
W3312 | Wall Cabinet |  |  | 33 |  |  | 0.41
W3612 | Wall Cabinet |  |  | 36 |  |  | 0.45
W3912 | Wall Cabinet |  |  | 39 |  |  | 0.48
W4212 | Wall Cabinet |  |  | 42 |  |  | 0.51
Spreadsheet: 845498d1697003586-index-match-error-sales-stewardship
Sheet: A v P

 | A v Plan YTD 23 | SOP |  |  | MAP |  |  | UP |  |  | MKP |  |  | NPK |  |  | AuSul |  |  | N.Potash |  |  | All
 | Sales Area | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | Plan | Sales | A v P | A V P W/O AS | Delta with AS | Delta W/O AS
 | Depalpur | 193 |  |  | 42 |  |  | 50 |  |  | 10.75 |  |  | 5 |  |  | 45 |  |  | 13
 | Okara | 166 |  |  | 38 |  |  | 42 |  |  | 10.3 |  |  | 6 |  |  | 40 |  |  | 13
 | Sahiwal | 149 |  |  | 27 |  |  | 26 |  |  | 8 |  |  | 5 |  |  | 35 |  |  | 12
 | [NAME] | 192 |  |  | 42 |  |  | 32 |  |  | 11.95 |  |  | 5 |  |  | 35 |  |  | 12
 | Sahiwal Region Total
 | [NAME] | 105 |  |  | 23 |  |  | 21 |  |  | 4 |  |  | 5 |  |  | 45 |  |  | 13
 | Vehari | 90 |  |  | 20 |  |  | 20 |  |  | 4 |  |  | 5 |  |  | 45 |  |  | 13
 | Lodhran | 80 |  |  | 17 |  |  | 18 |  |  | 3.5 |  |  | 4 |  |  | 35 |  |  | 12
 | [NAME] | 95 |  |  | 23 |  |  | 21 |  |  | 3.5 |  |  | 5 |  |  | 40 |  |  | 20
 | TT Singh | 80 |  |  | 18 |  |  | 20 |  |  | 4 |  |  | 5 |  |  | 30 |  |  | 12
 | Multan Region Total
 | Commercial Total
Spreadsheet: 219882d1363002687-conditional-formula-based-on-date-comparison-new-booking-form-example-for-excel-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00 |  | 2nd Mar 3rd Mar |  | 2013-03-04 00:00:00 |  | 2013-03-05 00:00:00 |  | 2013-03-06 00:00:00 |  | 2013-03-07 00:00:00 |  | 2013-03-08 00:00:00 |  | 9th Mar 10th Mar |  | 2013-03-11 00:00:00 |  | 2013-03-12 00:00:00 |  | 2013-03-13 00:00:00 |  | 2013-03-14 00:00:00 |  | 2013-03-15 00:00:00 |  | 16th Mar 17th Mar |  | 2013-03-18 00:00:00 |  | 2013-03-19 00:00:00 |  | 2013-03-20 00:00:00 |  | 2013-03-21 00:00:00 |  | 2013-03-22 00:00:00 |  | 23rd Mar 24th Mar |  | 2013-03-25 00:00:00 |  | 2013-03-26 00:00:00 |  | 2013-03-27 00:00:00 |  | 2013-03-28 00:00:00 |  | 2013-03-29 00:00:00 |  | 30th Mar 31st Mar |  | 2013-04-01 00:00:00 |  | 2013-04-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Start | Fri |  | Totals |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Totals |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Totals |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Totals |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Totals |  | Mon |  | Tue
Child Name | Mon AM | Mon PM | Tue AM | Tue PM | Wed AM | Wed PM | Thu AM | Thu PM | Fri AM | Fri PM | Date | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
Child 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 2013-03-11 00:00:00
Child 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2013-02-01 00:00:00
Spreadsheet: 718600d1613229809-conditional-format-if-multiple-criteria-met-cf-project-tracking-experimental-aligw
Sheet: Project 

Created Date | Project Location |  |  | Project Title / Description |  | PO # / Date |  | Terms |  |  | Project Manager |  |  | Customer Project Manager
 |  |  |  |  |  |  |  | BOD ? |  |  | Name |  |  | Name
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | BMS Job # |  | PO# |  | COM |  |  | Phone |  |  | Phone
Forecast Project Costs & Profit |  |  |  | Permits Required ? | Yes | Proj. Close Date |  | Proj. Duration |  | Delay Reason (If Applicable) |  |  | Days In Our Court
Sold Price |  |  |  | Actual Project Costs & Profit |  |  |  |  |  |  |  |  |  | LEAD DAYS | Order Date | Date Expected
Total Price With CO's |  |  |  |  |  | CO Explaination |  |  |  | Equipment Lead Time
CO 1 | CO Number | 1234 |  | CO 1 Cost
CO 2 | CO Number |  |  | CO 2 Cost
Total CO Price |  |  |  | Total CO Cost
Profit |  |  |  | Actual Profit |  |  | CO Profit
Percentage |  |  |  | Actual Percentage |  |  | [NAME]
Projected Total Project Cost |  |  |  | Actual Total Cost
Projected Equipment Cost |  |  |  | Actual Equipment Cost
Projected Sub Contractor Cost |  |  |  | Actual Sub Contractor Cost
Equipment Vendors |  |  |  | Equipment Description |  |  |  |  |  |  |  | Original Quote | Additional Costs | Submittal |  | PO #
Sub Contractors |  |  |  | Sub Contractor Scope
 |  |  |  |  |  |  |  |  | Lift Plan Required |  |  | Original Quote | Additional Cost | Change Orders |  | PO #
Engineering / Coring / Testing and BOD |  |  |  |  |  | BOD REQUIRED |  |  | Permit Required |  |  |  |  |  |  |  | NULL | CO1 | CO2
Mechanical
DEF |  |  |  |  |  |  |  |  |  | Permit |  |  |  |  |  | p
 |  |  |  |  |  |  |  |  |  | Permit
Electrical
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Sheet Metal & Duct
Controls
Rigging & Crane
Pipe Fitting
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Plumbing
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Balancing
Insulation
Fire & Sprinkler
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Cleaning & Misc
Spreadsheet: 670027d1585722856-automatic-invigilation-duty-list-in-excel-exam-duty-list
Sheet: Duty ListRoom 

 |  | Date of Exam
Room No | Batch | 2020-04-01 00:00:00 | 2020-04-02 00:00:00 | 2020-04-03 00:00:00 | 2020-04-04 00:00:00 | 2020-04-05 00:00:00 | 2020-04-06 00:00:00
R1 | C1
R2 | C2
R3 | [NAME]
R4 | C4
R5 | C5
R6 | C6
R7 | C7
R8 | C8
R9 | C9 |  |  |  |  |  |  |  | I need to assign teachers to this yellow coloums from the data sheet randomly and evenly
R10 | C10
R11 | C11
R12 | C12
R13 | C13
R14 | C14
R15 | C15
R16 | C16
R17 | C17
R18 | C18
Room no depends on number of students for data sheet
Spreadsheet: 213864d1360679413-how-do-i-insert-checkboxes-how-do-i-link-them-to-data-validation-and-vlookup-example3
Sheet: Sheet1

 |  |  |  |  | Order Form
How many computers do you need service for? |  |  |  |  | Product Description | Product Price | Your Order Totals
50
 |  |  |  |  | Service Package | 23000 | 23000
 |  |  |  | CHECKBOX
 |  |  |  | CHECKBOX | Spyware Installation Package | 12000
 |  |  |  | CHECKBOX | Deluxe Spyware Installation Package | 15000
 |  |  |  |  | Network Diagnostic | 25000
 |  |  |  |  |  | Total:
Data Validation |  | VLookUp
Computers |  | Service Package Question
25 |  | 25 | 12000
50 |  | 50 | 23000
100 |  | 100 | 42000
150 |  | 150 | 60000
250 |  | 250 | 85000
 |  | Spyware Installation Package
 |  | 25 | 7000
 |  | 50 | 12000
 |  | 100 | 16000
 |  | 150 | 24000
 |  | 250 | 24000
 |  | Deluxe Spyware Installation Package
 |  | 25 | 9500
 |  | 50 | 15000
 |  | 100 | 19000
 |  | 150 | 26000
 |  | 250 | 26000
 |  | Network Diagnostic
 |  | 25 | 15000
 |  | 50 | 25000
 |  | 100 | 45000
 |  | 150 | 60000
 |  | 250 | 78000
Spreadsheet: 881811d1730010103-how-to-have-return-results-of-a-function-split-across-multiple-lines-jeff-12345-testfile-3-spill-365-aligw
Sheet: Agent Charges

Agent Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges. (Done)
Assesorial Charges by Agent: |  |  | AGT-2
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Agent | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME]
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 0 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | AGT-2 | 902.24 | ZIM | 234.44 | 36.88 | 134.81 | 6.84 | 7.95 | 0 | 99.45 | 84.5 | 101.71 | 186.34 | 9.32
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0 | LCL | AGT-2 | 0 | Ever | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: BUG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BUG
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  | 15110 | -348950 | -133 | -403 | 10252 | -294563
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | 16908.8 |  |  |  | -16909
3 |  | Interdesk |  |  |  |  | 16101572 | 41121828 | 14943 | 35671 |  |  | 1938640 | 4676504 | 1938640 | 4676504 | -3892223 | -9388679
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 0 |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | -6719000 | -13738465 | 27118 | -2595152 | -4500 | -43029 |  |  |  | 183
7 |  | Liquidations
8 |  | Interdesk |  |  |  |  | -21579459 | -53470940 |  |  |  |  | -1938640 | -4676504 | -1938640 | -4676504 | 3877280 | 9353008
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  |  |  | 319487 | 808319
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | 1363174 | 3088563 | -1363174 | -3088563
14 |  | Cash Out
15 |  | Cash In |  |  |  |  |  |  | 0 | 0
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  | 1479157 | 3717635 | 41589 | 104535 |  |  | 3214 | 7916 |  |  | -49296 | -125569
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 1376523 | 3117825 | -330097 | -747670 | -3081 | -6978 | -10252 | -23221 | 64239 | 145501
23 | Fuel: |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense: |  |  |  |  |  |  |  | 0
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  | -1383 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2449663 |  | -2482870
25 |  | Demand |  |  |  |  | 0 | -20775 |  | 0 |  | -251301 |  | -1802844 |  |  |  | 287775
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  |  | 54937 |  |  |  | -54933
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 95418d1295012598-date-calculation-for-forum-date
Sheet: Sheet1

Planned End Date | Actual End Date | Days Difference |  | Summary Total
2009-04-28 00:00:00 | 2009-04-28 00:00:00 |  |  | Before | amount
2009-04-23 00:00:00 | 2009-04-23 00:00:00 |  |  | After | amount
2009-10-09 00:00:00
2009-07-10 00:00:00 | 2008-12-09 00:00:00
2009-07-10 00:00:00 | 2008-10-07 00:00:00
2009-07-10 00:00:00 | 2008-10-07 00:00:00
2009-07-10 00:00:00 | 2008-10-07 00:00:00
2009-07-10 00:00:00 | 2008-10-07 00:00:00
2009-06-26 00:00:00 | 2009-07-15 00:00:00
2009-05-07 00:00:00 | 2009-04-30 00:00:00
2009-04-02 00:00:00 | 2009-04-02 00:00:00
2009-05-07 00:00:00 | 2009-05-07 00:00:00
2009-07-10 00:00:00 | 2009-07-10 00:00:00
2009-07-10 00:00:00 | 2009-07-10 00:00:00
2008-12-16 00:00:00 | 2008-12-16 00:00:00
2009-06-26 00:00:00 | 2009-06-26 00:00:00
Spreadsheet: 679500d1590456198-extract-data-based-on-text-string-contents-organizing-results-sample-pipeline-workbook_1
Sheet: Data-Pipeline

 | Last Modified | Applications Out | In Process | Submitted | PreApproved TBD | Approved | Docs Out | Closed | Post Closing | Applications Out - Now Closed | Dormant | Cancelled | Leads | Duplicate Categories
All Files/1. [NAME]'s loans with MyHang/Leads/Wes Sample's loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/1.  Applications Out Loans/Tester1, [NAME] and Tester2, [NAME] loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/Dormant/Sample, Remi and [NAME] loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/Sample, Marvin loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/Cancelled/[NAME] and [NAME] loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/5.  Approved Loans/Patrick & Alexander Sample loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/4.  PreApproved TBD Loans/Joe Sample & Tim Sample loan file/ | 2020-01-01 00:00:00
All Files/1. [NAME]'s loans with MyHang/9. Applications out - now closed/[NAME] loan file/ | 2020-01-01 00:00:00
Issue 1
I fully acknowledge this may be a naming convention issue, but I'll ask the group, in case it can be solved with formulas.
The formulas in columns C:N are customized for the length of the header for each column (the value being referenced in the formula)
These formulas are behaving correctly and looking for specific words in the text string in column A.
Problem is this is causing a few duplicative entries (see rows 8/9).
In the case of row 8, the correct entry should be in cell F8 (not G8).
In the case of row 9, the correct entry should be in cell [NAME] (not C9 or I9).
Issue 2
I would like to paste the corrected data in columns C:N in the "Consolidated Data" sheet.
I would like to paste them in an organized list format (paste 1st result in row 2, paste 2nd result in row 3, and so on…
Perhaps this is a macro challenge for the macro board…
Spreadsheet: andy_zipper__603__11_20_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 280 | 29 | 32 | 93.8 | 103.6 | 17.37 | 2001-11-20 12:04:00
 | NG F2 | 300 | 64 | 67 | 85.7 | 89.7 | 16.54 | 2001-11-20 12:04:00
 | NG G2 | 305 | 82 | 85 | 78.5 | 81.4 | 15.33 | 2001-11-20 12:04:00
 | NG H2 | 300 | 85 | 89 | 70 | 73.3 | 13.51 | 2001-11-20 12:04:00
 | NG J2 | 295 | 79.5 | 83 | 58.8 | 61.4 | 11.15 | 2001-11-20 12:04:00
 | NG K2 | 300 | 83 | 85 | 54.2 | 55.6 | 10.35 | 2001-11-20 12:04:00
 | NG M2 | 305 | 90 | 93 | 52.9 | 54.7 | 10.32 | 2001-11-20 12:04:00
 | NG N2 | 310 | 96 | 100 | 52 | 54.2 | 10.35 | 2001-11-20 12:04:00
 | NG Q2 | 315 | 102 | 108 | 51 | 54.1 | 10.41 | 2001-11-20 12:04:00
 | NG U2 | 315 | 109 | 113 | 51.6 | 53.6 | 10.42 | 2001-11-20 12:04:00
 | NG V2 | 320 | 118 | 125 | 52.6 | 55.8 | 10.9 | 2001-11-20 12:04:00
 | NG X2 | 340 | 127.5 | 130 | 51.1 | 52.1 | 11.03 | 2001-11-20 12:04:00
 | [NAME] | 355 | 138 | 141 | 51.3 | 52.4 | 11.57 | 2001-11-20 12:04:00
 | NG H3 |  |  |  |  |  |  | 2001-11-19 14:44:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 102455d1300386305-duplicating-cells-of-data-dup-address
Sheet: Sheet1

Name | Street1 | City | State | Zip
[NAME] | 1234 Anywhere St | Somewhere | CO | 12345 |  | 1234 Anywhere St | Somewhere | CO | 12345
[NAME] |  |  |  |  |  | 1234 Anywhere St | Somewhere | CO | 12345
[NAME] | 2222 Nowhere Circle | Somewhere | CO | 12345 |  | 2222 Nowhere Circle | Somewhere | CO | 12345
[NAME] |  |  |  |  |  | 2222 Nowhere Circle | Somewhere | CO | 12345
[NAME] | 16777 Someplace Land | Somewhere | CO | 12345 |  | 16777 Someplace Land | Somewhere | CO | 12345
[NAME] |  |  |  |  |  | 16777 Someplace Land | Somewhere | CO | 12345
[NAME] |  |  |  |  |  | 16777 Someplace Land | Somewhere | CO | 12345
[NAME] |  |  |  |  |  | 16777 Someplace Land | Somewhere | CO | 12345
[NAME] | 10 bbbbbbb | bbbbbbb | mn | 1234 |  | 10 bbbbbbb | bbbbbbb | mn | 1234
Spreadsheet: 481861d1474675200-extract-data-from-a-table-with-criteria-lists
Sheet: Sheet1

 | Basket1 | Basket2 | Basket3 | Basket4
 | Apple | Lime | Watermelon | A
 | Pear | Lemon | Grapes | D
 | Apple | Melon |  | H
 | Orange | Pineapple
 | Peach
 | Basket1
Basket1 | Basket3
Basket2 | Basket1
Basket4 | Basket2
Spreadsheet: 867996d1714721329-excel-formula-to-lookup-multiple-lookups-rows-and-column-value-book1-1-1-
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Out-Patient | CONSULTATION
Out-Patient | DENTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In-Patient | LABORATORY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | RADIOLOGY
 |  |  | Provider Class | VVIP | VIP | A+ | A | A3 | B | B3 | MB1 | MB2 | MB3 | MB4 | InterNational | Reimb | Referral | Grand Total |  |  |  |  |  | MEDICATION
 |  |  | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4076374.317856938 |  |  |  |  | DENTAL
 |  |  | Counts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43750.07142857143 |  |  |  |  | OPTICAL
 |  |  | ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131.6707142857143 |  |  |  |  | ROOM AND BOARD
 |  |  | OverAll ACPC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.1741180014353 |  |  |  |  | PACKAGE DEAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER SERVICES