Skip to Content
0
Former Member
Jul 19, 2016 at 01:40 PM

How to count the number of times a variable comes in a column

134 Views

I have to generate a report of the top 10 occurrences and the # of times they occur. For e.g in the table below

ID Name 1 John 2 John 3 Mary 4 Mary 5 Mary
6 Peter 7 Peter 8 Peter 9 Peter 10 Peter 11 Mitt 12 Mitt 13 Mitt 14 Mitt 15 Mitt

So I need to generate a report which shows John - 2 ; Mary - 3; Peter - 5 and Mitt - 5. Names with the # of times they occur. Is there any way to get this done.

Thx-Amit