1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I'm creating a word list that combines the most common 3000 Chinese characters into words, I can't seem to make it so the characters only appears once.

Column A: single character word list (一,我,你,们) etc.

column B: a dictionary that include 10000 words from the any characters (possibly even those not in the word list).

Column C: a word list that includes all possible combinations of characters from A that with column B(e.g. column A has 人, 民,理 and 物 but not 吾, so column C has 人民, 人物, 物理, but not 吾人).

I want to make it so column D has only on occurrence of a character from Column A. So 人民 appears but 人物 doesn't, while at the same 物理 appears. Any remaining characters can be left as single characters instead of words.

What do I do?

submitted by /u/Evening_Reach_8293
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#single character
#characters
#Chinese characters
#word list
#dictionary
#column A
#column B
#combination
#column C
#column D
#characters only once
#occurrence
#10000 words
#combinations of characters
#remaining characters