Duplicate values

[TUNGANA KURMA RAJU]

What formula will work to get all cell references of duplicate
values(numeric or text) in a range(non-blank)?

[Anirudh]

Hi Tungana,

Pls try this

=IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")


"TUNGANA KURMA RAJU" wrote:

> What formula will work to get all cell references of duplicate
> values(numeric or text) in a range(non-blank)?

[Anirudh]

=IF(COUNTIF(a$5:$a9,a5)>1,"Duplicate","")
and dragdown

"Anirudh" wrote:

> Hi Tungana,
>
> Pls try this
>
> =IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")
>
>
> "TUNGANA KURMA RAJU" wrote:
>
> > What formula will work to get all cell references of duplicate
> > values(numeric or text) in a range(non-blank)?

[TUNGANA KURMA RAJU]

Hello Anirudh,
I think you haven't understood my question.Your formula is only testing the
duplicate entries,whereas I have asked for test,identify and extract the
duplicate values to another location.Suppose
col a1:a6 contains raju,priya,rina,james,priya,james
and if I entre formula in f5 to extract the duplicate the results should be
like
this ---priya,james,priya,james or a2,a4,a5,a6.
Give me the formula

"Anirudh" wrote:

> =IF(COUNTIF(a$5:$a9,a5)>1,"Duplicate","")
> and dragdown
>
> "Anirudh" wrote:
>
> > Hi Tungana,
> >
> > Pls try this
> >
> > =IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")
> >
> >
> > "TUNGANA KURMA RAJU" wrote:
> >
> > > What formula will work to get all cell references of duplicate
> > > values(numeric or text) in a range(non-blank)?

[Dave Peterson]

Maybe you could Anirudh's suggestion to identify those duplicates and then
filter on that column.

Show just the duplicate cells and copy the visible rows to that other location.

TUNGANA KURMA RAJU wrote:
>
> Hello Anirudh,
> I think you haven't understood my question.Your formula is only testing the
> duplicate entries,whereas I have asked for test,identify and extract the
> duplicate values to another location.Suppose
> col a1:a6 contains raju,priya,rina,james,priya,james
> and if I entre formula in f5 to extract the duplicate the results should be
> like
> this ---priya,james,priya,james or a2,a4,a5,a6.
> Give me the formula
>
> "Anirudh" wrote:
>
> > =IF(COUNTIF(a$5:$a9,a5)>1,"Duplicate","")
> > and dragdown
> >
> > "Anirudh" wrote:
> >
> > > Hi Tungana,
> > >
> > > Pls try this
> > >
> > > =IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")
> > >
> > >
> > > "TUNGANA KURMA RAJU" wrote:
> > >
> > > > What formula will work to get all cell references of duplicate
> > > > values(numeric or text) in a range(non-blank)?

--

Dave Peterson