Hello,

I would appreciate your help in this.

I have a column with different values as shown in the image.

2017-08-31_1421_001_001_001.png

I need to do 2 things.

1. A formula or command to return all different values in this column, for example:
Order new device
Disconnect...
Transfer....
etc.

2. A formula or command to count how many occurrences of each case:

Order new device|5
Disconnect|6
etc.

Please let me know if any clarifications is needed,

Thanks a lot in advance,