I just uploaded an extract of the file but I didn't put an ID number with it, did you get it?
Hi again, the file id is 236778. In this extract I have removed the columns which show name, address etc and I have just sent you the two columns which contain the fields that I want to interrogate. Thanks
Your selected ranges of cells will now be highlighted for duplicate data!
Here is the revised Excel file with conditional formatting applied:
http://wikisend.com/download/687434/Extract Same Cell Ph over 14 A_rev1.xlsx
I hope this helped.
Please remember to rate my service positively (3-5 stars/faces) once you have all the information you need. Tips are always highly appreciated! If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess