You're welcome. Thanks for the feedback!

Biff

"csong005" wrote in message
...
T. Valko

Thanks for the help!!!! It works perfectly.

csong005

"T. Valko" wrote:

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.