如何从excel表里面用函数随机抽取男女各两名?答:I$3:I$4,I3)>1),INDEX($C:$C,INDEX(SMALL(IF($B$3:$B$19=I$2,ROW($3:$19),4^10),ROW(INDIRECT("1:"&COUNTIF($B$3:$B$19,I$2))),RANDBETWEEN(1,COUNTIF($B$3:$B$19,I$2))),I3))同时按Ctrl+Shift+Enter三键输入数组公式,右拉J2,再一起下拉到第I3:J3 ...
现在有身份证和性别信息,如何用EXCEL筛选出不同年龄段的男性和女性?答:=IF(IF(MOD(MID(D2,15,3),2),"男","女")="男",IF(YEAR(TODAY())-MID(D2,7,4)>60,"Y",""),IF(YEAR(TODAY())-MID(D2,7,4)>55,"Y",""))