How can I filter multiple numbers using Advanced Filter option?

How can I filter multiple numbers using Advanced Filter option?

Please help me understand how do I filter multiple numbers using Advanced Filter option?

Filtering text works for me, but not the numbers. Is there any format required?

enter image description here

答案1

I think what's missing is column label/headers/title which Advanced Filter seems to be using (see the popup in the beginning of the screen recording) to associate the columns to match (which in a one column filter it would really not be needed, it seems to still need it.)

enter image description here

相关内容