=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)?
|