I actually had already found the glitch with rows B and C, and changed it in
the formula you gave me. I still seem to be having the problem I discribed in
my previous message, however. I'm not sure what I'm doing wrong, but It only
puts "keep" or "delete" on every other row consistently down the spreadsheet.
About 40 rows down it merges two different employees and after that it misses
several mailing addresses in a row. Also, when I try to sort on column H, it
gives me the error, "This operation requires the merged cells to be
identically sized."

Any thoughts?

"Bob Tarburton" wrote:

Sorry, all the references to column B should have been to column C.
I didn't mean to look at the name at all, just the ID, and the Home/Mail
column.
Had it set up wrong in my sheet when I was checking the formula.
It shouldn't matter how many entries for each person or what order they
start in, as long as the ID# is consistent and column C has "Home" or "Mail"

=IF(ISNA(MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000 ="Mail"),0),0)),IF(ROW(A2)-1=MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000="Home" ),0),0),"Keep","Duplicate"),IF(ROW(A2)-1=MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000="Mail" ),0),0),"Keep","Duplicate"))

If there's a problem I'll get back tomorrow.