Reply to thread

Message: [QUOTE="John McGhie, post: 6817213"] Yes. See here: [URL]http://www.mrexcel.com/articles/duplicates-with-conditional-formatting.php[/URL] (Read it all, carefully...) You will need to add a further formula to copy the data you find to somewhere else. Cheers -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:john@mcghie.name [/QUOTE]