How to Find Duplicate Rows in Excel

[@SaurabhPawar-y9n]

Thank You, brother. it is very helpful I used this formula in my office work. and a lot of my work was reduced.

[@AjayAnandXLnCAD]

My pleasure 😀

[@nayazahmedahmed6323]

Thanks for your nice excel trick, believe me I have solved my great issue easily. I had to identify duplicates in above 2000 rows and delete. Done with ease.👍👍👍👍👍👍😊 Excellent fabulous

[@florenciocortez4269]

Tried this on my spreadsheet and very helpful. Thanks Ajay!

[@pranavgandhi9224]

Wow amazing.....this helped me a lot ... thankyou sir

[@adnantahir4530]

Very helpful tutorial

[@s.k.sheikhinsaan108]

Thanks, video is very usefull

[@jonasreuel2669]

Thank you so much sir. its very useful for me.

[@AjayAnandXLnCAD]

My pleasure 😀

[@modawiyu3360]

Thank you so much, that’s help me alot 👌🏻👍🏻👍🏻

[@gaetanomaximus8650]

Thanks! Brilliant!

[@BanaCJ]

Thk bro, you really carry me

[@dharanias3537]

Thank you.. Worked for me

[@AjayAnandXLnCAD]

Glad to hear that :)

[@govinda_verma]

Very useful.. thanks Sir.

[@niketgamre913]

Great it is very helpful.

[@10morrisonka]

You RUUULEEE !!!💖💖💖💖💖THANK YOU, AJAY !! LOVE ! A LOTTT @@

[@AjayAnandXLnCAD]

You are welcome dear ❤️

[@mshaidul5247]

Thanks bro

[@satyamdhruwa911]

Great...sir 👍👍👍

[@AjayAnandXLnCAD]

Thank you 😀 Hope you have seen the first part of the video too, Formula to cells containing Duplicate values

[@TeamHuanimal]

thank u !

[@keerthichiluvuri531]

Thnq, it worked for me

[@AjayAnandXLnCAD]

Great!

[@fomujungfunjung471]

Thanks

[@AjayAnandXLnCAD]

My pleasure :)

[@RohitKumar-cc7zi]

Good bro

[@opurbosarker4657]

How is it possible to get the summation of more than one the duplicate cell values with function?

[@entrepreneurlearning7674]

nice

[@islamjohir279]

Nice

[@AjayAnandXLnCAD]

Thanks

[@pradeepmaddy3573]

Hi how can I highlighted duplicate and orginal

[@saneshkp9810]

Remarks of some cells show 0 what it means

[@queenm5962]

Hi, that is great, but I have a question: how can I find duplication in time-interval (overlapping time periods) in the same room. when scheduling in excel. for example I have reservation data arranged in a table as: reservation1: start time: 8:00 am, end time: 10:00 am, in room:305 reservation2: start time:9:00 am, end time: 10:00 am, in room:305 reservation3: start time: 8:00 am, end time: 9:00 am, in room:305 how can I have excel see that there are "three" reservation in same room!!

[@AjayAnandXLnCAD]

Interesting! I will answer this in a descriptive way. So, please post this question in quora and tag me.

[@niksahz9932]

With this formula few of the count is coming 0