In Sheet2 find the converted numeric values. This is a named range in Name Manager ... UPC_codes. It was done by referencing the text numbers in Sheet1 with this entered in A2 of Sheet2 filled down and across I copied that range and pasted values back unto the range.
In Sheet3 A1 this formula counts the total number of UPC_codes. In B1 this formula counts the number of unique UPC_codes.
In column A is a list of all UPC_codes ... duplicates and all. Formula is Column B is a helper column. It assigns a row number to the first occurrence of each UPC_code tagging them as unique. Formula isColumn C is the unique extractions. Formula is The total count of each unique. Then in E3 filled down and across returns the row location under each Lettered Bin.
Bookmarks