We provide loan in 5 Sector. At present we have 150 clients (day by day the number is increasing) but each client have multiple account with us.
We want to count sector wise number of client (not account) by using formula (not Pivot Table).
* Each client has unique identification number
* MS- Off Ver: Excel 2007
Regards,
Arif
Bookmarks