ask for help-MS Excel - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ask for help-MS Excel

ask for help-MS Excel# Database - 数据库

w*j2004-06-15 07:06

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*f2004-06-15 07:06

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*j2004-06-15 07:06

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*f2004-06-15 07:06

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?