| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique vaules
Hi,
I would like to add some kind of feature to my XLS file but have no idea how. I have an excel file where i put all e-mail addresses for newsletter. I gather more information then an email address but this feature is about that. All e-mails are row under row in column C. Every new person is added in the last row (after last person). Now, I would like the Excel to inform me (msgbox) when i input an e-mail address which is already in the document (the user registered himself twice). I was looking for the solution of my problem for a long time but there is absolutely nothing what google finds about it. I would like to have an "E-Mail already exists!" message box when duplicate email inputed. I hope someone knows what am i talking about and is able to help me. Thanks in advance. Best regards Byru |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique vaules
Byru,
In an adjacent column add the formula =IF(and(A1<"",COUNTIF($A$1:A1,A1)1),"Email already exists","") and copy down -- HTH RP (remove nothere from the email address if mailing direct) "byru" wrote in message ... Hi, I would like to add some kind of feature to my XLS file but have no idea how. I have an excel file where i put all e-mail addresses for newsletter. I gather more information then an email address but this feature is about that. All e-mails are row under row in column C. Every new person is added in the last row (after last person). Now, I would like the Excel to inform me (msgbox) when i input an e-mail address which is already in the document (the user registered himself twice). I was looking for the solution of my problem for a long time but there is absolutely nothing what google finds about it. I would like to have an "E-Mail already exists!" message box when duplicate email inputed. I hope someone knows what am i talking about and is able to help me. Thanks in advance. Best regards Byru |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique vaules
Or maybe use this
http://www.cpearson.com/excel/NoDupEntry.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... Byru, In an adjacent column add the formula =IF(and(A1<"",COUNTIF($A$1:A1,A1)1),"Email already exists","") and copy down -- HTH RP (remove nothere from the email address if mailing direct) "byru" wrote in message ... Hi, I would like to add some kind of feature to my XLS file but have no idea how. I have an excel file where i put all e-mail addresses for newsletter. I gather more information then an email address but this feature is about that. All e-mails are row under row in column C. Every new person is added in the last row (after last person). Now, I would like the Excel to inform me (msgbox) when i input an e-mail address which is already in the document (the user registered himself twice). I was looking for the solution of my problem for a long time but there is absolutely nothing what google finds about it. I would like to have an "E-Mail already exists!" message box when duplicate email inputed. I hope someone knows what am i talking about and is able to help me. Thanks in advance. Best regards Byru |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to add different vaules based on qauntity, is this possible? | Excel Worksheet Functions | |||
| find and add vaules | Excel Worksheet Functions | |||
| Sum first five vaules of changing range | Excel Discussion (Misc queries) | |||
| If no value in a1 how do I get a2 a3 a4 a5 a6 a7 a8 not to show their vaules | Excel Worksheet Functions | |||
| Truning 0 vaules red | Excel Worksheet Functions | |||
Linear Mode
