Alright, I know how I would do this in VBA. But, I was curious to see if anyone knew of a formula I could use to compare the values of 2 cells to see how similar they are.

I was unable to find any such function that could be used in formulas, so I will just go ahead and work on my VBA function.

But, I'll check back and see if anyone has anything for this.

Thanks.