| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I search for duplicate words in a column?
I need to check for duplicate names in a column. Is there a way to do this?
|
|
#2
|
|||
|
|||
|
Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet. Then, simply create a Pivot with the data of that single column. You will have to fist take it on rows and thewn again drag into data box as Count. That's it. Thanks, Manish Bajpai "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
|
#3
|
|||
|
|||
|
Without using pivot tables:
Assume your values are in the range A1:A10, paste this code in A1 and drag down: =IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup") -- David Billigmeier "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
|
#4
|
|||
|
|||
|
Sorry... I see a typo, paste that code in B1 :-)
-- David Billigmeier "David Billigmeier" wrote: Without using pivot tables: Assume your values are in the range A1:A10, paste this code in A1 and drag down: =IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup") -- David Billigmeier "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
|
#5
|
|||
|
|||
|
David,
You are simply great !! Nice to brainstorm with you. Thanks, Manish "David Billigmeier" wrote: Sorry... I see a typo, paste that code in B1 :-) -- David Billigmeier "David Billigmeier" wrote: Without using pivot tables: Assume your values are in the range A1:A10, paste this code in A1 and drag down: =IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup") -- David Billigmeier "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
|
#6
|
|||
|
|||
|
Definitelly, nice to have met a fellow Excel fanatic!
Regards, Dave -- David Billigmeier "Manish Bajpai" wrote: David, You are simply great !! Nice to brainstorm with you. Thanks, Manish "David Billigmeier" wrote: Sorry... I see a typo, paste that code in B1 :-) -- David Billigmeier "David Billigmeier" wrote: Without using pivot tables: Assume your values are in the range A1:A10, paste this code in A1 and drag down: =IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup") -- David Billigmeier "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Linear Mode
