Thread: Getting the particular value on the basis of given criteria ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
  
Posts: 136
Default Getting the particular value on the basis of given criteria ?
Hello,

array-enter (CTRL + SHIFT + ENTER)
=MAX(IF(B1:B170,A1:A17))

HTH,
Bernd

Reply With QuoteReply With Quote