Forum Discussion

urgettingbloodeagled's avatar
urgettingbloodeagled
Copper Contributor
Jul 08, 2021
Solved

Comparing data & automatic adding of classification

Hi all,   I hope you can help me out here.    The file I'm working has about 5000 rows with various comments. I have to classify these comments in 4 categories and for one category I have to be e...
BI & Data Analysis
excel
office 365
  • urgettingbloodeagled's avatar
    urgettingbloodeagled
    Copper Contributor
    Jul 08, 2021
    Thanks for the quick turn around! your help is appreciated 😄
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jul 08, 2021

      You're welcome. Any issue let me know & please upload a dummy representative workbook
      Otherwise if problem solved, somewhere on each reply there's a link to mark as Best reponse => Can help those who search - Thanks

      • urgettingbloodeagled's avatar
        urgettingbloodeagled
        Copper Contributor
        Jul 16, 2021

        HI Lorenzo ,

         

        thanks again for your help, but I need to pick your brain once more.

         

        Attached you see a dummy example for the issue. As you can see, I have multiple comments with the same context, only the date is various. My question now is, is it possible to set up a auto detect?

         

        By that I mean, in the master file with all comments and classifications I have instead of 

         

        Misdelivered, delivered properly 10th March  - only Misdelivered, delivered properly* or even shorter; Misdelivered, delivered* and when I ran the look up that is detects the classification for the "long comment" in a shorter version.

         

        I hope you understand my thinking process here.

         

        thanks in advance, for even trying!

         

        kind regards

         

        urgettingbloodeagled

Resources