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.
match with variance
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: match with variance
You could use Conditional Formatting to highlight the match
=($A2-10)=$B2
=($A2-10)=$B2
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: match with variance
Agreed.
(It's all in the word "tolerance")
TX
(It's all in the word "tolerance")
TX
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 315
- Joined: 04 May 2010, 15:18
Re: match with variance
Thanks guys
that's sweet,
Darren.
that's sweet,
Darren.