怎么设置A1随机等于下列某组的某个数值 K1=甲~庚

a1等于8，k1不就等于乙吗？

楼主是研究六合彩？

=CHOOSE((MATCH(A1,{6,14,18,21,25,34,44,8,17,19,22,24,30,42,1,4,10,13,26,28,33,3,15,16,27,35,46,47,7,9,11,12,39,40,49,2,23,31,36,38,43,45,5,20,29,32,37,41,48},)-1)/7+1,"甲","乙","丙","丁","戊","己","庚")
或=MID("甲乙丙丁戊己庚",(MATCH(A1,{6,14,18,21,25,34,44,8,17,19,22,24,30,42,1,4,10,13,26,28,33,3,15,16,27,35,46,47,7,9,11,12,39,40,49,2,23,31,36,38,43,45,5,20,29,32,37,41,48},)-1)/7+1,1)