Forum Discussion
JELM_
Dec 21, 2022Copper Contributor
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...
JELM_
Dec 21, 2022Copper Contributor
Version 2202, and the Semi-Annual Enterprise Channel
Patrick2788
Dec 22, 2022Silver Contributor
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.
- Patrick2788Dec 22, 2022Silver ContributorYou're welcome! Glad to help. Happy Holidays!
- JELM_Dec 22, 2022Copper ContributorThank 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