close
杉林溪茶葉機能內衣動物叢林塑身衣
文章來自: http://tw.knowledge.yahoo.com/question/question?qid=1012111902061德州撲克乳酪蛋糕蜂蜜蛋糕黃金梭哈
L1︰Q1任貼一組期已開獎的號碼或填入任6個號碼~
各期中獎號碼相同個數︰
J2
=IF($B2="","",IF(COUNT(RANK($B2:$H2,$L$1:$Q$1)),COUNT(RANK($B2:$H2,$L$1:$Q$1)),""))
陣列~下拉填滿
各星數中獎總次數︰
S2
=IF(COUNTIF($J$2:$J$2000,S$1)>=1,COUNTIF($J$2:$J$2000,S$1),"")
右拉填滿
參考附件︰
http://www.FunP.Net/674286
文章來自: http://tw.knowledge.yahoo.com/question/question?qid=1012111902061德州撲克乳酪蛋糕蜂蜜蛋糕黃金梭哈
全站熱搜
留言列表
