Hi!

Thanks to shg, the final column holds a formula that gives each unique order (as defined by the row having the same items from the top row at the same quantities) a different "name". I need to convert the "names" to whole numbers starting with 1 and increasing. Then, when I filter the information by distro, I need the columns that have 0 as a quantity to hide so when I print the sheet it only shows the item numbers I need and their quantities below.

Please forgive my previous post with a similar question, I feel that this is more concise, and I'm unsure how to remove a post.

Thanks for your expertise!
macro test.xlsx
E