How to reduce a list of terms by taking out plural and singular equivalent terms so that I can add new terms from a second list?
I need help filtering a list but I'm not sure what the best way to go about it is?
I have one list in one column and I need to reduce the list by taking out any equivalent terms that are the plural or singular versions. Example: Let's say one of the terms in the list was Excel (singular). I want to be able to get rid of any terms that are listed as excels (plural). Similarly, if there is a term on the list as forums (plural), I need to be able to get rid of any terms that are listed as forum (singular). The end result will be to delete any terms that have the plural or singular equivalents.
Next, I need to take terms from another list in another column and I need to delete any terms from the first list that share any of the same terms from the second list. (I already know how to do this part with the remove duplicate feature alt-a > M). Then after I delete the duplicates, I need to see if this second list has any equivalent terms that are the singular or plural versions of the terms in the first list. Basically by using the same examples that I gave above, I will then need to delete the terms from the first list that have any plural or singular terms from the second list.
To sum it up, I have a large list of terms that I need to reduce by deleting any duplicates from a second list, then I need to reduce the list again by excluding any terms that have any plural and/or singular equivalents found in either the same list or the second list.
Any ideas?
Bookmarks