Pull Highest Cell Value that Meets Conditions

I'm trying to make a formula to pull the greatest value in a list, only if it meets criteria.

Apples		24
Apples		24
Orange		98
Cantalope		3
Apple		6
Pear		44
Orange		88
Apple		33

I would want a function that would return the fruit with the highest value, if it's listed.

EX:
Apple:33
Banana: -
Cantalope:3
Orange:98
Peach: -
Pear:44

I should have given more specification. Here is my project. I'm trying to get the "units" on the first sheet to pull from "Production" only if there is a value, and only take the highest value.

Hi Phonix,

I think you are looking for a MAX in a Pivot Table.. See:
https://www.youtube.com/watch?v=hO_2nxRcpZg

Why not use a pivot table...

Create a header row

column A = Fruit
column B = Count

Row Labels >> Fruit
Values >> Max of count

Note that in your sample you have both apples and apple in the top table.

Data Range

	A	B	C	D	E
1	Apple	24		Apple	33
2	Apple	24		Banana
3	Orange	98		Cantalope	3
4	Cantalope	3		Orange	98
5	Apple	6		Peach
6	Pear	44		Pear	44
7	Orange	88
8	Apple	33
9	------	------	------	------	------

This array formula** entered in E1 and copied down:

=IFERROR(1/(1/MAX(IF(A$1:A$8=D1,B$1:B$8))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.