|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 21st, 2009, 08:57 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding duplicates in column
Hi,
I have Excel 2002 and have 6000 emails addresses in a column. How can I find if there are any duplicates in that column? Thanks rock 
|
|
#2
August 21st, 2009, 09:10 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Finding duplicates in column
Assuming the data is in column A, add a formula in column B of
=IF(COUNTIF($A$1:$A1,$A1)1,"Duplicate","") Cpy that down, then you can filter column B for Duplicate
|
|
#3
August 21st, 2009, 11:52 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Finding duplicates in column
Sorry to be so newby Bob, but when you say 'copy' down, what exactly do you mean? I have entered the formula in B1 but.. Thanks rock Bob Phillips wrote: Assuming the data is in column A, add a formula in column B of =IF(COUNTIF($A$1:$A1,$A1)1,"Duplicate","") Cpy that down, then you can filter column B for Duplicate
|
|
#4
August 21st, 2009, 12:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Finding duplicates in column
Hi,
if you have 6000 rows what he means is to copy the formula from B1 all the way down to B6000. How you do that two ways 1 select the cell where the formula is, right click on the mouse, copy, then go one cell down, highlight from there to the last row where you see information in column A, right click on the mouse, paste 2 having the cell with the formula highlighted, move the mouse to the right bottom corner untill you see a bold cross like this +, when you see it double click in the mouse, it will copy the formula down up to it find a blank in the adjacent column in your case column A "rock" wrote: Sorry to be so newby Bob, but when you say 'copy' down, what exactly do you mean? I have entered the formula in B1 but.. Thanks rock Bob Phillips wrote: Assuming the data is in column A, add a formula in column B of =IF(COUNTIF($A$1:$A1,$A1)1,"Duplicate","") Cpy that down, then you can filter column B for Duplicate
|
|
#5
August 21st, 2009, 08:32 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Finding duplicates in column
Hi Rock,
Another way is to use Conditional Formatting under Format. Select the 6000 cells in the column and then Format Conditional Formatting click the down arrow for Formula Is enter =COUNTIF($A$1:$A$10,A1)1 click Format Patterns select a color OK your way out. Any duplicates will be highlighted in that color. HTH Regards, Howard "rock" wrote in message ... Hi, I have Excel 2002 and have 6000 emails addresses in a column. How can I find if there are any duplicates in that column? Thanks rock
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
