Deleting duplicates

[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

 

[Bernard Liengme]

Chip has lots on duplicates at
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[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.

 

[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?

 

[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