Hi,
I am trying to create a summary of a large amount of data. The data shows a list of firms and in which countries they have business in. In my excel table a company is given a 1 if they have business in a country and a 0 if they don't.
What I need to find out is the number of firms with business in numerous countries but I need to know the number for all possible combinations: e.g. in country 1 and 3 only, in country 1, 3 and 6 only etc.
The pivot table I have created does show this but in a very complicated way. You have to read across taking 1 to mean it is present in the country and 0 to mean it isnt. Once you reach the end of the row you know which of the 8 countries it is in and then at the end a total of the number of firms which meet this criteria is given.
Although I can follow this table, it needs to be formated in a way that someone could understand it without me having to explain. Additionally, in the future I could be adding up to 21 countries and this would make the current format very confusing.
Any advice or suggestions you can give me would be hugely appreciated
Thanks :-)
Bookmarks