Compare to a range of values using "from/to"
test
"Lisa O." wrote:
I'd like to compare values from one set of data to a range of data - without
having to type in each of the individual data range values to compare to.
For example:
look for 1001000 (Col A Value)
in range (Col B Values)
from 0000000
to 1999999
without having to use data fil to actually show each individual value, like:
0000000,0000001,0000002....all the way to 1999999
Thank you,
Lisa
|