Deleting rows with repeated number
 

I have a spreadsheet that has numbers repeated in a
certain column. I only need one column with each number.
Is there a way to quickly delete the repeated-numbered
rows?

Thank you!

Deleting rows with repeated number
 

Assuming in A,

in B1 add this formula, =COUNTIF(($A$1:A1,A1)1

Then add DataAUtofilter to this column, and filter on a value of TRUE.

The delete all of the visible rows.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Lopa" wrote in message
...
I have a spreadsheet that has numbers repeated in a
certain column. I only need one column with each number.
Is there a way to quickly delete the repeated-numbered
rows?

Thank you!

Deleting rows with repeated number
 

You could also look at Data / Filter / Advanced Filter / 'Copy To another
location' and 'Unique values only'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Mark Lopa" wrote in message
...
I have a spreadsheet that has numbers repeated in a
certain column. I only need one column with each number.
Is there a way to quickly delete the repeated-numbered
rows?

Thank you!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004