Return unique data from a list
It is an array formula you have to commit with ctrl+shift+enter, not just enter
=IF(ISERR(SMALL(IF(FREQUENCY(MATCH($A$2:$A$10,$A$2 :$A$10,0),MATCH($A$2:$A$10,$A$2:$A$10,0))0,ROW(IN DIRECT("1:"&ROWS($A$2:$A$10)))),ROWS($1:1))),"",IN DEX($A$2:$A$10,SMALL(IF(FREQUENCY(MATCH($A$2:$A$10 ,$A$2:$A$10,0),MATCH($A$2:$A$10,$A$2:$A$10,0))0,R OW(INDIRECT("1:"&ROWS($A$2:$A$10)))),ROWS($1:1))))
Adjust to suit
"csong005" wrote:
Is there a formula to return a unique data from a list? For example, from
A2:A2000 there are names of States (i.e. CA, TX, NY, NJ, etc) that are
repeated. The list does not contain all 50 States and I need to isolate
which of the 50 states are included in the list. Thanks.
|