company names

[RE: VLOOKUP fORMULA]

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

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/Duplicates.aspx

 

[Max]

One formulas play which gets you there
In G2: =IF(B2="","",IF(COUNTIF(B$2:B2,B2)>1,"",ROW()))
In H2: =IF(ROWS($1:1)>COUNT(G:G),"",INDEX(B:B,SMALL(G:G,ROWS($1:1))))
Copy G2:H2 down to cover the max expected extent of data in col B, say down
to H100? Minimize/hide col G. Col H will return the required uniques listing
of the companies in col B, with all results neatly packed at the top.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[Max]

Source data is assumed running in B2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---