Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicates in 1 column
I have a spread sheet w/ over 1000 client names. I need a formula that will let me know if a client shows up more than once in the column. My brain is dead trying to think of the formula..Any help would be appreciated! I have a time schedule on this-so hopefully I can get help fast! Thanks in advance! -- Delaina ------------------------------------------------------------------------ Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151 View this thread: http://www.excelforum.com/showthread...hreadid=388694 |
#2
|
|||
|
|||
Hi,
If names appear in Col A then in A1: =IF(COUNTIF($A$1:A1,A1)1,"Duplicate","Unique"). Copy the formula and paste to end of range within Col B. Regards, A -- Please rate my response if you found it helpful. Thanks. "Delaina" wrote: I have a spread sheet w/ over 1000 client names. I need a formula that will let me know if a client shows up more than once in the column. My brain is dead trying to think of the formula..Any help would be appreciated! I have a time schedule on this-so hopefully I can get help fast! Thanks in advance! -- Delaina ------------------------------------------------------------------------ Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151 View this thread: http://www.excelforum.com/showthread...hreadid=388694 |
#3
|
|||
|
|||
Hi, Delaina. Try this:
http://www.officearticles.com/excel/...ft_excel. htm ******************* ~Anne Troy www.OfficeArticles.com "Delaina" wrote in message ... I have a spread sheet w/ over 1000 client names. I need a formula that will let me know if a client shows up more than once in the column. My brain is dead trying to think of the formula..Any help would be appreciated! I have a time schedule on this-so hopefully I can get help fast! Thanks in advance! -- Delaina ------------------------------------------------------------------------ Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151 View this thread: http://www.excelforum.com/showthread...hreadid=388694 |
#4
|
|||
|
|||
Good afternoon Delaina Chip Pearson has come up with several ways of dealing with duplicates in lists. Check out his fine pages he http://www.cpearson.com/excel/duplicat.htm HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=388694 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |