在线等！怎么用excel把图书名称进行分类？ 用EXCEL表格 把10个词语任选5个进行组合，请问怎么操作...
\u5728EXCEL 200\u7248\u672c\u4e2d \u600e\u4e48\u5b9e\u73b0\u76f8\u540c\u7c7b\u4f3c\u540d\u79f0\u7684\u7b5b\u9009\u7edf\u8ba1 \u5728\u7ebf\u7b49 \u6025\u5594\uff01~\u8fd9\u7528\u4e0d\u7740\u5199\u516c\u5f0f\u7684\uff0c\u76f4\u63a5\u7528\u6570\u636e\u900f\u89c6\u8868\u5c31\u80fd\u641e\u5b9a\u3002
\u6211\u503e\u5411\u4e8e\u7528\u5b8f\u89e3\u51b3\u3002\u5427\u8fd910\u4e2a\u8bcd\u8bed\u8f93\u5165\u5230\u5355\u5143\u683cA1\u5230J1\u91cc\uff0c\u540c\u65f6\u6309Alt\u548cF11\u8fdb\u5165\u5b8f\u754c\u9762\uff0c\u70b9\u83dc\u5355\u7684\u63d2\u5165\uff0c\u6a21\u5757\uff0c\u7c98\u8d34\u5982\u4e0b\u4ee3\u7801\uff1a
Sub test()
Dim i, j, k1, k2, k3, k4, k5 As Byte
Dim xRng As Range
Range("A2:A253").ClearContents
j = --InputBox("\u8bf7\u95ee\u9700\u8981\u968f\u673a\u7ec4\u6210\u51e0\u4e2a\u8bcd\u7ec4\uff082\u548c252\u4e4b\u95f4\u7684\u6574\u6570\uff09\uff1f", "Hi")
Set xRng = Range("A2:A" & j + 1)
Do While i < j
k1 = Int(Rnd * 10) + 1
k2 = Int(Rnd * 10) + 1
Do While k2 = k1
k2 = Int(Rnd * 10) + 1
Loop
k3 = Int(Rnd * 10) + 1
Do While k3 = k1 Or k3 = k2
k3 = Int(Rnd * 10) + 1
Loop
k4 = Int(Rnd * 10) + 1
Do While k4 = k1 Or k4 = k2 Or k4 = k3
k4 = Int(Rnd * 10) + 1
Loop
k5 = Int(Rnd * 10) + 1
Do While k5 = k1 Or k5 = k2 Or k5 = k3 Or k5 = 94
k5 = Int(Rnd * 10) + 1
Loop
If WorksheetFunction.CountIf(xRng, 1) = 0 Then
i = i + 1
Range("A" & i + 1) = Cells(1, k1) & Cells(1, k2) & Cells(1, k3) & Cells(1, k4) & Cells(1, k5)
End If
Loop
End Sub
\u76f4\u63a5\u6309F5\u8fd0\u884c\u6b64\u5b8f\uff0c\u8f93\u5165\u4f60\u8981\u7684\u7ec4\u5408\u6570\uff0c\u5b8c\u6210\u3002
仅凭书名excel是不知道他归在哪一类的。
如果已有一列是分类，那么就好办了。排序即可
数据—筛选—自动筛选
你试下
筛选，排序。
绛旓細濡傛灉宸叉湁涓鍒楁槸鍒嗙被锛岄偅涔堝氨濂藉姙浜嗐傛帓搴忓嵆鍙
绛旓細Lookup_value涓洪渶瑕鍦鏁版嵁琛ㄧ涓鍒椾腑杩涜鏌ユ壘鐨勬暟鍊笺俆able_array涓洪渶瑕佸湪鍏朵腑鏌ユ壘鏁版嵁鐨勬暟鎹〃銆俢ol_index_num涓簍able_array 涓煡鎵炬暟鎹殑鏁版嵁鍒楀簭鍙枫俁ange_lookup涓轰竴閫昏緫鍊硷紝鎸囨槑鍑芥暟 VLOOKUP 鏌ユ壘鏃舵槸绮剧‘鍖归厤锛岃繕鏄繎浼煎尮閰嶃傚鏋滀负FALSE鎴0 锛屽垯杩斿洖绮剧‘鍖归厤锛屽鏋滄壘涓嶅埌锛屽垯杩斿洖閿欒鍊 #N/A銆傜瓟...
绛旓細1銆佷互excel2010鐗堟湰涓轰緥锛屽涓嬪浘鎵绀猴紝瑕佺粺璁″懆閿閲鍦650浠ヤ笂鍚650鐨鍥句功绉嶇被鏈夊灏戯紱2銆侀鍏堝湪C2鍗曞厓鏍艰緭鍏ュ叕寮=COUNTIF(B:B,">=650")锛屽垯鏄粺璁鍒楁湁澶氬皯涓暟鎹ぇ浜庣瓑浜650锛3銆佸涓嬪浘鎵绀猴紝鎸塭nter閿悗鍒欏彲寰楀嚭缁熻缁撴灉銆
绛旓細鐐广愭彃鍏ャ戦噷闈㈢殑绗竴涓浘鏍囥愭暟鎹忚琛ㄣ戯紝鐒跺悗鎷栧姩榧犳爣灏卞彲浠ヤ簡銆傛妸涔︾睄鍚嶇О銆佷綔鑰呬俊鎭佸垎绫诲彿銆佸垎绫诲悕绉般佸嚭鐗堢ぞ鍚嶇О鎷栧姩鍒拌鏍囩锛屼功绫嶄环鏍笺佽棌涔︽暟閲忔嫋鍔ㄥ埌鏁版嵁
绛旓細鏈変互涓嬪嚑椤瑰唴瀹瑰嵆鍙紝鍥句功绫诲埆锛屽浘涔﹀悕绉帮紝瀛樻斁浣嶇疆
绛旓細鏃㈢劧杩欎簺璁板綍瀛楁绗﹀悎绯荤粺鐨勮姹傦紝鎺ヤ笅鏉ュ氨闇瑕佷綘鐨鍥句功棣嗙鐞嗙郴缁熸彁渚涙暟鎹鍏ュ姛鑳藉嵆鍙傛妸琛ㄦ牸涓殑鏁版嵁杞崲鎴愪綘鐨勫浘涔﹂绠＄悊绯荤粺鎺ュ彈鐨勫鍏ユ牸寮忥紝鐢ㄧ鐞嗙郴缁熶腑鐨勨滄暟鎹鍏モ濆姛鑳借浆鍏ュ嵆鍙傚鏋滀綘鐨勫浘涔﹂绠＄悊绯荤粺鏈彁渚涒滄暟鎹鍏モ濆姛鑳斤紝鍒欓渶瑕佷綘鑷繁浠庢暟鎹簱鍚庡彴瀵煎叆--鎿嶄綔璧锋潵楹荤儲涓浜涳紝鑰屼笖瑕佹眰鍔″繀灏忓績...
绛旓細棣栧厛杈撳叆鈥=vlookup 灏变細濡傚浘鏄剧ず銆傜涓姝ユ牴鎹粈涔堬紝涔熷氨鏄牴鎹鍥句功缂栧彿锛屾煡鎵惧浘涔﹀悕绉帮紝杈撳叆鍥句功缂栧彿鐨勯偅涓牸瀛愶紝閫楀彿锛屽鍥炬墍绀恒傜浜屾锛 鍘诲摢閲岋紝涔熷氨鏄瑕佸幓閭ｇ墖鍖哄煙鏌ユ壘闇瑕佸緱鍒扮殑涓滆タ銆傗滃浘涔﹀悕绉扳濆拰鈥滃浘涔︾紪鍙封濈殑瀵瑰簲鍏崇郴鍦缂栧彿瀵圭収宸ヤ綔琛ㄤ腑銆傛墍浠ュ幓缂栧彿瀵圭収宸ヤ綔琛ㄧ殑濡傚浘鍖哄煙銆傜涓夋锛屽浘涔...
绛旓細鍦杩欓噷杩涜鍒嗗竷璁＄畻鏂规硶锛1銆佹眰涓绉嶇被鍒鍥句功鐨勬讳环鏍糞锛=sum锛坕f(a1锛歛n=鑷劧绉戝锛宐1锛歜n,0)锛夛級鍚屾椂鎸変笅ctrl+shift+enter銆2銆佹眰杩欑被鍥句功鐨勪釜鏁癟=countif(a1锛歛n,鈥滆嚜鐒剁瀛︹)鎸塭nter锛3銆佽繘琛屽钩鍧囦环璁＄畻p=round锛圫/T,2锛夊洖杞﹀嵆鍙傝繖鏍蜂笉鐭ラ亾鑳藉惁瑙ｅ喅鎮ㄩ棶棰樸傚笇鏈涗綘鏃╂棩瑙ｅ喅 ...
绛旓細闂涓锛氫功鐩簱瀛樿〃鏍鎬庝箞鍋氾紵 寮勪笁鍒楋細鍏ュ簱 鍑哄簱 搴撳瓨 鍏朵腑搴撳瓨=鍏ュ簱-鍑哄簱 鐢ㄤ竴涓叕寮忔悶瀹 闂浜岋細Excel琛ㄦ牸鍒朵綔鐨鍥句功淇℃伅 鍑虹増绀: 涓婃捣绉戝鏅強鍑虹増绀; 绗1鐗 (2009骞8鏈1鏃)涓涗功鍚: 鏂版墜瑙嗗惉杞绘澗瀛︾郴鍒楀钩瑁: 218椤垫鏂囪绉: 绠浣撲腑鏂囧紑鏈: 16ISBN: 9787542717993, 7542717995鏉″舰鐮: ...
绛旓細渚夸簬鍥句功妫绱㈠拰閿鍞傚昂瀵告柟闈紝涔︾睄澶у皬涓25.8鍘樼背瀹姐18.8鍘樼背楂橈紝鍘氬害涓3.2鍘樼背锛屾讳綋閲嶉噺绾︿负540鍏嬶紝鏃犺鏄槄璇讳綋楠岃繕鏄瓨鍌ㄩ兘鍗佸垎鑰冭檻鍒颁簡瀹炵敤鎬у拰渚挎惡鎬с傛棤璁烘槸涓撲笟鍥句功绠＄悊鍛橈紝杩樻槸甯屾湜鎻愬崌Excel鎶鑳界殑涓汉锛岃繖鏈功閮藉皢涓轰綘鎻愪緵澶勭悊鍥句功淇℃伅鐨勯珮鏁堝伐鍏峰拰鏂规硶锛屽府鍔╀綘蹇熶笂鎵嬪苟鎺屾彙杩欎竴鎶鑳姐
