formula for unique values

  • Thread starter Thread starter bridgeb3
  • Start date Start date
B

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?
 
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?
Click to expand...

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.
 
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.
Click to expand...

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