Excle高级筛选示例.xls

总总计计日日期期日日期期 500 1 11 02筛选 高级筛选 3 选择复制到其它位置 4 点击数据区域 5 选择Sheet 1并选中数据区域 6 点击条件区域框 7 选择条件区域 8 点击复制到框 9 在sheet2工作表中选择任一单元格作为输出数据的起始位置 10 点击确定 2002 4 18 MegaMart Milk 734 00 2002 4 18 MegaMart Bread 277 00 2002 4 23 MiniMartBread 357 00 2002 4 24 SuperMart Milk 433 00 2002 4 24 MegaMart Cookies 945 00 2002 4 29 MiniMartIce 122 00 顾顾客客产产品品Product MegaMartCookies Ice MiniMartMilk 使用这个条件区域Use this criteria range 查找满足to find Items 两行条件之一的记录 that exactly match the criteria 注注意 意 如果你想将筛选的结果输出到其它工作表 比如Sheet2 1 在Sheet 2工作表中 选择任一没用的单元格 2 选择数据 筛选 高级筛选 3 选择复制到其它位置 4 点击数据区域 5 选择Sheet 1并选中数据区域 6 点击条件区域框 7 选择条件区域 8 点击复制到框 9 在sheet2工作表中选择任一单元格作为输出数据的起始位置 10 点击确定 注注意 意 如果你想将筛选的结果输出到其它工作表 比如Sheet2 1 在Sheet 2工作表中 选择任一没用的单元格 2 选择数据 筛选 高级筛选 3 选择复制到其它位置 4 点击数据区域 5 选择Sheet 1并选中数据区域 6 点击条件区域框 7 选择条件区域 8 点击复制到框 9 在sheet2工作表中选择任一单元格作为输出数据的起始位置 10 点击确定 日日期期顾顾客客发发票票金金额额支支付付金金额额 2002 1 1 MegaMart 278 07 278 07FALSE 2002 1 3 MiniMart 789 00 500 00 2002 1 3 SuperMart 1 365 35 1 365 35使用这个条件区域 2002 1 3 FoodMart 240 17 240 17查找那些发票金额与支付金额不符的记录 2002 1 4 MegaMart 1 348 49 1 348 49 2002 1 11 FoodMart 2 023 35 2 023 35 2002 1 11 MegaMart 292 81 292 81 2002 1 18 MiniMart 1 802 92 1 802 92 2002 1 20 MegaMart 1 668 42 1 668 42 2002 1 20 MegaMart 566 00 566 00 2002 1 21 MegaMart 422 00 422 00 2002 1 21 FoodMart 1 335 74 1 335 74 2002 1 25 MegaMart 176 41 176 41 2002 1 25 MiniMart 870 48 870 48 2002 1 26 MiniMart 1 682 37 1 682 37 2002 1 26 MiniMart 1 704 22 1 704 22 2002 2 3 SuperMart 460 00 460 00 2002 2 3 MiniMart 1 607 04 1 607 04 2002 2 4 MiniMart 1 205 28 1 205 28 2002 2 7 MiniMart 2 191 67 2 191 67 2002 2 8 MiniMart 454 77 454 77 2002 2 17 MegaMart 1 800 00 1 800 00 2002 2 17 MiniMart 2 206 89 2 206 89 2002 2 22 MegaMart 122 15 122 15 2002 2 23 MiniMart 2 374 06 2 374 06 2002 2 23 MegaMart 1 347 57 1 347 57 2002 2 28 MegaMart 615 94 615 94 产产品品总总计计定定单单号号出出库库日日期期 Cookies 278 07104562002 8 1FALSE Bread 789 00104572002 8 2 Produce 1 365 35104582002 8 3使用这个条件区域 Produce 2408 4查找定单号中有数字的8的记录 Cookies 1 348 49104602002 8 5 Produce 2 023 35104612002 8 6 Produce 292 81104622002 8 7 Produce 1 802 92104632002 8 8 Cookies 1 668 42104642002 8 9 Milk 566 0010465 2002 8 10 Bread 422 0010466 2002 8 11 Produce 1 335 7410467 2002 8 12 Cookies 176 4110468 2002 8 13 Milk 870 4810469 2002 8 14 Milk 1 682 3710470 2002 8 15 Produce 1 704 2210471 2002 8 16 Cookies 460 0010472 2002 8 17 Milk 1 607 0410473 2002 8 18 Milk 1 205 2810474 2002 8 19 Cookies 2 191 6710475 2002 8 20 Milk 454 7710476 2002 8 21 Bread 1 800 0010477 2002 8 22 Milk 2 206 8910478 2002 8 23 Bread 122 1510479 2002 8 24 Cookies 2 374 0610480 2002 8 25 Milk 1 347 5710481 2002 8 26 Cookies 615 9410482 2002 8 27 定定单单号号出出库库日日期期产产品品总总计计 104562002 8 1 File 578 84FALSE 104572002 8 2 479 71 104582002 8 3 Binder 120 04使用这个条件区域 104592002 8 4 Boxes 583 91查找产品列为空的记录 104602002 8 5 193 07 104612002 8 6 Clipboards 92 56 104622002 8 7 Folders 646 00 104632002 8 8 Office pads 348 00 104642002 8 9 Pens 104 00 10465 2002 8 10 Clipboards 185 00 10466 2002 8 11 File 78 00 10467 2002 8 12 File Cabinet 433 00 10468 2002 8 13 Binder 959 00 10469 2002 8 14 Boxes 542 00 10470 2002 8 15 Card Holders 494 00 10471 2002 8 16 Clipboards 973 00 10472 2002 8 17 Folders 218 00 10473 2002 8 18 Office pads 379 00 10474 2002 8 19 Pens 396 00 10475 2002 8 20 Pens 282 00 10476 2002 8 21 File 503 00 10477 2002 8 22 File Cabinet 139 00 10478 2002 8 23 Binder 517 00 10479 2002 8 24 Boxes 965 00 10480 2002 8 25 Card Holders 558 00 10481 2002 8 26 Clipboards 909 00 10482 2002 8 27 Folders 657 00 定定单单号号出出库库日日期期产产品品总总计计 104562002 8 1 File 578 84FALSE 104572002 8 2 479 71 104582002 8 3 Binder 120 04使用这个条件区域 104592002 8 4 Boxes 583 91查找总计金额在前五名的记录 104602002 8 5 193 07 104612002 8 6 Clipboards 92 56 104622002 8 7 Folders 646 00 104632002 8 8 Office pads 348 00 104642002 8 9 Pens 104 00 10465 2002 8 10 Clipboards 185 00 10466 2002 8 11 File 78 00 10467 2002 8 12 File Cabinet 433 00 10468 2002 8 13 Binder 959 00 10469 2002 8 14 Boxes 542 00 10470 2002 8 15 Card Holders 494 00 10471 2002 8 16 Clipboards 973 00 10472 2002 8 17 Folders 218 00 10473 2002 8 18 Office pads 379 00 10474 2002 8 19 Pens 396 00 10475 2002 8 20 Pens 282 00 10476 2002 8 21 File 503 00 10477 2002 8 22 File Cabinet 139 00 10478 2002 8 23 Binder 517 00 10479 2002 8 24 Boxes 965 00 10480 2002 8 25 Card Holders 558 00 10481 2002 8 26 Clipboards 909 00 10482 2002 8 27 Folders 657 00 使用条件区域F1 H2顾顾客客产产品品总总计计顾顾客客产产品品 查找同时满足MegaMartCookies 500foodMart 所有条件的记录Cookies Cookies 日日期期顾顾客客产产品品总总计计 2003 1 1 MegaMart Ice 302 00 2003 1 3 FoodMart Produce 530 00日日期期顾顾客客 2003 1 4 MegaMart Cookies 223 002003 1 3 FoodMart 2003 1 11 MegaMart Cookies 363 002003 1 4 MegaMart 2003 1 20 MegaMart Cookies 478 002003 1 11 MegaMart 2003 1 20 MegaMart Milk 191 002003 1 20 MegaMart 2003 1 21 FoodMart Bread 684 002003 1 21 FoodMart 2003 1 25 MegaMart Cookies 614 002003 1 25 MegaMart 2003 2 17 MegaMart Bread 380 002003 2 28 MegaMart 2003 2 22 MegaMart Bread 120 002003 3 2 MegaMart 2003 2 23 MegaMart Milk 174 002003 3 4 FoodMart 2003 2 28 MegaMart Cookies 48 002003 3 5 MegaMart 2003 3 2 MegaMart Cookies 715 002003 3 12 FoodMart 2003 3 4 FoodMart Bread 561 002003 3 21 MegaMart 2003 3 5 MegaMart Cookies 468 002003 4 4 FoodMart 2003 3 12 FoodMart Produce 746 00 2003 3 12 MegaMart Ice Cream 752 00 2003 3 19 MegaMart Produce 399 00 2003 3 21 MegaMart Cookies 746 00 2003 3 21 MegaMart Milk 903 00 2003 4 4 FoodMart Milk 275 00 2003 4 18 MegaMart Bread 277 00 2003 4 18 MegaMart Milk 734 00 总总计计使用条件区域J1 L4 查找满足三个条件中任一条件 的记录 500 产产品品总总计计 Produce 530 00 Cookies 223 00 Cookies 363 00 Cookies 478 00 Bread 684 00 Cookies 614 00 Cookies 48 00 Cookies 715 00 Bread 561 00 Cookies 468 00 Produce 746 00 Cookies 746 00 Milk 275 00 顾顾客客产产品品 Mart Good Eats 日日期期顾顾客客产产品品总总计计 2003 1 1 FoodShopGood Eats 302 00 2003 1 3 FoodMartCoke 530 00 2003 1 4 MegaMartGood Treats 223 0