counting frequency of strings in cells
Hi,
Given the table below. In column C, D etc I want to get the result of how
frequent a certain port is mentioned.
A B
1
2 Route 1 Alexandria, Port Said, Damietta, Port Said, Alexandria
3 Route 2 Port Said, Damietta, Gebze, Izmir, Port Said,
4 Route 3 Port Said, Alexandria, Port Said, Damietta, Port Said
5 Route 4 Port Said, Beirut, Tartous, Limassol, Port Said
6 Route 5 Port Said, Damietta, Istanbul, Port Said
so if column C refers to Port Said and column D refers to Damietta, the
results should be:
C D
1 Port Said Damietta
2 2 1
3 2 1
4 3 1
5 2 0
6 2 1
Is this possible?
Many thanks in advance and have a nice day!
tom
|