Thread: Determing Range Criteria
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default Determing Range Criteria
Not on my machine.

Alan Beban

Jim Aksel wrote:
Half way there. That works to find the largest negative value.
I tried the ARRAY formula
=MIN(IF(A1:A1000,A1:A100))
Using this formula provides the same value as =MIN(A1:A100)
Reply With QuoteReply With Quote