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.
Excel Next Microsoft Excel courses are designed for those who work regularly with Excel spreadsheets and wish to become familiar with complex functions and features in Excel to reduce their work complexity. Our training method is activity-based to make existing Excel Users comfortable with advanced excel features and commands to increase their productivity. You will learn to use Excel better, faster and more efficiently. Along the way, you will learn how to use various advanced features in Excel so that you can save time and look good in front of your superiors & colleagues.
Advanced Excel Training