You can do this easily with the advanced filter. See this:

http://contextures.com/xladvfilter01.html#FilterUR

Note that if you want the results to appear on a different sheet start the
process from that sheet.

--
Biff
Microsoft Excel MVP


"Dubbo" wrote in message
...
Hi -
The following is data I grab from my business system to tell me that I
have
parts in a location that still need to be counted in stock take - I spit a
report that lists every location of every part - however I only want to
see a
list of the individual locations yet to be counted
Using the following data (but a much longer list)

A
1 09B02
2 09B04
3 07C06
4 03G09
5 09B02
6 03D02
7 09B02
8 07C06
9 09B02

I am trying to summarise (say on "Sheet 2") all the different locations
that
need to be counted - so like this

09B02 (shown only once even though it appears 3 other times)
09B04
07C06 (shown only once even though shown 1 other time)
03G09
03D02