excel高级筛选-提取不重复 复杂条件下的高级筛选提取数据

月份

TRUE

日期

2011-4-12

2011-5-10西南四川成都自营AAAA-206200,000.00 2014-10-26西南四川成都自营AAAA-208370,000.00 2010-7-16西南四川成都自营AAAA-209270,000.00 2011-6-7西南重庆重庆自营AAAA-210120,000.00 2009-10-26西南重庆重庆自营AAAA-212190,000.00 2013-7-18西南重庆重庆自营AAAA-213330,000.00 2010-6-11西南重庆重庆自营AAAA-214140,000.00 2010-4-13西南重庆重庆自营AAAA-215140,000.00 2010-5-28西南云南昆明加盟AAAA-217100,000.00 2011-12-9西北陕西西安自营AAAA-188380,000.00 2010-5-17西北陕西西安自营AAAA-194180,000.00 2014-3-26西北内蒙古包头加盟AAAA-195340,000.00 2012-8-17西北内蒙古呼和浩特加盟AAAA-196330,000.00 2014-5-25西北内蒙古呼和浩特加盟AAAA-197200,000.00 2009-12-13西北陕西宝鸡加盟AAAA-198250,000.00 2012-9-25西北陕西延安加盟AAAA-199390,000.00 2011-10-9西北甘肃兰州加盟AAAA-200400,000.00 2010-6-7华中江西南昌自营AAAA-176250,000.00 2011-7-23华中湖北宜昌自营AAAA-178150,000.00 2010-10-25华中湖北武汉自营AAAA-185260,000.00 2012-8-11华中湖南长沙加盟AAAA-186360,000.00 2012-5-27华中湖南长沙加盟AAAA-187380,000.00 2012-9-9华南广东广州自营AAAA-158120,000.00 2013-12-17华南广东广州自营AAAA-159230,000.00 2013-9-20华南广东深圳自营AAAA-161110,000.00 2011-11-3华南广东深圳自营AAAA-16680,000.00 2011-7-23华南广东深圳自营AAAA-16790,000.00 2013-8-15华南广东东莞加盟AAAA-168170,000.00 2011-4-16华南广东东莞加盟AAAA-169150,000.00 2009-7-22华南广东汕头加盟AAAA-170350,000.00 2013-8-22华南广东深圳加盟AAAA-171330,000.00 2013-6-21华南广东东莞加盟AAAA-172100,000.00 2010-8-5华南海南海口加盟AAAA-173330,000.00 2011-4-7华南海南海口加盟AAAA-17490,000.00 2011-8-29华南广东佛山加盟AAAA-175160,000.00 2011-10-13华东福建福州自营AAAA-048390,000.00 2013-4-23华东福建福州自营AAAA-049350,000.00

2014-3-22华东福建泉州自营AAAA-052230,000.00 2010-8-13华东福建厦门自营AAAA-053140,000.00 2012-8-4华东福建厦门自营AAAA-054350,000.00 2011-5-26华东福建厦门自营AAAA-055330,000.00 2012-10-1华东江苏南京自营AAAA-058300,000.00 2012-12-22华东江苏南京自营AAAA-059260,000.00 2011-4-1华东江苏苏州自营AAAA-06080,000.00 2012-11-3华东江苏太仓自营AAAA-061400,000.00 2013-9-5华东江苏芜湖自营AAAA-062230,000.00 2013-6-16华东江苏宜兴自营AAAA-063260,000.00 2011-5-18华东江苏常州自营AAAA-064390,000.00 2013-5-15华东江苏镇江自营AAAA-065270,000.00 2010-12-3华东江苏常熟自营AAAA-066150,000.00 2014-3-15华东江苏常熟自营AAAA-06780,000.00 2013-7-17华东江苏常州自营AAAA-068380,000.00 2009-10-30华东江苏昆山自营AAAA-069400,000.00 2010-6-10华东江苏南京自营AAAA-070280,000.00 2010-9-8华东江苏南京自营AAAA-071250,000.00 2010-5-8华东江苏南京自营AAAA-072230,000.00 2009-11-11华东江苏苏州自营AAAA-074200,000.00 2013-11-28华东江苏苏州自营AAAA-075240,000.00 2011-5-16华东江苏无锡自营AAAA-076380,000.00 2010-12-30华东江苏无锡自营AAAA-077260,000.00 2010-4-6华东江苏无锡自营AAAA-078350,000.00 2011-3-16华东江苏吴江自营AAAA-079280,000.00 2011-7-6华东江苏无锡自营AAAA-080330,000.00 2013-6-2华东上海上海自营AAAA-081210,000.00 2014-4-9华东上海上海自营AAAA-082370,000.00 2011-8-30华东上海上海自营AAAA-083110,000.00 2009-9-30华东上海上海自营AAAA-084130,000.00 2009-8-23华东上海上海郊县自营AAAA-085270,000.00 2012-9-13华东上海上海自营AAAA-086260,000.00 2011-8-29华东上海上海自营AAAA-095120,000.00 2012-9-25华东上海上海自营AAAA-097160,000.00 2010-3-3华东上海上海自营AAAA-098340,000.00 2011-8-10华东上海上海自营AAAA-099320,000.00 2009-11-14华东上海上海自营AAAA-102260,000.00 2011-8-27华东上海上海自营AAAA-103230,000.00 2014-11-4华东上海上海自营AAAA-104330,000.00 2009-12-2华东上海上海自营AAAA-105380,000.00 2011-12-28华东上海上海自营AAAA-10690,000.00 2012-4-15华东上海上海自营AAAA-107110,000.00 2011-12-3华东上海上海自营AAAA-108170,000.00 2013-10-17华东上海上海自营AAAA-109230,000.00

2012-6-23华东上海上海郊县自营AAAA-112270,000.00 2010-7-22华东上海上海郊县自营AAAA-114210,000.00 2012-8-16华东上海上海郊县自营AAAA-115190,000.00 2010-12-10华东上海上海郊县自营AAAA-116380,000.00 2014-7-26华东上海上海郊县自营AAAA-118310,000.00 2009-7-20华东上海上海自营AAAA-119270,000.00 2010-9-12华东上海上海自营AAAA-12090,000.00 2010-8-14华东浙江富阳自营AAAA-121150,000.00 2009-9-21华东浙江杭州自营AAAA-122130,000.00 2012-7-8华东浙江杭州自营AAAA-12380,000.00 2011-10-8华东浙江杭州自营AAAA-124190,000.00 2012-6-15华东浙江温州自营AAAA-128270,000.00 2010-4-30华东安徽蚌埠加盟AAAA-129100,000.00 2014-9-16华东安徽阜阳加盟AAAA-130270,000.00 2013-7-22华东福建福建加盟AAAA-133330,000.00 2014-9-16华东福建泉州加盟AAAA-136160,000.00 2014-3-31华东江苏淮安加盟AAAA-138380,000.00 2014-10-23华东江苏江阴加盟AAAA-139230,000.00 2012-9-16华东江苏连云港加盟AAAA-14070,000.00 2014-7-29华东江苏南通加盟AAAA-141230,000.00 2010-7-27华东江苏秦州加盟AAAA-142240,000.00 2010-12-22华东江苏通州加盟AAAA-143260,000.00 2013-12-15华东江苏无锡加盟AAAA-144380,000.00 2012-12-2华东江苏无锡加盟AAAA-145190,000.00 2011-11-5华东江苏丹阳加盟AAAA-146300,000.00 2009-10-24华东浙江浙江加盟AAAA-147400,000.00 2011-12-17华东浙江浙江加盟AAAA-148110,000.00 2014-8-17华东浙江浙江加盟AAAA-149380,000.00 2012-6-29华东浙江浙江加盟AAAA-150290,000.00 2013-5-10华东浙江浙江加盟AAAA-151190,000.00 2011-4-18华东浙江浙江加盟AAAA-153250,000.00 2013-4-1华东浙江浙江加盟AAAA-154270,000.00 2009-9-6华东江苏扬州加盟AAAA-156380,000.00 2009-8-19华东福建福州自营AAAA-157100,000.00 2010-10-3华北北京北京加盟AAAA-013260,000.00 2012-8-3华北天津天津加盟AAAA-014320,000.00 2014-5-13华北北京北京自营AAAA-015200,000.00 2009-12-19华北北京北京自营AAAA-017330,000.00 2011-8-15华北北京北京自营AAAA-018250,000.00 2014-4-18华北北京北京自营AAAA-020160,000.00 2011-11-29华北山东济南自营AAAA-027280,000.00 2011-9-14华北山东烟台自营AAAA-028130,000.00 2014-12-15华北山东济南自营AAAA-029320,000.00 2011-4-5华北山东济南自营AAAA-030240,000.00

2014-6-4华北河北秦皇岛加盟AAAA-032240,000.00 2009-7-9华北河北石家庄加盟AAAA-033250,000.00 2009-11-14华北山西山西加盟AAAA-035210,000.00 2011-6-8华北山西山西加盟AAAA-03690,000.00 2009-8-1华北山东济南加盟AAAA-038160,000.00 2011-9-6华北山东济南加盟AAAA-039110,000.00 2012-4-21华北山东潍坊加盟AAAA-041200,000.00 2014-12-27华北山东淄博加盟AAAA-042370,000.00 2009-10-8华北河南河南加盟AAAA-043150,000.00 2012-12-5华北河南河南加盟AAAA-04480,000.00 2010-3-22华北河南开封加盟AAAA-045210,000.00 2009-11-8华北河北沧州加盟AAAA-046190,000.00 2010-11-9东北辽宁大连自营AAAA-001150,000.00 2011-10-5东北辽宁大连自营AAAA-002280,000.00 2013-11-17东北辽宁大连自营AAAA-003190,000.00 2012-4-20东北辽宁沈阳自营AAAA-00490,000.00 2013-5-9东北辽宁沈阳自营AAAA-005270,000.00 2013-12-15东北辽宁沈阳自营AAAA-006180,000.00 2010-6-5东北辽宁沈阳自营AAAA-007280,000.00 2013-6-7东北辽宁沈阳自营AAAA-008340,000.00 2013-10-30东北辽宁沈阳自营AAAA-009150,000.00 2012-4-4东北辽宁沈阳自营AAAA-010220,000.00 2012-7-20东北辽宁沈阳自营AAAA-011120,000.00 2011-6-28东北黑龙江齐齐哈尔加盟AAAA-012350,000.00

103,908.0040,502.56 33,480.509,013.31 125,187.0045,645.87 62,012.0022,574.10 22,594.109,914.22 108,316.0038,732.25 85,770.5031,126.64 15,499.004,637.82 108,658.0032,389.82 119,815.5039,582.96 77,982.1026,099.07 72,553.5026,539.65 73,663.5026,525.95 42,953.5015,441.06 53,222.5019,271.22 81,474.5028,245.85 50,978.0018,331.70 34,068.0011,887.77 49,880.0017,679.11 103,156.0037,469.31 120,957.5042,528.11 74,768.0027,787.34 52,785.1021,237.42 83,692.0033,788.84 55,218.5023,788.94 78,171.0029,210.03 44,010.5017,014.54 73,297.5027,968.43 86,530.0030,961.41 102,682.0035,668.55 49,888.0016,644.14 43,431.0011,006.04 91,160.0032,220.27 81,095.5027,293.96 78,751.5050,038.23 133,238.5050,618.49 144,797.0055,811.66

106,703.0042,049.74 98,162.5039,030.18 97,473.0039,293.32 225,713.0087,514.96 87,781.0032,578.92 27,738.0010,091.54 61,861.0022,089.60 52,791.0020,683.86 119,017.0049,072.13 73,155.0028,003.74 48,007.0019,209.82 27,312.0010,499.07 83,735.8032,020.30 39,792.2016,006.37 150,337.2056,259.38 49,262.0019,088.07 80,842.0030,566.43 68,165.0031,946.86 57,826.0020,432.87 169,513.5064,451.36 46,243.2018,718.74 60,735.0021,733.05 36,938.0014,144.45 69,088.0022,770.55 144,717.0053,529.84 143,178.0053,815.57 64,120.0027,220.60 72,720.0027,514.13 134,295.0051,111.86 154,230.0057,516.18 147,275.2055,259.29 88,067.0032,786.34 153,762.0058,099.51 91,776.5035,378.17 132,376.0049,560.62 267,968.00101,538.92 89,749.0037,454.80 184,037.0070,037.31 138,033.0053,140.45 107,421.0040,346.81 102,873.0036,460.34 279,503.5438,299.40

89,907.0033,495.39 86,219.0034,388.27 75,627.0029,372.07 44,867.0013,393.43 34,733.2010,761.82 44,269.0016,708.48 53,034.0020,393.67 120,190.0045,913.90 81,298.4031,574.59 70,575.0026,597.65 59,202.0020,915.93 46,661.0017,428.09 31,012.0011,155.84 66,526.0024,139.33 76,487.0026,350.97 92,477.0031,745.84 63,523.0022,896.33 68,748.5024,883.33 67,939.0024,401.79 41,735.0014,033.92 85,948.0031,323.68 79,895.0028,975.01 54,622.0019,434.14 41,125.0015,340.69 25,843.009,296.13 43,769.5015,671.04 47,785.0017,446.09 54,112.0018,325.69 41,391.0015,302.06 13,902.204,851.37 60,476.5022,306.30 41,917.0014,076.55 57,255.6019,604.20 51,085.5017,406.07 59,378.0021,060.84 249,321.5088,623.41 99,811.0036,295.97 104,198.0037,273.60 72,584.0028,174.69 32,033.0012,905.52 49,939.0019,900.90 75,841.0029,013.92

100,483.5034,143.90 31,398.0012,056.14 97,840.5036,131.02 78,690.0028,750.52 26,127.508,951.88 34,785.5012,430.58 39,418.0014,499.12 55,732.0021,030.08 55,254.0020,277.18 19,707.006,777.39 57,062.0020,972.25 130,192.5046,208.17 86,772.0031,355.81 103,890.0039,519.21 107,766.0038,357.70 57,502.0020,867.31 116,300.0040,945.10 63,287.0022,490.31 112,345.0039,869.15 80,036.0028,736.46 73,686.5023,879.99 47,394.5017,636.83