deleting the repeating content

[Guest]

hi, I have some name like this

To
Jimm
Jimm
And
And

How to delete to repeating name, turning them into

To
Jimm
And

Thanks.

 

[Alan]

Try Advanced Filter, there is a good tutorial here
http://contextures.com/xladvfilter01.html
Regards,

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

 

[CLR]

It's a little clumbersome, but you can sort your column A go group all the
duplicates together, then use a helper column with a formula in B2 like
=if(A2=A1,1,0)........and copy down, and then sort on column B and this puts
all the duplcates together and they can be deleted as a block..........if
you have to do it frequently, a macro is the way to go.

Vaya con Dios,
Chuck, CABGx3