Hi Akash,

Am Thu, 10 Dec 2015 10:42:45 -0800 (PST) schrieb Akash Maheshwari:

I have two Columns. Column A is for Email ID & Column B is Mobile No.

What I want is if I try to enter any duplicate email id in Column A then system should prompt that duplicate record found.

select column A = Data = Data Validation = Custom =
=COUNTIF(A:A,A1)=1
And same action for column B.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional