[已解决]数据排列

丢丢铜

帮忙做个数据排列

最佳答案

月排行榜 / 总排行榜

baksy

2014-2-27 11:54

K3:Q3单元格的公式如下；
K3=IF(MOD(ROW()-1,2)=0,"男","女")
L3=INDIRECT(IF(MOD(ROW()-1,2)=0,"C","B")&INT((ROW()-1)/2)+1)
M3=IF(MOD(ROW()-1,2)=0,"",INDIRECT("D"&INT((ROW()-1)/2)+1))
N3=IF(MOD(ROW()-1,2)=0,INDIRECT("E"&INT((ROW()-1)/2)+1),"")
O3=IF(MOD(ROW()-1,2)=0,1,"")
P3=IF(MOD(ROW()-1,2)=1,1,"")
Q3=IF(MOD(ROW()-1,2)=0,INDIRECT("H"&INT((ROW()-1)/2)+1),"")

跳转到最佳答案楼层

baksy

K3:Q3单元格的公式如下；
K3=IF(MOD(ROW()-1,2)=0,"男","女")
L3=INDIRECT(IF(MOD(ROW()-1,2)=0,"C","B")&INT((ROW()-1)/2)+1)
M3=IF(MOD(ROW()-1,2)=0,"",INDIRECT("D"&INT((ROW()-1)/2)+1))
N3=IF(MOD(ROW()-1,2)=0,INDIRECT("E"&INT((ROW()-1)/2)+1),"")
O3=IF(MOD(ROW()-1,2)=0,1,"")
P3=IF(MOD(ROW()-1,2)=1,1,"")
Q3=IF(MOD(ROW()-1,2)=0,INDIRECT("H"&INT((ROW()-1)/2)+1),"")