In the formula, rng refers to your range C2:C294.

I have a column c2:c294 that contains Job names.

The formula *MUST* be entered as an array using the key combination of
CTRL,SHIFT,ENTER (not just ENTER).

Biff

"smonsmo" wrote in message
...
I entered c1 in each of the rng. Is that correct? If so, when I copy
down,
it only works on the first line. I assume I did something wrong. help

"T. Valko" wrote:

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not
just
ENTER):

=IF(ROWS($1:1)<=SUM((rng<"")/COUNTIF(rng,rng&"")),INDEX(rng,SMALL(IF(rng<"",IF (ROW(rng)-MIN(ROW(rng))+1=MATCH(rng,rng,0),ROW(rng)-MIN(ROW(rng))+1)),ROWS($1:1))),"")

Copy down until you get blanks

Biff

"smonsmo" wrote in message
...
I have a column c2:c294 that contains Job names. There may be identical
entries. I need to compile a list of all entries without duplicates or
blank
cells. This will need to be done automatically. Data sort or a macro
are
the obvious choices however in this case will not serve.
Any Ideas?
Thanks