Find Max value for the same code

[djwaz69]

Hi

i need help in a formula, I need the maximum value for the same code.

example : for code TL46NIFTY there are 3 values 15,089,125, 178,750,000 and 208,000,000.
book_123.xlsb

TL46NIFTY 15,089,125 - > i need zero against the value as value is not max.
TL46NIFTY 178,750,000 - > i need zero against the value as value is not max.
TL46NIFTY 208,000,000 - > i need 208,000,000 against the value as value because this is the max value for TL46NIFTY.

PS : there are somewhere 5000 data and i cannot use find unique code with max logic.