I have a spreadsheet with approx 1000 entries, and growing every day.

From column E, I want to be able to rank/sort the number of times a random value appears.

Every value in column E is either 6 characters, or 6 characters [space] / [space] 6 characters. The cell could also be blank.

Eg,

123ghf or 123ghf / 12ggby

Ideally I would like to have this 'sorted' within the original table, as the outcomes of each value in column E is in column L. And its this direct relationship that is really important.

I hope this makes sense?

Cheers!