On Mon, 19 Mar 2007 11:21:20 -0700, 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.
You could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/
and then use the UNIQUEVALUES formula to return a sorted array of the state
abbreviations.
Some something like
=INDEX(UNIQUEVALUES(rng,1),ROWS($1:1))
copy/dragged down would return a sequential list of the abbreviations.
--ron