Lowest average with conditionals and source data from 2 tables

Sophyex

New Member
Joined
May 22, 2011
Messages
1
Hi!

I have the attached (link) spreadsheet where I need a table to retrieve:

1. The 4 countries with the lowest average combining 2 tables
2. The 3 names on the Men and Women tables on the left according to the country resulted in 1 above
3. The ranking position of each Men and Women in 2 above


This is a simplified version, as the real one has over 50 countries (not always the same), and can vary from Men and women. In the case a country has men OR women ONLY, it should not be counted as lowest average.
At some point I'll need to add 2 more tables (e.i. boys and girls) so will need to retrieve the top countries with the lowest average considering all 4 divisions.

I know the format of the Men and Women tables is not easy to work with, but it comes from copy and pasting the results of filtered pivot tables (Pivot I and II tabs). If an auxiliary table needs to be created, it's not a problem, but should pick the data automatically.

Hope you can help me, really need it!!

Thanks so much!!!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top