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.
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?