Stock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?
Spacing on stacked bar charts
Hi all, I searched for a solution, but changing to 'text' axis doesn't work and that's the only solution I have seen offered. Issue: When using a date axis, there is too much white space / bars are too skinny to be legible despite gap width set all the way at 0. When switching to a text axis, the bar spacing is perfect, but the spacing between dates are at times nonsensical or for some reason it thinks the range is way different than what is highlighted. Here is how the data is highlighted, I only hid columns to make the picture a reasonably proportion the screenshots from above are when no columns are hidden. Is there a way to re-scale the gap-width when using a data axis to effectively to go something like -50%? Or to somehow manipulate the range and the months between labels when using a text axis? Thank you for the help. Matt
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with nested if and statements between 2 excel spreadsheets. I have a slightly large spreadsheet with names that are repeating and events repeating thus the file first needs to determine the class so it pulls the right time. The data contains Classes (class A, B and C), Name, Event and Time. Spreadsheet A is the times. Everyone's times are recorded on Spreadsheet A. Spreadsheet B is to track the times per participant on a different tab per participant. In Spreadsheet A, column A is the participant number, column C is event name, column G is the time and column H is the class. In spreadsheet B, (the formula will be in Spreadsheet B). First, I need the formula to look at the class listed in spreadsheet B Column C Row 4 (Class A), then the formula needs to look at column H in spreadsheet A for Class A. Then it needs to look for the rider number on spreadsheet B, Column C row 2 (1234), needs to search spreadsheet A column A for rider 1234, and last it needs to look for the event (Runs) in spreadsheet B, and searches spreadsheet A column C for runs. After it matches all 3 then it needs to return the time in column G. If it does not find all 3 matches, then it needs to leave it blank. IE: Spreadsheet B, Class "A", Rider "1234", Event "Runs", if it meets all three criteria's then return the time in Column G.Compute elapsed time
I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to account for the minutes where the start time minute is greater than the end time minute. Unless someone has another way of computing this.
Contest Scoring
I created a spreadsheet to calculate points for a Skillathon test we give to kids at our fair. On the main sheet, we input the points earned for each question. I created a second sheet to calculate the points for question 20. I have a table set up to auto-sort the teams by Amount. I want to be able to take the points from this table and have that input into the main score sheet. Need help with the function for this.
Runt-time Error 1401 When Importing a CSV file Using VBA
I am beyond frustrated that I cannot make this work. Let me explain. My spreadsheet needs to import a standard CSV file then parse that information into several different worksheets. The very first time I ran the import code it worked. The second time and every time after that it fails with the "Run-time error '1004': Application-defined or object-defined error" message. I tried this on a different computer with the same results first run it worked, every run after that it fails. Here is the code: Sub ImportCSV() Dim ws As Worksheet Dim csvFilePath As String Dim lastRow As Long ' Set the worksheet where you want to load the data Set ws = ActiveWorkbook.Sheets("Raw") ' Specify the path to your CSV file csvFilePath = "exportusers-all.csv" ' Clear existing data in the worksheet ws.Cells.Clear ' Import the CSV file With ws.QueryTables.Add(Connection:="TEXT;" & csvFilePath, Destination:=ws.Range("A1")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With End Sub This is the code I've found in numerous places when I search the internet when I search how to do it. I have tried this as a normal user and "Run as Administrator" both fail. My Trust Center > Macro Settings are as follows: Enable VBA macros - Selected Trust access to the VBA project object model - Checked The CSV file can be opened in a text editor and Excel without any issues, but if I try to import it, it fails completely. Any help or suggestions to resolve this problem would be greatly appreciated. Thanks.Hyperlink and view the cell in different workbooks
Hi Experts, I'd like some help with this, i have 2 workbooks, namely Test 1 and Test 2 .. Excel file (Test 1) TEST 1 100 TEST 2 200 TEST 3 300 Excel file (Test 2) TEST A 300 TEST B 200 TEST C 100 I'd like a formula whereby if i click "100" cell from (Excel file 1) it should open the (Excel file 2) and take me to it's cell with same value as excel file 1. Thank you.
