I did that, but it only does it that one time. If I change the original
list I have to run the filter again.

Is there a way to do this automatically or maybe another combination of
formulas that would do this?

Lila

"Buffgirl71" wrote in message
oups.com...
Data / Filter / Advanced Filter
Action: Copy to another location AND
Check the Unique Records only checkbox at the bottom left