delete duplicate cell

**yoanilman** · 09-02-2010, 10:50 AM

Hello Excel Gurus,
I've requirement to change the following data

Location_id Country Name phone
125 US JAY COSTA 4526558258
125 CA LAY CHIN 6525698255
125 NS GEORGE CHA 6289558965
462 CN FRANC BUTA 4895858546
462 BO ASHLY JHANG 1564557153
751 MX EMANUEL BONILLA 6529580320
751 NM JOSE NIKE 3205988221
751 NZ ANDREW GORENA 3986476050
751 BA MALLISA PORTILLO 6920571693

to this format:

Location_id Country Name phone
125 US JAY COSTA 4526558258
CA LAY CHIN 6525698255
NS GEORGE CHA 6289558965
462 CN FRANC BUTA 4895858546
BO ASHLY JHANG 1564557153
751 MX EMANUEL BONILLA 6529580320
NM JOSE NIKE 3205988221
NZ ANDREW GORENA 3986476050
BA MALLISA PORTILLO 6920571693

Basically I'm trying tp remove only dup from location_id and rest should stay as is.

Thanks,

**ChemistB** · 09-02-2010, 10:59 AM

Assuming your data is sorted as you've shown; In column D, E or F, starting in D2 (for example)
=IF(A2=A1,"",A2) dragged all the way down.
Then copy and paste special values into column A.
Does that work for you?

**yoanilman** · 09-02-2010, 11:17 AM

Thanks for the quick response, but there is little complexity. The data that I put here is just a sample there is 99% possibility that it won't be sorted. Also the actual data size is about 300-600k rows. these data basically come from Sybase db and get saved in excel csv format.