Hello, i have a question regarding excel function.
I have around 8 text in chinese characters and my goal is to find the most used Verbs in those texts.
I looked through the texts and made a list of the verbs. but making the exact number and summary of most used one without any function is quite hard :)
So my idea is to do a chart in excel and use some function, for example COUNTIF to help me find the repetition. but it is not sufficient enough, because i would need to write the function for every character separetelly. Is there something little more usefull - maybe a function that would take the whole excel sheet, make the number of repeating verbs (in my case chinese characters) and maybe even mark them out?
anyway ::)) thank you and happy new year
