Suppose, you have been given following and you will need to find duplicates in column A and sum the maximum values from column B. If duplicates don't exist, values will be taken as they are. The values which needs to be summed up are colored. The answer would be 123 in this.
The workbook related to this challenge can be downloaded from Challenge 41 – Sum the Maximum Number where duplicates Exist
The answer to this challenge would be published after a month i.e. on 23-May-16.