see:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200842


" VLOOKUP fORMULA" wrote:

Dear All, any body help me please

I have two columns

A-Name of Employee B-Name of Company

On column B some company names are repeating several times.

Is there any way to show only the company names in Column H without repeating.
Just want to know how many company people at present working over here.

Thanks