Hi Experts,
I’m stuck in a simple problem. Wanted to count the value of the excel.
|S.no Values
1 Delhi
2 Mumbai
3 Delhi
4 Jaipur
5 Mumbai
6 Mumbai
7 Mumbai
8 Delhi
9 Jaipur
10 Mumbai
Expected result would be-
|Values |Count |
|Delhi |3 |
|Mumbai|5 |
|Jaipur |2 |
Please help me in solve this. Thanks in advance.