compile list
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
|