|
查看: 1256|回复: 7
|
关于EXCEL的ADVANCE FITLER
[复制链接]
|
|
|
|
请问有那位可以教我怎样SET EXCEL的ADVANCE FILTER？ |
|
|
|
|
|
|
|
|
|
|
|
发表于 19-12-2005 02:15 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 19-12-2005 09:59 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 20-12-2005 09:03 AM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 29-9-2006 11:02 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 30-9-2006 01:22 AM
|
显示全部楼层
column A column B
Material Price
A 1
A 1
B 2
C 3
D 3.5
E 4
B 2
比如你有EXCEL sheet column A 和 column B, excel sheet have duplicate records ( material A & material B ). You can use advance filter 来 filter duplicate records then paste the result into different sheet or different cell.
Highligh column A & B , go to Data>>Filter>> Advance Filter . In the pop up screen, select "copy to another location". Put cursor on "copy to" then click on the cell where you want the result to copy to.Select "Unique Records Only" then click OK. system will paste the filtered list in the cell that you selected.
|
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 30-9-2006 06:24 PM
|
显示全部楼层
|
wats the advantage to use advanced filter? |
|
|
|
|
|
|
|
|
|
|
|
发表于 1-10-2006 11:10 PM
|
显示全部楼层
|
To filter unique records from a list with duplicate records. Also able to filter a list using pre-defined condition. |
|
|
|
|
|
|
|
|
|
| |
 本周最热论坛帖子
|
变色卡
千斤顶
1790 
108
