There are ways to five thousand

Users questions: Is there any way to column A in the cell to repeat more than forty thousand Chinese characters filtered out, leaving only three or four thousand never repeated characters, that is, as the result of column B.
Experts answer:: 1, select A2: A46685.2, "data * Advanced Filter * Filter * Filter the results will be replicated to other Location * Conditions zone * blank * copy * C2 * choose not to duplicate records * OK ", the results in column C the yellow area. Appendix: Chinese word 01.rar
  • This information provided by the users.Thanks!