You have been given following data and you need to show corresponding count. You need to write a formula which can generate this count. If needed, you can use a maximum of helper column also.

Download problem workbook from Find Duplicates and Show the Count

The solution to this problem will be published after a month i.e. on 9-Dec-17.