| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help Required - 11th Dec 2015
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help Required - 11th Dec 2015
On Friday, December 11, 2015 at 12:17:45 AM UTC+5:30, Claus Busch wrote:
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 Thanks Mr. Clause... Thanks for your help... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help Required - 11th Dec 2015
Hi Akash,
Am Thu, 10 Dec 2015 12:06:30 -0800 (PST) schrieb Akash Maheshwari: Thanks Mr. Clause... Thanks for your help... you are welcome Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Required 9th Dec 2015 | Excel Discussion (Misc queries) | |||
| VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) | Excel Programming | |||
| Comment in every 11th row | Excel Discussion (Misc queries) | |||
| Insert blank row after every 11th row. | Excel Programming | |||
| macro stops copying sheets into a book after the 11th sheet | Excel Programming | |||
Linear Mode
