C
chris4ua
I have a database of 126,000 voters in my county. I have them sorted b
street & address & precinct. I am looking to minimize the voter list t
a household list. Statistically I should be looking at 40,00
households. I have been working with an IF formul
(if(countif($I$1:I1,I1)>1,1,""). "I" is the column for the address.
use this formula twice. Once for the addresses and once for the stree
#'s. My idea is that after I run these two formulas in two seperat
columns that it will return a 1 in both columns when there is
duplicate. This works sporadically. It appears to work great and the
I start finding places where both original and duplicat
addresses/street #'s are taken out. I have also tried to use th
Advance Filter (unique records) option. It is not working for m
either. I am not versed on using Visual Basics. Can anyone help?
Thanks in advance. Here is a sample of the rows:
Id last name first name street address
63444 wells john 3286 samford avenue
63442 smith sarah 3286 samford avenue
11339 baylor eve 1422 stone ridge roa
street & address & precinct. I am looking to minimize the voter list t
a household list. Statistically I should be looking at 40,00
households. I have been working with an IF formul
(if(countif($I$1:I1,I1)>1,1,""). "I" is the column for the address.
use this formula twice. Once for the addresses and once for the stree
#'s. My idea is that after I run these two formulas in two seperat
columns that it will return a 1 in both columns when there is
duplicate. This works sporadically. It appears to work great and the
I start finding places where both original and duplicat
addresses/street #'s are taken out. I have also tried to use th
Advance Filter (unique records) option. It is not working for m
either. I am not versed on using Visual Basics. Can anyone help?
Thanks in advance. Here is a sample of the rows:
Id last name first name street address
63444 wells john 3286 samford avenue
63442 smith sarah 3286 samford avenue
11339 baylor eve 1422 stone ridge roa