Search results for query: *

Appreciate some timely insight! Novice - first time attempting to extract data via an API. I obtained a API Key and the Secret. Converted to base64. Now perplexed as to the next step where the instructions that I have state that I should "Enter the generated base64value in the header and...

Using Sumif to dynamically sum the values in column C for a 6 month prior period for the current year, 2021. Formula is correct - the sum for the desired months is displayed...

Timely insight needed! Have a HP Elite Book with Windows 7 Professional 64 Bit loaded and cannot log into windows for the past three days Ton of information on the laptop! Have attempted the following to no avail; Safe Mode Safe Mode with Command Prompt Enable Boot Logging Each time, I am...

Timely insight needed to create a formula to calculate the percent change between two estimates that also should consider the margin of error for each estimate. I am told that the estimates are for two non-overlapping time periods. The MS Excel 2016 worksheet include the following seven...

On a weekly basis, I receive over 2500 non-delimited records with the following format whereby all of the data is in column A. equip_type:"C","seller":"SampleSeller LLC","buyer":"SampleBuyerCorp","address":"1000 Main...

Timely insight needed! I have a MS Excel workbook with more than 40 worksheets. The worksheet names correspond to the account numbers in column C on Sheet 1 beginning at row 10. Note, column C contains the formula "=MID(Trim(D10),1,6) For Example, In column C at row 10 are the following...

Have an MS Excel 2017 workbook with three worksheets; "Combined", "Widgets", and "Washers." Each worksheet has four columns; AccountNo ItemNo Estimate_Iter1 Estimate_Iter2 Worksheet "Widgets" has data such as this; AccountNo ItemNo Estimate 5002056 500010 $650,000 5002056 500060...

Have MS Excel worksheet with approximately 50,000 records that have a column (column AC) containing abbreviated numbers such as $100K. I would like to convert the data within this column to the long format such as 100000. Have tried several approaches including the following; Creating two...

Timely insight appreciated. (Note, I did create a similar post in the MS Office forum and will delete that one) Context Receive a text file that contains data from a Sql Server database. I import the text file into MS Excel to create a Report. Data within MS Excel is like this; Equip Code...

https://res.cloudinary.com/engineering-com/raw/upload/v1566692107/tips/Tek_Tips_20190824_Sumproduct_tnpwsl.docx Have an MS Excel 2016 file with the following data. Equip Code Sale Date Sale Price 12345 1/25/2019 8000 12346 1/26/2019 10000 89023 1/18/2019 24569 88456 2/25/2019...

Encounter an error upon attempting to create a format file. Context: Have a very large comma delimited file that has over 1.3 million records. Upon opening the file with EmEditor, I delete the comment line that is on the very last record. Due to a comma within one of the fields, it appears...

Using Sql Server 2012 and attempting to load a CSV file with over 1,000,000 records. Within the file, the TransactionDate field is displayed as "YYYY-MM-DD 00:00:00" I am interested in storing the data in the database within the respective yearly tables with a date format like "YYYY-MM-DD."...

thread271-1784472 Revisited the post above regarding the processing of text files using AWK. I have a large CSV file - 220 megabytes with approximately 1,300,000 records. Upon reviewing the CSV file, there is a comma within one of the fields - the field "City" that contains data such as...

Receive the following error upon attempting to bulk insert a large CSV file (220 megabytes; 1,300,000 records) into a Sql Server 2012 database. Msg 4832, Level 16, State 1, Line 1 Bulk load: An unexpected end of file was encountered in the data file. Msg 7399, Level 16, State 1, Line 1 The OLE...

Have MS Excel 2016 workbook that has several links in worksheet "Analysis" that refers to the external file "Rates_201904" at path R:\Rate Sheets\2019\April\. Every month, I manually update the link to the following month's Rate sheet. For example, I will now update to the external file...

Using the code below to extract two fields from a large csv file. Currently receive an error - "Provider not found" and the words "xlcon.open" is highlighted. Any insight as to what the cause of the error is and a resolution? Thanks in advance Sub GetMyCSVData() Dim xlcon As...

Objective: Populate the last column, Col 18, on worksheet "ws3" with the date that the updated record(s) was/were appended to worksheet, ws3 I am using MS Excel 2016 and have data within two worksheets - "ws1" and "ws3." ws1 is refreshed (from a CSV file on the network drive) upon opening...

Have a voluminous monthly MS Excel worksheet (Over 240,000 records) with equipment sale and re-sale data throughout the year such as displayed below. EqNo------- Region------ SaleAmount-------SaleDate A-250------- 146------- 8,000------- 1/5/2018 A-300------- 146------- 25,000------- 1/7/2018...

Have workbook with 25 worksheets. I need to merge all of the worksheets except two worksheets ("EquipmentTest" and "CapitalTest") to a single worksheet named "Combined." Note, The 23 remaining worksheets have the same column headers, same number of columns. For any given week, the number of...

Have five columns on an MS Excel worksheet containing over 20000 records with unique Equipment IDs. I am attempting to create formulae for columns 4 and 5 to extract just one equipment ID per unique department and for unique region. Any insight as how to best accomplish this using a formula in...