Forum Discussion

jiddar zahid's avatar
jiddar zahid
Copper Contributor
Nov 12, 2018

Help with Excel

hi i'm having problems with highlighting duplicates in Microsoft excel , the database that i have has a lot of entries that are duplicates but i'm unable to check them all so kindly if someone can help me with this do let me know how to do it

  • Jamil's avatar
    Jamil
    Bronze Contributor

    simply select the range from A4:B4548 and then go to Conditional formatting and highlight duplicates.

     

    see the attached file with the screenshot here.

     

Resources