Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter with Blank option

My filter has a blank option.


It happens because some values are in one of the worksheets and not in the other. The filter is pulling from worksheet X and the values are from worksheet Y.

I wanted to know how to make the filter work even without having to include information from one worksheet in another.