Monday, February 7, 2022

Find Value NOT Between a Range

Excel makes it easy to find values that are between a range; say numbers between 20 to 40. If you wanted to find value outside the range (i.e., 1-19 or 40 and above), Excel makes it equally as easy. I'll show two ways you can do this; one with filtering and the other with conditional formatting.

No comments:

Post a Comment