I would like to avoid a very boring thing.

[Francesco]

Hi to all,
I working on a BIG excel file that is a list of 1000
companies. Sometimes the companies are repeated because
they produce different kind of stuff.

My boss want me to remove all the repetition, one by one,
and leave just one entry for company.

Well I hope there is some kind of operation I can do to
automatize this process, to remove repeated companies, but
I dunno what can be.

Thanx you very much.
Francesco.

 

[Andy Brown]

Check out Data -- Filter -- Advanced Filter (unique records only).

Rgds,
Andy

 

[Frank Kabel]

Hi
you may also take a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[Guest]

I am sure someone has already said this but not sure. Sort
your spreadsheet by the company names. That will group
them together and you can delete the duplicates without
any problem.