Read carefully, it might get complicated.But i will try to be at the point as much as possible.

I have an excel workbook of some thousand rows. Now i have to figure out the and display the rows that have count greater than 1 and then how many times each row is repeated.

for example:

Now in the above example table there are different values for column B and the values are repeated and some are not. So I wanna filter the rows that have count greater than 1 ( for eg. " In progress"). So now, we have only rows that have count greater than 1.

Now i wanna Know how many times each row is repeated? like ; " In progress" is repeated 2 times.

It would have been easy if I only had 10 or 15 rows, But like i said I have thousands of rows with hundreds of different values.

So, how to accomplish it?