company names
 

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

company names
 

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

company names
 

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,R OWS($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
---
" VLOOKUP fORMULA" wrote:
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.

company names
 

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