stock

Good afternoon all, Can anyone help please, I am trying to return a date on a spreadsheet bases on criteria in 2 cells and am stuck! Column "AA" is a number - days of inventory left in stock, which is live from our system and I am trying to work out how many work days from today stock will...

hi folks, Struggling with this one and not sure there's actually a solution, but i'd love to be proven wrong (gauntlet, thrown.) I am compiling a Worksheet KPI that reports back a ranked list of performances, based on that areas stock holdings. Each of our stock holding areas hold a different...

Greetings, Thanks, in advance to those who might be able to help. I'll make it as concise as I can while providing context when needed. Scenario: I work for a Distribution Centre with about 10,000 unique location in the warehouse (4 different sizes and storage capacity [full, half, quarter...

Dear Team, I have problem in finding expiry stock, I have a file contain two sheets, First sheet shows the batch wise stock with expiry dates and the second sheet shows month wise consumption, for example I have first batch expiry in June-2019 with the qty of 1000, and my stock consumption in...

HiAll, Hopeeveryone is fine and fruity. This is my first post here, I've triedto find an answer in the forum posts but to no success. Hopefullysomeone can give me some advice or point me in the right directionfor my problem. Ihave a multi sheet workbook for stock control, sheet 1 is...

I have 8 years of daily stock data that includes a line for the daily stock price and 2 moving average lines and it's getting harder and harder to differentiate between the lines at the current data point because of how compressed the chart is getting. Is there a way to make the last 30 days of...

Hi Experts, I want to get specific text from the Column A to B like follows, please help with formula <tbody> SPVAR JAN 19 SPVAR IFG JAN 19 IFG R1 Adjustment JAN 19 R1 Adjustment Stock Adjustment JAN 19 Stock Adjustment IFG FEB 19 IFG SPVAR FEB 19 SPVAR Stock Adjustment FEB 19...

Hi, I have posted a problem earlier which got solved by user "Fluff". Now my supervisor found something in the solution that is not correct due to linking in other formula. Therefore, I am facing a new situation: I have 2 Sheets: Sheet 1: Columns B, C, D & E. Column B is the Stock Status...

Hi, am looking to find help for the following problem. I have 2 Sheets: Sheet 1: Columns B, C & D. Column B is the Stock Status (Either "No change" or "Change in Stock"). Column C is Transaction ID 1 (e.g XXX2342) and Column D is Transaction ID 2 (e.g XXX2341). Sheet 2: Columns D, E. Column...

Hello!! I have a workbook having more than 1700 sheets (Starts as Stock Code 1, Stock Code 2 ...) in which data starts from Column A8. I want to copy A8 to D (last row of Column D) to a new sheet with sheet name. In same way it will also display Column F9 to I (last row of Column I) and data...

Dear Team, I have a table of dates and GE Stock Prices. I would like a Calculated Column that calculates the change in stock value day by day. THE DAX I have created is this: Calculated Column for Change in GE Stock Prom Previous = IF ( MIN ( GEPrices[Date] ) = GEPrices[Date], BLANK...

Hi! I've a problem in DAX I can't solve. Perhaps you could help me... In an stock movement table, i have the next columns: Date-time, Product id, Movement id, Order id and Stock. The final stock value for each product is the number that appears in the column "Stock" in the last date-time and...

I am trying to write a formula that rounds up (or down) to the nearest whole number. Here are my parameters. This is for optimizing material lengths in manufacturing..... Cell P40 = number of stock lengths required Cell D22 = Quantity of Pcs Cell J6 = Length of Each Pc. Cell I40 = Length of...

Hi all, I have had a good look round the forums and still can't find what I am looking for. (Probably because I am not searching for the right thing!!) I am hoping the below can be dealt with using a new function, but open to all ideas. I am trying to build a forecasting tool for predicting...

I'm back, with another headache haha. I have 2 Sheets. Sheet 1 - Is user-friendly Sheet 2 - Is a database full of product information. Sheet 1 currently looks like... <tbody> A B 1 [In Stock?] [Product Name] 2 ? Product #3 3 ? Product #2 4 ? Product #4 5 ? Product #1 </tbody>...

Hi. Is there a way I can make my own stock screener that will pull data off line so I can sort by my own custom parameters?

Good morning, I'm trying to figure out a formula for this Look horizontally for the unique header value (A B C D E F G) Then vertically search column by column for the part # (it's always column 0) Give value for stock (always column 2) Sheet 1 Part # Stock 390-2 | function...

I have an excel sheet where I forecast an out of stock date. {=MIN(IF(Sheet1!K4:K368>0,Sheet1!K4:K368))}. formula stopped working properly and is looking at the number closest to zero which Is a past date. I Only need the formula to look at todays date forward

Hello, I'm new to VBA, so apologies if this seems a simple one.! I'm currently working on a stock check spreadsheet which contain a stock list with datasheets numbers (these would be typical numbers, but the cell may contain more than one) and size, and a requirements sheet with a typical...

Hi There, Another day, another challenge! I'm working on a stock shortages report and cant figure out how to lookup the stock value in another sheet and then cumulative subtract as it moves down the list. E.g Stock levels (Sheet3) <tbody> Column Part Qty A Apple 12 B Banana 6 C Carrot...