Forum Discussion
KLoveall
Jun 25, 2021Copper Contributor
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...
Patrick2788
Oct 18, 2022Silver Contributor
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.