Hi,
In column B enter
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

and in column C to remove the blank spaces

=IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<"",ROW(BlanksRange),ROW()+ROWS(Bl anksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))



"wx4usa" wrote:

I have a range of 1000 cells..A1:1000. This range holds the favorite
restaurant list as provided by our customers. So, in each cell is a
restaurant name. There are approximately 50+/- unique restaurant names
in these 1000 cells. Many are obviously repeated since different
customers say the rest is their favorite too.

How do I extract this list of the 50+/- unique restaurants mentioned
in the range of 1000 cells? and place these unique names in B1:50?

I need the unique list so that I can then count the number of
occurrences of each unique name and then rank them.