1

Say my data is in range A6:Z with the headers in row 5. I want to display rows with value in column C that is non-zero or #N/A. I tried OR(C6:C <> 0, IFNA(C6:C, true)) and OR(C6:C <> 0, ISNA(C6:C)) and none of them works.

1

Try the following

=INDEX(IF((IFNA(V6:V21))=0,,IFNA(V6:V21)))

enter image description here

To have just 0 values filtered out try

=INDEX(IF(V6:V21=0,,V6:V21))
6
  • Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. – marikamitsos Mar 16 at 17:50
  • I want to filter out only the 0 rows and keep the #N/A rows. If I use your method and apply NOT(ISBLANK( )) to the result (column W), I miss out the #N/A rows. – Myath Mar 16 at 19:18
  • So you want just 0 values filtered out. Yes? – marikamitsos Mar 16 at 19:26
  • Yes, only 0 values should be filtered out. – Myath Mar 16 at 19:27
  • Please check the answer again. And don't forget to accept :) – marikamitsos Mar 16 at 19:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.