| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare to a range of values using "from/to"
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display values set in a range?? | Excel Worksheet Functions | |||
| How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
| Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
