Double entries

V

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
 
J

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 ?
Click to expand...

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
 
V

Vass

Jan Karel Pieterse said:
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
Click to expand...

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

Many thanks

Vass
 
Top