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
C far from B
C far from B

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]

</tbody>

​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D1[/TH]
[TD]=IF(ABS(B1-C1)<=1,A1,"C far from B")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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!