Forum Discussion

spalmer's avatar
spalmer
Iron Contributor
Sep 24, 2019
Solved

Help with Recognizing new text

I'm trying to figure out if excel can recognize new text in a column of cells as I type it in.  I attached a document below to help.  As you can see I have two columns: one is a "JOB CODE" the other ...
excel
Formulas and Functions
spalmer's avatar
spalmer
Iron Contributor
Sep 25, 2019

Thank You Subodh!  those should work as well.  thank you for your time and help with this.  I really appreciate it! Subodh_Tiwari_sktneer 

  • spalmer's avatar
    spalmer
    Iron Contributor
    Sep 25, 2019

    Hi Subodh_Tiwari_sktneer 

    So I tried your formulas and they aren't working on my end.  I attached the document and on sheet 2 maybe you can help me out with what im doing wrong.  the way I have everything placed on sheet 2 is exactly like my official document I have.  thank you for your time

    • Subodh_Tiwari_sktneer's avatar
      Subodh_Tiwari_sktneer
      Silver Contributor
      Sep 25, 2019

      spalmer 

      Formula in K6 to get the unique job code is an array formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.

       

      If that resolves your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.

       

       

Resources