General discussion
June 8, 2004 at 12:26 PM
brifd1

Excel: a number within a range

by brifd1 . Updated 22 years, 3 months ago

I have 2 columns of #’s.
I want to check the # in (for instance) cell A4 vs. the range of #’s in C4:C35 to see if there is any # in that range within +5 or -5 of the value in cell A4.
What would the formula be that could do this?
Thanks for your ideas/help!

This discussion is locked

All Comments