少1則由最小值補1,多1則以最大值減1。F2:=IF((SUM($E$2:$E$4)<C2) * (E2=MIN($E$2:$E$4)),E2+1,IF(...
我是以如果總和多1時,取最小的那個值減1。E1:=IF((SUM($D$2:$D$4)>$C$2)*(D2=SMALL($D$2:$D$4,1)),D2-...
模式1解法:G2:=IF(COUNTIF($A$1:A2,A2)=1,A2,"")H2:=TEXTJOIN(",",,I...
試試看 a=[] b=[3,2,1] for i in range(1,4): c = b.copy() a.append(c) b[1...