I am having trouble pulling data from one spreadsheet into a table on another and would appreciate some help! In the attached, I have two worksheets: "Product SKUs" and "SKU List". I need to identify how many times a product SKU registered with an online attribute code at time of sale - columns A & B of "SKU List" pull all the occurrences over the date range and I need to report as follows: "SKU 123 received 5 different attribute codes over the date range". I do not need to know which codes SKU 123 received for this metric - I do, however, need to know the unique count. So if SKU 123 registered 12 times and used 5 different codes, I need to report 5, not 12. If SKU 234 also contained one of the 5 codes SKU 123 shows, that is fine - unique attributes per SKU is what I'm after.
In "SKU List", I tried to concatenate A & B's raw data of SKUs to attributes, sum the results in a pivot, and re-separate the concatenation. I then tried to use an index/match formula to pull the codes number on the "Product SKUs" sheet but this number is consistently returning "#N/A" (not all SKUs will have results but some/many will [though this sheet has been hella trimmed down for a sample]). I suspect this is because the SKU number pulled on the "SKU List" sheet is formulaic - if I directly type the SKU # over the formula-produced number on "SKU List" (col. M), the number pulls using index/match, but I do not have time to manually re-type each number (and have not found a general/number/text formatting option that seems to work).
Can you please help me understand what I need to do? All suggestions appreciated! Thanks in advance!
Bookmarks