View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline
external usenet poster
 
Posts: 76
Default does anyone know this formula

Column A B C
(999) 000-0000
(999) 111-1111 TRUE (can this check the array for
duplicate and
render true if no
dup exists in the range
(999) 111-1111 FALSE (can this check the array for
duplicates and
render FALSE is
there is in fact a dup...

any suggestion