作者:乔山办公网日期:
返回目录:excel表格制作
在H2单元格输入如下公式
=IF(COUNTIF(F1:F30,C1)>0,A2,"")
试试知以下公式道版
在G2中输入权
=SUMPRODUCT((D$2:D$6-C$2:C$6<=90)*B$2:B$6)
G3
=SUMPRODUCT((D$2:D$6-C$2:C$6>90)*(D2:D6-C2:C6<=360)*B$2:B$6)
G4
=SUMPRODUCT((D$2:D$6-C$2:C$6>360)*B$2:B$6)
=RANK(A1,A:A)
比如在A列
直接在B1输入公式=MIN(ABS(A1-{1,3,6,90,103,200}))然后下拉复制即可
祝你成功!