formula for unique values

[bridgeb3]

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?

 

[Glenn]

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?

Add a column H that counts the number of times the location in that row appears.
Assuming your data is in rows 2:1000, enter the following in H2 and fill down
to H1000:

=COUNTIF($G$2:$G$1000,"="&G2)

Then use and AutoFilter on that column to select only rows with a value of 1.

 

[bridgeb3]

Add a column H that counts the number of times the location in that row appears.
  Assuming your data is in rows 2:1000, enter the following in H2 and fill down
to H1000:

=COUNTIF($G$2:$G$1000,"="&G2)

Then use and AutoFilter on that column to select only rows with a value of 1.

That worked! As easy as that is, I would have never thought about
doing it that way. Thanks a lot for your help!