Assuming the data below starts in column A. I'm trying to write a formula in rows 1-3 that will look in Column D, find the top 3 in rank, then provide the adjacent from in columns A,B,C,E, and F. Help?
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Tiger | Woods | Golf | 10 | Birdie | Eagle |
Michael | Jordan | Basketball | 15 | Dunk | Jumper |
Babe | Ruth | Baseball | 12 | Homer | Double |
Wayne | Gretzky | Hockey | 11 | Goal | Assist |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>