Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new entry to list
I have a list of customers, and what i want is a macro to check the current
entry against the list. If the entry is not found in the list, i need it to be added to the bottom. If it is found in the list, just ignore it. Thanks! Jeremy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new entry to list
It may be easier to import both spreadsheets into Access and use its
find unmatched wizard query builder. Another option (there are probably better ones), would be to copy all of the list over to one excel spreadsheet, then type in the following formula which will check for any duplicate entries. =if(countif($a$1:a1,a1)1,"Duplicate,"Unique") This assumes that the unique customer ID is in column A. Once you know which are duplicate, you will want to copy these values (not the formulas) over to the next column so you can sort the list alaphbetically so all your duplicate ones are grouped and all the unique ones will be grouped. Now that you have all the unique ones, you know these are the ones to keep. As I mentioned, I am a beginner so there are probably better options, but I think this would work. -Andrew V. Romero |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new entry to list
I don't know what is going on, but I answered this question early this
morning and the post hasn't arrived. Maybe my work has blocked newsgroups...anyway...my idea is sort of a work around for your problem. I am still new at complex formulas, so there maybe another way to do this, but I would... -Copy both list into one worksheet. -Use the following formula to determine if the entry is a unique or duplicate =if(countif($a$1:a1,a1)1,"Duplicate","Unique") Convert or copy the formula values (not the formula- edit paste special) over to another column, then sort by that column. All the Unique entries will be at the bottom, thus you now have a list of only unique entries. -Andrew V. Romero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
drop down list shows first blank row after last list entry | Excel Discussion (Misc queries) | |||
How Do I Get A ComboBox To Add Entry To It's List If Not In List | Excel Programming | |||
new entry in list | Excel Programming |