match with variance

iksotof
3StarLounger
Posts: 313
Joined: 04 May 2010, 15:18

match with variance

Post by iksotof »

Hi, I am wanting to match two columns of values but want to factor in a tolerance of 10, so if I have a 30 versus a 20 then this will show as a match. Is this possible?

Thanks Darren.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: match with variance

Post by Rudi »

You could use Conditional Formatting to highlight the match

=($A2-10)=$B2
1.jpg
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: match with variance

Post by HansV »

Rudi, I think you'd want =ABS($A2-$B2)<=10
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: match with variance

Post by Rudi »

Agreed.
(It's all in the word "tolerance")

TX
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

iksotof
3StarLounger
Posts: 313
Joined: 04 May 2010, 15:18

Re: match with variance

Post by iksotof »

Thanks guys


that's sweet,

Darren.