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 |
