Results 1 to 4 of 4

Counting Unique Values Across 2 Columns

Threaded View

mrfloopa Counting Unique Values Across... 06-12-2012, 02:23 PM
NBVC Re: Counting Unique Values... 06-12-2012, 02:30 PM
mrfloopa Re: Counting Unique Values... 06-12-2012, 02:35 PM
NBVC Re: Counting Unique Values... 06-12-2012, 02:38 PM
  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Local Cluster
    MS-Off Ver
    Excel 2010
    Posts
    5

    Counting Unique Values Across 2 Columns

    This seems simple enough, but I can't seem to find anything. I have two columns, C and D, with first and last names in each one respectively. I would like to count the unique values across both columns. I.e., how many different people there are. I figured out how to do one column, but due to the fact that some people have the same first name and different last names (or vice-versa), this is not particularly useful. What's the best way to do this?
    Last edited by mrfloopa; 06-12-2012 at 02:36 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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