Software

Ask something
Discussion Locked

Excel: a number within a range

0 helpful
3 replies

by brifd1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

3 replies

by brifd1

Funny thing, I did a search on Walkenbach, as I've seen his books, but the article referenced did not turn up.

This discussion is closed to new replies.