Dave: Question about duplicate data in new worksheet
Posted by A.R. on May 15, 2001 12:00 PM
Regarding message you posted at 17341.html, data is in A:O where Company names are in Column C. The other columns include ID#, address, Zip code, Contact, etc. I do have a sheet called Duplicates. I tried the code you gave me but it did not work.
Posted by Dave Hawley on May 15, 2001 3:27 PM
Did you modify it to suit your data ? I have tried it a few times now and it works. For 18000 rows it will take some time to run though. If your data is sorted by Company name (Column A) and you could use replace the formula part of the code with this:
"=IF(COUNTIF(RC[-3]:R[18]C[-3],RC[-3])>1,1,""no"")"
This would help speed things up
Dave
OzGrid Business Applications
