Thread: How to determine the value from a list?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default How to determine the value from a list?
Hello Eric,

Enter with CTRL + SHIFT + ENTER
=MAX(IF(ABS($A$1:$D$1-A2)=MIN(ABS($A$1:$D$1-A2)),$A$1:$D$1))

Regards,
Bernd

Reply With QuoteReply With Quote