Filtering a listobject(excel table) with a value that doesn't exit results all rows instead of none

can I get no rows? can I get list of optional legal parameters?

example listobject with col A

A 1 4 5

filter a=2 results 1,4,5 filter a=1 results 1 in this example I would like : opt 1: get no results for filtering with 2 opt 2: get a list of legal params: 1,4,5

  • 1
    I think this question would be more suited for stackoverflow? – Caraxian Oct 1 '14 at 22:59
  • How are you filtering? This is tagged vba, are you writing a macro? What's the macro look like? – Raystafarian Oct 2 '14 at 7:44

Your Answer

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

Browse other questions tagged or ask your own question.