排名後查表 算上下值差 (13317)

D11=SUM(VLOOKUP(N(IF({1},RANK(C11,C:C)-{0,1})),F:G,2,)*{1,-1})*C11

另解=-C11*NPV(-2,VLOOKUP(N(IF({1},RANK(C11,C:C)-{0,1})),F:G,2,))

另解=LOOKUP(RANK(C11,C:C),F$12:F$21,G$12:G$21-G$11:G$20)*C11