S
spgprivate
With these functions they find the highest value which is less than or
equal to the lookup value. For example
A B
1 30
2 60
3 70
4 80
5 100
If I want the lookup the 'A' value of 66 it will return '2'.
I want to lookup the highest value ie anything over 60 return value of
3.
Anybody have any ideas ?
Simon
equal to the lookup value. For example
A B
1 30
2 60
3 70
4 80
5 100
If I want the lookup the 'A' value of 66 it will return '2'.
I want to lookup the highest value ie anything over 60 return value of
3.
Anybody have any ideas ?
Simon