Deleting duplicates

K

katana

Was wondering if anyone could help or if this was possible in excel

I have a spreadsheet that is a property database with colums a to
filled with data. There are two colums in each row that are unique t
each row, property number and road name (in colums e and f).

I can sort the database so the duplications hide and all the dat
appears only once but I would like them both to disappear so it leave
the only the unduplicated data.

How do I do it? Thanks for the hel
 
K

katana

Thanks but I'm having trouble as the list has the two unique identifiers
of address and number of property that I'm having the problems.
 
B

Bernard Liengme

In G1 enter =E1&G1 (adjust if database begins in some other row)
In H1 enter =COUNTIF($G$1:G1,G1)
G1:H1 down the columns to end of database
H1 will have numbers 1 for unique entries and for the first entries of
duplicates
Select all of H; Copy then Edit|Paste Special -Values
Sort by H (you could delete G now)
Any help?
 
V

vezerid

katana,

your post is confusing. What is unique, each column separately or their
combination? Which duplicates is it you cannot tolerate? Duplicate
property numbers? Or duplicate property/road combo?

At any rate, consider the technique of an auxiliary column with the
formula

=E2&F2

copied down. Then maybe you can apply the techniques found at Chip's
site adapted to the new setup.

HTH
Kostis Vezerides
 
Top