Max or Min with condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I search the minimum and maximum values of the rows that follow a
specific condition?

e.g.
A mission means having to travel to a set of destinations.
Columns are Mission, Destination, Arrival and Departure.
How can I build a formula that for a specific mission, searches the lowest
arrival date and highest departure date? In that way I will know from which
day to which day was the mission.

If I could do an array I would do MAX((mission=A1)*(departure_date))

Thank you
 
=MAX(IF(mission=A1,departure_date))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)
 
Why didn't you? It works, but for MIN you would need

=MIN(IF(Mission=A1,departure_date))

both entered with ctrl + shift & enter

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Aakash Android Tablet - World's Cheapest Tablet is Finally Launched 0
Conditional Formating: MAX & MIN 3
conditions and the max function 1
Function for 2nd and third low or Max 2
Time-calculation question 3
Return Min & Max value of Conditional Formatted cells 20
Calculating Max & Min in a negative numbes 6

Back
Top