閱: 1805 | 回: 1
等級(jí):學(xué)有小成
-
積分:10
-
財(cái)富值:2.00
-
身份:普通用戶
06,07,08,10,12,13,15,17,18,19,20,21,22,24,26,27,28,29,30,31
04,05,08,09,10,12,14,15,16,17,20,21,22,23,24,25,26,27,28,30
06,07,08,09,10,12,14,15,16,17,18,19,21,23,24,25,26,27,28,30
05,06,07,08,10,14,15,16,17,18,19,20,21,22,23,24,25,26,28,30
04,06,08,09,11,12,13,16,18,20,21,22,23,24,25,26,27,28,29,30
06,08,09,10,13,15,16,17,18,19,20,21,22,23,24,26,27,29,30,31
05,07,08,09,12,13,15,16,17,18,19,20,21,22,23,24,25,26,27,28
05,06,07,08,09,11,12,13,14,15,16,19,20,21,22,24,27,29,30,31
05,06,07,08,09,11,12,13,14,15,16,17,19,20,21,22,23,27,29,30
05,07,08,10,11,15,16,17,18,19,20,22,23,24,25,26,28,29,30,31
04,06,09,10,12,13,14,15,16,17,18,20,21,24,25,26,27,29,30,31
04,05,06,09,10,11,12,14,15,17,18,19,20,21,22,23,24,25,26,27
04,06,07,08,09,10,11,12,13,15,16,17,18,21,22,23,27,28,29,30
07,08,09,10,12,13,14,15,16,17,18,19,20,22,23,25,26,27,28,30
04,05,06,07,09,10,12,13,14,17,18,20,21,22,24,25,26,28,29,30
05,06,07,08,09,11,14,15,17,18,19,20,21,22,24,26,27,28,30,31
07,08,09,10,11,12,13,14,16,18,19,20,22,24,25,26,27,29,30,31
04,05,06,07,08,09,12,13,14,17,19,20,21,23,25,26,27,28,29,30
05,06,07,08,12,13,14,15,16,17,18,19,20,21,23,25,26,27,28,29
05,06,08,09,10,11,12,16,18,19,20,21,22,24,25,26,27,28,30,31
04,06,07,08,10,11,12,14,15,17,18,20,22,23,24,25,26,27,29,30
06,09,10,12,13,14,16,17,18,19,20,21,23,24,25,26,27,28,29,30
05,06,07,09,10,11,12,13,14,15,16,17,19,21,22,23,24,25,27,28
04,05,06,07,08,10,11,12,14,17,18,19,20,21,22,23,24,25,27,28
05,07,08,09,10,11,14,15,17,18,19,20,21,23,25,26,27,29,30,31
06,08,09,10,11,12,13,14,15,18,19,20,21,22,23,24,26,27,29,30
04,05,06,08,09,10,11,12,13,14,19,20,22,24,25,26,27,28,30,31
06,07,09,10,12,14,15,16,17,18,19,20,21,22,23,24,27,28,29,30
06,07,08,10,11,13,14,15,16,17,18,19,21,22,23,24,25,27,29,30
04,05,08,09,10,12,14,15,16,17,20,21,22,23,24,25,26,27,28,30
06,07,08,09,10,12,14,15,16,17,18,19,21,23,24,25,26,27,28,30
05,06,07,08,10,14,15,16,17,18,19,20,21,22,23,24,25,26,28,30
04,06,08,09,11,12,13,16,18,20,21,22,23,24,25,26,27,28,29,30
06,08,09,10,13,15,16,17,18,19,20,21,22,23,24,26,27,29,30,31
05,07,08,09,12,13,15,16,17,18,19,20,21,22,23,24,25,26,27,28
05,06,07,08,09,11,12,13,14,15,16,19,20,21,22,24,27,29,30,31
05,06,07,08,09,11,12,13,14,15,16,17,19,20,21,22,23,27,29,30
05,07,08,10,11,15,16,17,18,19,20,22,23,24,25,26,28,29,30,31
04,06,09,10,12,13,14,15,16,17,18,20,21,24,25,26,27,29,30,31
04,05,06,09,10,11,12,14,15,17,18,19,20,21,22,23,24,25,26,27
04,06,07,08,09,10,11,12,13,15,16,17,18,21,22,23,27,28,29,30
07,08,09,10,12,13,14,15,16,17,18,19,20,22,23,25,26,27,28,30
04,05,06,07,09,10,12,13,14,17,18,20,21,22,24,25,26,28,29,30
05,06,07,08,09,11,14,15,17,18,19,20,21,22,24,26,27,28,30,31
07,08,09,10,11,12,13,14,16,18,19,20,22,24,25,26,27,29,30,31
04,05,06,07,08,09,12,13,14,17,19,20,21,23,25,26,27,28,29,30
05,06,07,08,12,13,14,15,16,17,18,19,20,21,23,25,26,27,28,29
05,06,08,09,10,11,12,16,18,19,20,21,22,24,25,26,27,28,30,31
04,06,07,08,10,11,12,14,15,17,18,20,22,23,24,25,26,27,29,30
06,09,10,12,13,14,16,17,18,19,20,21,23,24,25,26,27,28,29,30
05,06,07,09,10,11,12,13,14,15,16,17,19,21,22,23,24,25,27,28
04,05,06,07,08,10,11,12,14,17,18,19,20,21,22,23,24,25,27,28
05,07,08,09,10,11,14,15,17,18,19,20,21,23,25,26,27,29,30,31
06,08,09,10,11,12,13,14,15,18,19,20,21,22,23,24,26,27,29,30
04,05,06,08,09,10,11,12,13,14,19,20,22,24,25,26,27,28,30,31
06,07,09,10,12,14,15,16,17,18,19,20,21,22,23,24,27,28,29,30
06,07,08,10,11,13,14,15,16,17,18,19,21,22,23,24,25,27,29,30
以上數(shù)據(jù),是否可以用Excel或者其他的設(shè)定一個(gè)值,如圖
篩選出幾行中包含相同的內(nèi)容
我的個(gè)性簽名
等級(jí):傳說(shuō)級(jí)人物-
積分:2734 -
財(cái)富值:4 -
身份:普通用戶
把你的數(shù)據(jù)分列一下成單獨(dú)的單元格就能使用這個(gè)提取重復(fù)值的功能了 http://www.microgift.cn/WenKu/article.aspx?id=55