查找不重复值函数方法集锦_chrisfang.xls

data={1;2;1;2;"a";"a";"b"}rw=ROW(INDIRECT("1:"&ROWS(data)))rw:newdata:11223a4b567newdata1=SMALL(IF(FREQUENCY(order,order),order),R...