T
TUNGANA KURMA RAJU
What formula will work to get all cell references of duplicate
values(numeric or text) in a range(non-blank)?
values(numeric or text) in a range(non-blank)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anirudh
Hi Tungana,
Pls try this
=IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")
Pls try this
=IF(COUNTIF(a$5:$a9,G9)>1,"Duplicate","")
A
Anirudh
=IF(COUNTIF(a$5:$a9,a5)>1,"Duplicate","")
and dragdown
and dragdown
T
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
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
D
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.
filter on that column.
Show just the duplicate cells and copy the visible rows to that other location.