excel 一列数字取前三个不相同的数字的公式答:D16=IF(C16<>0,(C16*100+LOOKUP(1,0/($C$1:C15<>C16),$C$1:C15)*10+(LOOKUP(1,0/(($C$1:C15<>C16)*($C$1:C15<>LOOKUP(1,0/($C$1:C15<>C16),$C$1:C15))),$C$1:C15))&""),SUBSTITUTE((100+LOOKUP(1,0/($C$1:C15<>C16),$C$1:C15)*10+(LOOKUP(1,0/(...