skus

  1. Z

    Extract 1-N value(s) from a string of text in 1 cell - multiple extraction values in separate tables (excel formula needed)

    Thank you in advance for the help! ? After extensive forum research, I decided to post since I was unable to find a comparable problem/solution. Summary I need a formula that can extract a value from within a string of text based on a list of multiple criteria to look for (e.g. if value 1, 2...
  2. T

    Line Chart

    Im looking to have a line chart that shows a % for the number of sku's that were delivered on time. At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ). Im not great with charts , so could do with your help. Axis: Chart Date Values...
  3. I

    How can i match data from one sheet to another to give me a result

    I have two sheets, I would like to find and match both sku's on both sheets, if the sku from sheet1 matches the sku from sheet2, i want to extract a column from sheet 2. Sheet1: <tbody> SKU QOH 1008 0 1011 0 1013 0 2135 0 </tbody> Sheet2: <tbody> SKU QOH 1008 4 1011 6 1013...
  4. U

    How to add new items from list A to list B

    Hi. I have a sheet where I am working out product sales. In Sheet1 Column A I have all my SKUs. Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time. The problem is, as we add new products, the list of SKUs in Sheet1 will grow. So I...
  5. G

    Creating a SKU GAP Fill report.

    I need to produce a SKU GAP Fill report and would like to get some help. We have thousands of accounts and 53 SKU's and I need to find out from the sales reports from distributors which accounts are missing key SKU's. Any help would be appreciated.
  6. J

    Scrap Produt IDs SKUs from category Page Power BI

    below details are given on Source Code page. How can i scrap these SKUs for all pages in that particular category...
  7. S

    Convert Column and Rows....kinda

    This is what my data looks like <tbody> 60633082 60633006 60633084 60633080 60633046 1 9 2 4 1 3 2 0 0 1 2 0 3 2 1 2 0 0 4 0 0 0 1 1 5 2 3 4 0 1 </tbody> This is what I need it to look like: <tbody> 1 60633082 9 2 60633082 0 3 60633082 2 4 60633082 0 5 60633082 2 1...
  8. I

    Find Matching SKU and Item Numbers

    Hi, I have an excel sheet that has around 5000 products, i have 2 columns that are Code (C) and SKU (D), I would like to generate a report that tells me what items are duplicate. I would use the SKU to find identical SKU's so i can remove them from our system and i would also look for...
  9. C

    Find Duplicates in column and extract rows

    Hi, I have a small file that I can attach, if needed. It is about 400kb in size. I have tried multiple different angles on this work, but just can't seem to get this working correctly. The workbook contains (3) worksheets. One sheet is titled "PRODUCTS" and the others are "INVENTORY SKUS"...
  10. C

    Highlight Rows that have duplicates

    Hi, I have approximately 58,000 rows on one worksheet which contains products, and (COLUMN A) will contain the SKU#. On another worksheet, I am bringing over a "column" that represents a certain amount of (sku's) that are the products I wish to use. So in (COLUMN B), I am pasting the column...
  11. Y

    Highlight values equal to a list

    Hi, I have a list of sku's that I always edit and add more and I have a fixed list of sku's in another sheet. The first list is my inventory and the second list is sku's specific price that I have to use. How can I "run a scan" on the first list of the second list sku's and if a sku matches...
  12. P

    Create a list of base sku's or product groups

    Please help, Skus are in column A, Color is column B, All I need is if column B =Satin Bronze remove 10 from the end of the sku of column A There are about 15 finishes so I will need to edit for each one but thus is the best wat to get to the base sku's. In the sample row 1 is Satin Bronze and...
  13. R

    Advanced Filter?

    Hi All: I've never used Advanced Filter and I'm having trouble getting the results I want. Here's my problem - I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs...
  14. J

    Return Two Separate Sets of Child Values from Parent Cell

    Hi Excel Guru's, Looking for some advice on the best way to approach what I'm trying to do... after attempting to google or search the forums I think I'm failing to accurately search/describe what I'm trying to do and have resorted to creating this thread. 1. I'm trying to first reference a...
  15. L

    Complicated (for me) Lookup or Compare

    Hey folks, I've got another one for the genius residents of this fine forum. At work I run a report that creates an excel file. I've already created a master with the VBA required to clean it up so the process will be run the query, paste into the master, then run the macros and save the...
  16. G

    Any update on cheaper Premium SKUs?

    Anyone hear any new rumours?
  17. L

    Populate Column based on matching table

    Hi all, I need some help. I have 2 workbooks, one (results.xlsm) with SKUs in Column A, and I would like keywords I have for them put into Column B. The 2nd workbook (keywords.xls) has some SKUs in Column A, and corresponding keywords in Column B. I would like to use some VBA to match SKUs...
  18. A

    Subtotal or VLOOKUP?

    So this is what my data looks like 2014 Usage 2015 Usage 20000007 20 11 20000007 -1 0 20000007 1 0 20000007 0 20000007 Total but for a spreadsheet that has about 10,000 items. Is there a formula that...

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