+ Reply to Thread
Results 1 to 2 of 2

Array? error checking formula???

  1. 04-26-2021, 04:45 PM #1
    Babbabooie
    Babbabooie is offline
    Registered User
    Join Date
    10-18-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    22

    Array? error checking formula???

    Thank You!
    Attached Files Attached Files
    Last edited by Babbabooie; 04-27-2021 at 03:13 PM.
    Reply With QuoteRegister To Reply
  2. 04-26-2021, 10:40 PM #2
    spitfireblue
    spitfireblue is offline
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Array? error checking formula???

    Hi,

    You could just use a countif formula to count the number of "NULLS" like this...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula error for checking cells
    By NickT83 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 07-21-2015, 09:06 AM
  2. Error checking/evaluation of a formula with errors (not the formula's output)
    By smaier69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2015, 08:41 PM
  3. checking for value in array getting error message
    By hopefulhart in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2015, 06:00 PM
  4. Help with nested if formula and error checking
    By barnesbrian813 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-09-2013, 11:37 AM
  5. Help with Array formula for checking cell entries
    By TheRobsterUK in forum Excel General
    Replies: 5
    Last Post: 02-24-2011, 10:28 PM
  6. how to Ignore formula Error Checking?
    By dlh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2008, 03:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1