Finding Double entry

[chandan12]

How can I find double entry in a row/column? And if double entry exists the ENTIRE ROW will be high lighted.

[MarvinP]

Hi chandan,

See if the attached solves your problem. I created it a while back for another question.

[amy_d2]

hi Candan,

select the row / column , go to Home - conditional formatting - highlight Cell rules - Duplicate values this will highlight the duplicates

if you want to remove duplicate then ,

Go to Home - Data - Remove duplicate

Thanks,
A

[chandan12]

amy_d2,

Sorry! I am not getting it. I had to mention that I am using Office 2003 and perhaps your suggestion is for Higher Version.

[chandan12]

Thanks for the help but I failed utilize it as I am using Office 2003 and your one is related with Office 2007.