Forum Discussion
Highlight or Conditional Format SIMILAR matches within the same column
I am trying to find a way to highlight SIMILAR matches to values within one column. I have found some helpful tips on comparing TWO datasets with similar matches found, but not anything that looks wi...
If you have access to LAMBDA, one approach might be using SCAN. You'd string-out the lookup value to make it an array then SCAN it. Feed the results to XMATCH but only accept hits if the element from the array is 90% as long as the total length (This can be adjusted). I may post a sample later, time permitting.