Count unique values based in diff column

[timtimba]

Hi,

In one column I have Instrument Name (column B), In column A I have the parent company name.

I want to count how many times dealer occurs in the list ... depending on the same

So here I want to check CF Industries and count the corresponding Portfolio manager if CF is repeated in column B
subsidiary occuring elsewhere. example table below:

portfolio_manager</SPAN>	instrument_name</SPAN>
Cormac Weldon (Fund Manager)</SPAN>	CF INDUSTRIES HOLDINGS INC</SPAN>
	ANADARKO PETROLEUM CORP</SPAN>
Chris Kinder (Fund Manager),Simon Brazier (Fund Manager)</SPAN>	FIRST QUANTUM MINERALS LTD</SPAN>
Gabriel Heskin</SPAN>	AUD traded cash</SPAN>
	USD traded cash</SPAN>
Jonathan Crown (Fund Manager),Neil Robson,Steve Thornber (Fund Manager)</SPAN>	KANGWON LAND INC</SPAN>
Jonathan Crown (Fund Manager),Pauline Grange,Neil Robson,Steve Thornber (Fund Manager)</SPAN>	GREAT EAGLE HOLDINGS LTD</SPAN>
Matthew Rees</SPAN>	UKT 3 3/4 07/22/52</SPAN>
	UKT 5 03/07/25</SPAN>
	UKT 4 3/4 12/07/30</SPAN>
	UKT 6 12/07/28</SPAN>
Diane Sobin (Fund Manager),Cormac Weldon (Fund Manager)</SPAN>	JOHNSON CONTROLS INC</SPAN>
Lisa Lim</SPAN>	GS HOME SHOPPING INC</SPAN>
	HYUNDAI HOME SHOPPING NETWORK CORP</SPAN>
Paul Witchalls (Fund Manager)</SPAN>	USD traded cash</SPAN>
Sarah Williams (Fund Manager)</SPAN>	KEIHAN ELECTRIC RAILWAY CO</SPAN>
Stephen Moore (Fund Manager)</SPAN>	FRANKLIN RESOURCES INC</SPAN>
	EMERSON ELECTRIC CO</SPAN>
	FEDERATED INVESTORS INC-CL B</SPAN>
	SCHWAB (CHARLES) CORP</SPAN>
	MSC INDUSTRIAL DIRECT CO-A</SPAN>
	JANUS CAPITAL GROUP INC</SPAN>
	TD AMERITRADE HOLDING CORP</SPAN>
	F5 NETWORKS INC</SPAN>
	COMCAST CORP-CLASS A</SPAN>
	LAS VEGAS SANDS CORP</SPAN>
	PAYCHEX INC</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>