Results 1 to 10 of 10

Unique Records in a Column with a twist

Threaded View

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    19

    Talking Unique Records in a Column with a twist

    Hi All,

    I would like to place a formula in cells A2 down that does a running count of unique combinations of columns B and C.
    For example, the first record is a white dog, so at that point there is 1 category of dog, next is a brown dog, so there there is now 2 categories etc.

    I initially tried to adapt an array formula 1/COUNTIF($B$2:$B8,$B$2:$B8) but this wont quite do the trick.

    Please see file attached.
    Any ideas from anyone would be most appreciated.

    Thanks

    Ciaran Mc
    Attached Files Attached Files

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