removing DUPLICATES

[wacks]

i merge two EXCEL database...

Example

Name Address
John Paul 111 Beverly Hills Blvd
Paul Simon 111 Beverly Hills Blvd
Pepe Smith 222 Main Street.

* i just want to appear ONE (1) Address, either john paul or paul simon will show

how can i remove DUPLICATES on my database?

1. should i remove it on Excel first?
2. or can i use Crystal Reports to remove duplicates? how? is there a FORMULA for crystal? coz i haven't tried this yet... thnx




im quite in a rush and i need you response .. thanks a lot

 

[Naith]

There's more than one way to do this.

You don't seem to care whether you get Paul or John, so I will suggest something like the following.

You can group by address, suppress your group header and details, place all your fields in the group footer.

Naith

 

[Ngolem]

either that or put a conditional suppress on the Address

not PreviousIsNull({table.address}) and {table.address} = previous({table.address})

this will leave one address and the people that are there

Jim Broadbent

 

[synapsevampire]

I would suggest that you get some form of address standardization software to help out with this in the future.

The problem with the approaches offered here is that they check only the address, which means that these would be considered the same:

Ima Nothim
1 Main St.
NYC, NY

Uri Shorenot
1 Main St.
San Francisco, CA

Create a formula to group on which contains the address, city and zip.

-k