Using Filter Function to IGNORE #N/A

**Howardc1001** · 01-15-2022, 11:09 PM

I have set up a filter formula to extract Data based on specified item

However I have $N/A items in the data and need Filter to exclude these when generating a result

=FILTER(A1:H8,H1:H8=Q1,"Not Found")

I have attached sample Data

It would be appreciated if someone could kindly amend my formula

**wk9128** · 01-16-2022, 12:55 AM

Cell O6 formula

Formula:

=FILTER(FILTER(A1:H8,ISNUMBER(SEARCH(H1:H8,Q2))),{1,0,0,0,0,0,1,1})

**Bo_Ry** · 01-16-2022, 01:10 AM

Please try

=FILTER(FILTER(A2:H8,COUNTIFS(O5:Q5,A1:H1)),IFNA(H2:H8,)=Q2)

**Howardc1001** · 01-16-2022, 01:58 AM

Many thanks for the help Guys. Formula works perfectly

**wk9128** · 01-16-2022, 02:03 AM

@Howardc1001 You're Welcome. Glad to help . Thank You for the feedback

Using Filter Function to IGNORE #N/A

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using Filter Function to IGNORE #N/A

Re: Using Filter Function to IGNORE #N/A

Re: Using Filter Function to IGNORE #N/A

Re: Using Filter Function to IGNORE #N/A

Re: Using Filter Function to IGNORE #N/A

Thread Information

Users Browsing this Thread

Similar Threads

Filter only columns with data and ignore the others

Trying to filter a column and ignore hidden rows

[SOLVED] Find / Filter Min / Max Dates & Ignore #N/A

Macro for Filter ignore specific cell value

Filter uniques and ignore empty cells

Make filter ignore some rows

How to ignore lines in filter?

Bookmarks

Bookmarks

Posting Permissions