+ Reply to Thread
Results 1 to 7 of 7

FORMULA Remove #NUM error not using IFERROR OR IS ERROR

  1. 01-02-2017, 11:20 AM #1
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,143

    FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    Hi All

    Happy New Year 2017 .

    Using one look up to have multiple results but the issue since its an array using iferror is slowing the calculation in a big spreadsheet of 60000 rows of data

    Is there another way to pull multiple ocurrences without using iferror.

    Thanks if anyone can assist
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-02-2017, 11:53 AM #2
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    Thanks JEAN! Wish you the same.

    Maybe you can try the following approach...

    In D2 (Array Formula)
    Please Login or Register  to view this content.
    and copy across.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 01-03-2017, 09:04 AM #3
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,143

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    Description Amount 1 2 3 4
    Oranges 10 10 20
    Apples 12
    Pears 14
    Grapes 15
    Oranges 20
    Apples 30
    Mango 25
    Leticji 10
    pomelos 30
    Mango 11
    Pears 45
    pomelos 35
    pomelos 22

    Hi
    Try but I am getting blanks as I drag down .

    Could you advise where I am going wrong

    Could you send me the file with a copy with the formula

    Thanks
    Jean
    Reply With QuoteRegister To Reply
  4. 01-03-2017, 09:14 AM #4
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    Actually you should use the below formula which can be copied across and down as well.
    Please Login or Register  to view this content.
    Refer to the green tab in the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 01-03-2017, 03:03 PM #5
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,143

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    thanks working now
    Reply With QuoteRegister To Reply
  6. 01-03-2017, 03:07 PM #6
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,948

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  7. 01-03-2017, 04:22 PM #7
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: FORMULA Remove #NUM error not using IFERROR OR IS ERROR

    You're welcome Jean! Glad to help.

    Please mark your thread as Solved as described by John in Post#6.
    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] My IFERROR has an Error
    By Alewis2122 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2016, 02:09 PM
  2. [SOLVED] IfError or On Error loop help
    By SKooLZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2015, 07:18 AM
  3. [SOLVED] IFERROR on third error?
    By djarcadian in forum Excel General
    Replies: 2
    Last Post: 02-22-2015, 05:14 PM
  4. IFERROR within IFERROR until no error. Help.
    By XNemo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-26-2014, 12:30 PM
  5. [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
  6. IFError Forumula Error
    By Hudson in forum Excel General
    Replies: 2
    Last Post: 02-27-2012, 01:53 PM
  7. Excel 2007 : iferror function to remove #value error
    By Jerseynjphillypa in forum Excel General
    Replies: 1
    Last Post: 10-26-2011, 09:59 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