求助,请哪位帮助我解决一个excel分组情况下的排列组合问题
http://zhidao.baidu.com/question/528532689.html?fr=iks&word=excel+%B1%ED%B8%F1%B5%C4%CE%CA%CC%E2%2C%CE%D2%D3%D016%D7%E9%CA%FD%BE%DD%2C%C3%BF%D7%E97%B8%F6%CA%FD%D7%D6%2C%D3%D0%C4%C7%D0%A9%D7%E9%D7%E9%BA%CF%2C%D6%D8%B8%B4%D6%B5%D3%D06%B8%F6&ie=gbk ——百度知道
-
答:假设七组数据分别在A1:G4区域 则按下图,在A7中输入公式:=INDEX(A$1:A$4,MOD(INT((ROW(A1)-1)/4^(7-COLUMN(A1))),4)+1)向右拉到G7,再