Maximum with condition

[MetLife]

Hi,

I have 2 columns of data. I want to find the largest value in column A (these are integers) but column B has to be equal to the text "death" in the corresponding row. There are around 1000 rows of data.

Do you know if there is a formula to do this?

Also is there a way of getting the "k"th largest if the corresponding value is "death" in column B?

Thanks,

 

[Fluff]

How about

=maxifs(a:a,b:b,"death")

 

[felixstraube]

How about?:

HighLowDataPoints.xlsx
	A	B	C	D	E
1	Int	Text		Largest Int	8
2	1	something
3	2	death		N	2
4	3	something		N largest	4
5	4	death
6	5	zap!
7	6	kapow!
8	7	crunch!
9	8	death
Sheet3

Cell Formulas
Range	Formula
E1	E1	=MAX(A2:A9*(B2:B9="death"))
E4	E4	=LARGE(A2:A9*(B2:B9="death"), E3)