EXCEL HELP

jia066

情况是这样的，有一张庞大的excel的表格，需要进行分类。有一个row有很多不同的business name，比如KFCXXX路，KFCxxx1路，KFCxxx2路，想要说就选择kfc这个关键词，然后可以看到所用和kfc有关的字样，想要知道该怎么做？先谢过

H

Data->Filter->AutoFilter->Custom AutoFilter->Show rows where: CONTAINS "KFC"

y12345678

用SAS做比较方便

jia066

用了这个方法，不过manager想要只要选择关键字比如kfc,从那个filter的dropdown list，然后可以看到所有跟kfc有关的东西

jia066

I have no idea how to use SAS

ppy006

create another column, put down the category, e.g. KFC, then  autofilter

y12345678

有一个row有很多不同的business name，比如KFCXXX路，KFCxxx1路，KFCxxx2路，
具体是咋样的

ivy_cn

May change the "one row" to many columns first: copy-past special-transpose; then the whole matrix, then use pivot table to organize the data...; finally use the drop-down list of the column within the pivot table to control the names you would like to show(there are many tick boxes to control on or off of the items within the drop down function)

jia066

原帖由 ppy006 于 2009-10-13 12:35 发表
create another column, put down the category, e.g. KFC, then  autofilter

If I put down the category, how can i connect the category to data?

jia066

原帖由 ivy_cn 于 2009-10-13 12:43 发表
May change the "one row" to many columns first: copy-past special-transpose; then the whole matrix, then use pivot table to organize the data...; finally use the drop-down list of the column within th ...

I don't know how to use matrix

ppy006

1. Data->Filter->AutoFilter->Custom AutoFilter->Show rows where: CONTAINS "KFC"
2. put down "KFC" in the first cell of Column "Category"
3. copy & paste into the lines below
4. same process to other customers

[ 本帖最后由 ppy006 于 2009-10-13 13:15 编辑 ]

H

原帖由 ppy006 于 2009-10-13 12:56 发表
3. copy & paste into the lines below (don't drag down, otherwise it would copy to the hidden lines)

Are you sure? IMHO, Filter isn't like Group.

[ 本帖最后由 H 于 2009-10-13 18:14 编辑 ]

ppy006

Just tested it. You're right. already amended my last reply. Thanks

[ 本帖最后由 ppy006 于 2009-10-13 13:16 编辑 ]

jia066

原帖由 ppy006 于 2009-10-13 12:56 发表
1. Data->Filter->AutoFilter->Custom AutoFilter->Show rows where: CONTAINS "KFC"
2. put down "KFC" in the first cell of Column "Category"
3. copy & paste into the lines below
4. same process to ot ...

do you mean to create a new category column ? and then copy a list of KFC under 'KFC' category?
Sorry, i am not good at excel at all. I dont fully understand what you mean

ppy006

baciscally what I mean is create a new column, put down "KFC" in this new column for all the the business name starting with :KFC", e.g.KFCXXX路，KFCxxx1路，KFCxxx2路. then you should be able to filter them by "KFC" in this column.

我家住Bentleigh

去网上看一下怎么做PV TABLE就可以了