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