List Consolidation

Hi Alex, welcome to the forum. Going the macro route there are several options:

1. Filter the list in place (hide the rows with countries having 0 people)
2. Filter the list to another location, then clear the original info and paste the filtered list in its place
3. Delete the rows in which people is 0.

2 and 3 produce the same results, just different methods of doing so. Here are examples of all 3:

1. Filter the list in place:

Please Login or Register  to view this content.

2. Advanced Filter, overwrite original list with filtered data. This uses columns C, D and E to hold the temporary criteria and filtered data.

Please Login or Register  to view this content.

3. Delete rows containing 0's in column B:

Please Login or Register  to view this content.

Hope that helps!