Results 1 to 30 of 30

Countif function goes crazy

Threaded View

ANS Countif function goes crazy 07-31-2013, 10:13 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 10:20 AM
Norie Re: Countif function goes... 07-31-2013, 10:21 AM
ANS Re: Countif function goes... 07-31-2013, 10:35 AM
GeneralDisarray Re: Countif function goes... 07-31-2013, 10:22 AM
daddylonglegs Re: Countif function goes... 07-31-2013, 10:24 AM
ANS Re: Countif function goes... 07-31-2013, 10:33 AM
Norie Re: Countif function goes... 07-31-2013, 10:38 AM
ANS Re: Countif function goes... 07-31-2013, 10:53 AM
daddylonglegs Re: Countif function goes... 07-31-2013, 10:46 AM
ANS Re: Countif function goes... 07-31-2013, 11:06 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 11:09 AM
ANS Re: Countif function goes... 07-31-2013, 11:22 AM
ANS Re: Countif function goes... 08-01-2013, 03:01 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 10:57 AM
ANS Re: Countif function goes... 07-31-2013, 11:03 AM
ANS Re: Countif function goes... 07-31-2013, 11:07 AM
Norie Re: Countif function goes... 07-31-2013, 11:06 AM
ANS Re: Countif function goes... 07-31-2013, 11:11 AM
GeneralDisarray Re: Countif function goes... 07-31-2013, 11:18 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 11:27 AM
ANS Re: Countif function goes... 07-31-2013, 11:35 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 11:34 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 11:45 AM
ANS Re: Countif function goes... 07-31-2013, 11:47 AM
Jonmo1 Re: Countif function goes... 07-31-2013, 11:56 AM
Norie Re: Countif function goes... 07-31-2013, 11:52 AM
ANS Re: Countif function goes... 08-01-2013, 02:34 AM
daddylonglegs Re: Countif function goes... 08-01-2013, 07:23 AM
ANS Re: Countif function goes... 08-04-2013, 04:55 AM
  1. #1
    Registered User
    Join Date
    09-30-2012
    Location
    Tel-Aviv
    MS-Off Ver
    Excel 2010
    Posts
    84

    Countif function goes crazy

    Hi all,
    I have a set of about 30K records (and a strong enough machine to handle processing data). Some of the records are duplicates, so in order to clean up and understand the data better, here is what I did in order to get a frequency table of the duplicates:

    1. Copied the data to a new sheet, performed "remove duplicates".
    2. In column B, next to each value in this short list, I ran a countif function, with =countif(range in the original sheet,value in the short list).
    I remembered to ctrl+shift+enter and dragged the formula to all values.

    However, the sum of column B is GREATER than the number of records in the original file......... I don't understand how that could be!
    Another strange thing is that everytime I run it, one value (couldn't find any pattern as to which value), gets an absurdly high count, such as 3170.
    (However, even with excluding this high number, the total count still doesn't match).

    Anyone had any similar experiences?
    Can you suggest what happened?

    Thanks a lot

    << going to resume banging my head against a wall >>

    P.S. I tried converting all the values to text, but got the same results.
    Last edited by ANS; 07-31-2013 at 10:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple IF function (driving me CRAZY)
    By johnstonJr in forum Excel General
    Replies: 9
    Last Post: 07-10-2012, 05:56 PM
  2. Replies: 9
    Last Post: 07-02-2012, 07:02 PM
  3. Using Countif Function with the Month & Year Function
    By laya1024 in forum Excel General
    Replies: 3
    Last Post: 02-03-2009, 07:52 PM
  4. [SOLVED] You're Crazy
    By Lewis Clark in forum Excel General
    Replies: 2
    Last Post: 07-27-2006, 10:20 PM
  5. Embed a countif function in subtotal function?
    By Stuck at work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 11:20 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