Thread: Min-Max question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Min-Max question
Just point to the cell in the array formula:
=MIN(IF(Data!A1:A6=B2,Data!B1:B6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Gina" wrote:
=MIN(IF(Data!A1:A6="Apples",Data!B1:B6))

If instead of typing "Apples" I wanted to reference Cell B2 of the current
worksheet to find the value- Do you know how I could do that?
Reply With QuoteReply With Quote