T
toadflax
Hi,
I am struggling with a dataset of 9699 rows and 29 columns in Excel
2003. I have already removed exact-duplicate records but now seem to
have some near-duplicates that differ only by the value in one column.
Specifically, they appear to be identical except that the duplicate
records have a blank in Column M rather than text. Is there any way to
easily delete records where the only difference between it and another
record is that one (or perhaps even more than one) of the fields is
blank? I'm only interested in retaining records with actual
differences in the text in each column, not those that only differ by
having some data missing. I've searched on several terms but haven't
come across anything that quite matches what I'm trying to do.
Thanks very much,
Michelle
I am struggling with a dataset of 9699 rows and 29 columns in Excel
2003. I have already removed exact-duplicate records but now seem to
have some near-duplicates that differ only by the value in one column.
Specifically, they appear to be identical except that the duplicate
records have a blank in Column M rather than text. Is there any way to
easily delete records where the only difference between it and another
record is that one (or perhaps even more than one) of the fields is
blank? I'm only interested in retaining records with actual
differences in the text in each column, not those that only differ by
having some data missing. I've searched on several terms but haven't
come across anything that quite matches what I'm trying to do.
Thanks very much,
Michelle