Highest Value
Sorry Bernd; i didnt get you..
"Bernd P" wrote:
Hello Jacob,
There could be more than one with the max value in sheet1, I think.
I suggest to array-enter into Sheet2!C2:
=MAX((Sheet1!$A$2:$A$100=A2)*Sheet1!$B$2:$B$100))
then copy down...
Regards,
Bernd
|