Thread: Find the first lowest value in a column that exceeds $foo
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Find the first lowest value in a column that exceeds $foo
Hello,

=LOOKUP(-B1,-A1:A24,A1:A24)

Regards,
Bernd
Reply With QuoteReply With Quote