View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Akash Maheshwari Akash Maheshwari is offline
external usenet poster
 
Posts: 31
Default Help Required - 11th Dec 2015

Hi Team,

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.

Same is the case with Email id, if I try to enter any duplicate mobile no in Column B then system should prompt that duplicate record found.

Pls suggest how can I do the same.

Awaiting for your response.

Best Regards

Akash Maheshwari