| 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 |
| 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 | |||
Threaded Mode
