Find Duplicate Name in 1 Column and Return Maximum of all Values associated with that Name

Hi everyone,

I intend to find duplicate values (in Column B) based on a cell of interest (Cell B7). Then, look through prices (in Column C) to return the maximum value associated with those duplicates into Cell H7.

Below is an attachment of an example.

Picture 1.jpg

I have tried this formula so far:

Please Login or Register  to view this content.

But the above formula only finds the maximum value in 1 cell, not the whole column.

How would you go about doing this?

Thanks in advance!

Thank you so much, bebo021999!
The code you provided was so simple to understand, and it that solved the problem!