|
Re: Distinct list formula
Bob's formula works just fine for me. The only time it leaves a blank is if
all the uniques have been extracted (these blanks are at the end of the
range by design) OR....if there is/are empty cells within the original list.
Biff
"summergs" <summergs.2clne6_1155675609.0946@excelforum-nospam.com> wrote in
message news:summergs.2clne6_1155675609.0946@excelforum-nospam.com...
>
> 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
>
|