Hello Saurabh, If you are not an expert in Macros (like me :P), try ASAP Utilities:- http://www.asap-utilities.com/
Regards, Prasad K From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saurabh Madhusudan Patel Sent: 10 March 2014 15:06 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Duplicate Removal Dear All, Is there any solution to this? Regards, Saurabh Patel "The earth is enjoyed by heroes"-this is the unfailing truth. Be a hero. Always say, "I have no fear." - Swami Vivekanand From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saurabh Madhusudan Patel Sent: Friday, March 07, 2014 2:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Duplicate Removal Hi All, I have a huge database having the name. There are too many duplicates which cannot be removed via pivot. Mentioned below is the example. Also attached is the sample list. Is there is a faster way to remove or track the duplicates via any tool or formula? St Francis Hospital South Saint Francis Hospital South Wyoming County Community Hospital Wyoming County Community Hosp St Michael's Hospital Saint Michael's Hospital Regards, Saurabh Patel Assistant Manager - Marketing Mediscribes, Inc. ezDI, LLC. +91 99099 94490 <https://www.facebook.com/ezdius> Description: Description: facebook <http://www.linkedin.com/company/ezdi-llc> Description: Description: linkedin "The earth is enjoyed by heroes"-this is the unfailing truth. Be a hero. Always say, "I have no fear." - Swami Vivekanand -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. http://www.imrbint.com/disclaimer.html -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
<<image001.png>>
<<image002.png>>