Leave out duplicates
I am making a picking list for my warehouse. I have received great help from the forum's contributors to help me sort the picking order in terms of location. I have several titles listed in many locations. I only want to pick one of each of those titles. But when I print the picking list in order of location the list prints the same title to be picked many times in its different locations. I would like to omit the duplicated titles. This would save the warehouse staff lots of time. I tried using the ! function but it is not working for me. I'm sure there is a very simple way of listing each title only once and in the optimum location. Any suggestions?