How do I search for duplicate words in a column?

Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet.

Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.

That's it.

Thanks,

Manish Bajpai

"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Without using pivot tables:

Assume your values are in the range A1:A10, paste this code in A1 and drag
down:

=IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")

--
David Billigmeier


"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Sorry... I see a typo, paste that code in B1 :-)


--
David Billigmeier


"David Billigmeier" wrote:

> Without using pivot tables:
>
> Assume your values are in the range A1:A10, paste this code in A1 and drag
> down:
>
> =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
>
> --
> David Billigmeier
>
>
> "Krista" wrote:
>
> > I need to check for duplicate names in a column. Is there a way to do this?

David,

You are simply great !!

Nice to brainstorm with you.

Thanks,

Manish

"David Billigmeier" wrote:

> Sorry... I see a typo, paste that code in B1 :-)
>
>
> --
> David Billigmeier
>
>
> "David Billigmeier" wrote:
>
> > Without using pivot tables:
> >
> > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > down:
> >
> > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> >
> > --
> > David Billigmeier
> >
> >
> > "Krista" wrote:
> >
> > > I need to check for duplicate names in a column. Is there a way to do this?

Definitelly, nice to have met a fellow Excel fanatic!

Regards,
Dave


--
David Billigmeier


"Manish Bajpai" wrote:

> David,
>
> You are simply great !!
>
> Nice to brainstorm with you.
>
> Thanks,
>
> Manish
>
> "David Billigmeier" wrote:
>
> > Sorry... I see a typo, paste that code in B1 :-)
> >
> >
> > --
> > David Billigmeier
> >
> >
> > "David Billigmeier" wrote:
> >
> > > Without using pivot tables:
> > >
> > > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > > down:
> > >
> > > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> > >
> > > --
> > > David Billigmeier
> > >
> > >
> > > "Krista" wrote:
> > >
> > > > I need to check for duplicate names in a column. Is there a way to do this?

Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet.

Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.

That's it.

Thanks,

Manish Bajpai

"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Without using pivot tables:

Assume your values are in the range A1:A10, paste this code in A1 and drag
down:

=IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")

--
David Billigmeier


"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Sorry... I see a typo, paste that code in B1 :-)


--
David Billigmeier


"David Billigmeier" wrote:

> Without using pivot tables:
>
> Assume your values are in the range A1:A10, paste this code in A1 and drag
> down:
>
> =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
>
> --
> David Billigmeier
>
>
> "Krista" wrote:
>
> > I need to check for duplicate names in a column. Is there a way to do this?

David,

You are simply great !!

Nice to brainstorm with you.

Thanks,

Manish

"David Billigmeier" wrote:

> Sorry... I see a typo, paste that code in B1 :-)
>
>
> --
> David Billigmeier
>
>
> "David Billigmeier" wrote:
>
> > Without using pivot tables:
> >
> > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > down:
> >
> > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> >
> > --
> > David Billigmeier
> >
> >
> > "Krista" wrote:
> >
> > > I need to check for duplicate names in a column. Is there a way to do this?

Definitelly, nice to have met a fellow Excel fanatic!

Regards,
Dave


--
David Billigmeier


"Manish Bajpai" wrote:

> David,
>
> You are simply great !!
>
> Nice to brainstorm with you.
>
> Thanks,
>
> Manish
>
> "David Billigmeier" wrote:
>
> > Sorry... I see a typo, paste that code in B1 :-)
> >
> >
> > --
> > David Billigmeier
> >
> >
> > "David Billigmeier" wrote:
> >
> > > Without using pivot tables:
> > >
> > > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > > down:
> > >
> > > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> > >
> > > --
> > > David Billigmeier
> > >
> > >
> > > "Krista" wrote:
> > >
> > > > I need to check for duplicate names in a column. Is there a way to do this?

I need to check for duplicate names in a column. Is there a way to do this?

Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet.

Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.

That's it.

Thanks,

Manish Bajpai

"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Without using pivot tables:

Assume your values are in the range A1:A10, paste this code in A1 and drag
down:

=IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")

--
David Billigmeier


"Krista" wrote:

> I need to check for duplicate names in a column. Is there a way to do this?

Sorry... I see a typo, paste that code in B1 :-)


--
David Billigmeier


"David Billigmeier" wrote:

> Without using pivot tables:
>
> Assume your values are in the range A1:A10, paste this code in A1 and drag
> down:
>
> =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
>
> --
> David Billigmeier
>
>
> "Krista" wrote:
>
> > I need to check for duplicate names in a column. Is there a way to do this?

David,

You are simply great !!

Nice to brainstorm with you.

Thanks,

Manish

"David Billigmeier" wrote:

> Sorry... I see a typo, paste that code in B1 :-)
>
>
> --
> David Billigmeier
>
>
> "David Billigmeier" wrote:
>
> > Without using pivot tables:
> >
> > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > down:
> >
> > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> >
> > --
> > David Billigmeier
> >
> >
> > "Krista" wrote:
> >
> > > I need to check for duplicate names in a column. Is there a way to do this?

Definitelly, nice to have met a fellow Excel fanatic!

Regards,
Dave


--
David Billigmeier


"Manish Bajpai" wrote:

> David,
>
> You are simply great !!
>
> Nice to brainstorm with you.
>
> Thanks,
>
> Manish
>
> "David Billigmeier" wrote:
>
> > Sorry... I see a typo, paste that code in B1 :-)
> >
> >
> > --
> > David Billigmeier
> >
> >
> > "David Billigmeier" wrote:
> >
> > > Without using pivot tables:
> > >
> > > Assume your values are in the range A1:A10, paste this code in A1 and drag
> > > down:
> > >
> > > =IF(COUNTIF($A$1:$A$10,A1)>1,"dup","nodup")
> > >
> > > --
> > > David Billigmeier
> > >
> > >
> > > "Krista" wrote:
> > >
> > > > I need to check for duplicate names in a column. Is there a way to do this?