View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
csong005 csong005 is offline
external usenet poster
 
Posts: 3
Default Return unique data from a list

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.