0

Filter in a Excel list

Judith Stettler

March 14, 2019 12:23

Answered

Follow

Hi,

I would like to create a list NL(rows) based on a table in Excel. That works without problems, as you can see in the picture. But there are some empty fields in the table I would like to exclude in the NL(rows). How can I set a filter to do so?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis March 22, 2019 21:30

  Hi Judith -

  You could try Conditionally Hiding the Rows that have a blank value.

• 0
  
  Judith Stettler March 25, 2019 07:55

  Thank you Harry, thats what I did.