Hello, I am trying to organize the information taken form more than one table into one, ranking only the entries different than zero into descending order.

From lists such as the below (note every continent is organized in a separate excell sheet)

EUROPE

italy 2%
england 0%

ASIA

thailand 1%
China 0%
Japan 6%

AMERICAS

US 7%
Canada 0%
Chile 5%

I need to be able to authomatically retreive the data different from ZERO, and organize them in descending order into a new excel spreadsheet.
as per below

US 7%
Japan 6%
Chile 5%
italy 2%
thailand 1%


Can you please let me know how to get this done, as I am trying but can't come up with anything./
cheers
yanti

Hi Yanti

Thanks for your question.

You can do this by:

1. Clicking in one of the two columns that contains your data, then go to Data - Filter - AutoFilter.

2. Click the dropdown arrow about the column with the % showing and select Custom.

3. Choose 'does not equal' from the box on the left, then type 0 into the box on the right (i.e. you are applying a filter so you can see only rows where the % is not 0).

4. Click OK.

5. Copy and paste the filter results into a new spreadsheet.

I hope this works for you - let me know by reply if you have any problems.
Amanda

Hi Amanda,
I was hoping to inser a formula in the summary table in order to retreive authomatically all the info and organize them.

as I have very many tables, I can't work on each and everyone, it would take me ages.

is it possible to achieve it with a macro or something similar?

cheers
yanti

This is a Visual Basic question which you really need to come on a course to understand the functions of doing this