+ Reply to Thread
Results 1 to 2 of 2

count unique (frequency formula)

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,139

    count unique (frequency formula)

    Hi all

    Having some issues with sum(if(frequency formula.....

    in cell I95 (red highlight), i am trying to calculate UNIQUE instances of where an item is sold.

    my formula is as follows:

    {=SUM(IF(FREQUENCY(IF('Q4 CRM @Y'!$K:$K='2014PERF'!$Z95,IF('Q4 CRM @Y'!$A:$A=$Y95,'Q4 CRM @Y'!$I:$I)),'Q4 CRM @Y'!$I:$I)>0,1))}

    it is showing 0....not sure why ....

    basically, what I am trying to do is as follows:

    FIND UNIQUE "ship-to # (column I in the "Q4 CRM @Y" tab) for specified CITY and (column K in the "Q4 CRM @Y" tab) and by DEALER (column A in the "Q4 CRM @Y" tab, marked as a 1)

    in the 2014PERF sheet, cell Y95 = 1 and Z95 = City...so basically, count how many unique times there is a ship-to for QUEBEC that is dealer

    it should be around 644 or so.....but getting 0

    any help, pls and thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: count unique (frequency formula)

    Column I are Numbers stored as text convert them to real numbers.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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] Extract unique values between two dates and count their frequency
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2014, 10:01 AM
  2. Replies: 3
    Last Post: 06-01-2014, 02:09 AM
  3. XLS Array - Unique Value and Frequency?
    By markp99 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-11-2012, 05:48 PM
  4. Replies: 0
    Last Post: 03-22-2012, 08:44 PM
  5. COUNT Unique using Frequency
    By kw42chan in forum Excel General
    Replies: 7
    Last Post: 12-15-2011, 08:49 AM

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