How to delete duplicate record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lillian Lian - 07 Dec 2007 21:54 GMT

I have one excel spread sheet has sheet1 and sheet2, after I combined
together it has a lots of duplicate record, I hight light the data--> advance
filter--> check unique record only, on the left site of ColumnA, is show
random number like
1
3
5
7
8
9
with total of 866 rows, but actually only 530 rows, how can I reumber on the
left site of ColumnA

Thanks.

Lillian

Reply to this Message

JLGWhiz - 07 Dec 2007 23:19 GMT

You are still in filter mode. Select the 530 items and copy to the
clipboard. Then get out of filter mode and your row numbers will come back.
Then you can paste the 530 items where you want them. Or in the advanced
filter mode you can specify where you want them copied to, all in one fell
swoop.

> I have one excel spread sheet has sheet1 and sheet2, after I combined
> together it has a lots of duplicate record, I hight light the data--> advance
[quoted text clipped - 12 lines]
>
> Lillian

Reply to this Message

Lillian Lian - 08 Dec 2007 00:03 GMT

Thank for the help, it works fine

> You are still in filter mode. Select the 530 items and copy to the
> clipboard. Then get out of filter mode and your row numbers will come back.
[quoted text clipped - 18 lines]
> >
> > Lillian

Reply to this Message