Ask Experts Questions for FREE Help !
Ask
    Burdugoy's Avatar
    Burdugoy Posts: 1, Reputation: 1
    New Member
    		  
    #1

    May 30, 2009, 04:31 AM
    How to count unique values in specific names
    Hi guys,

    Anyone can help me what is the formula in excel MS office 2007
    Of counting the unique numbers in one column A against column B
    Example:

    Column A (Cheque Numbers) Column B

    1234 Charice
    1235 Charice
    1235 Charice
    1233 Isabel
    1236 Isabel
    1236 Isabel

    How many cheques received by Isabel and Charice
    Please help.
    Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jun 4, 2009, 01:17 AM

    Like this:

    =SUMPRODUCT(--($B$1:$B$10="Charice"),--($A$1:$A$10<>"")/COUNTIF($A$1:$A$10,$A$1:$A$10&""))
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Unique pet names for a kitten [ 27 Answers ]

Hi I'm new. I was looking for pet names when I found this site. I was wondering if anyone had any or could come up with any ideas on pet names for a cat, with ice cream being the topic, that are unique, that you wouldn't mind me considering for my new kitten. She is calico with short hair. I've...

Trying to extract unique values from 2 spreadsheets [ 2 Answers ]

Hello, I have 2 lists of names/addresses. I have a master list of about 35,000(list1) and another list of about 16,000(list2) that was compiled from names of list1. All I am trying to do is subtract list2 from list1 so that I end up with the 19,000 names that are unique to list1 but not on list...

Filter from 2 Columns (Unique values) in Excel [ 1 Answers ]

I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143

How to find unique values in an entire column [ 10 Answers ]

hi all please tell me how can I findout the unique values in an entire coloumn. for example I have 3 coloumn in an sheet. Name Prod. Value a 24 100 b 26 240 a 33 120 a 21 200

View more questions Search