Duplicate numbers

  • Thread starter Thread starter kbkst via OfficeKB.com
  • Start date Start date
K

kbkst via OfficeKB.com

I am doing a copy and paste with phone numbers on my spreadsheet. I then
manually have to search for duplicates. I there a way that excel can do that
for me?

Also, When I copy phone numbers, I must copy one number, go to spreadsheet
and paste. Back & forth. Is there a way to highlight and copy all of the
numbers I need on the page in one shot and then paste to my spreadsheet?
Can't scroll down because they are far apart from eachother.

Hope someone can help.
kbkst
 
try using the autofilter option on your list of numbers and select the
option to display only unique items. Then you can copy that list.
 
What version of excel are you using?
try using the autofilter option on your list of numbers and select the
option to display only unique items. Then you can copy that list.
Click to expand...
 
Assuming all your phone numbers are in column A:
In a blank column:
=IF(MAX(COUNTIF(A:A,A:A))>1,"Duplicate","Non Duplicate")
Copy this formula down the column.
If you need more help with this, post back.

George Gee
 
George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column C
starting with row 2 and going down the page. I went into column D2 and typed
the formula changing the A's to C's. But how do I copy this formula into my
numbers in the previous column?
Thanks,
kbkst

George said:
Assuming all your phone numbers are in column A:
In a blank column:
=IF(MAX(COUNTIF(A:A,A:A))>1,"Duplicate","Non Duplicate")
Copy this formula down the column.
If you need more help with this, post back.

George Gee
I am doing a copy and paste with phone numbers on my spreadsheet. I then
manually have to search for duplicates. I there a way that excel can do
Click to expand...
[quoted text clipped - 9 lines]
Hope someone can help.
kbkst
Click to expand...
Click to expand...
 
You don't copy the formula into the 'C' column.
You copy the formula into all the rows in the 'D' column,
alongside all the cells that contain your pasted numbers.
Copy and paste this formula into D2,
=IF(MAX(COUNTIF(C:C,C:C))>1,"Duplicate","Non Duplicate")
Drag it down the column as far as you have numbers in Column C.
Or with D2 selected, double-click the small black square at the
bottom right of the cell.

George Gee


kbkst via OfficeKB.com said:
George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column C
starting with row 2 and going down the page. I went into column D2 and
typed
the formula changing the A's to C's. But how do I copy this formula into
my
numbers in the previous column?
Thanks,
kbkst

George said:
Assuming all your phone numbers are in column A:
In a blank column:
=IF(MAX(COUNTIF(A:A,A:A))>1,"Duplicate","Non Duplicate")
Copy this formula down the column.
If you need more help with this, post back.

George Gee
I am doing a copy and paste with phone numbers on my spreadsheet. I then
manually have to search for duplicates. I there a way that excel can do
Click to expand...
[quoted text clipped - 9 lines]
Hope someone can help.
kbkst
Click to expand...
Click to expand...
Click to expand...
 
It worked!! Thank you so much. Do you know how to delete the duplicate
numbers? When I do a delete row for a number it deletes the first number and
then deletes all the text that says "duplicate", but does not delete the
numbers.

kbkst

George said:
You don't copy the formula into the 'C' column.
You copy the formula into all the rows in the 'D' column,
alongside all the cells that contain your pasted numbers.
Copy and paste this formula into D2,
=IF(MAX(COUNTIF(C:C,C:C))>1,"Duplicate","Non Duplicate")
Drag it down the column as far as you have numbers in Column C.
Or with D2 selected, double-click the small black square at the
bottom right of the cell.

George Gee
George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column C
Click to expand...
[quoted text clipped - 19 lines]
Click to expand...
 
I'm not really sure what you are trying to do!
Do you wish to delete all the rows that have 'Duplicate' in Column 'D'?

If yes, then select D2 > Click Data on the top toolbar > Filter >
Autofilter.
This will put a small down arrow above all columns that contain data.
Click the down arrow in column 'D' and click on 'Duplicates'
This will show all the duplicate rows.
Select all the rows you wish to delete, by highlighting the row header
numbers,
right-click, select 'Delete row'.

Practise on a copy of your worksheet first.

To show all rows again: Data > Filter > 'Show all'.

George Gee



kbkst via OfficeKB.com said:
It worked!! Thank you so much. Do you know how to delete the duplicate
numbers? When I do a delete row for a number it deletes the first number
and
then deletes all the text that says "duplicate", but does not delete the
numbers.

kbkst

George said:
You don't copy the formula into the 'C' column.
You copy the formula into all the rows in the 'D' column,
alongside all the cells that contain your pasted numbers.
Copy and paste this formula into D2,
=IF(MAX(COUNTIF(C:C,C:C))>1,"Duplicate","Non Duplicate")
Drag it down the column as far as you have numbers in Column C.
Or with D2 selected, double-click the small black square at the
bottom right of the cell.

George Gee
George Gee:
I need help. Cannot get this to work. My numbers are pasted in Column
C
Click to expand...
[quoted text clipped - 19 lines]
Hope someone can help.
kbkst
Click to expand...
Click to expand...
Click to expand...
 
Back
Top