How to get no of meeting Based on Client name and unique Meeting Id

[Anonymous]

Hii..

my source like below ..

Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1305486H	1/12/2017	Analyst Marketing Day	GRP	AXA Inv Mgrs - Europe	European Shares
Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1307755H	2/15/2017	Field Trip	GRP	Amansa Capital	Asian Shares
1320065H	3/16/2017	Analyst Marketing Day	1X1	T Rowe Price - Investment Advisor	Latin American Shares
1310503H	3/2/2017	Non Deal Management	GRP	Bank J Safra Sarasin	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	Lombard Odier Darier Hentsch & Cie - Private Bank	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	BDK Capital SAS	PanEuro Shares

      How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

Thanks