I have a spreadsheet with locations from a warehouse. We have 2 deep
racks for each location, so multiple pallet id's can fit in those
racks. I would like to have a formula that will show me the locations
that only appear once so I can tell which locations have an empty
slot.

My spreadsheet has cust code, item, prod date, lot, pallet id, cases,
location in columns A-G. I want to run a formula that will list A-G
of only the rows that have a unique G (location code appearing
once).

Is this possible?