Return unique data from a list
Try this:
Assumes no empty/blank cells within the range.
Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):
=IF(ROWS($1:1)<=SUM(1/COUNTIF(A$2:A$20,A$2:A$20)),INDEX(A$2:A$20,SMALL(I F(ROW(A$2:A$20)-MIN(ROW(A$2:A$20))+1=MATCH(A$2:A$20,A$2:A$20,0),RO W(A$2:A$20)-MIN(ROW(A$2:A$20))+1),ROWS($1:1))),"")
Copy down until you get blanks
Biff
"csong005" wrote in message
...
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.
|