How to Find Duplicate Data in Excel using Data Validation and Conditional Formatting - Part 1

[@thirusambath.]

Wowe.....Im recently started to watche your videos....your explanation is superb bro.... This is very helpful How to contact you.... please tell me bro

[@Prabasmsoffice]

prabastech.com/

[@vasanthnathan5732]

superv

[@Ridetoright111]

...!! Excellent Prabha..!! I am addicted to your presentation..!!

[@Prabasmsoffice]

Addiction on learning is good for health. Keep learning.

[@Ridetoright111]

@@Prabasmsoffice Thank you..!! Keep posting video even if it is small things..!!😊😊

[@tharunkumar1958]

Usually we accepts registration through Google Forms, there particpant register twice or thrice unknowingly. When we export, we will sort & remove those twice registrations, Now this DUPLICATE option through Conditional Formatting more helpful for us.. Thank you so much..

[@vigithra]

Finally I learnt how to find duplication in excel

[@ramkumarv767]

Super. Nice tips

[@Prabasmsoffice]

+Ram Kumar Thanks Ram.

[@rajasanthosh9617]

sir, entire row data va hight light panna mudiyuma sir using select a single cell panna pothu

[@Prabasmsoffice]

Please elaborate your request. Thanks.

[@rajasanthosh9617]

@@Prabasmsoffice For eg : D4 cell la irunthu cursor B2 cell ah select panna pothu 2 row la irukura entire data (A2 : Z2) conditional formatting mulam maga highlight panna mudiyuma and nan entha cell ah select panna lum antha row la irukura data mattum highlight aganum sir. This is my doubt sir please help me

[@adhemanthkumar8073]

Sir, Can I use this formula vertical mode?

[@Prabasmsoffice]

Why not?

[@subhashini7613]

Super explanation bro 👌

[@venkatasubramanian5721]

google sheet laa itha apply pana apply agala sir ena pbm sir?

[@dm-zd5nu]

super bro

[@kmentertainment55]

How to unlock for rows?

[@Gaajinikanth]

Learn new things today how to set formula in data validation.

[@Prabasmsoffice]

Stay tuned, I will try to cover this.

[@Gaajinikanth]

@@Prabasmsoffice i edit ready my comment..

[@pratabsinghb3199]

how we can find duplicate name which is in different format ( may be one name is short form another one in full name) in excel

[@Prabasmsoffice]

Refer these two videos kzbin.info/www/bejne/fpbGZZ1-adKJirM kzbin.info/www/bejne/hoDWqWqLfLiDa5o

[@suryatamil3104]

Sir... How to find triplicates in excel?

[@muthumech5196]

Bro formula copied but I can not past Please this step only briefly explain.

[@Prabasmsoffice]

Sure

[@ameerhamja2893]

Hi Here i couldn't paste foula in Data validation.. what wrong..

[@Prabasmsoffice]

Check the formula you entered, data validation does not accept improper formula.

[@savethink9704]

HOW TO LEARN VISUAL BASIC

[@kanmaniram785]

Entha formula va drag panalama data validation la poi duplicate repeated anadhuna

[@Prabasmsoffice]

Please elaborate your question.

[@aravinds7716]

Nice Video on Finding and to avoid duplicate ji i tried it on my excel but i am getting error in after formula copied the data val tool bar becomes disable my excel sheet contains all formulas and macros other than that its a new way to find duplicate

[@Prabasmsoffice]

+aravind s Amyway finally it is working, right. Try this in a fresh workbook to understand it better. Then implement wherever you need this. Thanks for following me regularly. Keep learning and supporting.

[@ameerhamja2893]

Hi bro Nice info.. still found duplicate using Sort function..

[@Prabasmsoffice]

Share the working file to me for checking

[@muruga403]

Thanks

[@Prabasmsoffice]

+Muvi Ra Thanks buddy

[@muthupandimuniyandi1439]

benefits

[@sivaprakasansivaprakasan1479]

EXCEL ent - SIR.