Thread: How to determine the minimum value with given condition?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default How to determine the minimum value with given condition?
I would create a new column (let's say G) with the formula in G2 and copy it
down:
=IF(A2$C$1,B2,"")

Then I would put in D1:
=MIN(G1:G65536)

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote