thank you Anne this is my answer!
--
Jackie


"Anne Troy" wrote:

Several methods, Jackie:
http://www.officearticles.com/excel/...ft_excel. htm
************
Anne Troy
www.OfficeArticles.com

"Jackie" wrote in message
...
I have 3 columns & about 40 rows of accounts (text). I would like to be
able
to find all the duplicate accounts and have them filtered out to a blank
column. Data sort does not work because of the volume of accounts &
number
of columns. I have tried advanced filter but it only copies the entire
cells
-- does not just give me the duplicate records. I really appreciate your
help with this!
--
Jackie