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 Formula to look up duplicates

Ok here is the senario.
I have huge spreedsheet that
is driven by a tabale area taht
poplutes and adress, st, zip ect.
Driven off the phone # in the table array.
The main sheet in about 50K rows.
I would like a formula tath I could put in the
last column, that would chekc phone number
column for duplicates and return a true or
false if this text in fact duplicated in the phone #
column.
Please advise
DL