Results 1 to 34 of 34

Count Unique Values based on 2 columns

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Smile Count Unique Values based on 2 columns

    Hello Again,

    I am trying to count the unique values based in 2 column.

    Search within this list and get the result above format

    ColumnB2 Column D2
    Class Relation
    B CHILD
    VIP Employee
    B CHILD
    C CHILD
    B CHILD
    B CHILD
    A Spouse
    A Spouse
    A Spouse
    A CHILD
    B CHILD
    C Employee
    C Employee
    C Employee

    Get Result below

    ColumnL2 ColumnM2 ColumnN2 ColumnO2
    CLASS EMPLOYEE SPOUSE CHILD
    VIP 1 o
    A 0 3 1
    B 0 0 5
    C 3 0 1

    Can anyone help me to solve this issue please
    Last edited by hecgroups; 02-12-2012 at 11:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1