+ Reply to Thread
Results 1 to 5 of 5

#N/A issues, Cannot make them go away, HELP!

  1. 02-24-2016, 09:35 PM #1
    Hillster
    Hillster is offline
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    #N/A issues, Cannot make them go away, HELP!

    I have a workbook with data that I am trying to program to look for re-occurrences as a pair in previous number data, there are a lot of cells with #N/A. I do not want them on the worksheet at all. Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Hillster; 02-24-2016 at 10:04 PM.
    Reply With QuoteRegister To Reply
  2. 02-24-2016, 09:42 PM #2
    InvisibleMan
    InvisibleMan is offline
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: #N/A issues, Cannot make them go away, HELP!

    You can use IFERROR to cater for this.
    Reply With QuoteRegister To Reply
  3. 02-24-2016, 09:53 PM #3
    Hillster
    Hillster is offline
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    Re: #N/A issues, Cannot make them go away, HELP!

    Ok, I have IF functions in the cells. How would I incorporate the IFERROR formula? does it go in prior to the formulas I have now or......?
    Reply With QuoteRegister To Reply
  4. 02-25-2016, 03:38 AM #4
    InvisibleMan
    InvisibleMan is offline
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: #N/A issues, Cannot make them go away, HELP!

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-25-2016, 01:58 PM #5
    Hillster
    Hillster is offline
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    Re: #N/A issues, Cannot make them go away, HELP!

    Got it, thank you so much!
    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. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. Datedif Negative Issues and General Issues Adding/Subtracting/Rounding Months and Days
    By DaveBre in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2014, 01:50 AM
  4. Data Validation List Issues/Sorting Issues
    By taylorbe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2014, 09:53 AM
  5. how to make ####(hash)symbol to disappear and make another sheet works on previous macro?
    By pejoi in forum Excel General
    Replies: 8
    Last Post: 11-08-2013, 07:46 AM
  6. trying to make a button on summary page to make new working sheet
    By dbzisme in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-07-2013, 05:41 PM
  7. How can i make reference based on cell make non pivot slicer and make connection to cell
    By zeko90 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2013, 06:34 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