Find Repeating Data On The Sheet With Number Of Repetitions

        As sample, data in Column A was used in this macro.

When the button is pressed,data in "Column A" are listed  into "Column G" and "Column H" with the number of repetitions.

Tutorial's video :