Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting strings in excel with Pivot | Excel Discussion (Misc queries) | |||
Counting Text Strings With Conditions | Excel Discussion (Misc queries) | |||
Counting text strings | Excel Worksheet Functions | |||
Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) | |||
counting unique strings | Excel Discussion (Misc queries) |