+ Reply to Thread
Results 1 to 6 of 6

Formula to count unique strings broken down by month

Hybrid View

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to count unique strings broken down by month

    Hi AlKey

    Thank you for the prompt reply.

    It appeared to work perfectly on the example, however, when I tried it in the actual spreadsheet (with the ranges / references amended) I got some unexpected results.

    I have attached another example (v2) which mirrors my data and has your formula in place.

    As you can see the last three entries (Oct to Dec) are coming up with a fractional result. They are very close to the expected result and I have tried to trouble shoot it myself but it is approaching the end of my day and I don't think my brain can cope any more

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Count Unique Customer by Month
    By byankton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2013, 12:39 AM
  2. [SOLVED] Broken Count formula
    By Notters in forum Excel General
    Replies: 1
    Last Post: 08-21-2012, 09:06 AM
  3. Count unique for specific month
    By Bob@Sun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2011, 02:52 PM
  4. Count unique days within month
    By jirib in forum Excel General
    Replies: 7
    Last Post: 08-26-2010, 06:12 PM
  5. Count Unique Strings
    By stacy_jeanne@yahoo.com in forum Excel General
    Replies: 4
    Last Post: 04-27-2005, 03:06 PM

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