Double entries

[Vass]

I have just imported a datebase inot Excel and I have every line repeated

How can I make Excel delete every other row so I only have one line of data
and no repeats ?

thanks

 

[Jan Karel Pieterse]

Hi Vass,

How can I make Excel delete every other row so I only have one line of data
and no repeats ?

Data, filter, advanced filter, check "Unique records only" and "COpy to
another location". Then OK and remove the original table when you're happy
with the new one.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Vass]

Hi Vass,


Data, filter, advanced filter, check "Unique records only" and "COpy to
another location". Then OK and remove the original table when you're happy
with the new one.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Excellent, it did exactly what it said on the tin !

Many thanks

Vass