How not to include values in the filter?

[F_Ribeiro]

Good morning everybody!

I would like to know how to not include specific values in the filter criteria (0 and blanks for example). In short, data I don't want to work with.

This would avoid a repetitive effort on the spreadsheet I use and just now I thought about it, ha ha...

 

[RoryA]

It's not clear (to me at least) what you mean, as I presume it's more complicated than just unticking 0 and 'Blanks' in the filter dropdowns?

 

[F_Ribeiro]

It's not clear (to me at least) what you mean, as I presume it's more complicated than just unticking 0 and 'Blanks' in the filter dropdowns?

This values are example. Basically, I would like to inform in the code which values I do not want to filter, if they are in a much smaller amount than those I want to display.

 

[RoryA]

This is the first time you have mentioned code...

If you only wish to exclude two values, it's pretty simple. There is no direct way to exclude more than that, but there are a few workarounds, such as:
- use an advanced filter; or
- create a list of valid values in code and filter for those; or
- use a formula column that can exclude the values you want.

 

[F_Ribeiro]

I believe I have solved the problem.

I didn't follow any of the alternatives you suggested, but I created an If inside a loop that checks if the cell's content is "0" or "blank", and then hides the line. It's not exactly what I wanted and it takes longer to load than a filter, but at least it automated that process. Thank you for responding, until next time.

F. Ribeiro