I send out mailers for my company to customers from a bunch of different spreed sheets that are emailed to me. I seperate them by the date of their wedding in order to send out our information in a timly manner. To avoid duplicates I use an If, then statement.
Example:
(in b2) If (b4=c4, 1, 0) (to check for same last name)
(in c2) If (b5=c5, 1, 0) (to check if first name is the same)
(in d2) if (b2+c2=2, M, 0) (to check if first name and last name match then it puts a C which I change to wingdings font)
If D2 has an M in it I delete that customers information.
yes it's more than I need to do but hey, I get paid by the hour.
You can email me if you need anymore help with this.
Answers & Comments
Verified answer
I send out mailers for my company to customers from a bunch of different spreed sheets that are emailed to me. I seperate them by the date of their wedding in order to send out our information in a timly manner. To avoid duplicates I use an If, then statement.
Example:
(in b2) If (b4=c4, 1, 0) (to check for same last name)
(in c2) If (b5=c5, 1, 0) (to check if first name is the same)
(in d2) if (b2+c2=2, M, 0) (to check if first name and last name match then it puts a C which I change to wingdings font)
If D2 has an M in it I delete that customers information.
yes it's more than I need to do but hey, I get paid by the hour.
You can email me if you need anymore help with this.
Well, you just select the cells and delete them.
If you've got duplicated records then you really should be using a RDBMS. ie Access. Not a spreadsheet software.
Ant...