View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gotroots Gotroots is offline
external usenet poster
 
Posts: 114
Default Deifine range ignoring duplicates

In Define Name in Excel 2007 I want to create a formula for A:A that excludes
duplicates in the range.

How do you create this formula.