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

Formula to look up duplicates
 

See Chip Pearson's site for methods of flagging duplicates.

http://www.cpearson.com/excel/Duplicates.aspx


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 16:54:00 -0800, Dylan @ UAFC
wrote:

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