Hi All!
For a project, I have to do a language check on a set of words to determine if they have any actual meaning in other languages. I've been able to do that, but now I have to find a way to neatly present the data. And I used conditional formatting to highlight the words that are actual translations. But I can't figure out how to chart the results. Here is an example of what I am working with:
Capture.JPG
So what i need is for the words with actual translations to populate on another tab. Then under the name the language that has the translation would populate, then beside that the translation would appear. And I need that to happen for each word that has a translation (which are highlighted in red).
I imagine it to look something like this:
Capture2.JPG
But, it needs to ignore the words that have no red cells in the row.
Anyone have any ideas? I thought that maybe this could be a formula or a function, but I am wondering if it would require VBA.
I've attached a workbook for testing!
Bookmarks