I have created an Excel workbook for a motorcycle judging contest. Each bike has a row with field info, including scores. I am using the LARGE function to find the top 3 places, where column V lists sum of the scores:
What I need help with:Please Login or Register to view this content.
1. Resolve ties by referencing the MILEAGE field; the higher mileage takes precedence.
2. Pull NAME & LOT# field contents from the cells referenced by the LARGE function.
Any help is appreciated.
Bookmarks