Deleting duplicates

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 r filled with data. There are two colums in each row that are unique to each row, property number and road name (in colums e and f).

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

How do I do it? Thanks for the help

Chip has lots on duplicates at
http://www.cpearson.com/excel/duplic...tingDuplicates
--------------------------------------------------------------------------------

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"katana" <[email protected]> wrote in
message news:[email protected]...
>
> 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 r
> filled with data. There are two colums in each row that are unique to
> each row, property number and road name (in colums e and f).
>
> I can sort the database so the duplications hide and all the data
> appears only once but I would like them both to disappear so it leaves
> the only the unduplicated data.
>
> How do I do it? Thanks for the help
>
>
> --
> katana
> ------------------------------------------------------------------------
> katana's Profile:
> http://www.excelforum.com/member.php...o&userid=31271
> View this thread: http://www.excelforum.com/showthread...hreadid=509436
>

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.

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"katana" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> katana
> ------------------------------------------------------------------------
> katana's Profile:
> http://www.excelforum.com/member.php...o&userid=31271
> View this thread: http://www.excelforum.com/showthread...hreadid=509436
>

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