Results 1 to 12 of 12

Remove duplicates inside the cells (with criteria)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2007
    Location
    Germany
    MS-Off Ver
    MS Office 2007 on Windows 10 (German Version)
    Posts
    105

    Remove duplicates inside the cells (with criteria)

    Hello,

    I have a worsheet "Is" which has a column D. Column D contains of words followed by their grammatical identities in "{}". Seperator for the words is ";".
    Now there are some words which are available multiple times but their grammtical identities inside "{}" differ. For example: " franc {adv.}; franc {m.}; franc {xy}; franc {??}". Now i have the word "franc" multiple times. I want to delete all those duplicates which dont have the grammatical identity "{m.}" or "{f.}". So the task is:

    a) find duplicates inside the cells of Column D/worksheet "is"
    b) delete all duplicates and leave only those which are followed by "{m.}" or "{f.}" . For example ( wordxy {adv.}; wordyy {adj.}; wordxy {m.}; wordxy {adj.} ==> wordyy {adj.}; wordxy {m.})
    c) if there are duplicates but non of them has the grammatical identity "{m.}" or "{f.}" then delete the duplicates and leave which ever has the first position. For example ( word25 {xy.}; word1 {adv.}; word2 {n.} ==> word25 {xy}; {word1 {adv.})

    I am attaching example wordlist along this thread and hope some one can help me clean this wordlist.
    Attached Files Attached Files
    Last edited by julia81; 04-11-2012 at 09:48 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1