software

I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
success. Any ideas. M I missing some'ting?

What are you doing? Just select the row you want to delete, right click and
select DELETE.

quot;mickeyfinzquot; wrote:

gt; I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
gt; success. Any ideas. M I missing some'ting?

I have a list of approx 3000 names and fax #'s. Included are about 600
duplicates that I want to delete so I have one name and fax number per line
with no duplications. I have followed the instructions in quot;HELPquot; w/o any
success. I was wondering if I am not alone?

quot;Barb Reinhardtquot; wrote:

gt; What are you doing? Just select the row you want to delete, right click and
gt; select DELETE.
gt;
gt; quot;mickeyfinzquot; wrote:
gt;
gt; gt; I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
gt; gt; success. Any ideas. M I missing some'ting?

I have no idea what you are checking in HELP. YOu may want to use a PIVOT
Table to determine which are dups. You could also use conditional
formatting to determine the dups using COUNTIF

www.mrexcel.com/tip063.shtml

quot;mickeyfinzquot; wrote:

gt; I have a list of approx 3000 names and fax #'s. Included are about 600
gt; duplicates that I want to delete so I have one name and fax number per line
gt; with no duplications. I have followed the instructions in quot;HELPquot; w/o any
gt; success. I was wondering if I am not alone?
gt;
gt; quot;Barb Reinhardtquot; wrote:
gt;
gt; gt; What are you doing? Just select the row you want to delete, right click and
gt; gt; select DELETE.
gt; gt;
gt; gt; quot;mickeyfinzquot; wrote:
gt; gt;
gt; gt; gt; I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
gt; gt; gt; success. Any ideas. M I missing some'ting?


Hi, I am no expert but this is what I use to filter duplicate entries in
a list.

Say your names are in col A and your fax #'s are in col B.

Put this in col C and copy down.

=IF(COUNTIF($A$1:$A$1500,A1)gt;1,quot;Duplicatequot;,quot;quot;)

This will put quot;duplicatequot; in col C where there is a duplication in
names.

I then filter col C for quot;duplicatequot; and delete.

HTH.--
greg7468------------------------------------------------------------------------
greg7468's Profile: www.excelforum.com/member.php...foamp;userid=9031
View this thread: www.excelforum.com/showthread...hreadid=536360
Hi, I am no expert but this works for me.

=IF(COUNTIF(A1:$A$100,A1)gt;1,quot;Duplicatequot;,quot;quot;)

If names are in Col a, #'s are in Col B.

Put this in Col C and copy down.

This will put a quot;duplicatequot; in Col C where there is a name
replication.

Filter Col C to show quot;duplicatesquot; and delete.

HTH.--
greg7468------------------------------------------------------------------------
greg7468's Profile: www.excelforum.com/member.php...foamp;userid=9031
View this thread: www.excelforum.com/showthread...hreadid=536360Use the advanced filter method.

See Debra Dalgleish's site for instructions.

www.contextures.on.ca/xladvfi....html#FilterUR
Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 06:47:02 -0700, mickeyfinz
gt; wrote:

gt;I have a list of approx 3000 names and fax #'s. Included are about 600
gt;duplicates that I want to delete so I have one name and fax number per line
gt;with no duplications. I have followed the instructions in quot;HELPquot; w/o any
gt;success. I was wondering if I am not alone?
gt;
gt;quot;Barb Reinhardtquot; wrote:
gt;
gt;gt; What are you doing? Just select the row you want to delete, right click and
gt;gt; select DELETE.
gt;gt;
gt;gt; quot;mickeyfinzquot; wrote:
gt;gt;
gt;gt; gt; I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
gt;gt; gt; success. Any ideas. M I missing some'ting?