software

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 amp; 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

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...l-new/200602/1

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?

Mark wrote:
gt;
gt; try using the autofilter option on your list of numbers and select the
gt; option to display only unique items. Then you can copy that list.

--

Dave Peterson

Chip Pearson has some techniques at:
www.cpearson.com/excel/duplicat.htm

quot;kbkst via OfficeKB.comquot; wrote:
gt;
gt; I am doing a copy and paste with phone numbers on my spreadsheet. I then
gt; manually have to search for duplicates. I there a way that excel can do that
gt; for me?
gt;
gt; Also, When I copy phone numbers, I must copy one number, go to spreadsheet
gt; and paste. Back amp; forth. Is there a way to highlight and copy all of the
gt; numbers I need on the page in one shot and then paste to my spreadsheet?
gt; Can't scroll down because they are far apart from eachother.
gt;
gt; Hope someone can help.
gt; kbkst
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...l-new/200602/1

--

Dave Peterson

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

George Gee

quot;kbkst via OfficeKB.comquot; lt;u18755@uwegt; wrote in message
news:5bfb1768fac9c@uwe...
gt;I am doing a copy and paste with phone numbers on my spreadsheet. I then
gt; manually have to search for duplicates. I there a way that excel can do
gt; that
gt; for me?
gt;
gt; Also, When I copy phone numbers, I must copy one number, go to
gt; spreadsheet
gt; and paste. Back amp; forth. Is there a way to highlight and copy all of the
gt; numbers I need on the page in one shot and then paste to my spreadsheet?
gt; Can't scroll down because they are far apart from eachother.
gt;
gt; Hope someone can help.
gt; kbkst
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...l-new/200602/1
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 Gee wrote:
gt;Assuming all your phone numbers are in column A:
gt;In a blank column:
gt; =IF(MAX(COUNTIF(A:A,A:A))gt;1,quot;Duplicatequot;,quot;Non Duplicatequot;)
gt;Copy this formula down the column.
gt;If you need more help with this, post back.
gt;
gt;George Gee
gt;
gt;gt;I am doing a copy and paste with phone numbers on my spreadsheet. I then
gt;gt; manually have to search for duplicates. I there a way that excel can do
gt;[quoted text clipped - 9 lines]
gt;gt; Hope someone can help.
gt;gt; kbkst

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...l-new/200602/1

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))gt;1,quot;Duplicatequot;,quot;Non Duplicatequot;)
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 Geequot;kbkst via OfficeKB.comquot; lt;u18755@uwegt; wrote in message
news:5c43b79e14a06@uwe...
gt; George Gee:
gt; I need help. Cannot get this to work. My numbers are pasted in Column C
gt; starting with row 2 and going down the page. I went into column D2 and
gt; typed
gt; the formula changing the A's to C's. But how do I copy this formula into
gt; my
gt; numbers in the previous column?
gt; Thanks,
gt; kbkst
gt;
gt; George Gee wrote:
gt;gt;Assuming all your phone numbers are in column A:
gt;gt;In a blank column:
gt;gt; =IF(MAX(COUNTIF(A:A,A:A))gt;1,quot;Duplicatequot;,quot;Non Duplicatequot;)
gt;gt;Copy this formula down the column.
gt;gt;If you need more help with this, post back.
gt;gt;
gt;gt;George Gee
gt;gt;
gt;gt;gt;I am doing a copy and paste with phone numbers on my spreadsheet. I then
gt;gt;gt; manually have to search for duplicates. I there a way that excel can do
gt;gt;[quoted text clipped - 9 lines]
gt;gt;gt; Hope someone can help.
gt;gt;gt; kbkst
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...l-new/200602/1
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 quot;duplicatequot;, but does not delete the
numbers.

kbkst

George Gee wrote:
gt;You don't copy the formula into the 'C' column.
gt;You copy the formula into all the rows in the 'D' column,
gt;alongside all the cells that contain your pasted numbers.
gt;Copy and paste this formula into D2,
gt;=IF(MAX(COUNTIF(C:C,C:C))gt;1,quot;Duplicatequot;,quot;Non Duplicatequot;)
gt;Drag it down the column as far as you have numbers in Column C.
gt;Or with D2 selected, double-click the small black square at the
gt;bottom right of the cell.
gt;
gt;George Gee
gt;
gt;gt; George Gee:
gt;gt; I need help. Cannot get this to work. My numbers are pasted in Column C
gt;[quoted text clipped - 19 lines]
gt;gt;gt;gt; Hope someone can help.
gt;gt;gt;gt; kbkst

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...l-new/200602/1

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 gt; Click Data on the top toolbar gt; Filter gt;
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 gt; Filter gt; 'Show all'.

George Gee
quot;kbkst via OfficeKB.comquot; lt;u18755@uwegt; wrote in message
news:5c458f6da91b2@uwe...
gt; It worked!! Thank you so much. Do you know how to delete the duplicate
gt; numbers? When I do a delete row for a number it deletes the first number
gt; and
gt; then deletes all the text that says quot;duplicatequot;, but does not delete the
gt; numbers.
gt;
gt; kbkst
gt;
gt; George Gee wrote:
gt;gt;You don't copy the formula into the 'C' column.
gt;gt;You copy the formula into all the rows in the 'D' column,
gt;gt;alongside all the cells that contain your pasted numbers.
gt;gt;Copy and paste this formula into D2,
gt;gt;=IF(MAX(COUNTIF(C:C,C:C))gt;1,quot;Duplicatequot;,quot;Non Duplicatequot;)
gt;gt;Drag it down the column as far as you have numbers in Column C.
gt;gt;Or with D2 selected, double-click the small black square at the
gt;gt;bottom right of the cell.
gt;gt;
gt;gt;George Gee
gt;gt;
gt;gt;gt; George Gee:
gt;gt;gt; I need help. Cannot get this to work. My numbers are pasted in Column
gt;gt;gt; C
gt;gt;[quoted text clipped - 19 lines]
gt;gt;gt;gt;gt; Hope someone can help.
gt;gt;gt;gt;gt; kbkst
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...l-new/200602/1