《Excel高级筛选教程.ppt

EXCEL BIBLE 批量关键字快速查找 图文：@Excel大全 /excelbible 内容提要： 使用Excel高级筛选功能查找匹配多个关键字的记录 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE 上万条企业信息 想从中找到潜在客户？ 数千条商品目录 想查看热门关键词产品？ 几百册推荐书目 想找到心仪的阅读对象？ 必杀利器 高级筛选 之 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE 一份豆瓣推荐书单 旅行。 摄影。。 村上春树。。 … 想看点啥？ Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE Step 1 在表格里写下你的愿望清单 要点： 关键字的列标题要和清单当中一致（D1=B1） 每个关键字两边加星号* Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE Step 2 召唤高级筛选功能 要点： 【列表区域】即原始清单，务必包含标题行 【条件区域】即关键字列表，务必包含标题行 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE 一秒钟看到结果有木有？ “滴答” Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE 护手霜。 低于80块。。 低于5折。。 … 想要多个期望 同时满足？ 一份双11商品清单 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE Step 1 把期望条件横过来放 要点： 条件的列标题要和清单当中一致（H1=A1\I1=C1\J1=D1） 文本关键字两边加星号* 需要同时满足的关键字横向排列在同一行 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE Step 2 召唤高级筛选功能 要点： 【列表区域】即原始清单，务必包含标题行 【条件区域】即关键字列表，务必包含标题行 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. EXCEL BIBLE 哇噢，太快了有木有 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd.