Results 1 to 3 of 3

Counting Duplicate cells in multiple columns - pt2

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2003
    Posts
    5

    Counting Duplicate cells in multiple columns - pt2

    OK,

    I posted a question a couple of days ago and got some great help. But, now that I've looked a bit closer, I think I still need some guidance to get exactly what I need.

    I have a sheet with a list of various readers who have opened our last three e-newsletters. I'm trying to identify our highly avid readers (all 3) our avid readers (read 2/3) and our casual readers (read 1/3). I was able to get the proper count for the readers of all 3, but still am having trouble getting those who read only 2.The attached sheet shows what I was trying to do.

    The ? really arises in cell b9, which uses the formula previously suggested. However, the correct answer should be 1 instead of 2. Bob read 1&2 only while Fred read 1, 2 & 3.

    Any help would be greatly appreciated. We have over 25,000 records in each column and I'd hate to count manually
    Attached Files Attached Files

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