Filtering integers within a certain tolerance of one another across columns

[suzors]

Hello,

I have three value sets in columns A, B, and C.
I would like to bring up the values within one integer of one another in B and C.

Again, it doesn't matter how high or low the number is in B, as long as C is within 1 value away.

Thank you in advance for any help!

 

[FranzV]

Hi Suzors,

asuming that you want values in Column A to be displayed in Column D whenever the difference in values of B and C is less than or equal to 1, you can get it with a simple IF conditional function.

	A	B	C	D
1	1	6	8	C far from B
2	2	7	8	2
3	3	8	8	3
4	4	9	8	4
5	5	10	8	C far from B

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

​

Worksheet Formulas Cell Formula D1 =IF(ABS(B1-C1)<=1,A1,"C far from B") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

You can substitute "C far from B" with "" if you want the cell to be blank if the condition is not met.

Hope it helps.

 

[suzors]

Yes!
Thank you!