+ Reply to Thread
Results 1 to 3 of 3

I want to avoid error and extract all correct data

  1. 09-18-2019, 01:45 PM #1
    manish2303
    manish2303 is offline
    Registered User
    Join Date
    09-01-2019
    Location
    India
    MS-Off Ver
    10
    Posts
    21

    I want to avoid error and extract all correct data

    I want to extract data without error in sequential manner.

    I have attached sample file with input and expected output.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-18-2019, 02:06 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,101

    Re: I want to avoid error and extract all correct data

    It's not clear what Excel version you are using. Please amend your profile.

    this works with Excel 2010+

    =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$9)/(ISNUMBER($A$2:$A$9)),ROWS(A$14:A14))),"")
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 09-18-2019, 09:58 PM #3
    manish2303
    manish2303 is offline
    Registered User
    Join Date
    09-01-2019
    Location
    India
    MS-Off Ver
    10
    Posts
    21

    Re: I want to avoid error and extract all correct data

    Thanks Glenn Kennedy it worked
    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. Unexplainable Value error. Data type/links/formula is correct.
    By TinyDamooge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2016, 07:30 AM
  2. Interactive chart throws error message when I reduce data sources, how to avoid?
    By Butcher1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-31-2015, 12:55 PM
  3. [SOLVED] Need error handler code to avoid pivot table refreshing error if no data is available
    By adelkam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2015, 12:37 PM
  4. The correct way of referencing the data source for a pivot table... error
    By lgjmac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2013, 03:51 PM
  5. [SOLVED] Component Life Cycle Management, How to Extract Correct Data
    By JONBOY666 in forum Excel General
    Replies: 5
    Last Post: 05-01-2013, 10:52 PM
  6. Error moving or deleting cells caused an invalid cell reference - how to avoid this error
    By prontrad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 12:07 PM
  7. Extract data to avoid copy & pasting
    By pixifaery in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2010, 04:28 PM

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