Sorry, yes I'm looking for Unique entries I was saying distinct as in
SQL "select distinct...". Here's a mock up of what I'm dealing with.
I dump data into a worksheet and then slice and dice it lots of
different ways, but I have static information such as
Apples
Oranges
Grapes
Melon
Apples
Grapes
Cherries
Apples
So I want to change this into:
Apples
Oranges
Grapes
Melon
Cherries
I quickly tried Bob's array formula and it seemed to work, though if
the data in column A was seen as a dupe column B was blank, leaving me
with gaps. I can probably clean this up by combining the info into
column C but i'll get to that. I'm just looking for other ways to
accomplish this. Also, if someone knows of an article please include
the link. I'm been searching for the article suggested by Evan but the
search functionality on the website leaves a little to be desired.
Thanks again.
--
summergs
------------------------------------------------------------------------
summergs's Profile:
http://www.excelforum.com/member.php...o&userid=37419
View this thread:
http://www.excelforum.com/showthread...hreadid=571901