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?
multi Vehicle maintenance log record
i need to make a vehicle maintenance log that will have 7 different vehicles, track all the oil changes, inspections, registrations that will notify us when something is expiring, and be able to attach receipts and documents to it. what is the best way to do this?
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.
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.
Grouping data sourced from another sheet in that workbook.
I am trying to make a monthly inventory count workbook through excel nut am having trouble consolidating the counts. I have a made a simple version of what I need but am getting stuck on the final sheet trying to group the data together. In my workbook I have a sheet with all my input data which I have attached below. I have fed this through PowerQuery so that the information from this Sheet can go into all other sheets on that workbook, and I only need to update one Sheet if new stock comes in, or leaves. From there I have the "Bar" Sheets where the counts get entered. As I will be dealing with a lot of stock, felt better to make a "Loose" & "Cartons" column and then just sure make an extra column where the calculations can be made giving a full total amount. Last Sheet is where I would like to consolidate all the totals from the "Bar" sheets into one area. which I have used the formula ="SheetName"[@Cell] as I do not know any other ways of bringing across this data. And here lies the problem. As on the "Full Stock List" sheet i have cells that are not actual values, the rows are not grouped, and if I try to sort by Item Name alphabetically, only the original 5 columns will sort, leaving the new columns untouched. If anyone can help explain how I can get around this, that would be most helpful, as I need to make this Workbook much much bigger.
[52 week high] formula not working
I have a spreadsheet where I track my portfolio data. I have attached a sample. It appears that the "[52 week high]" formula is not working properly. It shows up as the same price as the current "Price" for most securities. While this is in theory possible, the "Price" is below the "[Previous close]", so therefore it appears incorrect. Is this a known issue? How can it be resolved?Copy a formual, locking 1 data cell
Hello I have this formual to calculate the value in cell F11. I woul like to copy the formula down to F12, 13, 14, 15 and 16. Needing to lock the cell F5 value in the formula. Copy and paste only changes for F% to F6 to F& and so on. Thank you =(D11-(B11+F5)-(G11)+C11)/D11
