Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with An Array Formula and Duplicates | Excel Worksheet Functions | |||
Duplicates Formula | Excel Worksheet Functions | |||
Duplicates in Rand Formula | Excel Discussion (Misc queries) | |||
Formula to recognize Duplicates | Excel Worksheet Functions | |||
Formula that recognizes duplicates | Excel Worksheet Functions |