Prev: League Table
Next: Average of a string containing multiple values
From: nozzaworld on 22 Feb 2010 07:36
I am using excel 2002. I have a row of data, with some duplicated records. I
want to be able to delete ALL duplicates.

e.g.
bob
bob
scott
john

would delete all record of bob leaving just the following:

scott
john

How can I achieve this? Any help will be greatly apprenciated.

Many thanks

--
nozzaworld


"muddan madhu" wrote:

> use helping column
>
> In Cell B2 put this formula and drag it down
>
> =IF(A2=A1,"duplicate","unique")
>
> use filter to delete the duplicate
>
>
> On Feb 12, 6:01 pm, Emece <Em...(a)discussions.microsoft.com> wrote:
> > Hi.
> >
> > I have a workbook in Excel 2007 with several phone numbers. If the numbers
> > are duplicated I applied a conditional formatting so as to display them in
> > red, using the following formula: =COUNTIF($A:$A,$A2)>1. Additionally if the
> > value is repeated I need to delete one of the rows. Which is the best way to
> > do this?
> >
> > Thanks in advance
> >
> > Regards
> > Emece.-
>
>
 | 
Pages: 1
Prev: League Table
Next: Average of a string containing multiple values