for 2007以上版本或wps
=IFERROR(INDEX($C$3:$C$11,SMALL(IF(MATCH($C$3:$C$11,$C$3:$C$11,0)=ROW($C$3:$C$11)-2,ROW($C$3:$C$11)-2),ROW(A1))),"")
ctrl+shift+enter
for 2003
=IF(ISERROR(INDEX($C$3:$C$11,SMALL(IF(MATCH($C$3:$C$11,$C$3:$C$11,0)=ROW($C$3:$C$11)-2,ROW($C$3:$C$11)-2),ROW(A1)))),"",INDEX($C$3:$C$11,SMALL(IF(MATCH($C$3:$C$11,$C$3:$C$11,0)=ROW($C$3:$C$11)-2,ROW($C$3:$C$11)-2),ROW(A1))))
ctrl+shift+enter