Reply by be09. 1/ Method 1 (will take 5 minutes): To find the duplicate numbers: In D3 you use the formula:
=IF(COUNTIF(C3:C37772,C3)>1,"Duplicate"," ") Select cell D3 and Fill down to the final data. Duplication of any cell will display text Duplicate, you used Autofillter select Duplicate and delete these lines, the remaining lines do not overlap. 2/ Method 2 quick and easy (takes 30 seconds): To filter duplicate numbers you use the Advanced Filter. View attachments. 2012/11/22, Manjunath Narayanappa <[email protected]>: > Dear Team, > > In the above attached Spreadsheet, I have more than 3777 row in which Column > C has duplicate entries > Wherein im unable to remove duplicate entries due to space in it. > > Please teach me so it will be new learning for me > > Regards > Manjunath > > ________________________________ > > PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL > > > > For Aon's standard conditions associated with this e-mail please visit > http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp > > Aon UK Limited > > Registered Office: 8 Devonshire Square, London EC2M 4PL > > Registered in London No. 210725 . VAT Registration No. 480 8401 48 > > > > Aon UK Limited is authorised and regulated by the Financial Services > Authority in respect of insurance mediation activities only. > > -- > 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 post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
