+ Reply to Thread
Results 1 to 4 of 4

Array remove #num error

  1. 05-21-2019, 10:34 PM #1
    kenjcd
    kenjcd is offline
    Registered User
    Join Date
    08-22-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Array remove #num error

    Good day people!

    Please Login or Register  to view this content.
    I'm trying to remove the #num error in this formula. How to correct it?
    Attached Files Attached Files
    Last edited by kenjcd; 05-21-2019 at 10:39 PM.
    Reply With QuoteRegister To Reply
  2. 05-21-2019, 10:36 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Array remove #num error

    Try wrapping IFERROR around your formula like this and array entering.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dave
    Reply With QuoteRegister To Reply
  3. 05-21-2019, 10:39 PM #3
    kenjcd
    kenjcd is offline
    Registered User
    Join Date
    08-22-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Array remove #num error

    Quote Originally Posted by FlameRetired View Post
    Try wrapping IFERROR around your formula like this and array entering.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thanks for prompt reply Dave!
    Reply With QuoteRegister To Reply
  4. 05-21-2019, 10:55 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Array remove #num error

    You are welcome. And thank you for marking your thread Solved.
    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. [SOLVED] VBA copy value from array to another array - Type mismatch error
    By gargantuLars in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2019, 01:13 PM
  2. [SOLVED] Filtering an array - error when there is no longer a match in the array
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2018, 11:25 AM
  3. [SOLVED] FORMULA Remove #NUM error not using IFERROR OR IS ERROR
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2017, 04:22 PM
  4. [SOLVED] VBA help needed to capture Error and Remove Pivot if error exist else resume
    By Tescatlipoca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2014, 05:46 PM
  5. remove #VALUE and #N/A from an Array
    By apolloni in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 01:10 PM
  6. Array problem: Key words-Variant Array, single-element, type mismatch error
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2005, 01:54 AM
  7. Array problem: Key words-Variant Array, single-element, type mismatch error
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2005, 12:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1