Closed Thread
Results 1 to 2 of 2

Array formula working in one workbook but not another

  1. #1
    Registered User
    Join Date
    10-27-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    98

    Question Array formula working in one workbook but not another

    Hi All

    I wasn't sure if I needed a new post or if I should continue the original?
    But I think this is a different issue, so figured it was best to start a new topic (apologies if that was not correct)

    Yesterday CARACALLA gave me an amazing formula to count distinct values in a range, excluding blank cells or cells where values begin with '#'
    Original post here

    It works great in the dummy data doc I uploaded called Book1.xlsx

    But I can't get it working in my 'Clients Workbook' and I'd be super grateful if anyone can see where I'm going wrong.

    It's throwing errors about a circular ref but I have no idea why?

    Any help would be appreciated
    All the best
    Vicky
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11)
    Posts
    52,050

    Re: Array formula working in one workbook but not another

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...values-if.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array formula Not Working - Help
    By GemBox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2017, 07:30 AM
  2. [SOLVED] Use of Row() in array formula not working
    By jswalemail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2013, 12:47 AM
  3. [SOLVED] Working with Workbook array
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2006, 01:36 AM
  4. [SOLVED] Array formula not working
    By bj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  5. Array formula not working
    By bj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM

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