1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/it2d
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel
#spreadsheet
#dates
#date columns
#most recent
#top-ten
#data analysis
#data extraction
#column
#recent
#magic the gathering
#decks
#game outcome
#list generation
#data sorting
#automation
#formulas
#functions
#data manipulation
#querying