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 |