Hi

I wonder if anyone can help me please.

I have a list 240 countries in column A. In column B, the number of people in each country is populated by an automated process done on a separate workbook. 90% of the countries will always be zero 90% of the time but I can never predict.

I need this list of 240 countries consolidated to just a list of those counties who's population is greater than zero.

My first list looks like this.
Country A 10
Country B 0
Country C 0
Country D 3
Country E 0

And I need it consolidated to this.

Country A 10
Country D 3

Is this possible to do? Don't mind if its done via formula or VBA.

Thanks

Alex.