array

[Guest]

I have this formula
=IF(ROWS($2:2)<=SUM((W$2:W$67<>"")/COUNTIF(W$2:W$67,W$2:W$67&"")),INDEX(W$2:W$67,SMALL(IF(W$2:W$67<>"",IF(ROW(W$2:W$67)-MIN(ROW(W$2:W$67))+1=MATCH(W$2:W$67,W$2:W$67,0),ROW(W$2:W$67)-MIN(ROW(W$2:W$67))+1)),ROWS($2:2))),"")
It works great in sorting some of my data and removing any duplicate entries.
I would like to use it in another project this time without removing the
duplicates.
I don't have the experience to spot which part of the formula is removing
the duplicates.
Thanks for the guidance.
Steve

 

[Bob Phillips]

How about

=W2

and copy down?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)