Thread: Express Array Function as VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NoodNutt[_2_] NoodNutt[_2_] is offline
external usenet poster
  
Posts: 39
Default Express Array Function as VB
Formula should have been

{ =MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A5 ,Data!$G$2:$G$250)))}
Reply With QuoteReply With Quote