Alright, so what I am dealing with is, I have an inventory release form where employees enter all the parts, and quantities of those parts, they are taking on a job. But a few days later another employee might pull up that job's spreadsheet and enter more parts below, and some of those parts might be duplicates from above. What I want is a separate sheet that lists all the part numbers for the job (ideally in order, but that isnt necessary), while obviously removing all the duplicates.
I have attached a basic workbook that illustrates what I want.
Thanks ahead of time!
Bookmarks