Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to count unique values in specific names (https://www.askmehelpdesk.com/showthread.php?t=359440)

  • May 30, 2009, 04:31 AM
    Burdugoy
    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
  • Jun 4, 2009, 01:17 AM
    JBeaucaire

    Like this:

    =SUMPRODUCT(--($B$1:$B$10="Charice"),--($A$1:$A$10<>"")/COUNTIF($A$1:$A$10,$A$1:$A$10&""))

    • All times are GMT -7. The time now is 09:34 AM.