 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Removig Duplicates
Is there anyway to remove duplicates when the first 3 words in cell are the same even though the last few words are not the same ex: O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\04-chas O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\09-Matot O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\05-Dvar O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\05-arimftim O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\05-Dvaze Try entering this formula into cell B1: assumes that your first string is in cell A1. This is an array formula, so enter it using Ctrl-Shift-Enter =SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-MAX((MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1)="\")*ROW(INDIRECT("1:" & LEN(A1))))),"") Watch the line wrapping. Then copy it down, and use those results to look for duplicates. HTH, Bernie MS Excel MVP > Is there anyway to remove duplicates when the first 3 words in cell are the > same even though the last few words are not the same [quoted text clipped - 4 lines] > O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\05-arimftim > O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\05-Dvaze
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.