array
 

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,SMAL L(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),RO W(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

array
 

How about

=W2

and copy down?

--
---
HTH

Bob

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



"smonsmo" wrote in message
...
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,SMAL L(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),RO W(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