finding & filtering out duplicate cells
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
|