Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a series of values within an Array
I have a two-dimensional array, sorted along one dimension:
e.g. array(n,1) array(n,2) 10 10020 10 20127 10 30568 11 09654 11 21678 11 54689 12 65894 .. .. 99 11111 I want to quickly find only those rows (n) within the array that match a particular value so that I can limit some looping to only that area of the array. For instance, let's say I was able to find out that for the value "11", the lower bound is 4 (if n starts at 1) and the upper bound is 6. Any suggestion? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding next number in a series | Excel Worksheet Functions | |||
Finding the Max, Min values based on certain criteria for an array | Excel Discussion (Misc queries) | |||
Finding Minimum Value in series, excluding zero values | Excel Worksheet Functions | |||
Finding series index if I know the Series Name | Charts and Charting in Excel | |||
Need help finding unique values and transforming an n x 1 Array | Excel Programming |