No, you can remove the duplicate ones, then you are left with the unique
ones and an move those wherever you want. In all other cases you would need
to use a filter

--


Regards,


Peo Sjoblom


"andy" wrote in message
...
Is there anyway to automatically remove unique entries on excel 07?