Re: Sort and remove duplicates

In article <1190991653.009964.230380@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
JimJx <webmaster@xxxxxxxxxxxxxxxx> wrote:

: On Sep 28, 10:33 am, gba...@xxxxxxxxxx (Greg Bacon) wrote:
:
: > Why does the Green row get 1,2,3,4,5 on the output?
:
: Because Green would be a dup and 1,2,3,4,5 comes before 2,2,3,4,5

Ah. I thought you wanted to remove duplicates in the other columns
too. (The five 2s threw me off.)

Glenn Jackman's answer is what you want.

Greg
--
To admit that labor needs protection is to acknowledge its inferiority.
-- Henry George, Protection or Free Trade
.