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.
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?