Need: assign different whole number to each unique order, hide 0 qty column when filtered

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

Hello esmithqg, and welcome to the forum.

You could/should have just edited your previous post rather than starting a new one. I have closed the other post for you.