Skip to main content

Cell content comparison tools

  • December 13, 2020
  • 3 replies
  • 65 views

Hello all,
I am wondering if there are tools in AT to compare text inserted in two different cells?
Thanks for your time.

Caroline

3 replies

Forum|alt.badge.img+19
  • Inspiring
  • December 13, 2020

I love the question, but I think I need a little more context. Are you thinking about a formula that compares values? Or, is this something more complex?


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • December 13, 2020

If you are comparing text in two different cells in the same row/record, you can use a formula field.

  • You can test if the cells have exactly the same text with the = operator.
  • You can test if one text value is contained within another text value with FIND or SEARCH. Both are documented in the Formula Field Reference.

If you want to compare text in cells across different rows/records, you will need to use a scripting solution.


  • Author
  • New Participant
  • December 22, 2020

I love the question, but I think I need a little more context. Are you thinking about a formula that compares values? Or, is this something more complex?


I am thinking of something like track changes in Microsoft Word

Courriel dicté et envoyé d’un téléphone intelligent. Veuillez excuser les erreurs. Email dictated and sent with a smartphone. Please excuse typos.