excel中怎么把一列中的数值1-30的值都返回到另一列中为1答:在G2单元格输入公式:=IF(AND(C2>=30,C2<=60),A2&",",""),下拉至资料最后哪行,再在F2输入公式:=CONCATENATE(E2,E3,E4,E5,E6,E7,E8,E9,E10,E11,E12,E13,E14,E15,E16,E17,E18,E19,E20,E21,E22,E23,E24,E25,E26,E27,E28,E29,E30,E31)&CONCATENATE(E32,E33,E34,E35,E36,E37,...