Results 1 to 8 of 8

COUNTIF beaviour with dynamic arrays

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    693

    COUNTIF beaviour with dynamic arrays

    Hi, can someone pls explain to me why the following first example works but the second one does not?

    There's apparently restrictions in what Countif (countifs etc.) are willing to accept as a range argument:

    Works:
    A1 = UNIQUE(B1:B10)
    C1 = COUNTIF(A1#,"*")

    Does not work (i.e. combination into one formula):
    D1 = COUNTIF(UNIQUE(B1:B10),"*")

    As a further question: Why does UNIQUE output an empty cell as a Zero?
    What would be a way to have UNIQUE show both empty cells and cells with a true zero as distinct unique outputs?
    What UNIQUE does instead is output two Zeroes as distinct unique items.

    Any help much appreciated.

    Thanks and Regards
    Last edited by RaulSerg; 05-21-2020 at 12:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Arrays, Dynamic Drop down list, Filters and multiple rows
    By Big_Kev007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2020, 06:35 AM
  2. Dynamic Arrays
    By andrewc in forum Excel General
    Replies: 4
    Last Post: 02-29-2020, 03:41 AM
  3. [SOLVED] Countif using vba arrays
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-10-2016, 09:20 PM
  4. [SOLVED] CountIF VBA Arrays
    By lloydgodin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2013, 08:09 PM
  5. [SOLVED] COUNTIF and arrays?
    By aikorei in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-16-2012, 11:27 AM
  6. Using Dynamic Arrays
    By ozi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2007, 09:35 AM
  7. Dynamic Arrays
    By Chiba in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 12:05 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