Hi Forum,

I was trying to design a macro which should count the unique rows in the sheet and should display them accordingly. (Possibly in second sheet).

I'll just give a quick example for this scenario

Sheet 1:
String Age
str1 5
str1 5
str1 3
str1 3
str1 3
str2 5


When I run a macro now I should get the results as follows in sheet 2:

Sheet 2:
String Age Count
str1 5 2
str1 3 3
str2 5 1

Can anyone help me in designing macro for this. Thanks for your help.