next closest value in unsorted column
Hi,
I have a column with numbers that cant be sorted. There is an input x that
does not have an exact much in any of the values. I need VBA to return the
interval values for x.
2, 5, 76, 14, -7, 32.
For x = 15, i want lo = 14 and hi = 32.
Thanks!
--
______
Regards,
Greg
|