Zend certified PHP/Magento developer

Max value for multiple datasets in different orders

I need to find the max value of specific Cities on each sheet so would like to write a formula where Max of odd cities (City, 1, 3, 5). The tables are sorted by Salary, not by City alpha. (Cities are not numerical in dataset, actual City names)

TAB 1

City # Salary
City 1 $58115
City 2 $57436
City 3 $56839
City 4 $56784
City 5 $56430
Max 1, 3, 5: $XXXXX

TAB 2:

City # Salary
City 2 $58112
City 1 $57439
City 5 $56848
City 4 $56620
City 3 $56500
Max 1, 3, 5: $XXXXX