Another interpretation:
=INDEX(B1:B99,MATCH(1,--(ABS(B1:B99-A1)=MIN(ABS(B1:B99-A1))),0))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
Jeff wrote:
Hi
I have a list of numbers in column "B" and I also have a number in cell A1.
I want to get the closest number in column B to the value in A1 using a
formula,
is this possible?
Thanks for your help.
--
Dave Peterson
|