w**j
发帖数: 174 | 1 My Excel file's filter function doesn't work.
When I click Auto Filter and choose one of the model#"MC". It shows all MC
from the beginning but other model# will come out from line 1160.
The original data was copied from other files, not input directly. It may
cause the problem?
Anyone knows what wrong with my Excel file and how to solve it?
Your help is highly appreciated. |
n****f
发帖数: 905 | 2 Check if there are some blank space in that field.
【在 w**j 的大作中提到】
: My Excel file's filter function doesn't work.
: When I click Auto Filter and choose one of the model#"MC". It shows all MC
: from the beginning but other model# will come out from line 1160.
: The original data was copied from other files, not input directly. It may
: cause the problem?
: Anyone knows what wrong with my Excel file and how to solve it?
: Your help is highly appreciated.
|
w**j
发帖数: 174 | 3 Yes. There is some blank space. But usually, I can still filter with blank
space. There will be a model# as (blank). Right?
【在 n****f 的大作中提到】
: Check if there are some blank space in that field.
|
n****f
发帖数: 905 | 4 Delete these blank space to see what happened.
MC
may
【在 w**j 的大作中提到】
: Yes. There is some blank space. But usually, I can still filter with blank
: space. There will be a model# as (blank). Right?
|
