Count and order (Z-A) number of recurring text strings

Hi zgoldflo 

here are two options:

Option 1. Pivot table:

Use the route_taken in the rows area, the user_type in the columns area and again the route_taken in the values area of the Pivot table. This will automatically apply a count.

To sort the Pivot table, open the filter icon for route_taken and select "More Sort Options..."

Then choose "Descending" and select "Count of route_taken" from the dropdown list

In addition/alternatively you can apply a value filter to get only the top X values:

Option 2. Formula solution with COUNTIFS

Then do a manual sort on the Grand Total column.

I would recommend the Pivot table, because it's much more flexible