Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range search
Hi everyone,
I am trying to search for whether a data is within a range (multiple ranges). example: data value = 1 range 1 = 0 - 3 range 2 = 4 - 5 range 3 = 6 - 10 and so on if data value is found within a range, the range number is return. in this case, range 1 will be return I am doing this for a large number of ranges, if there a way to it? Thanks Allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search range for text not in another range | Excel Discussion (Misc queries) | |||
Need Help soon on how to search through a range | Excel Programming | |||
Search Range for item in seperate range | Excel Programming | |||
How to search a range for a suburb in a large range | Excel Programming | |||
Search in Range | Excel Programming |