Forum Discussion
Textual Analysis/Theme Analysis in Excel without an outside AI software?
I'm wondering if there's a way for Excel to look at comments with a formula, and then automatically label themes with a 1 in Excel if they fall into a specific theme category. For example, please loo...
Thank you so much for taking the time to look into this! My team and I are okay with the accuracy not being perfect, and we'd like to find a way to do the first approach that you mentioned: build a list of words or phrases for each theme, and then create formulas to assign themes using lookups and matching. Do you have any resources on how to do this? Or are you able to provide additional direction to accomplish this? Thank you SO much!
Which version of Excel do you have? If you go to File | Account, in the section where it says About Excel, which 'channel' are you on?
- Version 2202, and the Semi-Annual Enterprise Channel
I had to get a bit creative because there's a big difference in functions available in Semi-Annual vs Current/Monthly. The formula is not as elegant as I'd like but it gets the job done. Please see attached demo workbook.
- Thank you so much for your help! I was able to set it up how I'd like. I really appreciate your assistance!! Best wishes and happy holidays,
Julie