sku

  1. F

    Use of the Forecast Function for Predicting Future Sales

    Hello, I am a total newbie at forecasting and have a question about the forecasting function. I have three months worth of sales data for 8 SKUs. I need to predict the next six months of sales for these SKUs. Would the =FORECAST(x, known_y's, known_x's) function work for me here? Here's...
  2. D

    Generate SKU numbers for product list in Excel

    Hi Guys, Total Newbie in Excel - but I can figure some things out. I have a list of product categories structured like this: Seasonal/Christmas/Trees/Ornaments/Red I would like excel to generate numeric values for each category and a random value for each individual product. So Seasonal...
  3. J

    Plotting a graph to show individual SKU sales over time, revised.

    Hi, Please see the image below showing sales for each SKU over each week; What I am trying to set out to do is almost complete at this stage, but it's not quite right. Ideally I would like to have each date as a point along the bottom, and to have the values on the right Y axis. Therefore...
  4. W

    I have two sheets in Excel that both contain data and would like to merge data.

    Hi Guys, I have two sheets in Excel that both contain data. Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique...
  5. H

    SKU auto creation

    Hi everyone I am new to this forum but have a question I hope someone can help me with. Firstly, I am not an advanced user on Excel :-) I have a very large CSV file that contains an inventory but I need to assign an SKU to every line in the CSV. This SKU needs to be a set of numbers but with...
  6. S

    Creating Custom Product SKU and Pricing

    We manufacture products based on roughly 8 items that make up a single product. Each item has a description, cost and sale price. Our goal is to create a SKU generator and price calculator based on these different product options. A sample SKU might look like G1-A4-B9-H4-M5-J2-R6-K5 with a...
  7. B

    Counting in groups or bunches

    Hey guys, I am trying to create unique SKUs for a data set I have. What I would like to accomplish is to create a new SKU for every new product. These SKUs should be numerical but I cannot use the drag tool or a basic formula because each product takes up anywhere between 2-50 rows. Each...
    • BMR
    • Thread
    • count count formula countif group count sku
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top