+ Reply to Thread
Results 1 to 4 of 4

Finding Unique Count for a Concatenated Range of Columns.

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,179

    Finding Unique Count for a Concatenated Range of Columns.

    Dear Forum,

    I am trying to find the Unique Count for 2 Column Ranges .
    Col A ---- Col B
    153 ------Mr A
    153 ------Mr A
    153 ------Mr A
    153 ------Mr B

    Sam------Wild
    Sam------Wild
    Sam------Hanks

    So I need to get the answer 2 as the Value 153 is combined with just 2 different Names Mr A and Mr B..
    Similarly, the First Name Sam just has 2 Differen Last Names 1. Wild and 2. Hanks.

    P.S. WOuld prefer a NOn-Helper Column Approach...

    Warm Regards
    e4excel
    Last edited by e4excel; 01-12-2012 at 06:31 AM.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,199

    Re: Finding Unique Count for a Concatenated Range of Columns.

    with CTRL+SHIFT+ENTER, rather than just ENTER.

    Please Login or Register  to view this content.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,179

    Re: Finding Unique Count for a Concatenated Range of Columns.

    Dear Haseeb,

    Thanks once again for helping me out but the answers I am getting are 4 for the First Example whereas the answer I am expecting is 2..
    My Apologies the columns should have been C and D..

    Please Login or Register  to view this content.
    Actually I want to check the no of times for each 153 with different names so in the example from the first post it will be just twice as 153 is mentioned 3 times with MR A and just 1 time with Mr B.

    So, unique answer I need is 2..

    Hope this is not so tough...!

    Warm Regards
    e4excel

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,179

    Re: Finding Unique Count for a Concatenated Range of Columns.

    I think i found it myself as previously I had received help from DonkeyOte so just modified and got it working...!

    with a small Line in the SUMPRODUCT
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    The PlotNoRng = C2:C8 AND PurcNameRng = D2:D8

    So this works good to see this working without the use of any helper columns..

    Warm Regards
    e4excel

+ Reply to Thread

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