Max of every every type

Please send me a formula where max of every header 1 column is taken from header 2 and replicated in resulted column C

head 1 head 2 result sheet
Apple 2 8
Apple 8 8
Apple 4 8
orange 1 9
orange 2 9
orange 2 9
orange 9 9


Thanks

You can use this array* formula in cell C2:

=MAX(IF(A$2:A$100=A2,B$2:B$100))

* Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

Copy the formula down to the bottom of your data.

Hope this helps.

Pete