Multiple count if criteria?

So I'm trying to count the number of times something comes up, and if that doesn't show up then I want to count the number of times the next thing comes up and so on.

if that doesn't make sense here is an example of what I want it do do:

Manchester 1
London 1
Bristol 1
Manchester 2
Digital 1
Bristol 2
London 2
London 3
Bristol 3
London 4

so if this is my data set I'm trying to get the formula to read each cell and count each thing like in column B above

this is what I've been trying to make work but I can't get it to check the first then the second then the third then the fourth criteria

=COUNTIF(((($E$2:$E2,"Manchester"),COUNTIF($E$2:$E2,"London")),COUNTIF($E$2:$E2,"Bristol")),COUNTIF($E$2:$E2,"Digital"))

I know that doesn't work but that's the idea. I've also tried AND, OR, IFERROR, and COUNTA but I can't work it out.

Any help would be massively appreciated

Pls try this formula

Formula:

Please Login or Register  to view this content.