How can you find the max value in AA and max value in AD to return AB that has the highest rank for each column (AA & AD)?

Not sure if Im stating it correctly, but I know it exists.

Thank you.

Wagers.xlsm | ||||||
---|---|---|---|---|---|---|

AA | AB | AC | AD | |||

12 | G/L $$ | What (Rank) | # Bets | % | ||

13 | $83.80 | R:V (1) | 52 | 69% | ||

14 | $52.85 | U:V-Y (2) | 41 | 66% | ||

15 | $36.90 | M:O - R:V (3) | 27 | 67% | ||

16 | $33.70 | R:V - X:Z (4) | 20 | 70% | ||

17 | $19.65 | M:O - R:T (5) | 40 | 58% | ||

18 | $7.80 | ATS>0:Pick (6) | 29 | 55% | ||

19 | $2.22 | M:O (7) | 75 | 53% | ||

NBA |

Cell Formulas | ||
---|---|---|

Range | Formula | |

AA13 | AA13 | =MAX(IF($Y$9:$AP$9,$Y$9:$AP$9,"")) |

AB13:AB19 | AB13 | =INDEX($Y$1:$AP$1,MATCH(AA13,$Y$9:$AP$9,0)) |

AC13:AC19 | AC13 | =INDEX($Y$6:$AP$6,MATCH(AA13,$Y$9:$AP$9,0)) |

AD13 | AD13 | =OFFSET($X$1,MATCH(W5,$W$2:$W$9,0),MATCH(AB13,$Y$1:$AP$1,0)) |

AA14:AA19 | AA14 | =MAX(IF($Y$9:$AP$9<AA13,$Y$9:$AP$9,"")) |

AD14:AD19 | AD14 | =OFFSET($X$1,MATCH($Z$12,$W$2:$W$9,0),MATCH(AB14,$Y$1:$AP$1,0)) |

Press CTRL+SHIFT+ENTER to enter array formulas. |