Count unique names in list

[Closed]

Report

Irish - Feb 10, 2012 at 01:58 PM

Hello,

I need to know how to count the number of unique names in a list based off of mulitple conditions. So, i have a sheet of data with mulitple columns(please note that i cannot delete columns or rows, must use data as is in order to allow other formulas to continue working). Lets say:

ColumnA Column B
Market Client
CHS Larry
CHS Bob
CHS Larry
AUG Hillary
AUG Hillary
SAV Bart
SAV Bart
SAV Pat

So i need a formula that will tell me how many unique names are in Column B for a specified market. For example, i need to know that there are 2 unique names in CHS. Every market will have it's own formula.

Count unique names in list
Excel count names in list - How-To - Excel
How to count your best friends list on snapchat - How-To - Instant Messaging
Skype - Hide the users count from the contact list - How-To - Skype
Excel formula needed to count a list of names ✓ - Forum - Excel
Creating multiple workbooks from a template and a list of names ✓ - Forum - Excel

Count unique names in list

Your reply

Subscribe To Our Newsletter!