Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare cells in a column for duplicates
As I enter in company names into column B in my worksheet I would like a
macro to automaticlly check to see if I have a duplicate name already entered and if so show it in a pop-up windows as an error. Now I thought a Loop If statement would work however if memory serves me correct I would have to enter all the names in my statement. Any assistance would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare cells in a column for duplicates
I think macro is good option but you can achieve something simiar with
conditional formatting. Essentially, the conditional formatting will highlight the entered name, if it has been already entered. Select the range where you will be entering the data goto Format--Conditional Formatting From the drop down select 'Formula Is' Enter the formula as =IF(COUNTIF($A$1:$A$20,A5)1,1,0) Set the color pattern Here you can change the range from A1:A20 to your actual range. HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Mekinnik" wrote: As I enter in company names into column B in my worksheet I would like a macro to automaticlly check to see if I have a duplicate name already entered and if so show it in a pop-up windows as an error. Now I thought a Loop If statement would work however if memory serves me correct I would have to enter all the names in my statement. Any assistance would be appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare cells in a column for duplicates
Take a look at this page:
http://www.cpearson.com/Excel/Duplicates.aspx and this page http://www.cpearson.com/excel/NoDupEntry.aspx -- Regards, Tom Ogilvy "Mekinnik" wrote: As I enter in company names into column B in my worksheet I would like a macro to automaticlly check to see if I have a duplicate name already entered and if so show it in a pop-up windows as an error. Now I thought a Loop If statement would work however if memory serves me correct I would have to enter all the names in my statement. Any assistance would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
Counting Cells in a column depending on another column but excluding duplicates | Excel Discussion (Misc queries) | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions |