Finding most recent dates in carious columns of date information
I play a lot of Magic: The Gathering. I have a spreadsheet that tracks when I play each of my decks and the outcome of the game. The spreadsheet has a section for each deck, and then a column of dates for when I played those decks.
I'm trying to find a way to take those columns of dates and generate a list of, for example, the top-ten most recent decks I played. I don't know how to get Excel to do that, because it would need to look at all of the date columns and find the top-ten most recent dates and the deck they correspond to. I don't even know how to begin to do that.
Any thoughts or suggestions?
Thanks.