| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I find duplicates in one column of an exel spreadsheet?
I have a spreadsheet with over 2000 rows of data I would like to quickly
isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet?
Hi Bill,
try to use a pivot table hth regards from Brazil Marcelo "Bill in Wichita" escreveu: I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet?
Bill
If you just want to identify them and we'll say they are in A1:A2000 then in a spare column alongside enter =COUNTIF($A$1:$A$2000,A1) and copy down This will give you the number of times they appear in the list and you can autofilter or sort on that -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Bill in Wichita" <Bill in wrote in message ... I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet
Bewdy Nick, Simple and works a charm
"Nick Hodge" wrote: Bill If you just want to identify them and we'll say they are in A1:A2000 then in a spare column alongside enter =COUNTIF($A$1:$A$2000,A1) and copy down This will give you the number of times they appear in the list and you can autofilter or sort on that -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Bill in Wichita" <Bill in wrote in message ... I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet?
Actually, I had the same problem once.
First I did sort by this column. Suppose your column is A. on one empty column, for example E, in cell E2 put formula =If(A1=A2, 1, 0), and extend to all of the column E. Then all of the duplicated records will be found. sum of column E, you will know how many duplicates you've got. Hope it can send you help! Viesta Shanghai, CN "Bill in Wichita" wrote: I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet
This will give comparision result to one particular cell. What about other
duplicate values. Thank You Vij "ViestaWu" wrote: Actually, I had the same problem once. First I did sort by this column. Suppose your column is A. on one empty column, for example E, in cell E2 put formula =If(A1=A2, 1, 0), and extend to all of the column E. Then all of the duplicated records will be found. sum of column E, you will know how many duplicates you've got. Hope it can send you help! Viesta Shanghai, CN "Bill in Wichita" wrote: I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet
But of course! Thanks - you saved me! Forget the pivotal tables and the
formulas. This is much easier. Peggy "ViestaWu" wrote: Actually, I had the same problem once. First I did sort by this column. Suppose your column is A. on one empty column, for example E, in cell E2 put formula =If(A1=A2, 1, 0), and extend to all of the column E. Then all of the duplicated records will be found. sum of column E, you will know how many duplicates you've got. Hope it can send you help! Viesta Shanghai, CN "Bill in Wichita" wrote: I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find duplicates in one column of an exel spreadsheet?
"Bill in Wichita" wrote: I have a spreadsheet with over 2000 rows of data I would like to quickly isolate those with duplicate names or phone numbers. Can I do this in Filter? I know I can eliminate duplicates but I want to find them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a string within a column | Excel Discussion (Misc queries) | |||
| Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
Hybrid Mode
