I have a listbox that looks like as follows
With the first letter of each line being the Aisle in a warehouse the number being the location, the second to last letter being the height location, and the last being the front of the location or the rear. I've been able to compare a complete list of all locations to a complete list of currently scanned locations to create a list of all empty pallet locations in the warehouse. WIth some aisles only being able to contain 1 pallet deep and some being to to handle 2. As you can notice with the above some have a single spot open and some have both the front and the rear. I want to find the duplicates then compare the end letter to see if its a true duplicate then output both of those lines so I know the location is truly empty for both the front and the rear. Locations with 1 pallet spot open mean nothing to me.