I have a serious problem when it comes to autofiltering.
I have imported some data from another sheet and try to use autofilter
a. I can select the exact value in the autofilter option, and it will display correct data
b. I can NOT select "Higher than" or "Lower than" (and similar choices), then nothing is selected.
c. If I double click on the cells (commit), then it seems that the content in the cell is activated and I can use "Higher than " etc.
Is there a workaround for this?
I have imported some data from another sheet and try to use autofilter
a. I can select the exact value in the autofilter option, and it will display correct data
b. I can NOT select "Higher than" or "Lower than" (and similar choices), then nothing is selected.
c. If I double click on the cells (commit), then it seems that the content in the cell is activated and I can use "Higher than " etc.
Is there a workaround for this?