Results 1 to 10 of 10

Count Unique values after being filtered

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    6

    Question Count Unique values after being filtered

    Hello.

    I have been stumbling with this all day and I've not been able to figure it out.

    Screen Shot 2014-11-04 at 7.36.58 PM.png

    For example:
    Hit the filter on "Type" and select "house" only
    The value given is 4 which is the number of unique in the entire column, however that is not accurate after filter is applied
    The value for unique numbers is actually 3
    Also then if it is a Dwelling then it needs to be subtracted from the number in cell A13
    So Cell C13 would have to be subtracted from the value of cell A13

    Formula being used in cell A13 is =SUM(IF(FREQUENCY(A2:A11, A2:A11)>0,1))-C13

    In this case the answer I am looking for in cell A13 is 2 however, I am unable to figure out a formula to give me that.

    Help is appreciated.
    Last edited by tylert; 11-04-2014 at 09:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count unique values in filtered list?
    By Cayenne in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 10-23-2014, 04:58 PM
  2. Count unique, visible values in a filtered column
    By kajakk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2013, 08:42 AM
  3. count unique values in filtered column
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2013, 10:40 AM
  4. Count Unique Values in a Filtered Column
    By mashley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2008, 10:56 AM
  5. Count Unique Values In A Filtered Row with Duplicates
    By jcpotwor in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 09:10 PM

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