• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

How to extract values from a column skipping the errors.

Please check the attached file and embedded image for clarification.

Nishan Rashed
Nishan Rashed
  • 2
1 Solution
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.
In F2

Open in new window

Confirm with Ctrl+Shift+Enter and copy down until you get blank cells.
Nishan RashedAuthor Commented:
Thanks! it works
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Nishan! Glad to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now